Return-Path: <balld@phoenix.webslingerZ.com>
Mailing-List: contact cocoon-users-help@xml.apache.org; run by ezmlm
Delivered-To: mailing list cocoon-users@xml.apache.org
Received: (qmail 33053 invoked from network); 1 Mar 2000 20:24:25 -0000
Received: from phoenix.webslingerz.com (balld@206.66.49.24)
  by locus.apache.org with SMTP; 1 Mar 2000 20:24:25 -0000
Received: from localhost (balld@localhost)
	by phoenix.webslingerZ.com (8.8.7/8.8.7) with ESMTP id PAA24488
	for <cocoon-users@xml.apache.org>; Wed, 1 Mar 2000 15:21:31 -0500
Date: Wed, 1 Mar 2000 15:21:31 -0500 (EST)
From: Donald Ball <balld@webslingerZ.com>
To: cocoon-users@xml.apache.org
Subject: Re: SQL processor & Informix question
In-Reply-To: <38BB0ABC.6302D429@ec-group.com>
Message-ID: 
 <Pine.LNX.4.10.10003011518250.24343-100000@phoenix.webslingerZ.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
X-Spam-Rating: locus.apache.org 1.6.2 0/1000/N

> I get the following stackstrace in the error log:
> 
> java.sql.SQLException: Not in transaction.
>         at java.lang.Throwable.fillInStackTrace(Native Method)
>         at java.lang.Throwable.fillInStackTrace(Compiled Code)
>         at java.lang.Throwable.<init>(Compiled Code)
>         at java.lang.Exception.<init>(Compiled Code)
>         at java.sql.SQLException.<init>(SQLException.java:43)
>         at
> com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:263)
>         at com.informix.jdbc.IfxSqli.errorDone(IfxSqli.java:2919)
>         at com.informix.jdbc.IfxSqli.receiveError(IfxSqli.java:2804)
>         at com.informix.jdbc.IfxSqli.receiveMessage(Compiled Code)
>         at com.informix.jdbc.IfxSqli.executeRollback(IfxSqli.java:448)
>         at
> com.informix.jdbc.IfxSqliConnect.rollback(IfxSqliConnect.java:904)
>         at
> org.apache.cocoon.processor.sql.SQLProcessor.processQuery(Compiled Code)
> 
>         at org.apache.cocoon.processor.sql.SQLProcessor.process(Compiled
> Code)
>         at org.apache.cocoon.Engine.handle(Compiled Code)
>         at org.apache.cocoon.Cocoon.service(Cocoon.java:145)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
>         at
> org.apache.jserv.JServConnection.processRequest(JServConnection.java:314)
> 
>         at
> org.apache.jserv.JServConnection.run(JServConnection.java:188)
>         at java.lang.Thread.run(Thread.java:479)
> 
> Any ideas?

Sure. I'm stupidly explicitly commiting transactions even when not
necessary. I should be checking to see if the connection is in autocommit
mode. Would you like to send in a patch?

- donald