I realize this reply is over a year late, but I was
having similar problems and believe I've discovered
the reason why.
Around line 1057 of the SQLTransformer is the
following check:
if (query.length() > 6 &&
!query.substring(0,6).equalsIgnoreCase("SELECT")) {
isupdate = true;
}
Since your query starts with SET ROWCOUNT 200, and not
SELECT, the transformer assumes it's an update. Later
on, around line 1269 is the following:
} else if ( isupdate && !isstoredprocedure ) {
transformer.start( "returncode", attr );
this.serializeData(manager, String.valueOf( rv )
);
transformer.end( "returncode" );
rv = -1; // we only want the return code shown
once.
}
Since isupdate is now true this match is returning all
your <returncode>'s. In order to avoid this you'll
have to modify the first check to be more general.
Andrew
>My problem is still there:
>beginning with SET ROWCOUNT 200, the request works on
Sybase >Jsql, but it is failing in the Cocoon
application, and >returning as many times
<returncode>-1</returncode>
>
>I didn't find anything on the Web nor in the
archives to solve >this.
>Is it a Cocoon request decoding problem?
>
>Please help me!
>
>Matt
__________________________________________
Yahoo! DSL Something to write home about.
Just $16.99/mo. or less.
dsl.yahoo.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
