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.
