Since you have <WatchedResources />, this suggests you are using some version of 5.5. In this case, the <ResourceParams /> is ignored (you set them as attributes on the <Resource /> tag).
"Mark Whitby" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I've done that and I now get the following error: > > org.apache.jasper.JasperException: Unable to get connection, DataSource > invalid: "java.sql.SQLException: No suitable driver" > > This is what I have in my context.xml file: > > <!-- The contents of this file will be loaded for each web application --> > <Context> > > <!-- Default set of monitored resources --> > <WatchedResource>WEB-INF/web.xml</WatchedResource> > > <!-- Uncomment this to disable session persistence across Tomcat > restarts --> > <!-- > <Manager pathname="" /> > --> > > <ResourceLink > name="jdbc/TestDB" > global="jdbc/TestDB" > type="javax.sql.DataSource" auth="Container" /> > > > </Context> > > > Any further suggestions? > > Mark > ----- Original Message ----- > From: "Parsons Technical Services" <[EMAIL PROTECTED]> > To: "Tomcat Users List" <users@tomcat.apache.org> > Sent: Sunday, February 19, 2006 7:02 PM > Subject: Re: JNDI Datasource Problem > > >> Look up resource link. It goes in the context.xml >> >> Also only put the jar file in the common/lib and no where else. >> >> >> ----- Original Message ----- >> From: "Mark Whitby" <[EMAIL PROTECTED]> >> To: "Tomcat Users List" <users@tomcat.apache.org> >> Sent: Sunday, February 19, 2006 12:53 PM >> Subject: JNDI Datasource Problem >> >> >> Hey guys, >> >> Thanks for the help with the previous problem I had, I've managed to >> solve them now thanks to your help. But now I'm having a problem with >> setting up a DataSource connection. I've followed the example word for >> word and got the following error: >> >> javax.servlet.ServletException: Unable to get connection, DataSource >> invalid: "org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create >> JDBC driver of class '' for connect URL 'null'" >> >> I did a google search for this but only managed to find something on the >> NetBeans website which wasn't much help. I've edited the server.xml file >> as stated, placed the relevent jar file >> (mysql-connector-java-3.1.12-bin.jar) in the lib folder in my web >> application and in the /common/lib folder in the Tomcat home folder and >> I've reset the server and I'm still getting the same problem. >> >> I'm using MySQL, database is called 'fyptest' and the table is called >> 'testdata'. So where am I going wrong? >> >> Many thanks >> >> Mark Whitby >> >> Server.xml file: >> >> <Context path="/DBTest" docBase="DBTest" >> debug="5" reloadable="true" crossContext="true"> >> >> <Logger className="org.apache.catalina.logger.FileLogger" >> prefix="localhost_DBTest_log." suffix=".txt" >> timestamp="true"/> >> >> <Resource name="jdbc/TestDB" >> auth="Container" >> type="javax.sql.DataSource"/> >> >> <ResourceParams name="jdbc/TestDB"> >> <parameter> >> <name>factory</name> >> <value>org.apache.commons.dbcp.BasicDataSourceFactory</value> >> </parameter> >> >> <!-- Maximum number of dB connections in pool. Make sure you >> configure your mysqld max_connections large enough to handle >> all of your db connections. Set to 0 for no limit. >> --> >> <parameter> >> <name>maxActive</name> >> <value>100</value> >> </parameter> >> >> <!-- Maximum number of idle dB connections to retain in pool. >> Set to -1 for no limit. See also the DBCP documentation on this >> and the minEvictableIdleTimeMillis configuration parameter. >> --> >> <parameter> >> <name>maxIdle</name> >> <value>30</value> >> </parameter> >> >> <!-- Maximum time to wait for a dB connection to become available >> in ms, in this example 10 seconds. An Exception is thrown if >> this timeout is exceeded. Set to -1 to wait indefinitely. >> --> >> <parameter> >> <name>maxWait</name> >> <value>10000</value> >> </parameter> >> >> <!-- MySQL dB username and password for dB connections --> >> <parameter> >> <name>username</name> >> <value>javauser</value> >> </parameter> >> <parameter> >> <name>password</name> >> <value>pilks2</value> >> </parameter> >> >> <!-- Class name for the old mm.mysql JDBC driver - uncomment this >> entry and comment next >> if you want to use this driver - we recommend using Connector/J >> though >> <parameter> >> <name>driverClassName</name> >> <value>org.gjt.mm.mysql.Driver</value> >> </parameter> >> --> >> >> <!-- Class name for the official MySQL Connector/J driver --> >> <parameter> >> <name>driverClassName</name> >> <value>com.mysql.jdbc.Driver</value> >> </parameter> >> >> <!-- The JDBC connection url for connecting to your MySQL dB. >> The autoReconnect=true argument to the url makes sure that the >> mm.mysql JDBC Driver will automatically reconnect if mysqld >> closed the >> connection. mysqld by default closes idle connections after 8 >> hours. >> --> >> <parameter> >> <name>url</name> >> >> <value>jdbc:mysql://localhost:3306/fyptest?autoReconnect=true</value> >> </parameter> >> </ResourceParams> >> </Context> >> >> web.xml file: >> >> <resource-ref> >> <description>DB Connection</description> >> <res-ref-name>jdbc/TestDB</res-ref-name> >> <res-type>javax.sql.DataSource</res-type> >> <res-auth>Container</res-auth> >> </resource-ref> >> >> >> >> --------------------------------------------------------------------- >> 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]
