Kawthar,
As for Steve's concerns:
It is the same one. The short story: Mark Mathews wrote it MySQL liked it
and adopted it and him. So it went from org.gjt.mm to com.mysql. Both names
will work fine but to be up to date use the com.mysql.
As for server.xml having only one is fine, and on TC4 this is common. If you
move to TC5 then you can have multiple files with each part applying to only
the app that it is included with. For now don't worry about it.
If your application is running OK as ROOT other than the DBCP problems then
you are fine. It is that most people set up a new context and don't mess
with the ROOT at first. But again if the rest of the app runs you're fine.
Now for fifty questions:
You are rebooting after changes? It has bitten me several times.
Have you done a manual connection?
Class.forName("com.mysql.jdbc.Driver");
connection =
DriverManager.getConnection(
"jdbc:mysql://localhost:3306/ecpa",
"youruser",
"yourpassword");
If the manual connection fails then:
Can you access the database directly and log on using the username and
password that is in the context?
Can you open a prompt and ping localhost? I have seen it fail.
If so use the IP of your machine if you can ping it otherwise you have other
issues.
Are you running a firewall on the machine?
What OS are you on?
What are the rights for the user in the database, can the user gain access
from localhost?
Doug
----- Original Message -----
From: "Kawthar Bt M Sulaiman" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 17, 2004 11:46 PM
Subject: Re: JDBC/mySQL problem.
> Followed your suggestion, but still not working.
>
> Thnx,
> --Kawthar
>
> >>> [EMAIL PROTECTED] 18/03/2004 12:18:00 PM >>>
> Kawthar,
>
> Change:
>
> <Resource auth="Container" description="JDBC Connection to
> MySQL v4.0.18" name="mySQLDatabase" scope="Shareable"
> type="javax.sql.DataSource"/>
>
> <Resource name="jdbc/mySQLDatabase" auth="Container"
> type="javax.sql.DataSource"/>
>
> To:
>
> <Resource auth="Container" description="JDBC Connection to
> MySQL v4.0.18" name="jdbc/mySQLDatabase" scope="Shareable"
> type="javax.sql.DataSource"/>
>
> Should work either way, mine did, just cleaner and proper.
> Note name is changed in second entry, added jdbc/ .
>
>
> Doug
>
> ----- Original Message -----
> From: "Parsons Technical Services" <[EMAIL PROTECTED]>
> To: "Tomcat Users List" <[EMAIL PROTECTED]>
> Sent: Wednesday, March 17, 2004 11:02 PM
> Subject: Re: JDBC/mySQL problem.
>
>
> > Kawthar,
> >
> > Try this context in place of yours.
> >
> > <Context path="/db" docBase ="ROOT" debug="9" reloadable="true">
> > <Resource auth="Container" description="JDBC Connection to
> > MySQL v4.0.18" name="mySQLDatabase" scope="Shareable"
> > type="javax.sql.DataSource"/>
> >
> > <Resource name="jdbc/mySQLDatabase" auth="Container"
> > type="javax.sql.DataSource"/>
> >
> > <ResourceParams name="jdbc/mySQLDatabase">
> > <parameter>
> > <name>factory</name>
> >
> > <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
> > </parameter>
> > <parameter>
> > <name>username</name>
> > <value>xxxx</value>
> > </parameter>
> > <parameter>
> > <name>password</name>
> > <value>xxxx</value>
> > </parameter>
> > <parameter>
> > <name>maxActive</name>
> > <value>100</value>
> > </parameter>
> > <parameter>
> > <name>maxIdle</name>
> > <value>5</value>
> > </parameter>
> > <parameter>
> > <name>maxWait</name>
> > <value>10000</value>
> > </parameter>
> >
> > <parameter>
> > <name>driverClassName</name>
> > <value>org.gjt.mm.mysql.Driver</value>
> > </parameter>
> > <parameter>
> > <name>url</name>
> > <value>jdbc:mysql://localhost:3306/ecpa?autoReconnect=true</value>
> > </parameter>
> > </ResourceParams>
> >
> > <Logger className="org.apache.catalina.logger.FileLogger"
> > prefix="DBlog." suffix=".txt"
> > timestamp="true"/>
> > </Context>
> >
> > Don't forget to close the statement and the result set.
> > I do mine in a finally block along with the conn.close() and each one
> is
> > wrapped in a try / catch.
> >
> > Make sure to restart Tomcat after you make changes to the
> server.xml.
> >
> > Doug
> >
> >
> >
> >
> ---------------------------------------------------------------------
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
>
> >
> >
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
