[Fwd: datasource connect retry]

[David Kavanagh <da...@dotech.com>]

any thought, gents? I'll delve into the cocoon/avalon source if I have 
to, but it would be great if someone has knowledge of this already.

Thanks,
David

-------- Original Message --------
Subject: 	datasource connect retry
Date: 	Wed, 06 Aug 2003 14:53:42 -0400
From: 	David Kavanagh <da...@dotech.com>
Reply-To: 	users@cocoon.apache.org
To: 	users@cocoon.apache.org



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: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org