Re: AW: why can't my servlet connect to mysql...?

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]]On 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]]On 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