I noticed this problem with straight SQL too (insert / update) ...
If I open connection with autocommit(false), and then try to commit / rollback;
I get the same error
Ejaz
From: Glenn Barnard [mailto:barnardgl...@gmail.com]
Sent: Thursday, May 28, 2009 10:54 AM
To: user-java@ibatis.apache.org
There are a number of articles on this problem with SP's. However, I'm using
straight SQL. I'm not sure this is the issue, but I am using the N+1
technique to add child records to the master.
On Thu, May 28, 2009 at 11:48 AM, Ejaz X Mohammed <
ejaz.moham...@jpmorgan.com> wrote:
> I get same erro
I get same error with Sybase 12.5, but when I call a stored proc which has
begin tran / end tran
when I execute same stored proc directly via jdbc, I don't get "SET CHAINED
..." error
Should be something with driver ...jconn2.jar
Ejaz
From: Glenn Barnard [mailto:barnardgl...@gmail.com]
Sent
Hi, all…I’ve been using Ibatis for several months now to build an internal
web application. We’re using connection pooling and so far so good. So now
I’m trying to use the same connection pools for batch applications that are
scheduled to run via a chron type function from the same webserver. Those
my stack trace is:
org.springframework.jdbc.InvalidResultSetAccessException: SqlMapClient
operation; invalid ResultSet access for SQL []; nested exception is
com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred
in securityexam.xml. --- The error occurred while executing query
