thanx a lot all..i've already solved the problem by just copying the file mysql-connector-java-3.0.14-production-bin.jar into tomcat\common\lib folder... btw why don't tomcat search in my classpath for the file? cause the file is already included in my classpath as below:
-------------------------------------------------- C:\Documents and Settings\Administrator>echo %classpath% .;C:\jaf-1.0.2\activation.jar;C:\javamail-1.3.1\mail.jar;C:\javamail-1.3.1\lib\i map.jar;C:\javamail-1.3.1\lib\mailapi.jar;C:\javamail-1.3.1\lib\smtp.jar;C:\java mail-1.3.1\lib\inetfactory.jar;C:\mysql-connector-java-3.0.14-production\mysql-c onnector-java-3.0.14-production\mysql-connector-java-3.0.14-production-bin.jar;C :\Program Files\Apache Software Foundation\Tomcat 5.0\common\lib\servlet-api.jar ---------------------------------------------- --- "Meißner,_Heinz" <[EMAIL PROTECTED]> wrote: > i use, > in mysql/lib/.... > > > -----Ursprüngliche Nachricht----- > > Von: Guy Katz [mailto:[EMAIL PROTECTED] > > Gesendet: Dienstag, 13. Juli 2004 15:54 > > An: [EMAIL PROTECTED] > > Betreff: Re: why can't my servlet connect to > mysql...? > > > > > > 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:[EMAIL PROTECTED] Behalf Of > > [EMAIL PROTECTED] > > Sent: Tuesday, July 13, 2004 2:20 PM > > To: [EMAIL 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:[EMAIL PROTECTED] > > > Gesendet: Dienstag, 13. Juli 2004 14:09 > > > An: [EMAIL 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:[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 > > ___________________________________________________________________________ > 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 > > ___________________________________________________________________________ > 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 > __________________________________ Do you Yahoo!? Yahoo! Mail - 50x more storage than other providers! 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
