eu preciso utilizar dois resultset
estou fazendo como no exemplo abaixo: no exemplo mostra a linha com erro...
esta dando a seguinte exception:
Exception in thread "main" org.firebirdsql.jdbc.FBSQLException: The result set is closed
at org.firebirdsql.jdbc.AbstractResultSet.checkCursorMove(AbstractResultSet.java:218)
at org.firebirdsql.jdbc.AbstractResultSet.next(AbstractResultSet.java:260)
at testes.TesteLeitura.main(TesteLeitura.java:41)
Java Result: 1
CONSTRUÍDO COM SUCESSO (tempo total: 0 segundos)
como devo fazer para resolver esta situacao?
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
package testes;
import firedao.PdvPrcDAO;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import java.util.Properties;
import tabelas.MRP0M500AF081Dados;
/**
*
* @author Admin
*/
public class TesteLeitura {
public static void main(String[] args) throws SQLException, ClassNotFoundException {
Properties p = new Properties();
p.put("user", "SYSDBA");
p.put("password", "masterkey");
p.put("lc_ctype", "ISO8859_1");
Class.forName("org.firebirdsql.jdbc.FBDriver");
String url = "jdbc:firebirdsql:127.0.0.1/3050:c:/pdvjgs/dados/mpdv.fdb";
Connection con1 = DriverManager.getConnection(url, p);
String sql1 = "select first 10 * from pdvprc";
PreparedStatement stmt1 = con1.prepareStatement(sql1);
ResultSet rs1 = stmt1.executeQuery();
String sql2 = "select first 10 * from trbmaq";
PreparedStatement stmt2 = con1.prepareStatement(sql2);
ResultSet rs2 = stmt2.executeQuery();
rs1.next();
rs2.next();
rs1.next();
rs1.close();
rs2.close();
stmt1.close();
stmt2.close();
con1.close();
}
}