Re: JDBC Connection pooling

[Nathan McMinn]

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]>