[Squirrel-sql-users] Connecting to DB2

Discussion:

GarethH

2007-03-07 15:25:33 UTC

Hi,

Im trying to connect to DB2 with SQuirreL but i cant find the
"COM.ibm.db2.jdbc.app.DB2Driver" driver. I've added the db2java.zip to the
extra class path but it still cant find it. Any ideas?

Regards,
Gareth.

--
View this message in context: http://www.nabble.com/Connecting-to-DB2-tf3362719.html#a9354949
Sent from the squirrel-sql-users mailing list archive at Nabble.com.

Robert Manning

2007-03-07 21:59:20 UTC

Permalink

Post by GarethH
Hi,
Im trying to connect to DB2 with SQuirreL but i cant find the
"COM.ibm.db2.jdbc.app.DB2Driver" driver. I've added the db2java.zip to the
extra class path but it still cant find it. Any ideas?

Michael Feill

2007-03-08 08:05:19 UTC

Permalink

I'm using both, and both are working well.

For JDBC if added the following environment variable:
CLASSPATH=.;C:\Program Files\SQLLIB\java\db2java.zip.

The JCC I loaded with additional classpath in the driver dialog.

But it should not make any deferens which way you are using.

Michael

Post by Robert Manning

I've been using db2jcc.jar and db2jcc_license_cu.jar that cam with my
DB2 server (Personal Edition) software. With personal edition it is
located a java sub-directory under the DB2 installation directory. And
the class name in this case is : com.ibm.db2.jcc.DB2Driver
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
_______________________________________________
Squirrel-sql-users mailing list
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

--
View this message in context: http://www.nabble.com/Connecting-to-DB2-tf3362719.html#a9370174
Sent from the squirrel-sql-users mailing list archive at Nabble.com.

GarethH

2007-03-13 13:26:22 UTC

Permalink

Hi,

I added the jar files you said to the extra class and it couldnt find either
of the drivers you talked about. I think the problem might be that im not
starting SQuirrel correctly. In the quick start guide it says

"Just remember that when executing the jar file directly you don't use your
current class path ($CLASSPATH on Unix or %CLASSPATH% on Windows) so if you
have your JDBC drivers in your class path then SQuirreL won't see them. See
The Driver for more information."

Does that mean if i start SQuirrel using "java -jar squirrel-sql.jar" that
it wont be able to see the classpath?, if this is correct, how else would i
start SQuirrel on a hp-ux box?

Regards,
Gareth.

Post by Michael Feill
I'm using both, and both are working well.
CLASSPATH=.;C:\Program Files\SQLLIB\java\db2java.zip.
The JCC I loaded with additional classpath in the driver dialog.
But it should not make any deferens which way you are using.
Michael

Post by Robert Manning

--
View this message in context: http://www.nabble.com/Connecting-to-DB2-tf3362719.html#a9454289
Sent from the squirrel-sql-users mailing list archive at Nabble.com.

Robert Manning

2007-03-13 22:00:23 UTC

Permalink

Post by GarethH
Hi,
I added the jar files you said to the extra class and it couldnt find either
of the drivers you talked about. I think the problem might be that im not
starting SQuirrel correctly. In the quick start guide it says
"Just remember that when executing the jar file directly you don't use your
current class path ($CLASSPATH on Unix or %CLASSPATH% on Windows) so if you
have your JDBC drivers in your class path then SQuirreL won't see them. See
The Driver for more information."
Does that mean if i start SQuirrel using "java -jar squirrel-sql.jar" that
it wont be able to see the classpath?, if this is correct, how else would i
start SQuirrel on a hp-ux box?

How about squirrel-sql.sh ?

Rob