squirrel-sql-users

[Squirrel-sql-users] Installation of ORACLE driver (and plugin)

[Frank R. <f.r...@se...>]

Hi,

it seems SquirrelSQL is my long time longed for DB tool...

Installation worked out trouble-free. Then I copied ORACLEs ojdbc14.jar
to /usr/local/bin/SquirrelSQL/lib, it appears as it should in "Java
Class Path". But pressing the button doesn't display any drivers. Any idea?

Second issue: trying to download the ORACLE plugin. The link in "See our
download section  for details" misses the "www" prefix. Getting there
and reading "See the plugins page for instructions on installing
plugins" I click plugins. After that I am back where I started.
Scrolling down to "Beta Plugins" and clicking "Oracle" I am lead upwards
to section "Installation" to restart the game... ;) oooomph - Well then,
how to get the ORACLE plugin?

Regards
Frank

Re: [Squirrel-sql-users] Installation of ORACLE driver (and plugin)

[Robert M. <rob...@gm...>]

On 3/23/07, Frank Reifenstahl <f.r...@se...> wrote:
> Hi,
>
> it seems SquirrelSQL is my long time longed for DB tool...
>
> Installation worked out trouble-free. Then I copied ORACLEs ojdbc14.jar
> to /usr/local/bin/SquirrelSQL/lib, it appears as it should in "Java
> Class Path". But pressing the button doesn't display any drivers. Any idea?

You mean pressing the "List Drivers" button doesn't display any
drivers in the Class Name drop-down?  If so, instead of placing it in
the lib directory, you link directly to it using the
"Add" button on the "Extra Class Path" tab.

>
> Second issue: trying to download the ORACLE plugin. The link in "See our
> download section  for details" misses the "www" prefix. Getting there
> and reading "See the plugins page for instructions on installing
> plugins" I click plugins. After that I am back where I started.
> Scrolling down to "Beta Plugins" and clicking "Oracle" I am lead upwards
> to section "Installation" to restart the game... ;) oooomph - Well then,
> how to get the ORACLE plugin?

The Oracle plugin comes with the installer now.  That documentation
needs to be re-written.

Rob

Re: [Squirrel-sql-users] Installation of ORACLE driver (and plugin)

[Frank R. <f.r...@se...>]

>> Hi,
>>
>> it seems SquirrelSQL is my long time longed for DB tool...
>>
>> Installation worked out trouble-free. Then I copied ORACLEs ojdbc14.jar
>> to /usr/local/bin/SquirrelSQL/lib, it appears as it should in "Java
>> Class Path". But pressing the button doesn't display any drivers. Any
>> idea?
> 
> You mean pressing the "List Drivers" button doesn't display any
> drivers in the Class Name drop-down?  

That's what I mean...

> If so, instead of placing it in
> the lib directory, you link directly to it using the
> "Add" button on the "Extra Class Path" tab.

I have tried this twice, at first with the JAR located in
/usr/local/bin/SquirrelSQL/lib and then putting it into my home dir, two
misses... :/

Regards
Frank

Re: [Squirrel-sql-users] Installation of ORACLE driver (and plugin)

[Robert M. <rob...@gm...>]

On 3/26/07, Frank Reifenstahl <f.r...@se...> wrote:
> >> Hi,
> >>
> >> it seems SquirrelSQL is my long time longed for DB tool...
> >>
> >> Installation worked out trouble-free. Then I copied ORACLEs ojdbc14.jar
> >> to /usr/local/bin/SquirrelSQL/lib, it appears as it should in "Java
> >> Class Path". But pressing the button doesn't display any drivers. Any
> >> idea?
> >
> > You mean pressing the "List Drivers" button doesn't display any
> > drivers in the Class Name drop-down?
>
> That's what I mean...
>
> > If so, instead of placing it in
> > the lib directory, you link directly to it using the
> > "Add" button on the "Extra Class Path" tab.
>
> I have tried this twice, at first with the JAR located in
> /usr/local/bin/SquirrelSQL/lib and then putting it into my home dir, two
> misses... :/
>

Ok, then could you check your squirrel-sql.log file for errors?  What
this condition seems to indicate is that the ojdbc14.jar file doesn't
contain any classes that implement the java.sql.Driver interface.  If
there are exceptions during the search for Driver implementations you
should get an INFO message in the log stating such.

Rob