Return-Path: 
 <dev-return-46051-apmail-cocoon-dev-archive=cocoon.apache.org@cocoon.apache.org>
Delivered-To: apmail-cocoon-dev-archive@cocoon.apache.org
Received: (qmail 11100 invoked by uid 500); 8 Aug 2003 00:47:09 -0000
Mailing-List: contact dev-help@cocoon.apache.org; run by ezmlm
Precedence: bulk
list-help: <mailto:dev-help@cocoon.apache.org>
list-unsubscribe: <mailto:dev-unsubscribe@cocoon.apache.org>
list-post: <mailto:dev@cocoon.apache.org>
Reply-To: dev@cocoon.apache.org
Delivered-To: mailing list dev@cocoon.apache.org
Received: (qmail 11087 invoked from network); 8 Aug 2003 00:47:08 -0000
Received: from ms-smtp-02.nyroc.rr.com (24.92.226.49)
  by daedalus.apache.org with SMTP; 8 Aug 2003 00:47:08 -0000
Received: from dotech.com (roc-66-67-139-126.rochester.rr.com [66.67.139.126])
	by ms-smtp-02.nyroc.rr.com (8.12.5/8.12.2) with ESMTP id h780lGiY019573
	for <dev@cocoon.apache.org>; Thu, 7 Aug 2003 20:47:16 -0400 (EDT)
Message-ID: <3F32F2C1.6090803@dotech.com>
Date: Thu, 07 Aug 2003 20:45:53 -0400
From: David Kavanagh <dak@dotech.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US;
 rv:1.4) Gecko/20030624 Netscape/7.1 (ax)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: dev <dev@cocoon.apache.org>
Subject: [Fwd: datasource connect retry]
Content-Type: multipart/alternative;
 boundary="------------030906060602030607060509"
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N

This is a multi-part message in MIME format.
--------------030906060602030607060509
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

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 <dak@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


--------------030906060602030607060509
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1">
  <title></title>
</head>
<body text="#000000" bgcolor="#ffffff">
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.<br>
<br>
Thanks,<br>
David<br>
<br>
-------- Original Message --------
<table cellpadding="0" cellspacing="0" border="0">
  <tbody>
    <tr>
      <th valign="baseline" align="right" nowrap="nowrap">Subject: </th>
      <td>datasource connect retry</td>
    </tr>
    <tr>
      <th valign="baseline" align="right" nowrap="nowrap">Date: </th>
      <td>Wed, 06 Aug 2003 14:53:42 -0400</td>
    </tr>
    <tr>
      <th valign="baseline" align="right" nowrap="nowrap">From: </th>
      <td>David Kavanagh <a class="moz-txt-link-rfc2396E" href="mailto:dak@dotech.com">&lt;dak@dotech.com&gt;</a></td>
    </tr>
    <tr>
      <th valign="baseline" align="right" nowrap="nowrap">Reply-To: </th>
      <td><a class="moz-txt-link-abbreviated" href="mailto:users@cocoon.apache.org">users@cocoon.apache.org</a></td>
    </tr>
    <tr>
      <th valign="baseline" align="right" nowrap="nowrap">To: </th>
      <td><a class="moz-txt-link-abbreviated" href="mailto:users@cocoon.apache.org">users@cocoon.apache.org</a></td>
    </tr>
  </tbody>
</table>
<br>
<br>
<pre>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 &lt;j2ee&gt; 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: <a class="moz-txt-link-abbreviated" href="mailto:users-unsubscribe@cocoon.apache.org">users-unsubscribe@cocoon.apache.org</a>
For additional commands, e-mail: <a class="moz-txt-link-abbreviated" href="mailto:users-help@cocoon.apache.org">users-help@cocoon.apache.org</a>
</pre>
</body>
</html>

--------------030906060602030607060509--