There is no ResourceParams in 5.5. Check the documentation again, and make sure you're looking at the docs for 5.5 not 5.0.
-- Len On 2/19/06, Mark Whitby <[EMAIL PROTECTED]> wrote: > Yes I'm using version 5.5.15. What I have in the server.xml file is what is > advised in the Tomcat set up pages. So would it make any difference > removing one of these or as it's ignored does it not matter? > > Mark > > ----- Original Message ----- > From: "Bill Barker" <[EMAIL PROTECTED]> > To: <users@tomcat.apache.org> > Sent: Sunday, February 19, 2006 8:40 PM > Subject: Re: JNDI Datasource Problem > > > > 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] > > > > > --------------------------------------------------------------------- > 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]
