@Override
public void setUp() throws Exception {
super.setUp();
TestUtil.createTable(
con,
"BugFreezeTable",
"Col1 INTEGER NOT NULL,"
+ "Col2 DATE NOT NULL,"
+ "Col3 DOUBLE PRECISION NULL,"
+ "Col4 SMALLINT NOT NULL,"
+ "Col5 NUMERIC (10) NULL,"
+ "Col6 DATE NULL,"
+ "Col7 NUMERIC (10) NOT NULL,"
+ "Col8 NUMERIC (10) NULL");
}
public void xtestLocking() throws Exception {
Connection con = TestUtil.openDB();
Connection con2 = TestUtil.openDB();
TestUtil.createTable(con, "test_lock", "name text");
Statement st = con.createStatement();
Statement st2 = con2.createStatement();
con.setAutoCommit(false);
st.execute("lock table test_lock");
st2.executeUpdate("insert into test_lock ( name ) values ('hello')");
con.commit();
TestUtil.dropTable(con, "test_lock");
con.close();
con2.close();
}
protected void setUp() throws Exception {
// We must change the default TZ before establishing the connection.
// Arbitrary timezone that doesn't match our test timezones
TimeZone.setDefault(TimeZone.getTimeZone("GMT+01"));
connect();
TestUtil.createTable(
con,
"testtimezone",
"seq int4, tstz timestamp with time zone, ts timestamp without time zone, t time without time zone, tz time with time zone, d date");
// This is not obvious, but the "gmt-3" timezone is actually 3 hours *ahead* of GMT
// so will produce +03 timestamptz output
con.createStatement().executeUpdate("set timezone = 'gmt-3'");
// System.err.println("++++++ TESTS START (" + getName() + ") ++++++");
}