RE: Problem with stored procedure and resultMap or resultClass?

2005-06-03 Thread Ravi Sundaar
My question is fairly simple: How can I use ibatis to get result sets from a stored procedure that has no "OUT" or "INOUT" parameters? The stored procedures that I need to invoke take one or more "IN" parameters and generate one or more result sets. They don't have any declared "OUT" or "INOUT" p

RE: Oracle Cursor From Stored Procedure

2005-06-03 Thread Carson Reinke
That will work, thanks! Thanks. Carson Reinke [EMAIL PROTECTED] P: 248.333.7700 x108 -Original Message- From: Sven Boden [mailto:[EMAIL PROTECTED] Sent: Friday, June 03, 2005 3:30 PM To: ibatis-user-java@incubator.apache.org Subject: Re: Oracle Cursor From Stored Procedure Try exam

Re: Oracle Cursor From Stored Procedure

2005-06-03 Thread Sven Boden
Try example "7) showcase_storedprocedure1.txt" on http://issues.apache.org/jira/browse/IBATIS-53 You need to use a TypeHandlerCallback. Regards, Sven Boden On Fri, 3 Jun 2005 15:29:29 -0400, you wrote: > >Anyone have information about using an Oracle cursor as a OUT parameter >from a stored pr

Oracle Cursor From Stored Procedure

2005-06-03 Thread Carson Reinke
Anyone have information about using an Oracle cursor as a OUT parameter from a stored procedure? Thanks. Carson Reinke [EMAIL PROTECTED] P: 248.333.7700 x108

RE: Problem with stored procedure and resultMap or resultClass?

2005-06-03 Thread Ravi Sundaar
Actually, I did use "casefileId" and not "@casefileId" - using "@casefileId" was one of my desperate attempts after trying so many different things. The result is the same, nevertheless... Thanks for the suggestion anyway. Any other thoughts? Ravi.>From: "Niels Beekman" <[EMAIL PROTECTED]>>Reply-T

Re: Calling DAO within TypeHandlerCallback

2005-06-03 Thread Brandon Goodin
Sounds more like we need to provide savepoints support for this kind of stuff. Nested Transactions sound yucky. Brandon On 6/3/05, Niels Beekman <[EMAIL PROTECTED]> wrote: > Yes, but they are not separate, I think the following happens: > > MyDao > getObject() > startTran

RE: Problem with stored procedure and resultMap or resultClass?

2005-06-03 Thread Niels Beekman
Maybe because you are putting a '@casefileId' in your parameterName? Try using 'casefileId'. Hope this helps, Niels From: Ravi Sundaar [mailto:[EMAIL PROTECTED] Sent: vrijdag 3 juni 2005 12:44 To: ibatis-user-java@incubator.apache.org Cc: [EMAIL PROTECT

Problem with stored procedure and resultMap or resultClass?

2005-06-03 Thread Ravi Sundaar
 am running into a problem accessing result sets from stored procedure using ibatis datamapper. My DBMS is sybase and driver is Jtds. Here is the sqlmap: http://www.ibatis.com/dtd/sql-map-2.dtd"> javaType="java.lang.String" mode="IN"/> {call stpRtrvPropAssessmt (?)}

RE: Calling DAO within TypeHandlerCallback

2005-06-03 Thread Niels Beekman
Yes, but they are not separate, I think the following happens: MyDao getObject() startTransaction() MyTypeHandlerCallBack.getResult() MyOtherDao.getOtherObject() startTransaction() - state is already ac