SQL-JAVA ResultSet problem

Expand Post »

Hi,

I get the following exception when i try to run the following code segment.

JAVA Syntax (Toggle Plain Text)
stmt = (Statement) conn.createStatement();
 
rs = stmt.executeQuery( "SHOW TABLES");
 
if(rs.first()) {
	stmt.execute( "DROP TABLE " + rs.getString(1));
	while (rs.next()){
		stmt.execute( "DROP TABLE " + rs.getString(1));
	}
}
stmt = (Statement) conn.createStatement();
			
rs = stmt.executeQuery( "SHOW TABLES");
						
if(rs.first()) {
	stmt.execute( "DROP TABLE " + rs.getString(1));
	while (rs.next()){
		stmt.execute( "DROP TABLE " + rs.getString(1));
	}
}

And the exception i get is:

SQLException: Operation not allowed after ResultSet closed
SQLState: S1000
VendorError: 0

Last edited by yassar; Apr 23rd, 2008 at 4:45 am.

Similar Threads

Problem with database connection in JSP
JNDI/JDBC lookup problem with Sun Java Application Server 8.2 in Java
plz tell me how to solve problem in JSP
Problem adding registration data to mysql database in JSP
Date type problem JSP, mySQL in Java

yassar

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

35 posts
since May 2005

Permalink

Apr 23rd, 2008

Re: SQL-JAVA ResultSet problem

You have executed a new query here through your statement so the result set you obtained with that statement is no longer valid and you cannot retrieve field values from it.

java Syntax (Toggle Plain Text)
stmt.execute( "DROP TABLE " + rs.getString(1));
stmt.execute( "DROP TABLE " + rs.getString(1));

Create a separate statement object to make your "DROP TABLE" calls with.

java Syntax (Toggle Plain Text)
PreparedStatement updateStmt = conn.prepareStatement("DROP TABLE ?");
 
stmt = conn.createStatement();
 
rs = stmt.executeQuery( "SHOW TABLES");
 
while (rs.next()) {
    updateStmt.setString(1, rs.getString(1));
    updateStmt.executeUpdate();
}
updateStmt.close();
stmt.close();
PreparedStatement updateStmt = conn.prepareStatement("DROP TABLE ?");

stmt = conn.createStatement();
			
rs = stmt.executeQuery( "SHOW TABLES");
						
while (rs.next()) {
    updateStmt.setString(1, rs.getString(1));
    updateStmt.executeUpdate();
}
updateStmt.close();
stmt.close();

Ezzaral

Moderator

Featured Poster

Reputation Points: 3239

Solved Threads: 838

Posting Genius

Offline

6,756 posts
since May 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Java Forum Timeline: null pointer exception --- urgent

Next Thread in Java Forum Timeline: Help In Java

DaniWeb Message

Cancel Changes

User Name
Password