Re: interesting exception in 3.0

2010-05-14 Thread Clinton Begin
Thanks so much Francois, I appreciate the effort you applied to validating this. Cheers, Clinton 2010/5/14 François Schiettecatte > Clinton > > Ok this is interesting, I was able to reliably replicate the problem, I > even grabbed the source code and included in the source code tree of my > app

Re: interesting exception in 3.0

2010-05-14 Thread François Schiettecatte
Clinton Ok this is interesting, I was able to reliably replicate the problem, I even grabbed the source code and included in the source code tree of my application and still got the issue, but... the server I am running this one was rebooted due to a power failure and now the problem has gone a

RE: Need support for Dynamic procedure invocation

2010-05-14 Thread Nicky Jha
Joe/Jeff This worked with your suggestion.Thank you so much!!! Nicky -Original Message- From: Jeff Butler [mailto:jeffgbut...@gmail.com] Sent: Friday, May 14, 2010 6:31 PM To: user-java@ibatis.apache.org Subject: Re: Need support for Dynamic procedure invocation Yes - this the best app

Re: Need support for Dynamic procedure invocation

2010-05-14 Thread Jeff Butler
Yes - this the best approach. Jeff Butler On 5/14/10, Joe Gooch wrote: > I suggest going with a dynamic SQL approach in the mapped statement. > > public class DynamicProcedureParams { > private String procedureName; > private List params = new ArrayList(); > > // getters and setters here

RE: Need support for Dynamic procedure invocation

2010-05-14 Thread Joe Gooch
I suggest going with a dynamic SQL approach in the mapped statement. public class DynamicProcedureParams { private String procedureName; private List params = new ArrayList(); // getters and setters here } {call $procedureName$ #params[]# } Joe Confidentiality Notice: This e-mail tra

RE: Need support for Dynamic procedure invocation

2010-05-14 Thread Nicky Jha
Hi Jeff, Thanks for this, if I was to do as suggested and compose the entire string with parameter values, how will the parameter types (e.g. date, smallint etc) be handled? Nicky! -Original Message- From: Jeff Butler [mailto:jeffgbut...@gmail.com] Sent: Friday, May 14, 2010 4:53 PM

Re: Need support for Dynamic procedure invocation

2010-05-14 Thread Jeff Butler
This won't work (as you've discovered). iBATIS 2.x does not reparse the string for variables after string substitution. You'll need to do this with the dynamic tags, or you'll need to compose the entire string (including parameter values - like {call myproc('fred')}). Jeff Butler On Fri, May 1