Sha256: 42257daa2a1d839af17d9fa89361a22d4753aee2260f6c9ae0db2b2c21e399ee
Contents?: true
Size: 802 Bytes
Versions: 12
Compression:
Stored size: 802 Bytes
Contents
import java.sql.*;
import java.io.*;
public class SelectTest extends PgpoolTest {
public void do_test() throws SQLException {
try {
for (int i = 0; i < 1; i++) {
connection.setAutoCommit(false);
Statement stmt = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
pstmt = connection.prepareStatement("SELECT count(*) FROM sel");
rs = pstmt.executeQuery();
rs.next();
logwriter.println(rs.getInt(1));
rs.close();
pstmt.close();
pstmt = connection.prepareStatement("SELECT sum(a) FROM sel");
rs = pstmt.executeQuery();
rs.next();
logwriter.println(rs.getInt(1));
rs.close();
pstmt.close();
connection.commit();
}
} finally {
connection.close();
logwriter.close();
}
}
public String getTestName() {
return "select";
}
}
Version data entries
12 entries across 12 versions & 1 rubygems