public void testServPrepStmtSetObjectAndNewSupportedTypes() throws Exception {
  createTable("testSetObjectSPS1","(id INT, d DATE, t TIME, dt DATETIME, ts TIMESTAMP)");
  Connection testConn=getConnectionWithProps("useServerPrepStmts=true");
  this.pstmt=testConn.prepareStatement("INSERT INTO testSetObjectSPS1 VALUES (?, ?, ?, ?, ?)");
  validateTestDataLocalDTTypes("testSetObjectSPS1",insertTestDataLocalDTTypes(this.pstmt));
  createTable("testSetObjectSPS2","(id INT, ot1 VARCHAR(100), ot2 BLOB, odt1 VARCHAR(100), odt2 BLOB)");
  this.pstmt=testConn.prepareStatement("INSERT INTO testSetObjectSPS2 VALUES (?, ?, ?, ?, ?)");
  validateTestDataOffsetDTTypes("testSetObjectSPS2",insertTestDataOffsetDTTypes(this.pstmt));
}

public void testServPrepStmtSetObjectAndNewSupportedTypes ( ) throws Exception { createTable ( "testSetObjectSPS1" , "(id INT, d DATE, t TIME, dt DATETIME, ts TIMESTAMP)" ) ; Connection testConn = getConnectionWithProps ( "useServerPrepStmts=true" ) ; this . pstmt = testConn . prepareStatement ( "INSERT INTO testSetObjectSPS1 VALUES (?, ?, ?, ?, ?)" ) ; validateTestDataLocalDTTypes ( "testSetObjectSPS1" , insertTestDataLocalDTTypes ( this . pstmt ) ) ; createTable ( "testSetObjectSPS2" , "(id INT, ot1 VARCHAR(100), ot2 BLOB, odt1 VARCHAR(100), odt2 BLOB)" ) ; this . pstmt = testConn . prepareStatement ( "INSERT INTO testSetObjectSPS2 VALUES (?, ?, ?, ?, ?)" ) ; validateTestDataOffsetDTTypes ( "testSetObjectSPS2" , insertTestDataOffsetDTTypes ( this . pstmt ) ) ; }
test for ( server ) preparedstatement . setobject ( ) . validate new methods as well as support for the types java . time . local [ date ] [ time ] and java . time . offset [ date ] time .
