Example usage for java.sql ResultSet CLOSE_CURSORS_AT

Introduction

In this page you can find the example usage for java.sql ResultSet CLOSE_CURSORS_AT_COMMIT.

Prototype

int CLOSE_CURSORS_AT_COMMIT

To view the source code for java.sql ResultSet CLOSE_CURSORS_AT_COMMIT.

Click Source Link

Document

The constant indicating that open ResultSet objects with this holdability will be closed when the current transaction is committed.

Usage

From source file:com.taobao.tdhs.jdbc.TDHSStatement.java

public int getResultSetHoldability() throws SQLException {
    return ResultSet.CLOSE_CURSORS_AT_COMMIT;
}

From source file:net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.java

protected static int getHoldability(String holdability, Connection connection) throws SQLException {
    if (HOLD_CURSORS_OVER_COMMIT.equals(holdability)) {
        return ResultSet.HOLD_CURSORS_OVER_COMMIT;
    } else if (CLOSE_CURSORS_AT_COMMIT.equals(holdability)) {
        return ResultSet.CLOSE_CURSORS_AT_COMMIT;
    }/*from   w w  w  . j  a v  a 2 s. c  om*/

    return connection.getHoldability();
}

From source file:com.couchbase.CBConnection.java

/**
 * Retrieves the current holdability of <code>ResultSet</code> objects
 * created using this <code>Connection</code> object.
 *
 * @return the holdability, one of/*from   w w  w.  j a va 2s . c o  m*/
 * <code>ResultSet.HOLD_CURSORS_OVER_COMMIT</code> or
 * <code>ResultSet.CLOSE_CURSORS_AT_COMMIT</code>
 * @throws java.sql.SQLException if a database access error occurs
 *                               or this method is called on a closed connection
 * @see #setHoldability
 * @see java.sql.DatabaseMetaData#getResultSetHoldability
 * @see java.sql.ResultSet
 * @since 1.4
 */
@Override
public int getHoldability() throws SQLException {
    checkClosed();
    return ResultSet.CLOSE_CURSORS_AT_COMMIT;
}

From source file:com.alibaba.wasp.jdbc.result.JdbcDatabaseMetaData.java

/**
 * Does this database supports a result set holdability.
 * //from ww  w.j  av a  2s  . co m
 * @param holdability
 *          ResultSet.HOLD_CURSORS_OVER_COMMIT or CLOSE_CURSORS_AT_COMMIT
 * @return true if the holdability is ResultSet.CLOSE_CURSORS_AT_COMMIT
 */
public boolean supportsResultSetHoldability(int holdability) {
    return holdability == ResultSet.CLOSE_CURSORS_AT_COMMIT;
}

From source file:com.alibaba.wasp.jdbc.result.JdbcDatabaseMetaData.java

/**
 * Gets the result set holdability./*from www .j  a  v  a2  s  .co  m*/
 * 
 * @return ResultSet.CLOSE_CURSORS_AT_COMMIT
 */
public int getResultSetHoldability() {
    return ResultSet.CLOSE_CURSORS_AT_COMMIT;
}

From source file:net.starschema.clouddb.jdbc.BQConnection.java

/**
 * <p>//w  w w.  j  a va  2  s . c  o  m
 * <h1>Implementation Details:</h1><br>
 * There's no commit.
 * </p>
 * 
 * @return CLOSE_CURSORS_AT_COMMIT
 */
@Override
public int getHoldability() throws SQLException {
    return ResultSet.CLOSE_CURSORS_AT_COMMIT;
}

From source file:net.starschema.clouddb.jdbc.BQDatabaseMetadata.java

/**
 * <p>//from w  w  w .ja  va 2  s  .  c  o  m
 * <h1>Implementation Details:</h1><br>
 * Returns ResultSet.CLOSE_CURSORS_AT_COMMIT
 * </p>
 */
@Override
public int getResultSetHoldability() throws SQLException {
    return ResultSet.CLOSE_CURSORS_AT_COMMIT;
}

From source file:net.starschema.clouddb.jdbc.BQStatementRoot.java

/**
 * <p>//from  w ww. ja  v a2  s .  c om
 * <h1>Implementation Details:</h1><br>
 * Read only mode, no commit.
 * </p>
 * 
 * @return CLOSE_CURSORS_AT_COMMIT
 */

public int getResultSetHoldability() throws SQLException {
    return ResultSet.CLOSE_CURSORS_AT_COMMIT;
    // TODO
}

From source file:org.kawanfw.sql.jdbc.ConnectionHttp.java

/**
 * Creates a <code>Statement</code> object for sending SQL statements to the
 * database. SQL statements without parameters are normally executed using
 * <code>Statement</code> objects. If the same SQL statement is executed
 * many times, it may be more efficient to use a
 * <code>PreparedStatement</code> object.
 * <P>/*from  www.j a v  a2 s . c o  m*/
 * Result sets created using the returned <code>Statement</code> object will
 * by default be type <code>TYPE_FORWARD_ONLY</code> and have a concurrency
 * level of <code>CONCUR_READ_ONLY</code>.
 * 
 * @return a new default <code>Statement</code> object
 * @exception SQLException
 *                if a database access error occurs
 */
@Override
public Statement createStatement() throws SQLException {
    testIfClosed();

    return new StatementHttp(this, ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY,
            ResultSet.CLOSE_CURSORS_AT_COMMIT);
}

From source file:org.kawanfw.sql.jdbc.ConnectionHttp.java

/**
 * Creates a <code>CallableStatement</code> object for calling database
 * stored procedures. The <code>CallableStatement</code> object provides
 * methods for setting up its IN and OUT parameters, and methods for
 * executing the call to a stored procedure.
 * // www  . jav a  2 s . c o  m
 * <P>
 * <B>Note:</B> This method is optimized for handling stored procedure call
 * statements. Some drivers may send the call statement to the database when
 * the method <code>prepareCall</code> is done; others may wait until the
 * <code>CallableStatement</code> object is executed. This has no direct
 * effect on users; however, it does affect which method throws certain
 * SQLExceptions.
 * <P>
 * Result sets created using the returned <code>CallableStatement</code>
 * object will by default be type <code>TYPE_FORWARD_ONLY</code> and have a
 * concurrency level of <code>CONCUR_READ_ONLY</code>.
 * 
 * @param sql
 *            an SQL statement that may contain one or more '?' parameter
 *            placeholders. Typically this statement is a JDBC function call
 *            escape string.
 * @return a new default <code>CallableStatement</code> object containing
 *         the pre-compiled SQL statement
 * @exception SQLException
 *                if a database access error occurs
 */
@Override
public CallableStatement prepareCall(String sql) throws SQLException {

    testIfClosed();

    return new CallableStatementHttp(this, sql, ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY,
            ResultSet.CLOSE_CURSORS_AT_COMMIT);
}

Example usage for java.sql ResultSet CLOSE_CURSORS_AT_COMMIT

Introduction

Prototype

Document

Usage