Re: Need help to configure oracle database

On 12/7/06, Sunitha Raghurajan <SRaghurajan@xxxxxxxxxxxxxxxxxx> wrote:
> How will I configure oracle database in sql squirrel. Do I need oracle 
> pluggin?

You don't need the Oracle plugin to connect to an Oracle server and do
basic things like view table content and execute SQL statements.  The
Oracle plugin gives source tabs for certain database objects
(procedures, views, triggers etc.) and also provides nodes in the tree
which without it you cannot access (such as triggers) except via SQL.
That said, I would highly recommend installing the Oracle plugin if
you connect to an Oracle database - it enhances SQuirreL's
capabilities.

You need to configure the Oracle JDBC driver in the driver definitions
window, then setup an Alias using that driver, and finally connect.  A
template JDBC URL is given when you configure a new alias and adding a
driver definition is as simple as modifying the Oracle thin driver
default definition to tell SQuirreL where the ojdbc14.jar driver jar
is located.  Let us know if you run into any problems getting
connected.

Rob

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV