cocoon-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Brian Johnson <>
Subject Re: transactions in the SQLTransformer
Date Wed, 14 May 2003 10:44:27 GMT
It should not be necessary to use the same connection for each query. 
Even if you are not using a J2EE datasource, Cocoon maintains a pool of 
database connections, so the connection is not actually closed after 
each query. Transaction processing does not require a single database 
connection, the only thing it requires is a single thread. The problem 
that I experienced is that Xalan spans multiple threads, so I had to 
switch to Saxon, which is single threaded. However, I was doing xslt 
processing in between several instances of the SQLTransformer, so that 
may or may not be an issue for you.

On Wednesday, May 14, 2003, at 01:13  AM, David Kavanagh wrote:

> 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

View raw message