Mailing-List: contact cocoon-dev-help@xml.apache.org; run by ezmlm
Precedence: bulk
Reply-To: cocoon-dev@xml.apache.org
Message-ID: <33485.10.0.0.5.1052889547.squirrel@ags01.agsoftware.dnsalias.com>
Date: Tue, 13 May 2003 23:19:07 -0600 (CST)
Subject: Re: transactions in the SQLTransformer
From: "Antonio Gallardo" <agallardo@agsoftware.dnsalias.com>
To: <cocoon-dev@xml.apache.org>
In-Reply-To: <3EC1D07F.3090703@dotech.com>
References: <3EC1D07F.3090703@dotech.com>
Importance: Normal
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

Hi:

I am not using SQLTransformer, but using Modular Database Action you get it.
More info at:

http://wiki.cocoondev.org/Wiki.jsp?page=ModularDatabaseActions

Best Regards,

Antonio Gallardo

David Kavanagh dijo:
> I need to a sequence of sql commands and be able to rollback if anyone
> fails. Does the SQLTransformer support transactions? I looked through
> the SQLTransformer code to see what this might take to add. Easy to add
> the parameter to turn the transaction processing on. The biggest problem
>  I saw was that connections are used for one query only, then closed.
> I'd  have to keep the connection open for the duration of query
> processing. I  can think of ways to do this, but are there any
> implications I should be  concerned about?
> If done right, I could see giving this feature back. Has there been any
> demand?
>
> David