no cant figure what youve done wrong or write
wait til sombody whit more experience answer you
one thing that i can tell you if you have an eror mysql anwser in the
startup dos windows! (on windows!) dont
know for linux and others im actuly stuck on a broadband connection failuir
under mandrake 9.1
----- Original Message -----
From: "Kawthar Bt M Sulaiman" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 18, 2004 8:51 PM
Subject: Re: JDBC/mySQL problem.
> Yes, I have the latest connector inside my /common/lib.
> mysql-connector-java-3.0.11-stable-bin.jar
>
> I even tried naming this without the word "stable" in it, and still
> not
> working.
>
> In my log file, I can see the following:
> Creating JNDI naming context
>
> Resource parameters for jdbc/mySQLDatabase =
> ResourceParams[name=jdbc/mySQLDatabase,
> parameters={url=jdbc:mysql://localhost:3306/ecpa?autoReconnect=true,
> serverName=localhost, maxActive=100,
> drvierClassName=com.mysql.jdbc.Driver, removeAbandoned=true,
> username=root, factory=org.apache.commons.dbcp.BasicDataSourceFactory,
> password=xxx}]
>
> ResourceRef[className=javax.sql.DataSource, factoryClassLocation=null,
> factoryClassName=org.apache.naming.factory.ResourceFactory, .....<same
> info as above>]
>
> Do you see anything strage? The factoryClassLocation is NULL.. is this
> a problem?
>
> Thanks,
> --Kawthar
>
> >>> [EMAIL PROTECTED] 18/03/2004 09:36:37 PM >>>
> hi my aplication use mysql and the conection config looks like that:
> (piece)
> <DRIVER>com.mysql.jdbc.Driver</DRIVER>
> <URL>jdbc:mysql://localhost:3306/database</URL>
> <LOGIN>root</LOGIN>
> <PASSWORD></PASSWORD>you dont need password wen your in local
> context
> +did you downloader the latest connecter
> mysql-connector-java-3.0.10-stable-bin from mysql and copied it under
> your
> comon /lib +/lib of your aplication ?
> here everyting works fine and im on tomcat 4.0
>
> ----- Original Message -----
> From: "Parsons Technical Services" <[EMAIL PROTECTED]>
> To: "Tomcat Users List" <[EMAIL PROTECTED]>
> Sent: Thursday, March 18, 2004 12:29 AM
> Subject: Re: JDBC/mySQL problem.
>
>
> > 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]
>
> >
> >
>
> ---------------------------------------------------------------------
> 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]
