tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Wong, Connie" <connie.w...@lmco.com>
Subject RE: MySQL question - No suitable driver
Date Wed, 28 Feb 2001 15:39:34 GMT
It works, I replaced my url to  "jdbc:mysql://localhost:3306/test"
Thank you very much.
Connie

> -----Original Message-----
> From:	Web master [SMTP:webmaster@unni.com]
> Sent:	Tuesday, February 27, 2001 4:23 PM
> To:	tomcat-user@jakarta.apache.org
> Subject:	Re: MySQL question - No suitable driver
> 
> 
> 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:50
> 3)
> > at
> >
> org.apache.tomcat.core.ServletWrapper.handleRequest(ServletWrapper.java:59
> 7)
> > 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:50
> 3)
> > at
> org.apache.tomcat.core.ContextManager.service(ContextManager.java:559) at
> >
> org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(Htt
> pC
> > onnectionHandler.java:160) at
> >
> org.apache.tomcat.service.TcpConnectionThread.run(SimpleTcpEndpoint.java:3
> 38
> > ) 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
> > 
> > 
> > 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, email: tomcat-user-help@jakarta.apache.org

Mime
View raw message