Re: JDBC problems with MySQL

[Adam Hardy]

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]