JDBC driver for DB2

[Zoe Peng]

Hi,
Does anybody know what is the correct driver for DB2?
is that COM.ibm.db2.jdbc.app.DB2Driver?
any servlet example to connect database? thanks.

[parul patidar]

go to
http://industry.java.sun.com/products/jdbc/drivers
i hope u will find there

[Zoe Peng]

Parul,
Thanks. Yep. it's correct jdbc driver for DB2

[Christian Waidner]

Hi!
There are two valid Drivers to use with the IBM DB2:
driver: COM.ibm.db2.jdbc.DB2Driver
url: jdbc:db2:databasename
driver: COM.ibm.db2.jdbc.net.DB2Driver
url: jdbc:db2://servername ort/database
The first one requires a DB2-client installation on your pc, the second one requires the "Applet-Server" on your DB2 (see jstrt for details).
bye,
Chris

------------------

[Zoe Peng]

O. yes.
I did both of them in my code. thanks.
Class.forName("COM.ibm.db2.jdbc.app.DB2Driver");
Connection con = DriverManager.getConnection("jdbc:db2 BNAME","","");
one is a driver, the other one is a dbURL.