cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sozonnik Andrew" <sozon...@kyivstar.net>
Subject RE: Database connection problem
Date Wed, 27 Mar 2002 07:42:46 GMT
Tell us, version of Cocoon and JDK.
Have you compiled Cocoon by yourself and under what JDK ?

-----Original Message-----
From: Derek Hohls [mailto:DHohls@csir.co.za] 
Sent: Wednesday, March 27, 2002 8:39 AM
To: cocoon-users@xml.apache.org
Subject: Re: Database connection problem


1) The jdbc driver file is loaded under:  WEB-INF/classes/....

2) The xconf file contains:

  <datasources>
    <jdbc name="my_connection">
      <pool-controller min="5" max="10"/>
      <auto-commit>true</auto-commit>
      <dburl>jdbc:mysql://localhost:3306/mydbase</dburl>
      <user>foo</user>
      <password>bar</password>
    </jdbc> 
  </datasources>

3) I am not sure what you mean by "access.log" - I only have 
cocoon.log and root.log in my WEB-INF/logs directory?

The first enty in the cocoon.log has the line:

FATAL_E (2002-03-26) 15:31.06:158   [cocoon  ]
 (Unknown-URI) Unknown-thread/JdbcConnectionPool: 
Excalibur could not create any connections.  
Examine your settings to make sure they are correct.  
Make sure you can connect with the same settings on your machine.

The root.log has no entries in it at all...


Thanks for responding - any comments on the above??

Derek

>>> demchenko@kyivstar.net 26/03/2002 05:11:18 >>>
1) You must have jdbc driver file in classpath
2) Check your cocoon.xconf
for <datasources>...</datasources> for pool configuration
3) See access.log for message like this
 DEBUG   (2002-03-26) 17:04.45:713   [access] (Unknown-URI)
Unknown-thread/Cocoon
Servlet: Trying to load class: org.gjt.mm.mysql.Driver

----- Original Message -----
From: "Derek Hohls" <DHohls@csir.co.za>
To: <cocoon-users@xml.apache.org>
Sent: Tuesday, March 26, 2002 4:43 PM
Subject: Database connection problem


> When trying to connect to a mySQL database, I get:
>
> Could not get the datasource java.sql.SQLException: There are no 
> connections in the pool, check your settings.
>
> I already have the setting for the driver in the web.xml;
>     <init-param>
>       <param-name>load-class</param-name>
>       <param-value>org.gjt.mm.mysql.Driver</param-value>
>     </init-param>
>
> I can also connect to, and 'see' the database with another,
front-end
> program.
>
> In fact, the connection AND database were working previously - does 
> anyone know if a mod_rewrite for the site in the Apache server would 
> affect this??  (seems strange, but thats the only major change that
has
> happened on the server that I know about) I have also checked the 
> connection without using the VirtualHost and get the same results...
>
> Any ideas as to what else to check?
>
> Thanks
> Derek
>
>
---------------------------------------------------------------------
> Please check that your question has not already been answered in the 
> FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>
>
> To unsubscribe, e-mail: <cocoon-users-unsubscribe@xml.apache.org>
> For additional commands, e-mail: <cocoon-users-help@xml.apache.org>
>
>


---------------------------------------------------------------------
Please check that your question has not already been answered in the FAQ
before posting. <http://xml.apache.org/cocoon/faqs.html>

To unsubscribe, e-mail: <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail: <cocoon-users-help@xml.apache.org>


---------------------------------------------------------------------
Please check that your question has not already been answered in the FAQ
before posting. <http://xml.apache.org/cocoon/faqs.html>

To unsubscribe, e-mail: <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail: <cocoon-users-help@xml.apache.org>



---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>

To unsubscribe, e-mail: <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail: <cocoon-users-help@xml.apache.org>


Mime
View raw message