<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META boundary="----=_Part_1272_6502918.1158186688930" alternative; multipart
Content-Type:>
<META http-equiv=Content-Type content="text/html; charset=us-ascii"
Content-Type: ------="_Part_1272_6502918.1158186688930" inline
Content-Disposition: html; text 7bit Content-Transfer-Encoding:>
<META content="MSHTML 6.00.2900.2963" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT color=#0000ff size=2><SPAN class=411081223-13092006>I have a
problem
with the way that Sybase ASE works with stored procs and triggers. I'm working
with a legacy database that is very poorly designed. All work is performed
using procs and triggers and it's almost impossible to trace it all down. The
problem I'm having is that ASE build results sets, know as done-in-proc result
sets, for each proc that is executed. As most of the triggers on this
databases tables call sp's there can be a large number of done-in-proc
resultSets. </SPAN></FONT></DIV>
<DIV><FONT color=#0000ff size=2><SPAN
class=411081223-13092006></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff size=2><SPAN class=411081223-13092006>The problem
manifests itself when an error is raised by a proc. The execution of the
SQL Statement returns but there can be multiple result sets and only the last
one contains the error. The JConnect JDBC driver has a parameter that can be
set, (IGNORE_DONE_IN_PROC) that tells the driver to ignore the done-in-proc
result sets and only look at the last one. (NO brainner right?)
</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff size=2><SPAN
class=411081223-13092006></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff size=2><SPAN class=411081223-13092006>My question
is,
is there a way to tell iBatis to only look at the last result set so I don't
need to set the parameter on the connection? I know support for multiple result
sets was recently added but I don't think that it was intended to be used for
this type of situation.</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff size=2><SPAN
class=411081223-13092006></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff size=2><SPAN
class=411081223-13092006>Thanks....</SPAN></FONT></DIV></BODY></HTML>
|