-
1. Re: JBoss-4.0.4-GA and Hibernate-3.1.3
ynprasad Jul 19, 2006 11:43 AM (in response to shanr)I am also having a similar issue wih the same environment and as ShanR said it worked on JBoss 4.0.0 and Hibernate 2.0 earlier.
We use WebDav for the files section, and when I try to upload a file, this SQL exception Already closed comes up.
INFO [STDOUT] org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter - WARNING - java.sql.SQLException: Already closed
ERROR [STDERR] java.sql.SQLException: Already closed at org.jboss.resource.adapter.jdbc.WrappedResultSet.close(WrappedResultSet.java:178)
ERROR [STDERR] at org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.close(StandardRDBMSAdapter.java:1383)
ERROR [STDERR] at org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.createRevisionDescriptors(StandardRDBMSAdapter.java:976)
Any suggestions please. -
2. Re: JBoss-4.0.4-GA and Hibernate-3.1.3
nabeelhamad Jul 21, 2006 6:37 AM (in response to shanr)We also had the exact problem.
In a particular part of our code first we close the Statement and then we close the resultSet. In the line where we close the result set the 'Already Closed' exception is thrown.
We tested the same on JBoss4.0.3 and is working fine. -
3. Re: JBoss-4.0.4-GA and Hibernate-3.1.3
ynprasad Jul 21, 2006 9:10 AM (in response to shanr)I found a soultion for my issue, since it was the exception from the apache.slide end, I have commented the closing part of statement and result set on the apache classes, so that Jboss can take care of it on this side.
So that fixed the exception being thrown on the console.
And coming to the previous question, I think the order matters, if a Statment is closed automatically the ResultSet is closed as it is associated with the Statement.
So if you really want to make sure all to be closed, make sure you close the ResultSet first and then Statement and finally the Connection.
Please let me know if this helps. -
4. Re: JBoss-4.0.4-GA and Hibernate-3.1.3
ssgemail Jul 24, 2006 3:09 AM (in response to shanr)try it as following:
if (rs != null){
rs.close();
}
if (stmt != null){
stmt.close();
} -
6. Re: JBoss-4.0.4-GA and Hibernate-3.1.3
pr_fi Sep 21, 2006 4:29 PM (in response to shanr)"pr_fi" wrote:
http://www.jboss.com/index.html?module=bb&op=viewtopic&t=86912
Apologies for above post. Request to moderator: please delete. Both.