Forums Register Login

Connecting to DB2 V8 from J2EE

+Pie Number of slices to send: Send
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.
+Pie Number of slices to send: Send
This works without database client. db2jcc.jar is required.

com.ibm.db2.jcc.DB2Driver
+Pie Number of slices to send: Send
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

 
+Pie Number of slices to send: Send
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.
Whip out those weird instruments of science and probe away! I think it's a tiny ad:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com


reply
reply
This thread has been viewed 1247 times.
Similar Threads
Works with JDBC/ODBC but not Direct JDBC
JDBC driver for DB2
HELP !!!!!!
no db2jdbc in java.library.path
UnsatisfiedLinkError: SQLConnect
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 29, 2024 09:16:06.