You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by neal <ne...@yahoo.com> on 2002/08/29 06:00:21 UTC

Setting up connection pooling via JNDI

I did a search on the Apache site and finally found reference to "commons"
... a subproject that has a bunch of the code referred to in the how-to for
JDNI setup, including collections, DBCP, and pool.

Do I really have to setup all this junk?  For crying out loud ... why is
this not bundled (or is it) with Tomcat4??!?!?!

Thanks.
Neal


--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>


RE: Setting up connection pooling via JNDI

Posted by neal <ne...@yahoo.com>.
Yeah, I just downloaded the jars and I think I'll give this a shot.

Thanks.
Neal


-----Original Message-----
From: Andrew Conrad [mailto:andrewconrad@attbi.com]
Sent: Wednesday, August 28, 2002 10:29 PM
To: 'Tomcat Users List'
Subject: RE: Setting up connection pooling via JNDI


Just drop the pool, dbcp, and commons into common/lib like you
mentioned.  Then follow the guide.  In Tomcat 4.1 you don't have to put
the factory parameter in your JNDI setup, but it will be required for
4.0.x.

4.0.x comes with Tyrex, but it has had problems and they are dropping
it.  You would be better off working with DBCP, IMO.


- Andrew

> -----Original Message-----
> From: micael [mailto:caraunltd@harbornet.com]
> Sent: Thursday, August 29, 2002 1:16 AM
> To: Tomcat Users List
> Subject: RE: Setting up connection pooling via JNDI
>
>
> How can you know about the directory and not have looked in
> there?  Weren't
> you remotely curious before putting out all these emails?  I
> usually have
> patience, but scheeeszzche!
>
> At 10:02 PM 8/28/2002 -0700, you wrote:
> >Nope.
> >
> >I read somewhere that its bundled with v4.1.  I'm using
> 4.0.4.   So, I guess
> >I have to download DBCP, collections, and pool and place
> them into my
> >common/lib dir (???).
> >
> >Neal
> >
> >
> >-----Original Message-----
> >From: Jacob Hookom [mailto:hookomjj@uwec.edu]
> >Sent: Wednesday, August 28, 2002 9:19 PM
> >To: 'Tomcat Users List'
> >Subject: RE: Setting up connection pooling via JNDI
> >
> >
> >It is, check out the common lib in your tomcat install....
> you will see
> >the libraries in there.
> >
> >| -----Original Message-----
> >| From: neal [mailto:nealcabage@yahoo.com]
> >| Sent: Wednesday, August 28, 2002 11:00 PM
> >| To: Tomcat Users List
> >| Subject: Setting up connection pooling via JNDI
> >|
> >| I did a search on the Apache site and finally found reference to
> >"commons"
> >| ... a subproject that has a bunch of the code referred to in the
> >how-to
> >| for
> >| JDNI setup, including collections, DBCP, and pool.
> >|
> >| Do I really have to setup all this junk?  For crying out
> loud ... why
> >is
> >| this not bundled (or is it) with Tomcat4??!?!?!
> >|
> >| Thanks.
> >| Neal
> >|
> >|
> >| --
> >| To unsubscribe, e-mail:   <mailto:tomcat-user-
> >| unsubscribe@jakarta.apache.org>
> >| For additional commands, e-mail: <mailto:tomcat-user-
> >| help@jakarta.apache.org>
> >|
> >| ---
> >| Incoming mail is certified Virus Free.
> >| Checked by AVG anti-virus system (http://www.grisoft.com).
> >| Version: 6.0.381 / Virus Database: 214 - Release Date: 8/2/2002
> >|
> >
> >---
> >Outgoing mail is certified Virus Free.
> >Checked by AVG anti-virus system (http://www.grisoft.com).
> >Version: 6.0.381 / Virus Database: 214 - Release Date: 8/2/2002
> >
> >
> >
> >--
> >To unsubscribe, e-mail:
> ><ma...@jakarta.apache.org>
> >For additional commands, e-mail:
> ><ma...@jakarta.apache.org>
> >
> >
> >--
> >To unsubscribe, e-mail:
> <mailto:tomcat-user-> unsubscribe@jakarta.apache.org>
> >For
> additional commands,
> e-mail:
> ><ma...@jakarta.apache.org>
>
>
>
> --
> To unsubscribe, e-mail:
> <mailto:tomcat-user-> unsubscribe@jakarta.apache.org>
> For
> additional commands,
> e-mail: <ma...@jakarta.apache.org>
>


--
To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
For additional commands, e-mail:
<ma...@jakarta.apache.org>


--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>


RE: Setting up connection pooling via JNDI

Posted by Andrew Conrad <an...@attbi.com>.
Just drop the pool, dbcp, and commons into common/lib like you
mentioned.  Then follow the guide.  In Tomcat 4.1 you don't have to put
the factory parameter in your JNDI setup, but it will be required for
4.0.x.  

4.0.x comes with Tyrex, but it has had problems and they are dropping
it.  You would be better off working with DBCP, IMO.


- Andrew

> -----Original Message-----
> From: micael [mailto:caraunltd@harbornet.com] 
> Sent: Thursday, August 29, 2002 1:16 AM
> To: Tomcat Users List
> Subject: RE: Setting up connection pooling via JNDI
> 
> 
> How can you know about the directory and not have looked in 
> there?  Weren't 
> you remotely curious before putting out all these emails?  I 
> usually have 
> patience, but scheeeszzche!
> 
> At 10:02 PM 8/28/2002 -0700, you wrote:
> >Nope.
> >
> >I read somewhere that its bundled with v4.1.  I'm using 
> 4.0.4.   So, I guess
> >I have to download DBCP, collections, and pool and place 
> them into my 
> >common/lib dir (???).
> >
> >Neal
> >
> >
> >-----Original Message-----
> >From: Jacob Hookom [mailto:hookomjj@uwec.edu]
> >Sent: Wednesday, August 28, 2002 9:19 PM
> >To: 'Tomcat Users List'
> >Subject: RE: Setting up connection pooling via JNDI
> >
> >
> >It is, check out the common lib in your tomcat install.... 
> you will see 
> >the libraries in there.
> >
> >| -----Original Message-----
> >| From: neal [mailto:nealcabage@yahoo.com]
> >| Sent: Wednesday, August 28, 2002 11:00 PM
> >| To: Tomcat Users List
> >| Subject: Setting up connection pooling via JNDI
> >|
> >| I did a search on the Apache site and finally found reference to
> >"commons"
> >| ... a subproject that has a bunch of the code referred to in the
> >how-to
> >| for
> >| JDNI setup, including collections, DBCP, and pool.
> >|
> >| Do I really have to setup all this junk?  For crying out 
> loud ... why
> >is
> >| this not bundled (or is it) with Tomcat4??!?!?!
> >|
> >| Thanks.
> >| Neal
> >|
> >|
> >| --
> >| To unsubscribe, e-mail:   <mailto:tomcat-user-
> >| unsubscribe@jakarta.apache.org>
> >| For additional commands, e-mail: <mailto:tomcat-user- 
> >| help@jakarta.apache.org>
> >|
> >| ---
> >| Incoming mail is certified Virus Free.
> >| Checked by AVG anti-virus system (http://www.grisoft.com).
> >| Version: 6.0.381 / Virus Database: 214 - Release Date: 8/2/2002
> >|
> >
> >---
> >Outgoing mail is certified Virus Free.
> >Checked by AVG anti-virus system (http://www.grisoft.com).
> >Version: 6.0.381 / Virus Database: 214 - Release Date: 8/2/2002
> >
> >
> >
> >--
> >To unsubscribe, e-mail: 
> ><ma...@jakarta.apache.org>
> >For additional commands, e-mail: 
> ><ma...@jakarta.apache.org>
> >
> >
> >--
> >To unsubscribe, e-mail:   
> <mailto:tomcat-user-> unsubscribe@jakarta.apache.org>
> >For 
> additional commands, 
> e-mail: 
> ><ma...@jakarta.apache.org>
> 
> 
> 
> --
> To unsubscribe, e-mail:   
> <mailto:tomcat-user-> unsubscribe@jakarta.apache.org>
> For 
> additional commands, 
> e-mail: <ma...@jakarta.apache.org>
> 


--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>


RE: Setting up connection pooling via JNDI

Posted by "Craig R. McClanahan" <cr...@apache.org>.

On Wed, 28 Aug 2002, neal wrote:

> Date: Wed, 28 Aug 2002 22:25:32 -0700
> From: neal <ne...@yahoo.com>
> Reply-To: Tomcat Users List <to...@jakarta.apache.org>
> To: Tomcat Users List <to...@jakarta.apache.org>
> Subject: RE: Setting up connection pooling via JNDI
>
> As usual Michael, I appreciate you sarcasm.
>
> I *DID* look in that directory.  THEY'RE NOT THERE!!!!!!
>
> The three jar files that are there are:
> 	naming-common.jar
> 	naming-resources.jar
> 	servlet.jar
> 	tools.jar
>
> I am using version 4.0.4.  As I stated in the below referenced email, I read
> that these were added back into version 4.1 ... apparently there's something
> else (Tyrex??) being used in the version of Tomcat I have installed.
>
> If there's something I'm missing then please ... spell it out for me!
>

If you'd told us what document you were looking at that said you needed
dbcp and so on, it would have helped, because you're either looking at
incorrect docs for your version of Tomcat, or you are misunderstanding the
requirements.

Tomcat 4.0.x does *not* require the commons packages -- it *does* include
everything you need except for the JDBC driver.

> Neal
>

Craig


>
> -----Original Message-----
> From: micael [mailto:caraunltd@harbornet.com]
> Sent: Wednesday, August 28, 2002 10:16 PM
> To: Tomcat Users List
> Subject: RE: Setting up connection pooling via JNDI
>
>
> How can you know about the directory and not have looked in there?  Weren't
> you remotely curious before putting out all these emails?  I usually have
> patience, but scheeeszzche!
>
> At 10:02 PM 8/28/2002 -0700, you wrote:
> >Nope.
> >
> >I read somewhere that its bundled with v4.1.  I'm using 4.0.4.   So, I
> guess
> >I have to download DBCP, collections, and pool and place them into my
> >common/lib dir (???).
> >
> >Neal
> >
> >
> >-----Original Message-----
> >From: Jacob Hookom [mailto:hookomjj@uwec.edu]
> >Sent: Wednesday, August 28, 2002 9:19 PM
> >To: 'Tomcat Users List'
> >Subject: RE: Setting up connection pooling via JNDI
> >
> >
> >It is, check out the common lib in your tomcat install.... you will see
> >the libraries in there.
> >
> >| -----Original Message-----
> >| From: neal [mailto:nealcabage@yahoo.com]
> >| Sent: Wednesday, August 28, 2002 11:00 PM
> >| To: Tomcat Users List
> >| Subject: Setting up connection pooling via JNDI
> >|
> >| I did a search on the Apache site and finally found reference to
> >"commons"
> >| ... a subproject that has a bunch of the code referred to in the
> >how-to
> >| for
> >| JDNI setup, including collections, DBCP, and pool.
> >|
> >| Do I really have to setup all this junk?  For crying out loud ... why
> >is
> >| this not bundled (or is it) with Tomcat4??!?!?!
> >|
> >| Thanks.
> >| Neal
> >|
> >|
> >| --
> >| To unsubscribe, e-mail:   <mailto:tomcat-user-
> >| unsubscribe@jakarta.apache.org>
> >| For additional commands, e-mail: <mailto:tomcat-user-
> >| help@jakarta.apache.org>
> >|
> >| ---
> >| Incoming mail is certified Virus Free.
> >| Checked by AVG anti-virus system (http://www.grisoft.com).
> >| Version: 6.0.381 / Virus Database: 214 - Release Date: 8/2/2002
> >|
> >
> >---
> >Outgoing mail is certified Virus Free.
> >Checked by AVG anti-virus system (http://www.grisoft.com).
> >Version: 6.0.381 / Virus Database: 214 - Release Date: 8/2/2002
> >
> >
> >
> >--
> >To unsubscribe, e-mail:
> ><ma...@jakarta.apache.org>
> >For additional commands, e-mail:
> ><ma...@jakarta.apache.org>
> >
> >
> >--
> >To unsubscribe, e-mail:
> <ma...@jakarta.apache.org>
> >For additional commands, e-mail:
> <ma...@jakarta.apache.org>
>
>
>
> --
> To unsubscribe, e-mail:
> <ma...@jakarta.apache.org>
> For additional commands, e-mail:
> <ma...@jakarta.apache.org>
>
>
> --
> To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
> For additional commands, e-mail: <ma...@jakarta.apache.org>
>
>


--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>


RE: Setting up connection pooling via JNDI

Posted by neal <ne...@yahoo.com>.
As usual Michael, I appreciate you sarcasm.

I *DID* look in that directory.  THEY'RE NOT THERE!!!!!!

The three jar files that are there are:
	naming-common.jar
	naming-resources.jar
	servlet.jar
	tools.jar

I am using version 4.0.4.  As I stated in the below referenced email, I read
that these were added back into version 4.1 ... apparently there's something
else (Tyrex??) being used in the version of Tomcat I have installed.

If there's something I'm missing then please ... spell it out for me!

Neal


-----Original Message-----
From: micael [mailto:caraunltd@harbornet.com]
Sent: Wednesday, August 28, 2002 10:16 PM
To: Tomcat Users List
Subject: RE: Setting up connection pooling via JNDI


How can you know about the directory and not have looked in there?  Weren't
you remotely curious before putting out all these emails?  I usually have
patience, but scheeeszzche!

At 10:02 PM 8/28/2002 -0700, you wrote:
>Nope.
>
>I read somewhere that its bundled with v4.1.  I'm using 4.0.4.   So, I
guess
>I have to download DBCP, collections, and pool and place them into my
>common/lib dir (???).
>
>Neal
>
>
>-----Original Message-----
>From: Jacob Hookom [mailto:hookomjj@uwec.edu]
>Sent: Wednesday, August 28, 2002 9:19 PM
>To: 'Tomcat Users List'
>Subject: RE: Setting up connection pooling via JNDI
>
>
>It is, check out the common lib in your tomcat install.... you will see
>the libraries in there.
>
>| -----Original Message-----
>| From: neal [mailto:nealcabage@yahoo.com]
>| Sent: Wednesday, August 28, 2002 11:00 PM
>| To: Tomcat Users List
>| Subject: Setting up connection pooling via JNDI
>|
>| I did a search on the Apache site and finally found reference to
>"commons"
>| ... a subproject that has a bunch of the code referred to in the
>how-to
>| for
>| JDNI setup, including collections, DBCP, and pool.
>|
>| Do I really have to setup all this junk?  For crying out loud ... why
>is
>| this not bundled (or is it) with Tomcat4??!?!?!
>|
>| Thanks.
>| Neal
>|
>|
>| --
>| To unsubscribe, e-mail:   <mailto:tomcat-user-
>| unsubscribe@jakarta.apache.org>
>| For additional commands, e-mail: <mailto:tomcat-user-
>| help@jakarta.apache.org>
>|
>| ---
>| Incoming mail is certified Virus Free.
>| Checked by AVG anti-virus system (http://www.grisoft.com).
>| Version: 6.0.381 / Virus Database: 214 - Release Date: 8/2/2002
>|
>
>---
>Outgoing mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.381 / Virus Database: 214 - Release Date: 8/2/2002
>
>
>
>--
>To unsubscribe, e-mail:
><ma...@jakarta.apache.org>
>For additional commands, e-mail:
><ma...@jakarta.apache.org>
>
>
>--
>To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
>For additional commands, e-mail:
<ma...@jakarta.apache.org>



--
To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
For additional commands, e-mail:
<ma...@jakarta.apache.org>


--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>


RE: Setting up connection pooling via JNDI

Posted by micael <ca...@harbornet.com>.
How can you know about the directory and not have looked in there?  Weren't 
you remotely curious before putting out all these emails?  I usually have 
patience, but scheeeszzche!

At 10:02 PM 8/28/2002 -0700, you wrote:
>Nope.
>
>I read somewhere that its bundled with v4.1.  I'm using 4.0.4.   So, I guess
>I have to download DBCP, collections, and pool and place them into my
>common/lib dir (???).
>
>Neal
>
>
>-----Original Message-----
>From: Jacob Hookom [mailto:hookomjj@uwec.edu]
>Sent: Wednesday, August 28, 2002 9:19 PM
>To: 'Tomcat Users List'
>Subject: RE: Setting up connection pooling via JNDI
>
>
>It is, check out the common lib in your tomcat install.... you will see
>the libraries in there.
>
>| -----Original Message-----
>| From: neal [mailto:nealcabage@yahoo.com]
>| Sent: Wednesday, August 28, 2002 11:00 PM
>| To: Tomcat Users List
>| Subject: Setting up connection pooling via JNDI
>|
>| I did a search on the Apache site and finally found reference to
>"commons"
>| ... a subproject that has a bunch of the code referred to in the
>how-to
>| for
>| JDNI setup, including collections, DBCP, and pool.
>|
>| Do I really have to setup all this junk?  For crying out loud ... why
>is
>| this not bundled (or is it) with Tomcat4??!?!?!
>|
>| Thanks.
>| Neal
>|
>|
>| --
>| To unsubscribe, e-mail:   <mailto:tomcat-user-
>| unsubscribe@jakarta.apache.org>
>| For additional commands, e-mail: <mailto:tomcat-user-
>| help@jakarta.apache.org>
>|
>| ---
>| Incoming mail is certified Virus Free.
>| Checked by AVG anti-virus system (http://www.grisoft.com).
>| Version: 6.0.381 / Virus Database: 214 - Release Date: 8/2/2002
>|
>
>---
>Outgoing mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.381 / Virus Database: 214 - Release Date: 8/2/2002
>
>
>
>--
>To unsubscribe, e-mail:
><ma...@jakarta.apache.org>
>For additional commands, e-mail:
><ma...@jakarta.apache.org>
>
>
>--
>To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
>For additional commands, e-mail: <ma...@jakarta.apache.org>



--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>


RE: Setting up connection pooling via JNDI

Posted by st...@teamics.com.
I'm still struggling to make basic JNDI work with MySQL.  I've download all
the jars you mentioned, but I keep getting the following error during
context lookup:

javax.naming.NamingException: Exception creating DataSource:
org.hsql.jdbcDriver
     at org.apache.naming.NamingContext.lookup(NamingContext.java:842)
     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:351)
     at foo.DBTest1.init(DBTest1.java:19)
     at org.apache.jsp.DbTest1$jsp._jspService(DbTest1$jsp.java:60)

Why would it be looking for a Hypersonic SQL driver?  I took a shot and
copied Hypersonic 1.61 hsqldb.jar to /common/lib, but when it had no effect
I removed it.

I'm currently running
Tomcat 4.04
MySQL 4.0.2-Alpha
MySQL Connector 2.0.14. (I copied mysql-connector-java-2.0.14-bin.jar and
jdbc2_0-stdext.jar to $TOMCAT_HOME/common/lib,)
Collections 2.0
Pool 1.0
DBCP 1.0

I get the same error no matter what code I run.  For example, Both code
blocks below result in the same error:
     Context ctx = new InitialContext();
     ctx.addToEnvironment(Context.INITIAL_CONTEXT_FACTORY,
          "com.sun.jndi.fscontext.RefFSContextFactory");
     Connection conn = ds.getConnection();
     if(ctx == null )
          throw new Exception("Boom - No Context");
     DataSource ds = (DataSource)ctx.lookup(
          "java:comp/env/jdbc/TestDB");              <-- Blows up here
--- AND ---
      Context ctx = new InitialContext();
      if(ctx == null )
          throw new Exception("Boom - No Context");
      DataSource ds =
            (DataSource)ctx.lookup(
               "java:comp/env/jdbc/TestDB");                       <--
Blows up here

I added the following to the web.xml file:
<resource-ref id="ResourceRef_TestDB">
      <description>DB Connection</description>
     <res-ref-name>jdbc/TestDB</res-ref-name>
     <res-type>javax.sql.DataSource</res-type>
     <res-auth>Container</res-auth>
</resource-ref>

Here is my server.xml file:

<Server port="8005" shutdown="SHUTDOWN" debug="0">
  <Service name="Tomcat-Standalone">
    <!-- Define a non-SSL HTTP/1.1 Connector on port 8080 -->
    <Connector className="org.apache.catalina.connector.http.HttpConnector"
               port="8080" minProcessors="5" maxProcessors="75"
               enableLookups="true" redirectPort="8443"
               acceptCount="10" debug="0" connectionTimeout="60000"/>
    <!-- Define the top level container in our container hierarchy -->
    <Engine name="Standalone" defaultHost="localhost" debug="0">
      <!-- Global logger unless overridden at lower levels -->
      <Logger className="org.apache.catalina.logger.FileLogger"
              prefix="catalina_log." suffix=".txt"
              timestamp="true"/>
      <Realm  className="org.apache.catalina.realm.JDBCRealm" debug="99"
             driverName="org.gjt.mm.mysql.Driver"
          connectionURL
="jdbc:mysql://localhost/authority?user=javauser;password=javadude"
              userTable="users" userNameCol="user_name" userCredCol
="user_pass"
          userRoleTable="user_roles" roleNameCol="role_name" />
      <!-- Define the default virtual host -->
      <Host name="localhost" debug="0" appBase="webapps" unpackWARs="true">
        <Valve className="org.apache.catalina.valves.AccessLogValve"
                 directory="logs"  prefix="localhost_access_log." suffix
=".txt"
                 pattern="common"/>
        <Logger className="org.apache.catalina.logger.FileLogger"
                 directory="logs"  prefix="localhost_log." suffix=".txt"
             timestamp="true"/>
        <!-- Tomcat Root Context -->
        <!--
          <Context path="" docBase="ROOT" debug="0"/>
        -->

        <!-- Tomcat Manager Context -->
        <Context path="/manager" docBase="manager"
         debug="0" privileged="true"/>

        <!-- Security Test -->
         <Context path="/stewart" docBase="stewart" debug="0"
                  reloadable="true" crossContext="true">
           <Logger className="org.apache.catalina.logger.FileLogger"
                      prefix="localhost_examples_log." suffix=".txt"
            timestamp="true"/>
          <Manager className
="org.apache.catalina.session.PersistentManager"
              debug="0"
              saveOnRestart="true"
              maxActiveSessions="-1"
              minIdleSwap="-1"
              maxIdleSwap="-1"
              maxIdleBackup="-1">
                <Store className="org.apache.catalina.session.FileStore"/>
          </Manager>
        </Context>
        <!-- Test JDBC to MySql -->
            <Context path="/DBTest" docBase="DBTest"
                    debug="5" reloadable="true" crossContext="true">

              <Logger className="org.apache.catalina.logger.FileLogger"
                         prefix="localhost_DBTest_log." suffix=".txt"
                         timestamp="true"/>

              <Resource name="jdbc/TestDB"
                           auth="Container"
                           type="javax.sql.DataSource"/>
              <ResourceParams name="jdbc/TestDB">
                <parameter>
                  <name>factory</name>

<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
                </parameter>
                <parameter>
                  <name>maxActive</name>
                  <value>100</value>
                </parameter>
                <parameter>
                  <name>maxIdle</name>
                  <value>30000</value>
                </parameter>
                <parameter>
                  <name>maxWait</name>
                  <value>100</value>
                </parameter>
                <parameter>
                 <name>username</name>
                 <value>javauser</value>
                </parameter>
                <parameter>
                 <name>password</name>
                 <value>javadude</value>
                </parameter>

                <parameter>
                   <name>driverClassName</name>
                   <value>org.gjt.mm.mysql.Driver</value>
                </parameter>

                <parameter>
                  <name>url</name>
                  <value>jdbc:mysql://localhost:3306/javatest</value>
                </parameter>
              </ResourceParams>
     </Context>
      </Host>

    </Engine>

  </Service>

 <!-- Define an Apache-Connector Service -->
  <Service name="Tomcat-Apache">

    <Connector className="org.apache.catalina.connector.warp.WarpConnector"
     port="8008" minProcessors="5" maxProcessors="75"
     enableLookups="true"
     acceptCount="10" debug="0"/>

    <!-- Replace "localhost" with what your Apache "ServerName" is set to
-->
    <Engine className="org.apache.catalina.connector.warp.WarpEngine"
     name="Apache" defaultHost="localhost" debug="0" appBase="webapps">

      <!-- Global logger unless overridden at lower levels -->
      <Logger className="org.apache.catalina.logger.FileLogger"
              prefix="apache_log." suffix=".txt"
              timestamp="true"/>

      <!-- Because this Realm is here, an instance will be shared globally
-->
      <Realm className="org.apache.catalina.realm.MemoryRealm" />

    </Engine>

  </Service>

</Server>

Any ideas?

Steve Mitchell
e-Business Architect/Developer
Integrated Corporate Solutions, Inc.
913-685-6506
stevem@teamics.com



                                                                           
           "neal"                                                          
           <nealcabage@yahoo.                                              
           com>                                                         To 
                                     "Tomcat Users List"                   
           08/29/2002 12:02          <to...@jakarta.apache.org>      
           AM                                                           cc 
                                                                           
                                                                   Subject 
           Please respond to         RE: Setting up connection pooling via 
             "Tomcat Users           JNDI                                  
                 List"                                                     
           <tomcat-user@jakar                                              
             ta.apache.org>                                                
                                                                           
                                                                           
                                                                           




Nope.

I read somewhere that its bundled with v4.1.  I'm using 4.0.4.   So, I
guess
I have to download DBCP, collections, and pool and place them into my
common/lib dir (???).

Neal


-----Original Message-----
From: Jacob Hookom [mailto:hookomjj@uwec.edu]
Sent: Wednesday, August 28, 2002 9:19 PM
To: 'Tomcat Users List'
Subject: RE: Setting up connection pooling via JNDI


It is, check out the common lib in your tomcat install.... you will see
the libraries in there.

| -----Original Message-----
| From: neal [mailto:nealcabage@yahoo.com]
| Sent: Wednesday, August 28, 2002 11:00 PM
| To: Tomcat Users List
| Subject: Setting up connection pooling via JNDI
|
| I did a search on the Apache site and finally found reference to
"commons"
| ... a subproject that has a bunch of the code referred to in the
how-to
| for
| JDNI setup, including collections, DBCP, and pool.
|
| Do I really have to setup all this junk?  For crying out loud ... why
is
| this not bundled (or is it) with Tomcat4??!?!?!
|
| Thanks.
| Neal
|
|
| --
| To unsubscribe, e-mail:   <mailto:tomcat-user-
| unsubscribe@jakarta.apache.org>
| For additional commands, e-mail: <mailto:tomcat-user-
| help@jakarta.apache.org>
|
| ---
| Incoming mail is certified Virus Free.
| Checked by AVG anti-virus system (http://www.grisoft.com).
| Version: 6.0.381 / Virus Database: 214 - Release Date: 8/2/2002
|

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.381 / Virus Database: 214 - Release Date: 8/2/2002



--
To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
For additional commands, e-mail:
<ma...@jakarta.apache.org>


--
To unsubscribe, e-mail:   <
mailto:tomcat-user-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <
mailto:tomcat-user-help@jakarta.apache.org>





--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>


RE: Setting up connection pooling via JNDI

Posted by neal <ne...@yahoo.com>.
Nope.

I read somewhere that its bundled with v4.1.  I'm using 4.0.4.   So, I guess
I have to download DBCP, collections, and pool and place them into my
common/lib dir (???).

Neal


-----Original Message-----
From: Jacob Hookom [mailto:hookomjj@uwec.edu]
Sent: Wednesday, August 28, 2002 9:19 PM
To: 'Tomcat Users List'
Subject: RE: Setting up connection pooling via JNDI


It is, check out the common lib in your tomcat install.... you will see
the libraries in there.

| -----Original Message-----
| From: neal [mailto:nealcabage@yahoo.com]
| Sent: Wednesday, August 28, 2002 11:00 PM
| To: Tomcat Users List
| Subject: Setting up connection pooling via JNDI
|
| I did a search on the Apache site and finally found reference to
"commons"
| ... a subproject that has a bunch of the code referred to in the
how-to
| for
| JDNI setup, including collections, DBCP, and pool.
|
| Do I really have to setup all this junk?  For crying out loud ... why
is
| this not bundled (or is it) with Tomcat4??!?!?!
|
| Thanks.
| Neal
|
|
| --
| To unsubscribe, e-mail:   <mailto:tomcat-user-
| unsubscribe@jakarta.apache.org>
| For additional commands, e-mail: <mailto:tomcat-user-
| help@jakarta.apache.org>
|
| ---
| Incoming mail is certified Virus Free.
| Checked by AVG anti-virus system (http://www.grisoft.com).
| Version: 6.0.381 / Virus Database: 214 - Release Date: 8/2/2002
|

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.381 / Virus Database: 214 - Release Date: 8/2/2002



--
To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
For additional commands, e-mail:
<ma...@jakarta.apache.org>


--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>


RE: Setting up connection pooling via JNDI

Posted by Jacob Hookom <ho...@uwec.edu>.
It is, check out the common lib in your tomcat install.... you will see
the libraries in there.

| -----Original Message-----
| From: neal [mailto:nealcabage@yahoo.com]
| Sent: Wednesday, August 28, 2002 11:00 PM
| To: Tomcat Users List
| Subject: Setting up connection pooling via JNDI
| 
| I did a search on the Apache site and finally found reference to
"commons"
| ... a subproject that has a bunch of the code referred to in the
how-to
| for
| JDNI setup, including collections, DBCP, and pool.
| 
| Do I really have to setup all this junk?  For crying out loud ... why
is
| this not bundled (or is it) with Tomcat4??!?!?!
| 
| Thanks.
| Neal
| 
| 
| --
| To unsubscribe, e-mail:   <mailto:tomcat-user-
| unsubscribe@jakarta.apache.org>
| For additional commands, e-mail: <mailto:tomcat-user-
| help@jakarta.apache.org>
| 
| ---
| Incoming mail is certified Virus Free.
| Checked by AVG anti-virus system (http://www.grisoft.com).
| Version: 6.0.381 / Virus Database: 214 - Release Date: 8/2/2002
| 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.381 / Virus Database: 214 - Release Date: 8/2/2002
 


--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>