i think you would need to change the context.xml?
On 2/20/06, 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> > >
