Make SQLTransformer stop on error

[Benjamin Boksa <be...@boksa.de>]

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