The following code should work if your database's root password is empty:
Class.forName(dbDriver).newInstance();
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
