Google for "sql 2005 HY010 jdbc -db2", and you'll get more info - it looks like you're not the first person to get this error, but I didn't see anything that led me to believe that this is a bug in iBATIS - more likely an issue with the driver, possibly configuration.
Try simplifying the mapped statement and/or doing the query with JDBC instead and see what happens. Larry On Mon, Apr 14, 2008 at 11:46 PM, nepalon <[EMAIL PROTECTED]> wrote: > > I am sure my DB is configured to allow more than one ResultSet open.As you > see in the above code, the code CategoryModel model = > categoryDao.getCategoryById(273) I code can work well.The code will load the > category object the id is 273 and its parent category object whick the id is > 270.In this code,more than one ResultSet was open. > > > > > Jeff Butler-2 wrote: > > > > 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. > >> > >> > > > > > > -- > 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-tp16624071p16695510.html > > > Sent from the iBATIS - User - Java mailing list archive at Nabble.com. > >
