I didn't see any mention of the Tomcat version here, but in 5.5 the <ResourceParams> part of the config is no longer used. All paramters go in the <Resource ...> tag with name="value" format just like name and auth from your example below. i.e. maxIdle="30".
-marc --- Mark Whitby <[EMAIL PROTECTED]> wrote: > 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> > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
