posted 14 years ago
Dear,
Im trying to retrive some information using select query and then pass the result set to another program. While running i got the error saying that the resultset is closed and can not have access. so I cleaned any pstmt.close or con.close . But still it throws me the same error. Do you know where is the problem? Here i copy the SELEC and TRIGGER classes and the error.
////////////Select///////////
//////// a piece of trigger class///////
////////////and here is the error/////////
java.sql.SQLException: Operation not allowed after ResultSet closed
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
Do you know how can i solve it?
Thank you so much,
Sahar.