Java Code Examples for java.sql.Connection#getHoldability()
The following examples show how to use
java.sql.Connection#getHoldability() .
You can vote up the ones you like or vote down the ones you don't like,
and go to the original project or source file by following the links above each example. You may check out the related API usage on the sidebar.
Example 1
Source File: GroupStatement.java From Zebra with Apache License 2.0 | 6 votes |
private Statement createInnerStatement(Connection conn, boolean isBatch) throws SQLException { Statement stmt; if (isBatch) { stmt = conn.createStatement(); } else { int tmpResultSetHoldability = this.resultSetHoldability; if (tmpResultSetHoldability == -1) { tmpResultSetHoldability = conn.getHoldability(); } stmt = conn.createStatement(this.resultSetType, this.resultSetConcurrency, tmpResultSetHoldability); } stmt.setQueryTimeout(queryTimeout); stmt.setFetchSize(fetchSize); stmt.setMaxRows(maxRows); setInnerStatement(stmt); return stmt; }
Example 2
Source File: GroupPreparedStatement.java From Zebra with Apache License 2.0 | 6 votes |
private PreparedStatement createPreparedStatementInternal(Connection conn, String sql) throws SQLException { PreparedStatement pstmt; if (autoGeneratedKeys != -1) { pstmt = conn.prepareStatement(sql, autoGeneratedKeys); } else if (columnIndexes != null) { pstmt = conn.prepareStatement(sql, columnIndexes); } else if (columnNames != null) { pstmt = conn.prepareStatement(sql, columnNames); } else { int resultSetHoldability = this.resultSetHoldability; if (resultSetHoldability == -1) { resultSetHoldability = conn.getHoldability(); } pstmt = conn.prepareStatement(sql, this.resultSetType, this.resultSetConcurrency, resultSetHoldability); } pstmt.setQueryTimeout(queryTimeout); pstmt.setFetchSize(fetchSize); pstmt.setMaxRows(maxRows); setInnerStatement(pstmt); return pstmt; }
Example 3
Source File: TGroupStatement.java From tddl5 with Apache License 2.0 | 6 votes |
/** * 会调用setBaseStatement以关闭已有的Statement */ private Statement createStatementInternal(Connection conn, String sql, boolean isBatch) throws SQLException { Statement stmt; if (isBatch) { stmt = conn.createStatement(); } else { int resultSetHoldability = this.resultSetHoldability; if (resultSetHoldability == -1) {// 未调用过setResultSetHoldability resultSetHoldability = conn.getHoldability(); } stmt = conn.createStatement(this.resultSetType, this.resultSetConcurrency, resultSetHoldability); } setBaseStatement(stmt); // 会关闭已有的Statement stmt.setQueryTimeout(queryTimeout); // 这句也有可能抛出异常,放在最后 stmt.setFetchSize(fetchSize); stmt.setMaxRows(maxRows); // 填充sql元信息 if (stmt instanceof DataChannel) { ((DataChannel) stmt).fillMetaData(sqlMetaData); } return stmt; }
Example 4
Source File: TGroupStatement.java From tddl with Apache License 2.0 | 6 votes |
/** * 会调用setBaseStatement以关闭已有的Statement */ private Statement createStatementInternal(Connection conn, String sql, boolean isBatch) throws SQLException { Statement stmt; if (isBatch) { stmt = conn.createStatement(); } else { int resultSetHoldability = this.resultSetHoldability; if (resultSetHoldability == -1) {// 未调用过setResultSetHoldability resultSetHoldability = conn.getHoldability(); } stmt = conn.createStatement(this.resultSetType, this.resultSetConcurrency, resultSetHoldability); } setBaseStatement(stmt); // 会关闭已有的Statement stmt.setQueryTimeout(queryTimeout); // 这句也有可能抛出异常,放在最后 stmt.setFetchSize(fetchSize); stmt.setMaxRows(maxRows); // 填充sql元信息 fillSqlMetaData(stmt, sql); return stmt; }
Example 5
Source File: TGroupPreparedStatement.java From tddl with Apache License 2.0 | 6 votes |
private PreparedStatement createPreparedStatementInternal(Connection conn, String sql) throws SQLException { PreparedStatement ps; if (autoGeneratedKeys != -1) { ps = conn.prepareStatement(sql, autoGeneratedKeys); } else if (columnIndexes != null) { ps = conn.prepareStatement(sql, columnIndexes); } else if (columnNames != null) { ps = conn.prepareStatement(sql, columnNames); } else { int resultSetHoldability = this.resultSetHoldability; if (resultSetHoldability == -1) // 未调用过setResultSetHoldability resultSetHoldability = conn.getHoldability(); ps = conn.prepareStatement(sql, this.resultSetType, this.resultSetConcurrency, resultSetHoldability); } setBaseStatement(ps); ps.setQueryTimeout(queryTimeout); // 这句可能抛出异常,所以要放到setBaseStatement之后 ps.setFetchSize(fetchSize); ps.setMaxRows(maxRows); fillSqlMetaData(ps, sql); return ps; }
Example 6
Source File: J2EEDataSourceTest.java From gemfirexd-oss with Apache License 2.0 | 5 votes |
/** * Verify connection holdablity is expected holdability * @param conn * @param expectedHoldability * * @throws SQLException */ private static void assertConnHoldability( Connection conn, int expectedHoldability) throws SQLException { int holdability = conn.getHoldability(); assertEquals (expectedHoldability, holdability); }
Example 7
Source File: ConnectionConcierge.java From cosmic with Apache License 2.0 | 5 votes |
public ConnectionConcierge(final String name, final Connection conn, final boolean keepAlive) { _name = name + s_mgr.getNextId(); _keepAlive = keepAlive; try { _autoCommit = conn.getAutoCommit(); _isolationLevel = conn.getTransactionIsolation(); _holdability = conn.getHoldability(); } catch (final SQLException e) { throw new CloudRuntimeException("Unable to get information from the connection object", e); } reset(conn); }
Example 8
Source File: JRJdbcQueryExecuter.java From jasperreports with GNU Lesser General Public License v3.0 | 5 votes |
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; } return connection.getHoldability(); }
Example 9
Source File: J2EEDataSourceTest.java From gemfirexd-oss with Apache License 2.0 | 5 votes |
/** * Verify connection holdablity is expected holdability * @param conn * @param expectedHoldability * * @throws SQLException */ private static void assertConnHoldability( Connection conn, int expectedHoldability) throws SQLException { int holdability = conn.getHoldability(); assertEquals (expectedHoldability, holdability); }
Example 10
Source File: TGroupPreparedStatement.java From tddl5 with Apache License 2.0 | 5 votes |
private PreparedStatement createPreparedStatementInternal(Connection conn, String sql) throws SQLException { PreparedStatement ps; if (autoGeneratedKeys != -1) { ps = conn.prepareStatement(sql, autoGeneratedKeys); } else if (columnIndexes != null) { ps = conn.prepareStatement(sql, columnIndexes); } else if (columnNames != null) { ps = conn.prepareStatement(sql, columnNames); } else { int resultSetHoldability = this.resultSetHoldability; if (resultSetHoldability == -1) // 未调用过setResultSetHoldability resultSetHoldability = conn.getHoldability(); ps = conn.prepareStatement(sql, this.resultSetType, this.resultSetConcurrency, resultSetHoldability); } setBaseStatement(ps); ps.setQueryTimeout(queryTimeout); // 这句可能抛出异常,所以要放到setBaseStatement之后 ps.setFetchSize(fetchSize); ps.setMaxRows(maxRows); if (this.getLocalInfileInputStream() != null) { LoadFileUtils.setLocalInfileInputStream(ps, this.getLocalInfileInputStream()); } if (ps instanceof DataChannel) { ((DataChannel) ps).fillMetaData(this.sqlMetaData); } return ps; }
Example 11
Source File: ConnectionConcierge.java From cloudstack with Apache License 2.0 | 5 votes |
public ConnectionConcierge(String name, Connection conn, boolean keepAlive) { _name = name + s_mgr.getNextId(); _keepAlive = keepAlive; try { _autoCommit = conn.getAutoCommit(); _isolationLevel = conn.getTransactionIsolation(); _holdability = conn.getHoldability(); } catch (SQLException e) { throw new CloudRuntimeException("Unable to get information from the connection object", e); } reset(conn); }
Example 12
Source File: J2EEDataSourceTest.java From spliceengine with GNU Affero General Public License v3.0 | 5 votes |
/** * Verify connection holdablity is expected holdability * @param conn * @param expectedHoldability * * @throws SQLException */ private static void assertConnHoldability( Connection conn, int expectedHoldability) throws SQLException { int holdability = conn.getHoldability(); assertEquals (expectedHoldability, holdability); }