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?
[code]/*
- 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();
}
}[/code]