Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Connecting to DB2 V8 from J2EE

 
Dilip kumar
Ranch Hand
Posts: 360
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 2874
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
This works without database client. db2jcc.jar is required.

com.ibm.db2.jcc.DB2Driver
 
Santosh Bhoj
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 2874
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic