Poolman

Sun, 16 Sep 2001 17:11:17 -0700

Hello all...
 
I am newbie in JSP..
 
I have installed poolman (pooling connection manager) from codestudio..
I have followed the instruction there...
I use Tomcat 3.2.3 and MySQL....
 
I used the mysql driver from resin
 
I have added classpath in autoexec.bat
 
PATH C:\JDK1.3.1\bin;C:\tomcat;%PATH%
set TOMCAT_HOME=c:\tomcat
set JAVA_HOME=c:\jdk1.3.1
SET CLASSPATH=C:\poolman\apps\WEB-INF;C:\poolman\build;C:\poolman\lib
 
I have modified the poolman.xml, I placed this xml in poolman\lib and tomcat\lib
 
<datasource>

- ============================== -->

<!-- Physical Connection Attributes -->

<!-- ============================== -->

<!-- Standard JDBC Driver info -->

<dbname>testdb</dbname>

<jndiName>jndi-testdb</jndiName>

<driver>com.caucho.jdbc.mysql.Driver</driver>

<url>jdbc:mysql_caucho://localhost:3306/vcdshop</url>

<username>root</username>

<password>ganteng</password>

<minimumSize>0</minimumSize>

<maximumSize>10</maximumSize>

<connectionTimeout>600</connectionTimeout>

<userTimeout>12</userTimeout>

<shrinkBy>10</shrinkBy>

<logFile>/home/poolman/testdb.log</logFile>

<debugging>true</debugging>

<!-- Query Cache Attributes-->

<cacheEnabled>true</cacheEnabled>

<cacheSize>20</cacheSize>

<cacheRefreshInterval>120</cacheRefreshInterval>

</datasource>

 
I also installed poolman.war
Tomcat had adding context for it.. when it start
 
But I found this error message when i run JSP Database Client from poolman

Error: 500

Location: /poolman/PoolMan.jsp

Internal Servlet Error:
javax.servlet.ServletException: javax/sql/ConnectionEventListener
        at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:508)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
        at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405)
        at org.apache.tomcat.core.Handler.service(Handler.java:287)
        at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
        at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:812)
        at org.apache.tomcat.core.ContextManager.service(ContextManager.java:758)
        at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:213)
        at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
        at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501)
        at java.lang.Thread.run(Thread.java:484)
Root cause: 
java.lang.NoClassDefFoundError: javax/sql/ConnectionEventListener
        at java.lang.ClassLoader.defineClass0(Native Method)
        at java.lang.ClassLoader.defineClass(ClassLoader.java:486)
        at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:111)
        at java.net.URLClassLoader.defineClass(URLClassLoader.java:248)
        at java.net.URLClassLoader.access$100(URLClassLoader.java:56)
        at java.net.URLClassLoader$1.run(URLClassLoader.java:195)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:297)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:290)
        at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:286)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:253)
        at org.apache.tomcat.loader.AdaptiveClassLoader.loadClass(AdaptiveClassLoader.java:446)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:253)
        at org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:136)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:253)
        at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:313)
        at java.lang.Class.newInstance0(Native Method)
        at java.lang.Class.newInstance(Class.java:237)
        at org.apache.jasper.servlet.JspServlet$JspServletWrapper.instantiateServlet(JspServlet.java:204)
        at org.apache.jasper.servlet.JspServlet.doLoadJSP(JspServlet.java:617)
        at org.apache.jasper.servlet.JasperLoader12.loadJSP(JasperLoader12.java:146)
        at org.apache.jasper.servlet.JspServlet.loadJSP(JspServlet.java:542)
        at org.apache.jasper.servlet.JspServlet$JspServletWrapper.loadIfNecessary(JspServlet.java:258)
        at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:268)
        at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:429)
        at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:500)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
        at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405)
        at org.apache.tomcat.core.Handler.service(Handler.java:287)
        at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
        at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:812)
        at org.apache.tomcat.core.ContextManager.service(ContextManager.java:758)
        at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:213)
        at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
        at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501)
        at java.lang.Thread.run(Thread.java:484)

Reply via email to