I think I have identified the problem.

I deployed a 'broken' HelloWorld war file to tomcat by coping it to
apache-tomcat-5.5.17/webapps. Tomcat then expanded it, so there is now
both a war file and a expanded directory structure.

In all of my attempts to fix the code, I was modifying the code within
the expanded structure and nothing seemed to work. Once I delete the
war file, everything now worked.

Why does tomcat work like this ? I would have expected one of the following:
  - Expand the war then delete the war
  - Do not expand the war

Can someone shed some light on where I might have gone wrong ?

-Thanks
Steve More

On 5/19/06, Stephen More <[EMAIL PROTECTED]> wrote:
On 5/17/06, Parsons Technical Services <[EMAIL PROTECTED]> wrote:
> Now I will assume you have reviewed
http://tomcat.apache.org/tomcat-5.5-doc/jndi-datasource-examples-howto.html
> for a per context and

Yes

> http://tomcat.apache.org/tomcat-5.5-doc/config/globalresources.html for a
> global approach.

Yes.

> Now for a few questions.
> Is the jndi for one app or several?

Right now, one app.

> Well if for one app, you can set it up in the context of the app.

I have been trying to do this.

> Both cases you need to add the drivers to the common/lib (thus the reason a
> simple war won't do).

I have copied mysql-connector-java-3.1.12-bin.jar to
apache-tomcat-5.5.17/common/lib

> Class.forName("com.mysql.jdbc.Driver");
>
>     connection =
>      DriverManager.getConnection(
>       "jdbc:mysql://192.168.1.19:3306/golive",
>       "daname",
>       "depassword");
>

I have this working fine.

Now that we have verified this first layer ( JDBC Driver installed OK
), how can I test the next layer ?

$CATALINA_HOME/webapps/DBTest/META-INF/context.xml

What can I do to verify that my context.xml is set correctly ?



-Thanks
Steve More

> ----- Original Message -----
> From: "Stephen More" <[EMAIL PROTECTED]>
> To: <users@tomcat.apache.org>
> Sent: Wednesday, May 17, 2006 5:34 PM
> Subject: Help with Tomcat & MySQL using JNDI
>
>
> Is there a war file available for download that will do nothing more than:
>     select 'HelloWorld from MySQL'; using JNDI ?
>
>
> I have tried following many examples on the web and I keep ending up with:
>     Cannot create JDBC driver of class '' for connect URL 'null'
>
> At this point I am pulling out my hair and thinking their must be a
> bug in tomcat 5.5.17 !
>
> Can anyone provide me with a simple working war using MySQL ?
>
>
> -Thanks
> Steve More
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
>
>
>
> ---------------------------------------------------------------------
> 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]

Reply via email to