tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Web master <webmas...@unni.com>
Subject Re: MySQL question - No suitable driver
Date Tue, 27 Feb 2001 21:23:07 GMT

I am using the MySql and I don't have any problem. Please check my db 
code below. One more thing, if you are using win '98 then use 8.3 
filename format in the class path.

public mysql_db(String uid, String pwd)
{
 
  try
  {
      Class.forName("org.gjt.mm.mysql.Driver").newInstance();
  } catch (Exception e)
  {
  System.out.println(e);
  return;
  }

  try
  {
      con = DriverManager.getConnection(
                 "jdbc:mysql://localhost:3306/test",uid,pwd);
  stmt = con.createStatement();
  } catch (Exception e)
  {
  System.out.println(e);
  return;
  }
}


Wong, Connie wrote:

> Hi,
> 
> I try to connect a servlet talk to the MySQL database.
>      I set:
>              
>      drivername = "org.gjt.mm.mysql.Driver" and
>                  url = "jdbc:mysql:tbl_data"
> 
> I downloaded MyODBC and fill in the ODBC setup and add the
> "mm_mysql-2_0_2-bin.jar" in the classpath.
> 
> When I run my servlet on the browser, it display the following Exception:
> 
> 
> java.sql.SQLException: No suitable driver at
> java.sql.DriverManager.getConnection(DriverManager.java:537) at
> java.sql.DriverManager.getConnection(DriverManager.java:146) at
> Benchmark_sql.query(Benchmark_sql.java:94) at
> Benchmark_sql.doGet(Benchmark_sql.java:47) at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at
> org.apache.tomcat.core.ServletWrapper.handleRequest(ServletWrapper.java:503)
> at
> org.apache.tomcat.core.ServletWrapper.handleRequest(ServletWrapper.java:597)
> at
> org.apache.tomcat.servlets.InvokerServlet.service(InvokerServlet.java:257)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at
> org.apache.tomcat.core.ServletWrapper.handleRequest(ServletWrapper.java:503)
> at org.apache.tomcat.core.ContextManager.service(ContextManager.java:559) at
> org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpC
> onnectionHandler.java:160) at
> org.apache.tomcat.service.TcpConnectionThread.run(SimpleTcpEndpoint.java:338
> ) at java.lang.Thread.run(Thread.java:484) n
> 
> 
> Can someon tell me what else I do miss?
> Thanks,
> Connie
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, email: tomcat-user-help@jakarta.apache.org
> 
> 
> 


Mime
View raw message