Why does the result set keep closing after just one insert? There are many more rows to insert for this result set.
sqlText = "select * from table;";
results1 = sql.executeQuery(sqlText);
while (results1.next()) //error occurrs here "this result set is closed"
CACTD_FileNumber = results1.getString("FileNumber");
sqlText = "INSERT INTO another_table VALUES(CACTD_FileNumber)";