Servlet Exceptions connecting to DB2 Database
 Technote (FAQ)
 
Problem
Custom application fails to connect to DB with "SRVE0026E: [Servlet Error]-[SQLConnect] " messages.

. . .
[3/10/05 13:54:25:428 EST] 11c59cfd WebGroup E SRVE0026E: [Servlet Error]-[SQLConnect]: com.mycompany.database.DbConnectionException: SQLConnect
at com.mycompany.database.DbConnectionFactory.returnConnection(DbConnectionFactory.java:264)
at com.mycompany.database.DbConnectionFactory.createDbConnection(DbConnectionFactory.java:171)
at org.apache.jsp._enterChg._jspService(_enterChg.java:89)
at com.ibm.ws.webcontainer.jsp.runtime.HttpJspBase.service(HttpJspBase.java:89)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.ibm.ws.webcontainer.jsp.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:344)
at com.ibm.ws.webcontainer.jsp.servlet.JspServlet.serviceJspFile(JspServlet.java:683)
at com.ibm.ws.webcontainer.jsp.servlet.JspServlet.service(JspServlet.java:781)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
 
Cause
The following UnsatisfiedLinkError was found about 70 lines above the servlet errors.

[3/10/05 13:54:24:085 EST] 11c59cfd SystemErr R java.lang.UnsatisfiedLinkError: SQLConnect

Customer was attempting to use the 64bit version of the db2java.zip driver to connect to their DB2 database.

WebSphere does not support the 64bit version of the client driver.

 
Solution
Use the 32bit DB2java.zip driver.

Run the <DB2Instance_home>/sqllib/bin/db2level to confirm db2java.zip 32bit version.

 
Historical Number
47711
111
000
 
 


Document Information


Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server > DB Connections/Connection Pooling
Operating system(s): AIX
Software version: 6.0
Software edition:
Reference #: 1204382
IBM Group: Software Group
Modified date: Apr 22, 2005