Is it possible that your procedure fails if called simultaneously? My guess is an error occured in the proc and failed to return a value.
I would verify in sqlplus your pl/sql is reentrant. Regards, Mike Fagan ----- Original Message ----- From: Hendry [mailto:[EMAIL PROTECTED] Sent: 5/18/2006 1:09:40 AM To: [email protected] Subject: Error calling procedure simultaneously > Hi all, > > I got a problem with my sql map, i got a procedure with parameter map > and result map, with return of oracle refcursor, and i'm using ibatis > library that i got from > http://opensource.atlassian.com/confluence/oss/display/IBATIS/Oracle+REF+CURSOR+Solutions > > The procedure is working fine, I also got the result cursor, but when my > application calls the same procedure simultaneously, i got an error > message.. > > Exception in thread "main" com.ibatis.dao.client.DaoException: Cause : > com.ibatis.common.jdbc.exception.NestedSQLException: > --- The error occurred in conf/queries.xml. > --- The error occurred while applying a result map. > --- Check the queries.content-order-map-max. > --- The error happened while setting a property on the result object. > --- Cause: java.lang.RuntimeException: Error setting properties of > '[EMAIL PROTECTED]'. Cause: > java.lang.IllegalArgumentException > Caused by: java.lang.RuntimeException: Error setting properties of > '[EMAIL PROTECTED]'. Cause: > java.lang.IllegalArgumentException > at .... > > Any help or comment would be very appreciated. Thanx. > > Regards, > Hendry >
