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 <[EMAIL PROTECTED]> wrote:
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]
