where did you put your driver jar?
-----Original Message-----
From: A mailing list for discussion about Sun Microsystem's Java Servlet API
Technology. [mailto:[EMAIL PROTECTED] Behalf Of Cadbury
Sent: Tuesday, July 13, 2004 12:15 PM
To: [EMAIL 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 [EMAIL PROTECTED] and 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 [EMAIL PROTECTED] and 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
