ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mike Fagan" <mfa...@tde.com>
Subject Re: Error calling procedure simultaneously
Date Mon, 22 May 2006 23:43:07 GMT

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:hendry.hu@elasitas.com]
Sent: 5/18/2006 1:09:40 AM
To: user-java@ibatis.apache.org
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 
> 'com.elasitas.content.valueobjects.ContentOrder@2200d5'.  Cause: 
> java.lang.IllegalArgumentException
> Caused by: java.lang.RuntimeException: Error setting properties of 
> 'com.elasitas.content.valueobjects.ContentOrder@2200d5'.  Cause: 
> java.lang.IllegalArgumentException
> 	at ....
> 
> Any help or comment would be very appreciated. Thanx.
> 
> Regards,
> Hendry
> 


Mime
View raw message