I got this to work by either placing the context directly into the server.xml file or placing the xml file into it's correct location in /usr/local/tomcat/conf/Catalina/localhost/DBTest.xml
Not exactly sure the reason, but it is working now. Steve -----Original Message----- From: Kawthar Bt M Sulaiman [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 16, 2004 9:09 PM To: [EMAIL PROTECTED] Subject: RE: JDBC problems with MySQL I got the same error message as yours. Still trying to figure out myself..... --Kawthar >>> [EMAIL PROTECTED] 17/03/2004 05:46:43 AM >>> It appears the attachment is stripped off.. Makes sense.. Here is the file. [wolfgang]# cat context.xml <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> <!-- Maximum number of dB connections in pool. Make sure you configure your mysqld max_connections large enough to handle all of your db connections. Set to 0 for no limit. --> <parameter> <name>maxActive</name> <value>100</value> </parameter> <!-- Maximum number of idle dB connections to retain in pool. Set to 0 for no limit. --> <parameter> <name>maxIdle</name> <value>30</value> </parameter> <!-- Maximum time to wait for a dB connection to become available in ms, in this example 10 seconds. An Exception is thrown if this timeout is exceeded. Set to -1 to wait indefinitely. --> <parameter> <name>maxWait</name> <value>10000</value> </parameter> <!-- MySQL dB username and password for dB connections --> <parameter> <name>username</name> <value>javauser</value> </parameter> <parameter> <name>password</name> <value>javadude</value> </parameter> <!-- Class name for mm.mysql JDBC driver --> <parameter> <name>driverClassName</name> <value>com.mysql.jdbc.Driver</value> </parameter> <!-- The JDBC connection url for connecting to your MySQL dB. The autoReconnect=true argument to the url makes sure that the mm.mysql JDBC Driver will automatically reconnect if mysqld closed the connection. mysqld by default closes idle connections after 8 hours. --> <parameter> <name>url</name> <value>jdbc:mysql://localhost/javatest?autoReconnect=true</value> </parameter> </ResourceParams> </Context> [wolfgang]# -----Original Message----- From: Steve Gums [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 16, 2004 2:38 PM To: 'Tomcat Users List' Subject: RE: JDBC problems with MySQL The .cap file can be open with notepad or whatever. I have it in the META-INF directory. If I copy the contents of this into the server.xml file it starts to work. Gotta be something simple that I am doing wrong here. Steve -----Original Message----- From: Adam Hardy [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 16, 2004 2:07 PM To: Tomcat Users List Subject: Re: JDBC problems with MySQL Steve, post the Resource & ResourceParams tags from your context for the webapp. State whether it's in a context.xml file, server.xml or whatever. Perhaps we can spot something. Adam ps this email has got some weird font - my mail reader is up the creek at the mo'. sorry On 03/16/2004 09:47 PM Steve Gums wrote: > Just an update. > I included a file, that works great on my webapp that is already running on > an old system, and you can see the change I made, which allows the app to > run. Not sure if this helps anyone. > > package com.voast.vkey.utils; > > import java.io.*; > import java.sql.*; > import javax.sql.*; > import javax.naming.*; > > public class DBUtils { > > public static Connection getConnection () throws Exception { > > Connection con = null; > /* Trying to figure this error out. --Temp comment-- > try { > Context ctx = new InitialContext(); > if ( ctx == null ) { > throw new Exception ("No Context"); > } > DataSource ds; > ds = (DataSource)ctx.lookup("java:comp/env/jdbc/VKEYDB"); > if ( ds != null ) { > con = ds.getConnection (); > }//end ds != null > }//try > catch ( Exception e ) { > LoggerUtil.globalLog ("ERROR","exception occured: " + > e.toString() ); > throw (e); > }//catch > */ > try { > Class.forName("com.mysql.jdbc.Driver").newInstance(); > con = DriverManager.getConnection("jdbc:mysql://localhost/vkey", > "<USER>","<PASSWORD>"); > }//try > catch (Exception e) { > LoggerUtil.globalLog ("DEBUG","exception occured: " + > e.toString() ); > throw (e); > }//catch > > return con; > > }//GetConnection > > }//DBUtils > > -----Original Message----- > From: Steve Gums [mailto:[EMAIL PROTECTED] > Sent: Tuesday, March 16, 2004 10:57 AM > To: [EMAIL PROTECTED] > Subject: JDBC problems with MySQL > > Users > > I know there has been a bazillion messages about this. I > searched the archives and couldn't find anything to solve my extremely > annoying issue. It has to be something really simple but I just can't find > it. > > > > My System: > > Solaris 9 > > Tomcat 5.0.19 > > MySQL 4.0.18 > > Connector J 3.0.11 > > > > I have the connector J jar in the /usr/local/tomcat/common/lib dir. > > I have basically copied the HOW-TO located at. > > http://jakarta.apache.org/tomcat/tomcat-5.0-doc/jndi-datasource-examples-how > to.html > > > > and my result is this. > > > Results > > > Foo Not Connected > Bar -1 > > > > I have tried everything I can think of. I verified the database and the > user/password combo. Works good. I even created a simple Java app that > connects and performs queries, which worked. That would indicate everything > is cool with the Connector J. I have verified that the jdbc/TestDB is in > the context and it is. As best I can tell ds (DataSource) is coming back > not null, but the call to getConnection is failing. I created a little more > verbose web app and get the following message. > > org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of > class '' for connect URL 'null', cause: No suitable driver > > > > This has to be something simple, because this works fine on my old machine. > I know I am forgetting some small step that I did the first time and failed > to do again. Trust me I have checked the configs about a million times, and > can't find any differences. Any help would be appreciated. > > > > Sorry to be so vague here, but this is really simple. I don't know what else > to include for info. > > > > Steve Gums > > [EMAIL PROTECTED] > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > -- struts 1.1 + tomcat 5.0.16 + java 1.4.2 Linux 2.4.20 Debian --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]