Re: Problem in resultMap:Cause: java.sql.SQLException: Invalid state, the ResultSet object is closed

2008-04-12 Thread nepalon
The DB i using is SQL Server2005.The error string(HY010) means "Invalid state, the ResultSet object is closed".Somebody says this error cause by using miscrosoft sql server driver,but I using jtds as my dirver. Larry Meadors wrote: > > This looks like a DB2 issue, you may want to search for that

Re: groupby x out of memory

2008-04-12 Thread Harvey Kim
Yeap, that's what I ended up doing. I used subsequent selects to get the list and that seem to have solved the problem. Although, I did get out of memory with using RowHandler even after I got rid of the groupBy but that only happened once (out of thousands of runs as oppose to happening everytim

Re: Problem in resultMap:Cause: java.sql.SQLException: Invalid state, the ResultSet object is closed

2008-04-12 Thread Larry Meadors
This looks like a DB2 issue, you may want to search for that error string (HY010), I think that's probably going to get you a solution quickest. Larry

Re: Sybase OEM

2008-04-12 Thread Jeff Butler
I have that *not quite* right - you need to also override the TransactionConfig and specify *that* class in the SqlMapConfig.xml file. Jeff Butler On Sat, Apr 12, 2008 at 7:12 AM, Jeff Butler <[EMAIL PROTECTED]> wrote: > I think your last option is not that bad - it centralizes the > initializ

Re: Sybase OEM

2008-04-12 Thread Jeff Butler
I think your last option is not that bad - it centralizes the initialization of the Connection. Another option with iBATIS is to implement your own transaction manager. Write a class that subclasses the current transaction manager you are using and override the getConnection() method. Look in the

Sybase OEM

2008-04-12 Thread Alex Perez
Hi All, I'm trying to adapt an existing application running with ibatis, to work with sybase. To write the sqlpmaps, I've just rewrited the SQL server 2000 ones, and just worked ok. The tests were done with Sybase ASA 9.x (the "enterprie version"). The problem begins when trying to get it workin