private int insertTestDataOffsetDTTypes(PreparedStatement pstmt) throws Exception {
  pstmt.setInt(1,1);
  pstmt.setObject(2,testOffsetTime,JDBCType.VARCHAR);
  pstmt.setObject(3,testOffsetTime);
  pstmt.setObject(4,testOffsetDateTime,JDBCType.VARCHAR);
  pstmt.setObject(5,testOffsetDateTime);
  assertEquals(1,pstmt.executeUpdate());
  if (pstmt instanceof CallableStatement) {
    CallableStatement cstmt=(CallableStatement)pstmt;
    cstmt.setInt("id",2);
    cstmt.setObject("ot1",testOffsetTime,JDBCType.VARCHAR);
    cstmt.setObject("ot2",testOffsetTime);
    cstmt.setObject("odt1",testOffsetDateTime,JDBCType.VARCHAR);
    cstmt.setObject("odt2",testOffsetDateTime);
    assertEquals(1,cstmt.executeUpdate());
    return 2;
  }
  return 1;
}

private int insertTestDataOffsetDTTypes ( PreparedStatement pstmt ) throws Exception { pstmt . setInt ( 1 , 1 ) ; pstmt . setObject ( 2 , testOffsetTime , JDBCType . VARCHAR ) ; pstmt . setObject ( 3 , testOffsetTime ) ; pstmt . setObject ( 4 , testOffsetDateTime , JDBCType . VARCHAR ) ; pstmt . setObject ( 5 , testOffsetDateTime ) ; assertEquals ( 1 , pstmt . executeUpdate ( ) ) ; if ( pstmt instanceof CallableStatement ) { CallableStatement cstmt = ( CallableStatement ) pstmt ; cstmt . setInt ( "id" , 2 ) ; cstmt . setObject ( "ot1" , testOffsetTime , JDBCType . VARCHAR ) ; cstmt . setObject ( "ot2" , testOffsetTime ) ; cstmt . setObject ( "odt1" , testOffsetDateTime , JDBCType . VARCHAR ) ; cstmt . setObject ( "odt2" , testOffsetDateTime ) ; assertEquals ( 1 , cstmt . executeUpdate ( ) ) ; return 2 ; } return 1 ; }
helper method for * setobject * tests . insert data into the given preparedstatement , or any of its subclasses , with the following structure : 1 - ` id ` int 2 - ` ot1 ` varchar 3 - ` ot2 ` blob 4 - ` odt1 ` varchar 5 - ` odt2 ` blob
