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: <[email protected]>
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 unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
