cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Zack Angelo <z...@nostromocorp.com>
Subject Re: Can't connect to MySQL with Cocoon 2
Date Sat, 04 May 2002 22:35:46 GMT
Daniel,

Apparently a lot of people have been having trouble getting mySQL+C2 to work
with the 1.4 JDK. I'd try 1.3 and see if that helps any. HTH.

-Zack

On 5/4/02 4:00 PM, "bulk@daniel-vogelheim.de" <bulk@daniel-vogelheim.de>
wrote:

> Hello all,
> 
> I have a problem connecting to a MySQL database with Cocoon. When I
> try to access a page that goes through the SQLTransformer, the browser
> doesn't deliver any result. There's no error message, the browser just
> sits there and waits for data. The Coccon core.log file contains an
> error message "No valid Jdbc Connection class available". (More
> details follow below.)
> 
> I've checked Google, the mailing list archive, and the FAQs, but
> didn't find anything that seemed to help. I'm surely missing
> something; aynone out there can help me?
> 
> 
> Thanks,
> Daniel
> 
> 
> Some more details:
> 
> WEB-INF/logs/sitemap.log contains:
> ------------------------------------
> DEBUG   (2002-05-01) 21:21.01:120
> [sitemap.transformer.sql](/cocoon/xxx/1.html)
> Thread-15/SQLTransformer: SQLTransformer executing query nr 0
> DEBUG   (2002-05-01) 21:21.01:124
> [sitemap.transformer.sql](/cocoon/xxx/1.html)
> Thread-15/SQLTransformer$Query: EXECUTING
>  SELECT * FROM PERSONEN WHERE ID = 1
> DEBUG   (2002-05-01) 21:21.01:147
> [sitemap.transformer.sql](/cocoon/xxx/1.html)
> Thread-15/SQLTransformer$Query: SQLTransformer$Query: could no
> t acquire a Connection -- waiting 5000 ms to try again.
> 
> The last message gets repeated over and over again. The query looks
> OK, but apparently something goes wrong, and Cocoon just tries again.
> That doesn't really make sense to me, since what ever is going wrong,
> will be just as wrong 5s later. Anyway... so something is wrong with
> the SQL connection. But what?
> 
> 
> WEB-INF/logs/core.log contains:
> ------------------------------------
> WARN    (2002-05-01) 21:55.23:219
> [core.datasources.stammbaum-mysql](/cocoon/xxx/1.html)
> Thread-15/LogKitLogger: Could not return Connection
> org.apache.avalon.excalibur.datasource.NoValidConnectionException: No
> valid Jdbc Connection class available
>       at
> org.apache.avalon.excalibur.datasource.JdbcConnectionFactory.newInsta
> nce(JdbcConnectionFactory.java:183)
>       at
> org.apache.avalon.excalibur.pool.ResourceLimitingPool.newPoolable(Res
> ourceLimitingPool.java:491)
> [...]
> 
> The stack trace is much longer; I'm happy to send more if anyone can
> use this. Cocoon can't get Jdbc Connection class. What does that mean?
> 
> 
> Excerpt from sitemap.xmap
> ----------------------------
> The relevant pipeline definition looks like:
> (If you're wondering why I use an XML serializer on an *.html ending:
> That's just for debugging; shouldn't have anything to do with the
> problem, right?)
> 
> <map:pipeline>
> <map:match pattern="xxx/*.html">
>  <map:generate src="xxx/person.xml"/>
>  <map:transform type="sql">
>   <map:parameter name="use-connection" value="xxx-mysql"/>
>   <map:parameter name="id" value="{1}"/>
>  </map:transform>
>  <map:serialize type="xml"/>
> </map:match>
> </map:pipeline>
> 
> Excerpt from WEB-INF/cocoon.xconf
> -----------------------------------
>   <jdbc logger="core.datasources.xxx-mysql" name="xxx-mysql">
>     <dburl>jdbc:mysql://localhost/xxx</dburl>
>     <user>daniel</user>
>     <password/>
>   </jdbc>
> 
> I can connect fine to the database using ODBC from Windows, and that
> parameter set. So I don't suspect anything wrong here.
> 
> Excerpt from WEB-INF/web.xml
> ------------------------------
> <init-param>
>   <param-name>load-class</param-name>
>   <param-value>
> [...snip ...]
>     <!-- MySQL JDBC driver -->
>     org.gjt.mm.mysql.Driver
>   </param-value>
> </init-param>
> 
> This loads the JDBC driver, right?
> 
> 
> System and Software versions
> ------------------------------
> - Coccon 2.0.2
> - Tomcat 3.3.1
> - Sun Java JSDK 1.4, Linux
> - RedHat Linux 7.2
> - mm.mysql JDBC driver 2.0.13
> (copied into WEB-INF/libs)
> - MySQL 3.23.41 
> (running on same host)
> 
> 
> 
> ---------------------------------------------------------------------
> 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