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: [email protected]
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 8888).  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:
>  
>     <jdbc name="db_user">
>       <pool-controller min="5" max="20"/>
>       <auto-commit>true</auto-commit>
>       <dburl>jdbc:mysql://localhost:3306/test</dburl>
>       <user>test</user>
>       <password>test</password>
>      </jdbc>  
>  
> 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]

Reply via email to