I once had a similar problem with DB2.  The problem was that the DB was configured to allow only one open ResultSet per connection.
With your query, you will have more than one open ResultSet - so make sure your DB is configured to allow this.
Jeff Butler

On Sat, Apr 12, 2008 at 10:47 PM, nepalon <inepalon@163.com> wrote:

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 error
> string (HY010), I think that's probably going to get you a solution
> quickest.
> Larry

View this message in context: http://www.nabble.com/Problem-in-resultMap%3ACause%3A-java.sql.SQLException%3A-Invalid-state%2C-the-ResultSet-object-is-closed-tp16624071p16656703.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.