Sha256: e6fce1a20c5c997cec182e2007f1c5c844f61a9bffb13ccfa4681af3839a7ab8
Contents?: true
Size: 1.1 KB
Versions: 12
Compression:
Stored size: 1.1 KB
Contents
/*
* Test for master/slave mode + temporary tables
*/
import java.sql.*;
public class CreateTempTableTest extends PgpoolTest {
public void do_test() throws SQLException {
try {
ResultSet rs;
PreparedStatement pstmt = null;
Statement stmt = null;
connection.setAutoCommit(false);
pstmt = connection.prepareStatement("CREATE TEMP TABLE t1(i INTEGER)");
pstmt.executeUpdate();
pstmt.close();
pstmt = connection.prepareStatement("/*NO LOAD BALANCE*/ INSERT INTO t1 SELECT ?");
pstmt.setInt(1, 100);
pstmt.executeUpdate();
pstmt.close();
pstmt = connection.prepareStatement("/*NO LOAD BALANCE*/ UPDATE t1 SET i = ?");
pstmt.setInt(1, 200);
pstmt.executeUpdate();
pstmt.close();
pstmt = connection.prepareStatement("/*NO LOAD BALANCE*/ SELECT sum(i) FROM t1");
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 "CreateTempTable";
}
}
Version data entries
12 entries across 12 versions & 1 rubygems