aspose file tools*
The moose likes JDBC and the fly likes Connecting to DB2 V8 from J2EE Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Connecting to DB2 V8 from J2EE" Watch "Connecting to DB2 V8 from J2EE" New topic
Author

Connecting to DB2 V8 from J2EE

Dilip kumar
Ranch Hand

Joined: Oct 16, 2000
Posts: 360
Hi All-

I'm looking for options available to connect to DB2 table from J2EE application running on JBoss 4. I searched on Google and found these methods. Are there any other options to connect to DB2 table ?

1. Using COM.ibm.db2.jdbc.app.DB2Driver . This access requires DB2 Client-software (DB-Connect) installed on the local machine.

2. The alternative way is to connect via the COM.ibm.db2.jdbc.net.DB2Driver.Access is slower compared to the app-driver.
Thanks much.
Adeel Ansari
Ranch Hand

Joined: Aug 15, 2004
Posts: 2874
This works without database client. db2jcc.jar is required.

com.ibm.db2.jcc.DB2Driver
Santosh Bhoj
Greenhorn

Joined: Sep 22, 2005
Posts: 1
Hi Adeel,
I am having a problem connecting to a DB2 ver 7 database usign com.ibm.db2.jdbc.app.DB2Driver. I get an Exception: 'java.lang.UnsatisfiedLinkError: SQLPrepare' when trying to execute a PreparedStatement. I do have a Connection Pool and a Data Source configured for the same database using the above mentioned driver and these work FINE.
I did copy the client DLLS onto my machine and put them in the PATH env variable. Still the problem exists. Any suggestions would be greatly appreciated !!!

Thanx,
Santosh







Originally posted by Adeel Ansari:
This works without database client. db2jcc.jar is required.

com.ibm.db2.jcc.DB2Driver
Adeel Ansari
Ranch Hand

Joined: Aug 15, 2004
Posts: 2874
Dear Santosh,

I think you had better make a new thread for this question. Because some of the folks already visited this thread and know what discussion is going on under this thread. Therefore might not come to participate. Your new thread might attract them to come in and assist.

Thanks.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Connecting to DB2 V8 from J2EE