I'm seeing a problem with cocoon 2.0.4 and my database connection. I'm running on JBoss3.0.7 with tomcat 4.1.x and JDK1.4.1_01
What happens is that I connect to the database to get information for a screen. That works fine. I drop the connection (close my port map), then the query fails (with the first stack trace fragement below).
Next, I restore my port map (so the connection is re-established) and I still see an error (the second stack trace fragment below).
It seems like the cocoon DataSource object isn't doing its thing. I've configured the datasource using the <j2ee> option. I have the JNDI datasource set up in jboss. We have other apps that have done a manual lookup of the JNDI datasource and are able to recover just fine. So, that leaves the Cocoon datasource as the culprit.
Anyone know anything about this?
Thanks, David
When the connection is broken...
DEBUG (2003-08-06) 14:42.09:309 [sitemap.transformer.sql] (/membership/) Thread-9/SQLTransformer: SQLTransformer:.executeQuery() query.execute failed
java.sql.SQLException: Failed to obtain connection. Made 5 attempts with 5000ms interval
at org.apache.cocoon.transformation.SQLTransformer$Query.getConnection(SQLTransformer.java:1006)
at org.apache.cocoon.transformation.SQLTransformer$Query.execute(SQLTransformer.java:1059)
at org.apache.cocoon.transformation.SQLTransformer.executeQuery(SQLTransformer.java:301)
Still, after the connection is restored...
DEBUG (2003-08-06) 14:44.04:514 [sitemap.transformer.sql] (/membership/) Thread-11/SQLTransformer$Query: SQLTransformer$Query: could not acquire a Connection -- waiting 5000 ms to try again.
ERROR (2003-08-06) 14:44.09:522 [sitemap.transformer.sql] (/membership/) Thread-11/SQLTransformer$Query: Caught a SQLException
java.sql.SQLException: Failed to obtain connection. Made 5 attempts with 5000ms interval
at org.apache.cocoon.transformation.SQLTransformer$Query.getConnection(SQLTransformer.java:1006)
at org.apache.cocoon.transformation.SQLTransformer$Query.execute(SQLTransformer.java:1059)
at org.apache.cocoon.transformation.SQLTransformer.executeQuery(SQLTransformer.java:301)
at org.apache.cocoon.transformation.SQLTransformer.endExecuteQueryElement(SQLTransformer.java:458)
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
