tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Marc Richards <mjr...@yahoo.com>
Subject Re: JNDI Datasource Problem
Date Mon, 20 Feb 2006 20:55:43 GMT
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 <ug82msw@cs.bham.ac.uk> 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: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message