Todd,
I went through this problem myself and found I needed to add a line to my
.profile to set the classpath. If you can telnet into your space you can set
it yourself. I put the details into an email to the list a few months ago so
check the archive under mm.mysql. Once this was set all went well.
Cheers
Bruce
----- Original Message -----
From: Kurtz Todd-sc4536 <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, January 22, 2000 5:28 AM
Subject: Re: Unable to load JDBC Driver
> Thanks all,
>
> That's what I suspected. Just don't have any control over
> the host.
>
> -----Original Message-----
> From: Sundar Rajan S [mailto:[EMAIL PROTECTED]]
> Sent: Friday, January 21, 2000 9:57 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Unable to load JDBC Driver
>
>
> Hey ,
> I've seen that one before.
> This happens if u dont set the classpath to the org.gjt.mm.mysql in the
> properties file in the linux system(guess should be the same in unix).
Once
> it did that , it worked fine.
>
>
>
> Thanks,
>
> S Sundar Rajan
>
>
> Alvin Lau <[EMAIL PROTECTED]> on 01/21/2000 06:22:08 PM
>
> Please respond to "A mailing list for discussion about Sun Microsystem's
> Java Servlet API Technology."
> <[EMAIL PROTECTED]>
>
> To: [EMAIL PROTECTED]
> cc: (bcc: S Sundar Rajan/India/IBM)
> Subject: Re: Unable to load JDBC Driver
>
>
>
>
> something likes this:
> ..
> public static final String JDBC_DRIVER="org.gjt.mm.mysql.Driver";
> public static final String DB="jdbc:mysql://localhost:3306/ems";
> public static final String DB_USER="wwwuser";
> public static final String DB_PW="";
> ...
>
> Class.forName(JDBC_DRIVER).newInstance();
> Connection conn=DriverManager.getConnection(DB,DB_USER,DB_PW);
> .... ("ems" is my db name", 3306 is port#)
>
> good luck!
>
> alvin
> -----Original Message-----
> From: A mailing list for discussion about Sun Microsystem's Java Servlet
> API Technology. [mailto:[EMAIL PROTECTED]]On Behalf Of Kurtz
> Todd-sc4536
> Sent: Friday, January 21, 2000 6:49 AM
> To: [EMAIL PROTECTED]
> Subject: Unable to load JDBC Driver
>
>
> Greetings,
>
> I do appreciate any help that you might provide. Many Thanks.
>
> The response I get from my servlet is:
> "Couldn't load database driver: org.gjt.mm.mysql.Driver"
>
> Basically, I am having problems getting my servlet to connect
> to my database with a JDBC driver. Everything works on my pc,
> but not on my server. Unfortunately, I don't have my own server
> connected to the Internet. I have a virtual hosting account with
> a web hosting company. I have a MySQL database set up there. They
> have the JDBC driver mm.mysql.jdbc-1.2b (org.gjt.mm.mysql.Driver).
> And, my class file is in my servlets directory. Other servlets
> do work in this directory, but none require a database connection
> except this one.
>
> Note: I'm displaying a false domain, user, and password here.
>
> As I mentioned, everything works on my pc via
> http://localhost:8080/examples/servlet/DBTest
>
> but not on the webhosting.com server at
> http://www.falsedomain.com/servlets/DBTest .
>
> THESE ARE QUESTIONS I ASKED MY WEB HOSTING COMPANY, BUT
> HAVEN'T RECEIVED A REPLY ON:
>
> CONCERNING LOADING THE JDBC DRIVER:
> 1. Is the JDBC driver named "org.gjt.mm.mysql.Driver"?
> 2. Is the JDBC driver already in our CLASSPATH?
> 3. Do I need to specify a path to the JDBC driver?
>
> CONCERNING CONNECTING TO THE DATABASE:
> 4. What is the correct path to the database "TestDB"?
> ex: "jdbc:mysql:WHAT GOES HERE?"
>
> THIS IS THE SECTION OF PERTINENT CODE:
>
> try {
> // Load the mysql Driver
> Class.forName("org.gjt.mm.mysql.Driver");
>
> // Get a Connection to the database
> con = DriverManager.getConnection(
> "jdbc:mysql:TestDB?user=falseUser password=falsePassword");
>
> // By the way, I don't think the line above works, but I'm not
> // sure because the error message refers to loading the driver,
> // not connecting to the database.
>
> /* But, the line below works on my local pc */
> // "jdbc:mysql://localhost/DBTest?user=root password=todd");
>
>
> Thanks Again,
> Todd Kurtz
>
>
___________________________________________________________________________
> 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
