Hi,
I am trying to set up a database resource in Tomcat 5.5.20 . I am having a
problem getting a DataSource object back from a JNDI lookup.
(I am getting a "org.apache.tomcat.dbcp.dbcp.BasicDataSource" object
returned and throwing an exception - code below)
My problem is similar to the "Re: MySql Connector" thread of messages.
I can see the resource listed in the Tomcat Administration Tool under Tomcat
Server --> Service --> Host --> Context(/dbtest)
and all the information for the datasource looks fine (as from the
context.xml file below).
My context.xml file (placed in my webapp under META-INF) looks as follows:
<Context crossContext="true" path="/dbtest" reloadable="true">
<Logger className="org.apache.catalina.logger.FileLogger"
prefix="localhost-dbtest-log."
suffix="txt"
timestamp="true"/>
<Resource
name="jdbc/MYSQLDS"
auth="Container"
type="javax.sql.DataSource"
maxActive="5"
maxIdle="3"
maxWait="10000"
username="myuser"
password="mypwd"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/testdb"/>
<WatchedResource>WEB-INF/web.xml</WatchedResource>
</Context>
My web.xml file contains the following:
<resource-ref>
<description>DB Connection</description>
<res-ref-name>jdbc/MYSQLDS</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
And the snippet/code I am using to acquire a datasource is as follows:
DataSource ds = null;
....
ds = (DataSource)initContext.lookup("java:/comp/env/jdbc/MYSQLDS");
....
When the app is run, I get back
java.lang.Exception: org.apache.tomcat.dbcp.dbcp.BasicDataSource
dbtest.HelloWorld.execute(HelloWorld.java:53)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(
NativeMethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke (
DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:585)
(by the way, I am running this within a Struts2 Framework)
Can anyone tell me what I am doing incorrectly still?
Thx,
Prem
