Bazile Lanneau
|
| Posted: 09/01/2002, 3:17 PM |
|
I am able to build the CCS examples in JSP 1.1 JDK 1.3 using Tomcat and MySql database. I have also sucessfully created a plain java application following the examples with DB2 to connect to a local database. I have added d:\sqllib\java\db2driver.zip to my CLASSPATH
I am trying build a test application with CCS to connect to a DB2 database but get a server error 500. There are no error error messages when building.
My web.xml file and error message is shown below.
Any suggestions are appreciated.
Thanks, Bazile
FROM SERVER d:\tomcat41\webapps\db21\META-INF\web.xml
<!--
//Connection Connection1 parameters @4-50DF703E
-->
<init-param>
<param-name>Connection.Connection1</param-name>
<param-value>
name=Connection1
driver=COM.ibm.db2.jdbc.app.DB2Driver
dbType=DB2
url=jdbc:db2:BANK
maxconn=5
user=XXX
password=XXXXXXXXXXXXX
timeout=500
dateLeftDelim='
dateRightDelim='
dateFormat=
booleanFormat=
</param-value>
</init-param>
<!--
//End Connection Connection1 parameters
-->
FROM SERVER ERROR LOG:
java.lang.RuntimeException: Unable to create connection 'Connection1' to the database.
at com.codecharge.db.PoolJDBCConnection.getConnection(PoolJDBCConnection.java:14)
at com.codecharge.db.JDBCConnection.(JDBCConnection.java:47)
at com.codecharge.db.PoolJDBCConnection.(PoolJDBCConnection.java:7)
at com.codecharge.PageController.select(PageController.java:295)
at com.codecharge.PageController.processRecord(PageController.java:813)
at com.codecharge.PageController.process(PageController.java:246)
at org.apache.jsp.EBS_0005fTRANSA_0005fmaint_jsp._jspService(EBS_0005fTRANSA_0005fmaint_jsp.java:905)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:136)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:202)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:289)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:240)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:260)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2350)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:171)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:405)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:380)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:508)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:533)
at java.lang.Thread.run(Thread.java:536)
|
|
|
 |
Bazile Lanneau
|
| Posted: 09/13/2002, 2:07 PM |
|
The db2 driver is db2java.zip.
This driver should be placed in the <TOMCAT_HOME>\common\lib directory and renamed to 'db2java.jar'. It appears that all files in the Tomcat lib directory must have a 'jar' extension. Renaming works because the file format is the same for jar as for zip.
This may be an issue regarding the Tomcat version.
-Bazile
|
|
|
|
|
