Hello Jens, There are two problems that are immediately apparent:
1. "user" should be "username" 2. you should append "?autoReconnect=true" to your url value when using MySQL which sweeps stale connections. Jake Thursday, October 17, 2002, 3:27:42 AM, you wrote: JK> Hi, JK> I got a problem setting up my jdbc connection pool as described in JK> http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-resources-howto.html. JK> I'm using the mySQL database and tomcat 4.1. JK> Following the jndi-resources-howto.html file I added to my server.xml: JK> <Context path="axis" docBase="/axis" debug="0"> JK> <Resource name="jdbc/auctionDB" auth="Container" JK> type="javax.sql.DataSource"/> JK> <ResourceParams name="jdbc/auctionDB"> JK> <parameter> JK> <name>username</name> JK> <value>user</value> JK> </parameter> JK> <parameter> JK> <name>password</name> JK> <value>pass</value> JK> </parameter> JK> <parameter> JK> <name>driverClassName</name> JK> <value>com.mysql.jdbc.Driver</value> JK> </parameter> JK> <parameter> JK> <name>url</name> JK> <value>jdbc:mysql://localhost:3306/timeslotauction</value> JK> </parameter> JK> <parameter> JK> <name>maxActive</name> JK> <value>8</value> JK> </parameter> JK> <parameter> JK> <name>maxIdle</name> JK> <value>4</value> JK> </parameter> JK> </ResourceParams> JK> </Context> JK> and in the web.xml: JK> <resource-ref> JK> <description> JK> description JK> </description> JK> <res-ref-name> JK> jdbc/auctionDB JK> </res-ref-name> JK> <res-type> JK> javax.sql.DataSource JK> </res-type> JK> <res-auth> JK> Container JK> </res-auth> JK> </resource-ref> JK> On my webpage I try the following: JK> Context initCtx = new InitialContext(); JK> Context envCtx = (Context) initCtx.lookup("java:comp/env"); JK> DataSource ds = (DataSource)envCtx.lookup("jdbc/auctionDB"); JK> which results in the following error message when I execute JK> envCtx.lookup("jdbc/auctionDB"): JK> javax.naming.NamingException: Cannot create resource instance JK> at JK> org.apache.naming.factory.ResourceFactory.getObjectInstance(ResourceFactory.java:189) JK> at JK> javax.naming.spi.NamingManager.getObjectInstance(NamingManager.java:301) JK> at org.apache.naming.NamingContext.lookup(NamingContext.java:834) JK> at org.apache.naming.NamingContext.lookup(NamingContext.java:181) JK> at org.apache.naming.NamingContext.lookup(NamingContext.java:822) JK> at org.apache.naming.NamingContext.lookup(NamingContext.java:194) JK> at org.apache.jsp.happyaxis_jsp._jspService(happyaxis_jsp.java:297) JK> at JK> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:136) JK> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) JK> at JK> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:204) JK> at JK> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:289) JK> at JK> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:240) JK> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) JK> at JK> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247) JK> at JK> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) JK> at JK> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:260) JK> at JK> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) JK> at JK> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) JK> at JK> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) JK> at JK> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) JK> at JK> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) JK> at JK> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) JK> at JK> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) JK> at JK> org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2396) JK> at JK> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180) JK> at JK> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) JK> at JK> org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170) JK> at JK> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) JK> at JK> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172) JK> at JK> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) JK> at JK> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) JK> at JK> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) JK> at JK> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174) JK> at JK> org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) JK> at JK> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) JK> at JK> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) JK> at JK> org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223) JK> at JK> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:405) JK> at JK> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:380) JK> at JK> org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:508) JK> at JK> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:533) JK> at java.lang.Thread.run(Thread.java:536) JK> I really hope someone can help. JK> Thanks JK> Jens JK> -- JK> To unsubscribe, e-mail: <mailto:tomcat-user-unsubscribe@;jakarta.apache.org> JK> For additional commands, e-mail: <mailto:tomcat-user-help@;jakarta.apache.org> -- Best regards, Jacob mailto:hoju@;visi.com -- To unsubscribe, e-mail: <mailto:tomcat-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:tomcat-user-help@;jakarta.apache.org>
