cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Benjamin Boksa <benja...@boksa.de>
Subject Make SQLTransformer stop on error
Date Fri, 30 Sep 2005 09:15:03 GMT
Hi,

is it possible to "stop" the SQLTransformer when an error occurs  
while processing more than one query in a single transformation?

I have the following case:

[...]
<query>INSERT INTO foo (key) VALUES (1)</query>
[...]
<query>INSERT INTO bar (key) VALUES (1)</query>
[...]

(foo and bar have a 1:n relation)

The first query fails ("Duplicate key...") as the file 'key' is  
declared as unique in the first table, but the query on bar gets  
executed, which has some nasty side-effects.

Is there any way to stop after the query on foo, when an error occurs?

Thanks for you answers in advance.

Regards,

Benjamin

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org


Mime
View raw message