Dear All,
We are using IBM WebSphere 4.0 with DB2 - both installed in seperate machines.
To get a connection to DB2 from jsp / servlet, we use the following (in a bean) to
connect to the database:
Class.forName ("COM.ibm.db2.jdbc.net.DB2Driver")
Connection connection =
DriverManager.getConnection("jdbc:db2://10.0.20.226:8083/test", "db2inst1", "ibmdb2")
And, the above is working fine.
We thought of using the "Data Source" option in WebSphere, but are having problems
setting it up !
We used the following (after setting up the datasource in admin) in jsp:
DataSource datasource =
(DataSource)initialcontext.lookup("java:comp/env/opinionusa/datasource")
And, we got the following error:
"java.sql.SQLException: java.lang.UnsatisfiedLinkError: no db2jdbc (libdb2jdbc.so)
in java.library.path "
To solve the above error, we copied libdb2jdbc.so (and libdb2jdsup.so.1,
libdb2jext.so) into the "jre/lib" path, set the classpath (LD_LIBRARY_PATH) to refer
to "jre/lib" folder, but we are getting a new error called:
SQLAlloc(): rc :*
We restarted the WebSphere server (later Linux 7.2 OS), but this time WebSphere itself
did not startup !!
On removing the files libdb2jdbc.so, libdb2jdsup.so.1 and libdb2jext.so from
"jre/lib", restarting the WebSphere (& Linux), WebSphere 4.0 started working !!
Has anyone tried creating DB2 DataSource in WS4.0 (running in Linux 7.2) before? Can
you please share the steps to be used in configuring DataSource?
Thanks & Regards,
Dayanand.
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
