David,

I checked. The mysql jar file is in common\lib directory!
I think my test app (direct access) would have had to have retrieved the
jdbc classes from the Tomcat lib as I didn't include them in the war file.

Thx,
Prem

On 7/23/07, David Smith <dns4@(protected):
>
> 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 <hwadechandler-apache@(protected):
> >>
> >> 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 <ppadarath@(protected):
> >>
> >> > 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@(protected)
> >> To unsubscribe, e-mail: users-unsubscribe@(protected)
> >> For additional commands, e-mail: users-help@(protected)
> >>
> >>
> >
>
>
> ---------------------------------------------------------------------
> To start a new topic, e-mail: users@(protected)
> To unsubscribe, e-mail: users-unsubscribe@(protected)
> For additional commands, e-mail: users-help@(protected)
>
>