git.8kb.co.uk Git - pgpool-ii/pgpool-ii_2.2.5/blob - test/jdbc/CreateTempTableTest.java

   1 import java.sql.*;
   2
   3 public class CreateTempTableTest extends PgpoolTest {
   4     public void do_test() throws SQLException {
   5
   6         try {
   7             ResultSet rs;
   8             PreparedStatement pstmt = null;
   9             Statement stmt = null;
  10
  11             connection.setAutoCommit(false);
  12
  13             pstmt = connection.prepareStatement("CREATE TEMP TABLE t1(i INTEGER)");
  14             pstmt.executeUpdate();
  15             pstmt.close();
  16
  17             pstmt = connection.prepareStatement("INSERT INTO t1 SELECT ?");
  18             pstmt.setInt(1, 100);
  19             pstmt.executeUpdate();
  20             pstmt.close();
  21
  22             pstmt = connection.prepareStatement("UPDATE t1 SET i = ?");
  23             pstmt.setInt(1, 200);
  24             pstmt.executeUpdate();
  25             pstmt.close();
  26
  27                 pstmt = connection.prepareStatement("SELECT sum(i) FROM t1");
  28                 rs = pstmt.executeQuery();
  29                 rs.next();
  30                 logwriter.println(rs.getInt(1));
  31                 rs.close();
  32                 pstmt.close();
  33
  34             connection.commit();
  35         }
  36         finally {
  37             connection.close();
  38             logwriter.close();
  39         }
  40     }
  41
  42     public String getTestName() {
  43         return "CreateTempTable";
  44     }
  45 }