oracle querytimeout,聊聊pg jdbc的queryTimeout及next方法

序

本文主要介绍一下pg jdbc statement的queryTimeout及resultSet的next方法

实例程序

@Test

public void testReadTimeout() throws SQLException {

Connection connection = dataSource.getConnection();

//https://jdbc.postgresql.org/documentation/head/query.html

connection.setAutoCommit(false); //NOTE 为了设置fetchSize,必须设置为false

String sql = "select * from demo_table";

PreparedStatement pstmt;

try {

pstmt = (PreparedStatement)connection.prepareStatement(sql);

pstmt.setQueryTimeout(1); //NOTE 设置Statement执行完成的超时时间,前提是socket的timeout比这个大

pstmt.setFetchSize(5000); //NOTE 这样设置为了模拟query timeout的异常

System.out.println("ps.getQueryTimeout():" + pstmt.getQueryTimeout());

System.out.println("ps.getFetchSize():" + pstmt.getFetchSize());

System.out.println("ps.getFetchDirection():" + pstmt.getFetchDirection());

System.out.println("ps.getMaxFieldSize():" + pstmt.getMaxFieldSize());

ResultSet rs = pstmt.executeQuery(); //NOTE 设置Statement执行完成的超时时间,前提是socket的timeout比这个大

//NOTE 这里返回了就代表statement执行完成,默认返回fetchSize的数据

int col = rs.getMetaData().getColumnCount();

System.out.println("============================");

while (rs.next()) { //NOTE 这个的timeout由socket的超时时间设置,oracle.jdbc.ReadTimeout=60000

for (int i = 1; i <= col; i++) {

System.out.print(rs.getObject(i));

}

System.out.println("");

}

System.out.println("============================");

} catch (SQLException e) {

e.printStackTrace();

} finally {

//close resources

}

}

PgStatement

ostgresql-9.4.1212.jre7-sources.jar!/org/postgresql/jdbc/PgStatement.java

executeInternal()

private void executeInternal(CachedQuery cachedQuery, ParameterList queryParameters, int flags)

throws SQLException {

closeForNextExecution();

// Enable cursor-based resultset if possible.

if (fetchSize > 0 && !wantsScrollableResultSet() && !connection.getAutoCommit()

&& !wantsHoldableResultSet()) {

flags |= QueryExecutor.QUERY_FORWARD_CURSOR;

}

if (wantsGeneratedKeysOnce || wantsGeneratedKeysAlways) {

flags |= QueryExecutor.QUERY_BOTH_ROWS_AND_STATUS;

// If the no results flag is set (from executeUpdate)

// clear it so we get the generated keys results.

//

if ((flags & QueryExecutor.QUERY_NO_RESULTS) != 0) {

flags &= ~(QueryExecutor.QUERY_NO_RESULTS);

}

}

if (isOneShotQuery(cachedQuery)) {

flags |= QueryExecutor.QUERY_ONESHOT;

}

// Only use named statements after we hit the threshold. Note that only

// named statements can be transferred in binary format.

if (connectio