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 <[EMAIL PROTECTED]> 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. > >
