Re: Database connection problems during upgrade
Actually, both were right. The only problem I had was trying to find a suitable mysql-***.jar version. Despite the fact that both the server and my PC are running Java 1.4 and Cocoon 1.8 :- mysql-connector-java-5.1.2-beta-bin.jar works on the server, and mysql-connector-java-3.1.7-bin.jar works on my PC but not the other way around. Sigh. But thanks again for the speedy help! >>> "Johannes Textor" <[EMAIL PROTECTED]> 2007/08/06 12:42 PM >>> > > this is probably because you have not included com.mysql.jdbc.Driver > > (not sure if this is the exact class name) in web.xml. > > Or maybe he didn't copy the actual driver class. > > For example, mine is: > WEB-INF/lib/mysql-connector-java-5.0.6-bin.jar > > > Tobia That might also be, although I'd think this would throw a "class not found" exception instead of a "no suitable driver" one (just guessing though) - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- This message is subject to the CSIR's copyright, terms and conditions and e-mail legal notice. Views expressed herein do not necessarily represent the views of the CSIR. CSIR E-mail Legal Notice http://mail.csir.co.za/CSIR_eMail_Legal_Notice.html CSIR Copyright, Terms and Conditions http://mail.csir.co.za/CSIR_Copyright.html For electronic copies of the CSIR Copyright, Terms and Conditions and the CSIR Legal Notice send a blank message with REQUEST LEGAL in the subject line to [EMAIL PROTECTED] This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Database connection problems during upgrade
> > this is probably because you have not included com.mysql.jdbc.Driver > > (not sure if this is the exact class name) in web.xml. > > Or maybe he didn't copy the actual driver class. > > For example, mine is: > WEB-INF/lib/mysql-connector-java-5.0.6-bin.jar > > > Tobia That might also be, although I'd think this would throw a "class not found" exception instead of a "no suitable driver" one (just guessing though) - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Database connection problems during upgrade
Johannes Textor wrote: > this is probably because you have not included com.mysql.jdbc.Driver > (not sure if this is the exact class name) in web.xml. Or maybe he didn't copy the actual driver class. For example, mine is: WEB-INF/lib/mysql-connector-java-5.0.6-bin.jar Tobia - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Database connection problems during upgrade
Hi Derek, this is probably because you have not included com.mysql.jdbc.Driver (not sure if this is the exact class name) in web.xml. Cheers, Johannes Original-Nachricht Datum: Mon, 06 Aug 2007 11:05:17 +0200 Von: "Derek Hohls" <[EMAIL PROTECTED]> An: users@cocoon.apache.org Betreff: Database connection problems during upgrade > I am in the process of upgrading to Cocoon 2.1.8 on the server. > At present , I am testing with Jetty (port ). I have copied all the > database connection settings to the new cocoon.xconf file, from my > local (test) PC (where everything works fine) e.g. all the XML > snippets that take the form: > > > > true > jdbc:mysql://localhost:3306/test > test > test > > > The Jetty container was restarted, but it seems the database cannot > be connected. The error.log file shows these messages: > > INFO (2007-08-06) 09:22.14:029 [sitemap.transformer.sql] (/test/do-login) > PoolThread-3/SQLTransformer: Unable to get connection; waiting 5000ms to > try again. > WARN (2007-08-06) 09:22.19:031 [core.manager] (/test/do-login) > PoolThread-3/ResourceLimitingJdbcDataSource: Could not return Connection > java.sql.SQLException: No suitable driver > > What are the possible causes of / solutions to this problem? > > Thanks > Derek > > PS The same database connections work OK under the older Cocoon > version running under Tomcat, on the same server. > > > -- > This message is subject to the CSIR's copyright, terms and conditions and > e-mail legal notice. Views expressed herein do not necessarily represent > the > views of the CSIR. > > CSIR E-mail Legal Notice > http://mail.csir.co.za/CSIR_eMail_Legal_Notice.html > > CSIR Copyright, Terms and Conditions > http://mail.csir.co.za/CSIR_Copyright.html > > For electronic copies of the CSIR Copyright, Terms and Conditions and the > CSIR > Legal Notice send a blank message with REQUEST LEGAL in the subject line > to > [EMAIL PROTECTED] > > > This message has been scanned for viruses and dangerous content by > MailScanner, > and is believed to be clean. > > > - > 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]
Database connection problems during upgrade
I am in the process of upgrading to Cocoon 2.1.8 on the server. At present , I am testing with Jetty (port ). I have copied all the database connection settings to the new cocoon.xconf file, from my local (test) PC (where everything works fine) e.g. all the XML snippets that take the form: true jdbc:mysql://localhost:3306/test test test The Jetty container was restarted, but it seems the database cannot be connected. The error.log file shows these messages: INFO (2007-08-06) 09:22.14:029 [sitemap.transformer.sql] (/test/do-login) PoolThread-3/SQLTransformer: Unable to get connection; waiting 5000ms to try again. WARN (2007-08-06) 09:22.19:031 [core.manager] (/test/do-login) PoolThread-3/ResourceLimitingJdbcDataSource: Could not return Connection java.sql.SQLException: No suitable driver What are the possible causes of / solutions to this problem? Thanks Derek PS The same database connections work OK under the older Cocoon version running under Tomcat, on the same server. -- This message is subject to the CSIR's copyright, terms and conditions and e-mail legal notice. Views expressed herein do not necessarily represent the views of the CSIR. CSIR E-mail Legal Notice http://mail.csir.co.za/CSIR_eMail_Legal_Notice.html CSIR Copyright, Terms and Conditions http://mail.csir.co.za/CSIR_Copyright.html For electronic copies of the CSIR Copyright, Terms and Conditions and the CSIR Legal Notice send a blank message with REQUEST LEGAL in the subject line to [EMAIL PROTECTED] This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]