when you say "in the classpath ;-)", where exactly did you place it in the
directory structure of tomcat?

-----Original Message-----
From: A mailing list for discussion about Sun Microsystem's Java Servlet API
Technology. [mailto:SERVLET-INTEREST@(protected)
HMeissner@(protected)
Sent: Tuesday, July 13, 2004 2:20 PM
To: SERVLET-INTEREST@(protected)
Subject: AW: why can't my servlet connect to mysql...?


moin,

in the classpath ;-)
< Class.forName("com.mysql.jdbc.Driver").newInstance(); >
u can see this driver in ure gui ?

sorry im using eclipse ...
greetz
heinz


> -----Ursprüngliche Nachricht-----
> Von: Guy Katz [mailto:gkatz@(protected)]
> Gesendet: Dienstag, 13. Juli 2004 14:09
> An: SERVLET-INTEREST@(protected)
> Betreff: Re: why can't my servlet connect to mysql...?
>
>
> where did you put your driver jar?
>
> -----Original Message-----
> From: A mailing list for discussion about Sun Microsystem's
> Java Servlet API
> Technology. [mailto:SERVLET-INTEREST@(protected)
> Sent: Tuesday, July 13, 2004 12:15 PM
> To: SERVLET-INTEREST@(protected)
> Subject: why can't my servlet connect to mysql...?
>
>
> hi...it seems that my servlet have problem connecting
> to mysql...
>
> here's a part of my servlet code:
>
> ---------------------------------------------
> public class RegisterUser extends HttpServlet{
>   public void service(ServletRequest request,
>      ServletResponse response)throws IOException{
>
>      response.setContentType("text/html");
>      PrintWriter pw = response.getWriter();
>      try{
>
> Class.forName("com.mysql.jdbc.Driver").newInstance();
> java.sql.Connection con;
> con = DriverManager.getConnection
> ("jdbc:mysql://127.0.0.1/mysql?user=root&password=root1234");
>
>
> }
> catch (Exception e){
> pw.println("\nError: " + e.getMessage());
> }
> }
> }
> -----------------------------------------------
> i got the error message: Error: com.mysql.jdbc.Driver
>
> any idea what did i do wrong here..? cause my another
> java application can connect to mysql without any
> problem..using the same syntax as above..
>
> thanx a lot. any help are greatly appreciated.
>
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Mail - You care about security. So do we.
> http://promotions.yahoo.com/new_mail
>
> ______________________________________________________________
> _____________
> To unsubscribe, send email to listserv@(protected)
> include in the body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources:
http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html

___________________________________________________________________________
To unsubscribe, send email to listserv@(protected)
of the message "signoff SERVLET-INTEREST".

Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html

___________________________________________________________________________
To unsubscribe, send email to listserv@(protected)
of the message "signoff SERVLET-INTEREST".

Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html

___________________________________________________________________________
To unsubscribe, send email to listserv@(protected)
of the message "signoff SERVLET-INTEREST".

Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html