The following code should work if your database's root password is empty:My problem is the driver isn't being loaded.Class.forName(dbDriver).newInstance();
Configuration problems, I believe...
connPool[i]=DriverManager.getConnection("jdbc:mysql://"+dbServer+"?user="+db
Login);As for connecting with a non-empty password, I don't know how to do that.
If you figure it out, please let me know.--Zeba
At 09:58 AM 11/16/00 -0800, Tony Keith wrote:
>Hello,
>
>I wrote a simple servlet to insert a row into a mysql database table.
>I'm running Tomcat 3.2b7.
>
>What are the steps to configure Tomcat to work with this servlet?
>The problem I'm having now is the driver isn't found.
>
>Where do I place the driver? In the lib directory?
>
>How do I reference a new instance of the driver?
>This is how I reference it now:
>Class.forName("org.mm.mysql.Driver").newInstance();
>
>Will the connection information remain the same?
>Here is the connection information I currently use:
>con = DriverManager.getConnection("jdbc:mysql://localhost/webdata",
>"user", "password");
>
>TIA
>--
>Tony Keith
-- Tony Keith Director of Information Technology Paycom.net 4215 Glencoe Avenue, First Floor Marina Del Rey, CA 90292 TEL: (310) 827-5880 ext. 304 FAX: (310) 827-5519
