Wednesday, April 2, 2014

Cursores con JDBC y Postgres

Se ocupa utilizar cursores al momento de realizar una consulta en una tabla grande, antes de utilizar cursores se debe cumplir los siguientes condiciones:

1. Servidor debe de usar el protocolo V3.

2. La conexión no debe de estar en autocommit;

conn.setAutoCommit(false);

3. El tipo de Resultset debe de ser ResultSet.TYPE_FORWARD_ONLY

4. La consulta debe de ser de sola sentencia.

1 comment:

  1. I have read your blog its very attractive and impressive. I like it your blog.

    Java Training in Chennai Core Java Training in Chennai Core Java Training in Chennai

    Java Online Training Java Online Training Core Java 8 Training in Chennai Core java 8 online training JavaEE Training in Chennai Java EE Training in Chennai

    ReplyDelete