I'm currently working on bug
http://nagoya.apache.org/bugzilla/show_bug.cgi?id=25098 to do with
processing update queries in SQLTransformer and from looking at the code
there appears to be a few other problems. Before proceeding I just want to
clarify how the SQLTransformer was intended to work.
>From the code the following XML block is valid:
<databaseQuery>
<execute-query>
<query name="select">SELECT * FROM TABLE1</query>
<query name="update">UPDATE SET Col1="5"</query>
<execute-query>
<databaseQuery>
Each query within the <execute-query> block would be executed in the same
transaction so that the entire block is rolled back if something goes wrong.
This is also useful when working with identity columns so that the identity
value of the last insert can be retrieved.
I would expect the result to look like:
<databaseQuery>
<rowset nrofrows="3" name="select">
<row><Col1>1</Col1></row>
<row><Col1>2</Col1></row>
<row><Col1>3</Col1></row>
</rowset>
<rowset returncode="3" name="update"/>
<databaseQuery>
However this is not what happens for numerous reasons.
My understanding is that the esql taglib does operate in this way and I
would have thought that it would be advantageous to have SQLTransformer to
do the same.
So, is my assumption on the output format correct? If so I'll go ahead with
the changes to make it so.
Cheers,
Dean
