Connecting to DB2 V8 from J2EE

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.

This works without database client. db2jcc.jar is required.

com.ibm.db2.jcc.DB2Driver

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

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.