Re: [Squirrel-sql-users] Setting up DB2 configuration giving problems

[Sharma, A. <Ash...@gs...>]

Thanks that was really helpful-I can set it up.
Thanks a ton!!!=20

-----Original Message-----
From: Robert Manning [mailto:rob...@gm...]=20
Sent: Monday, December 04, 2006 4:42 PM
To: Sharma, Ashutosh
Cc: SQuirreL Users List
Subject: Re: [Squirrel-sql-users] Setting up DB2 configuration giving
problems

On 12/4/06, Sharma, Ashutosh <Ash...@gs...> wrote:
>  Directory of C:\Program Files\SQuirreL SQL Client\lib
>
> 12/04/2006  12:08 PM    <DIR>          .
> 12/04/2006  12:08 PM    <DIR>          ..
> 11/09/2006  04:33 PM            30,117 commons-cli.jar
> 12/04/2006  11:23 AM           236,997 db2fs.jar
> 04/16/2001  05:27 PM         1,136,282 db2java.zip
> 12/04/2006  11:23 AM         1,124,512 db2jcc.jar
> 12/04/2006  11:23 AM            23,709 db2jcc_javax.jar
> 12/04/2006  11:23 AM             2,063 db2jcc_license_cisuz.jar
> 12/04/2006  11:23 AM             1,013 db2jcc_license_cu.jar
> 12/04/2006  11:23 AM           118,928 db2policy.jar
> 12/04/2006  11:23 AM           229,041 db2qgjava.jar
> 11/09/2006  04:33 PM            75,370 forms.jar
> 11/09/2006  04:33 PM         1,327,905 fw.jar
> 11/09/2006  04:33 PM           223,469 log4j.jar
> 11/09/2006  04:33 PM            38,698 nanoxml-2.1.jar
>               13 File(s)      4,568,104 bytes
>                2 Dir(s)   5,536,415,744 bytes free
> db2fs.jar, db2jcc.jar, db2jcc_javax.jar, db2jcc_license_cisuz.jar,
> db2jcc_license_cu.jar, db2policy.jar, db2qgjava.jar
> Doesn't work when I put under lib dir.
> Only when I put sqljava.zip-then it recongnizes it as IBM Net App
> Driver-otherwise nothing happens.
> Can u tell me-which one is the DB2 driver out of it and then how to
> configure it.

I would not recommend copying all of your jdbc driver files into
SQuirreL's lib directory.  While it should work just fine, it can
cause delays in certain areas of the app and isn't very easily
upgradeable (assuming you put the new version down in a separate
directory which is just good practice to avoid stale files).  However,
I'm not sure why it would cause your driver not to be recognized.

If you modify the driver definition there is an 'Extra Classpath' tab
that will allow you to point to the two files I mentioned previously
(db2cc.jar and db2cc_license_cu.jar).  Those two jar files are
required.  When you add them using the 'Extra Classpath' tab you
should then click the button labelled 'List Drivers'.  You should then
choose the option in the Class Name drop-down list labelled
'com.ibm.db2.jcc.DB2Driver'. Click OK button then you should see a
message stating that the driver was successfully registered.  Let us
know how it goes.

Rob