ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Christopher.Mathru...@sybase.com
Subject Multiple ResultSet's
Date Wed, 13 Sep 2006 23:19:46 GMT
<!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&nbsp;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&nbsp;that is executed. As most of the triggers on this 
databases tables call sp's there can be a large&nbsp;number of done-in-proc 
resultSets.&nbsp;</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff size=2><SPAN 
class=411081223-13092006></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT color=#0000ff size=2><SPAN class=411081223-13092006>The problem

manifests itself when an error is raised by a proc.&nbsp;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>&nbsp;</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>&nbsp;</DIV>
<DIV><FONT color=#0000ff size=2><SPAN 
class=411081223-13092006>Thanks....</SPAN></FONT></DIV></BODY></HTML>


Mime
View raw message