Hello Michael,
Yesssssss, I just got it working this past evening!!!!!
I've been on it for a few days and have tried everything
I could think of. =O
To install Tomcat 4.0.2 and get JNDI working, I used
the RPM found in the standard download area named
- tomcat4-4.0.2-2.noarch.rpm
along with the dependent RPMs:
- regexp-1.2-1.noarch.rpm
- servletapi4-4.0.2-1.noarch.rpm
- xerces-j-1.4.4-2.noarch.rpm
This should create the proper user for you and install
the proper init.d start/stop scripts.
I then replaced the tomcat4/ directory that the RPM
placed on my server with the jakarta-tomcat-4.0.2/
directory found in the GZip-TAR'd regular Tomcat
install base file named jakarta-tomcat-4.0.2.tar.gz
(e.g. non-RPM version) and configured JNDI as below
and things worked!!! =)
I'm thinking that the proper libraries weren't installed
by the RPM or something in the install didn't go right???
Not sure what no-arch signifies in the RPMs above, but
maybe I was just using the wrong install????
I tried adding and replacing JARs, but I couldn't find
the right combo that would enable the JNDI resource. It
was consistent as I couldn't create a mail JNDI resource
either. If you replace the entire tomcat directory and
thus the proper JARs, you should get it working.....
Best regards,
---Ross
From: Michael Donaghy <[EMAIL PROTECTED]>
To: Ross Fujii <[EMAIL PROTECTED]>
Subject: Re: Tomcat 4.0.2 - MySQL Connection Pooling
Date: 25 Feb 2002 23:31:02 -0500
By any chance do you have your problem working yet? I think I've got a
problem very similar to yours that I've spent quite a few hours on.
Thanks!
Michael
On Fri, 2002-02-22 at 17:14, Ross Fujii wrote:
>Hello,
>
>I'm trying to setup JNDI connection pooling in Tomcat 4.0.2 to a MySQL
>(v3.23.49) database. I'm also running an Apache 1.3.20 AJP13 connector
>(using mod_jk) if that makes a difference all on a RedHat Linux 7.2 server.
>
>The following is a snippet of the JNDI resource creation in server.xml:
>
> <Host name="www.abc.com" debug="0" appBase="webapps/abc.com"
>unpackWARs="true"> <Context path="/test" docBase="test" debug="1"
> reloadable="true" privileged="true"> <Resource
>name="jdbc/TestDB" auth="Container"
>type="javax.sql.DataSource"/> <ResourceParams name="jdbc/TestDB">
> <parameter><name>user</name><value>root</value></parameter>
><parameter><name>password</name><value>aseraser</value></parameter>
> <parameter> <name>driverClassName</name>
><value>org.gjt.mm.mysql.Driver</value> </parameter>
><parameter> <name>driverName</name>
><value>jdbc:mysql://localhost/menagerie</value> </parameter>
> </ResourceParams>
>
>The following is the corresponding web.xml: <resource-ref>
> <res-ref-name>jdbc/TestDB</res-ref-name>
><res-type>javax.sql.DataSource</res-type>
><res-auth>Container</res-auth> </resource-ref>
>
>The sample code that I'm using in a servlet to grab the connection is the
>following: //Get the pooled DB connection Context initCtx =
>new InitialContext(); Context envCtx =
>(Context)initCtx.lookup("java:comp/env"); DataSource ds =
>(DataSource)envCtx.lookup("jdbc/TestDB");
>
> //Connect to the DB data source and run a query ....
>
>The exception that is being thrown is:
>
> javax.naming.NamingException: Cannot create resource instance
>
>I was wondering if there is somemthing that I'm still missing???
>
>Some other notes: -- Have setup connection pooling to SQL 2000 DB on
>Windows 2000 using Tomcat 4.0.2b1 with no problem. -- Have coded a
>stand-alone application that works and is able to connect to MySQL and
>query the DB with no problems -- Have upgraded to the latest MySQL 2.0.11
>driver
>
>Any help or advice would be greatly appreciated. Thanks in advance, --Ross
>
>--
>To unsubscribe: <mailto:[EMAIL PROTECTED]> For
>additional commands: <mailto:[EMAIL PROTECTED]> Troubles
>with the list: <mailto:[EMAIL PROTECTED]>
_________________________________________________________________
Join the world�s largest e-mail service with MSN Hotmail.
http://www.hotmail.com
--
To unsubscribe: <mailto:[EMAIL PROTECTED]>
For additional commands: <mailto:[EMAIL PROTECTED]>
Troubles with the list: <mailto:[EMAIL PROTECTED]>
