Here is a complete stack trace of the exception javax.naming.NamingException: Cannot create resource instance at org.apache.naming.factory.ResourceFactory.getObjectInstance(ResourceFactory. java:167) at javax.naming.spi.NamingManager.getObjectInstance(NamingManager.java:311) at org.apache.naming.NamingContext.lookup(NamingContext.java:834) at org.apache.naming.NamingContext.lookup(NamingContext.java:181) at org.apache.naming.NamingContext.lookup(NamingContext.java:822) at org.apache.naming.NamingContext.lookup(NamingContext.java:181) at org.apache.naming.NamingContext.lookup(NamingContext.java:822) at org.apache.naming.NamingContext.lookup(NamingContext.java:181) at org.apache.naming.NamingContext.lookup(NamingContext.java:822) at org.apache.naming.NamingContext.lookup(NamingContext.java:194) at org.apache.naming.SelectorContext.lookup(SelectorContext.java:183) at javax.naming.InitialContext.lookup(InitialContext.java:354) at wwxchange.utility.DBPoolAccess.<init>(DBPoolAccess.java:28) at wwxchange.beans.UserAcctBean.loadProfile(UserAcctBean.java:103) at org.apache.jsp.Login$jsp._jspService(Login$jsp.java:149) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.ja va:201) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:381) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:473) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application FilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh ain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja va:243) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 66) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja va:190) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 66) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase .java:531) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 64) at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:2 46) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 64) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2347) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180 ) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 66) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve. java:170) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 64) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170 ) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 64) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 64) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java :174) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 66) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java: 1027) at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1125 ) at java.lang.Thread.run(Thread.java:536) ----- Original Message ----- From: "Nathan McMinn" <[EMAIL PROTECTED]> To: "Tomcat Users List" <[EMAIL PROTECTED]> Sent: Wednesday, January 15, 2003 3:19 PM Subject: Re: JDBC Connection pooling > That is where the tyrex jars are, problem is, I don't use HypersonicSQL, > which is the jar file tyrex is looking for. If I put the hypersonicSQL jars > there, it attempts to connect to a non-existent database. I found what was > causing that problem, and I have a new one (Progress!!). Now whenever I > attempt to get a connection from the pool, I get > > javax.naming.NamingException: Cannot create resource instance > > pretty vague, isn't it? > > Below is the XML from the relevant server and web.xml files. Maybe this > will help. > > I have this chunk of xml in the web.xml file for the application > > <resource-ref> > <description>wwxchange</description> > <res-ref-name>jdbc/wwxchange</res-ref-name> > <res-type>javax.sql.DataSource</res-type> > <res-auth>Container</res-auth> > </resource-ref> > > which is in turn, described by this context > > <Context path="/wwxchange" docBase="wwxchange" > debug="5" reloadable="true" crossContext="true"> > > <Logger className="org.apache.catalina.logger.FileLogger" > prefix="localhost_DBTest_log." suffix=".txt" > timestamp="true"/> > > <Resource name="jdbc/wwxchange" scope="Shareable" > type="javax.sql.DataSource"/> > <ResourceParams name="jdbc/wwxchange"> > > <parameter> > <name>factory</name> > <value>org.apache.commons.dbcp.BasicDataSourceFactory</value> > </parameter> > <parameter> > <name>url</name> > <value>jdbc:odbc:www_ship_2</value> > </parameter> > <parameter> > <name>maxActive</name> > <value>10</value> > </parameter> > <parameter> > <name>maxWait</name> > <value>5000</value> > </parameter> > <parameter> > <name>driverClassName</name> > <value>sun.jdbc.odbc.JdbcOdbcDriver</value> > </parameter> > <parameter> > <name>maxIdle</name> > <value>2</value> > </parameter> > </ResourceParams> > > </Context> > ----- Original Message ----- > From: "David Boyer" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Wednesday, January 15, 2003 3:01 PM > Subject: Re: JDBC Connection pooling > > > > The error you mention suggests Tyrex cannot find the hsql jdbc driver. > > The Class Loader How-To would suggest putting the hsql jar(s) in > > $TOMCAT_HOME/common/lib to make them available to both Tomcat's JNDI > > provider and your web applications. Isn't that where you have the Tyrex > > jars? > > > > >>> [EMAIL PROTECTED] 01/15/03 02:44PM >>> > > Any suggestions on what in particular to look for? I know the > > classloader > > that is spitting up on itself is the webapp classloader, because the > > exception doesn't occur until I attempt to access this application. Is > > that > > correct? > > > > ----- Original Message ----- > > From: "David Boyer" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Wednesday, January 15, 2003 2:27 PM > > Subject: Re: JDBC Connection pooling > > > > > > > For this particular error, the Tomcat classloader documentation > > would > > > probably be your best bet. > > > > > > >>> [EMAIL PROTECTED] 01/15/03 02:24PM >>> > > > When trying to get a connection pool set up, tomcat spits this > > > exception > > > back out. Nowhere in the code do I reference this class. Can > > anyone > > > point > > > me to a good HOWTO on connection pooling in tomcat 4.0.6? > > > > > > TyrexDataSourceFactory: Cannot create DataSource, Exception > > > java.lang.ClassNotFoundException: org.hsql.jdbcDriver > > > > > > > > > > > > -- > > > To unsubscribe, e-mail: > > > <mailto:[EMAIL PROTECTED]> > > > For additional commands, e-mail: > > > <mailto:[EMAIL PROTECTED]> > > > > > > > > > > > > > > -- > > To unsubscribe, e-mail: > > <mailto:[EMAIL PROTECTED]> > > For additional commands, e-mail: > > <mailto:[EMAIL PROTECTED]> > > > > > > > > > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>