• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Connecting to DB2 V8 from J2EE

 
Ranch Hand
Posts: 360
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Ranch Hand
Posts: 2874
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
This works without database client. db2jcc.jar is required.

com.ibm.db2.jcc.DB2Driver
 
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Did you just should on me? You should read this tiny ad:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic