Can I ask a quick question before I do that. I had my context.xml file separate, because I like that better, but it fails. When I put that context into the server.xml it worked. I am trying it again right now to make sure of this. Am I mistaken to think the context.xml file goes into webapps/<AppName>/META-INF/context.xml ?
I will post these files as requested in just a sec. Thanks for your help. 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]
