tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bill Barker" <wbar...@wilshire.com>
Subject Re: JNDI Datasource Problem
Date Sun, 19 Feb 2006 20:40:00 GMT
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" <ug82msw@cs.bham.ac.uk> wrote in message 
news:008201c6358a$5cb91430$0201a8c0@MarksLaptop...
> 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" <parsonstechnical@earthlink.net>
> 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" <ug82msw@cs.bham.ac.uk>
>> 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: users-unsubscribe@tomcat.apache.org
>> For additional commands, e-mail: users-help@tomcat.apache.org
>> 




---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message