package conexionDB;
 
import java.sql.Connection;
 
public class ConexionFirebird {
 
	public static Connection con_firebird;
 
	public static Connection conectar(String pURL, String pUser, String pPass) throws Exception {
		try {
			String databaseURL = "jdbc:firebirdsql:" + pURL;
			Class.forName("org.firebirdsql.jdbc.FBDriver");
			con_firebird = java.sql.DriverManager.getConnection(databaseURL, pUser, pPass);
			//System.out.println("Conexión a Firebird Correcta..");
		} catch (Exception e) {
			e.printStackTrace();
			throw new Exception(e);
		}
		return con_firebird;
	}
 
}//end class

import conexionDB.ConexionFirebird;
 
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
 
public static void DescargarMarcaciones(int pCism) throws Exception {
	// instancio conexion de firebird
	Connection connFB = ConexionFirebird.conectar();
	connFB.setAutoCommit(false);
	try {
		// preparo el string de la consulta
		String strSQL = "SELECT * FROM MI_PROCEDEMIENTO_ALMACENADO";
		// preparo el comando de ejecucion de solo lectura, y hacia adelante
		PreparedStatement psFB = connFB.prepareStatement(strSQL,
				ResultSet.TYPE_SCROLL_INSENSITIVE,
				ResultSet.CONCUR_READ_ONLY);
		// ejecuto y cargo en un ResultSet
		ResultSet rs = psFB.executeQuery();
                // commit 
                connFB.commit();
		// leemos e imprimimos los datos del resultset
		System.out.println(rs.getString("COLUMNA1") + " "
			+ rs.getInt("COLUMNA2") + " " + rs.getDate("COLUMNA3"));
	} catch (Exception ex) {
                connFB.rollback();
		throw ex;
	} finally {
		connFB.close();
	}
}