Thanks, Vance. Actually, the parameter above that is "driverClassName"
the one you are looking at use to be "url", but in some server.xml files
the second parameter is "driverName" instead of "url".
If you look at the 4.0 JNDI how-to it uses the "driverName" parameter below
"driverClassName"; however, in the 4.1 JNDI how-to it used "url" after the
driverClassName. Maybe the 4.0 how-to has an error in it.
I found the bug, I think, after I uninstalled 4.0.4 and install 4.1.9. My
closing tag was "</content>" instead of "</context>. For some reason 4.0.4
did not complain about it (or else I missed the message).
Now, I have another learning issue with the 4.1.9 manager. I'll cover that
in a new thread.
"Vance
Christiaanse"
<[EMAIL PROTECTED] To
com> "Tomcat Users List"
<[EMAIL PROTECTED]>
08/30/2002 02:34 cc
PM
Subject
Re: Trouble configuring Tomcat 4.0.4
Please respond to JNDI connection to MySQL
"Tomcat Users
List"
<tomcat-user@jakar
ta.apache.org>
You need to set "driverClassName" to the proper value,
com.mysql.jdbc.Driver, not "driverName".
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: "Tomcat Users List" <[EMAIL PROTECTED]>
Cc: "Tomcat Users List" <[EMAIL PROTECTED]>
Sent: Friday, August 30, 2002 12:20 PM
Subject: Re: Trouble configuring Tomcat 4.0.4 JNDI connection to MySQL
>
> Martin's advice made a difference. When I pulled in the tc 4.1
common/lib
> jars to my tc 4.04 common/lib I got past my problem for the first time.
> The new contents of common/lib are: activation.jar,
> commons-collections.jar, commons-dbcp.jar, commons-pool.jar,
> jdbc2_0-stdext.jar, jndi.jar, jta-spec1_0_1.jar, mail.jar,
> mysql-connector-java-2.0.14-bin.jar, naming-common.jar,
naming-factory.jar,
> naming-resources.jar, servlet.jar, tools.jar, xerces.jar.
>
> Now I have a new problem which hopefully is easy to correct:
>
> java.sql.SQLException: Cannot load JDBC driver class 'null'
> at
>
org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.jav
a:529)
> at
>
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:3
12)
> at foo.DBTest.init(DBTest.java:32)
>
> I've tried setting driverName to com.mysql.jdbc.Driver,
> org.gjt.mm.mysql.Driver, and even to
> com.mysql.jdbc.jdbc2.optional.MysqlDataSource. I also tried adding
> Class.forName(...).newInstance() to my code, but it was no help either.
>
> Here is my code:
> Class.forName("com.mysql.jdbc.Driver").newInstance();
> Context ctx = new InitialContext();
> ctx.addToEnvironment(Context.INITIAL_CONTEXT_FACTORY,
> "org.apache.naming.factory.DbcpDataSourceFactory");
> //"com.sun.jndi.fscontext.RefFSContextFactory");
> if(ctx == null )throw new Exception("Boom - No Context");
> DataSource ds = (DataSource)ctx.lookup
("java:comp/env/jdbc/TestDB");
> if (ds != null) {
> Connection conn = ds.getConnection(); <---
Blows
> up here
>
> Here is my host/context:
> ...
> <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>-->
> <!-- <value>
>
com.mysql.jdbc.jdbc2.optional.MysqlDataSource</value>-->
> <value>com.mysql.jdbc.Driver</value>
> </parameter>
> <parameter>
> <name>driverName</name>
> <value>jdbc:mysql://localhost:3306/javatest</value>
> </parameter>
> </ResourceParams>
> </Content>
> </Host>
> </Engine>
> </Service>
>
> Any thoughts?
>
> Steve
>
>
>
>
> Martin Jacobson
> <[EMAIL PROTECTED]
> t>
To
> Tomcat Users List
> 08/30/2002 06:01 <[EMAIL PROTECTED]>
> AM
cc
>
>
Subject
> Please respond to Re: Trouble configuring Tomcat 4.0.4
> "Tomcat Users JNDI connection to MySQL
> List"
> <tomcat-user@jakar
> ta.apache.org>
>
>
>
>
>
>
>
> [EMAIL PROTECTED] wrote:
>
> > Vance,
> >
> > Good eye. It use to be driverName but got changed along the way to
URL.
> > Probably when I started following the 4.1 how-to. In any case, I
changed
> > back to driverName and, alas, same problem.
> >
> > Vance, do you get the same error?
> >
> > 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:194)
> > at foo.DBTest1.init(DBTest1.java:20)
> > at org.apache.jsp.DbTest1$jsp._jspService(DbTest1$jsp.java:60)
> >
>
>
> Hi, I had this problem for ages, and resolved it by retrofitting the
> DataSource factory (& connection pool) from tc4.1. The basic problem is
> that Tyrex is broken; it happened to work for some people, but not for
> me and many others :-(
>
> At this point, Craig will probably come in and say to move to tc 4.1,
> and I'd say, 'fine, as long as you don't use SSL with a standalone
> tomcat, because the Coyote connector is broken in this respect.'
>
> What you can do is download 4.1.9, remove tyrex...jar from common/lib in
> 4.0.4, and drop in the commons-*.jar files from 4.1.
>
> Here is what I have in /usr/local/tomcat/common/lib
> activation.jar
> commons-collections.jar
> commons-dbcp.jar
> commons-pool.jar
> jdbc2_0-stdext.jar
> jndi.jar
> jta-spec1_0_1.jar
> mail.jar
> mm.mysql-2.0.14-bin.jar
> naming-common.jar
> naming-factory.jar
> naming-resources.jar
> servlet.jar
> xerces.jar
>
> HTH
> Martin
>
> PS: dont forget that the <user> parameter is <username> with DBCP
>
>
>
> --
> 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]>
