This could easily be caused by the mysql jar file not being in tomcat's
common/lib directory -- especially if local, non JNDI access is working.
--David
Prem Padarath wrote:
Hi Wade,
Yes, I have been able to connect with a plain java class and I have been
able to connect from within Struts2 directly. It is when I try to get a
DataSource object from Tomcat's JNDI that it messes.
Prem
On 7/23/07, Wade Chandler <[EMAIL PROTECTED]> wrote:
From a JSP page try to make a MYSQL connection using
just pure JDBC calls. It may be something to do with
your JDBC classes and the directory your JAR files are
housed. If I remember correctly I had to put my MYSQL
JAR file in the shared folder so the server could
access them. This versus having them in the
WEB-INF/lib folder. May or may not be your issue, but
make sure you can actually make a JDBC connection with
the drivers first. If not then the DataSource won't
work either.
I have never used
<WatchedResource>WEB-INF/web.xml</WatchedResource>
before either. Maybe comment out this line and see if
it has any impact.
Wade
--- Prem Padarath <[EMAIL PROTECTED]> wrote:
> 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
>
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
