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.
_________________________________________________________________
Send and receive Hotmail on your mobile device: http://mobile.msn.com
===========================================================================
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".
