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]