Hi, Thomas
I created a sample source which raises ArrayIndexOutOfBoundsException
at version upper 1.1.111. But it works fine at my 1.0.79 version.
Following is the complete source. Please check it out :
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
/**
* Test Case which destruct H2 Database.
* H2 Version 1.0.79 : No error occurs
* H2 Version upper 1.1.111 : Error occurs at 2nd execution
*
*/
public class H2DestructionTest {
static final String URL_LOCK_MODE_0 = "jdbc:h2:file:~/
testdb;LOCK_MODE=0";
static Connection getConnection() throws ClassNotFoundException,
SQLException {
Class.forName("org.h2.Driver");
return DriverManager.getConnection(URL_LOCK_MODE_0, "sa", "");
}
/**
* keep connection used by executeSql1 to rollback at following method
(roolBackExecuteSql1)
*/
static Connection outerConn;
/**
* Error thrown at 2nd trial.
* @throws Exception java.lang.ArrayIndexOutOfBoundsException
*/
public static void main(String[] args) throws Exception {
setUpTestTable();
executeSql1();
executeSql2();
roolBackExecuteSql1();
executeSql3();
executeSql4();
}
static void setUpTestTable() throws Exception {
Connection conn = getConnection();
PreparedStatement pstmt = conn.prepareStatement(
"CREATE TABLE IF NOT EXISTS DIP("
+ " WORK_NO VARCHAR(8),"
+ " REPORT_NO VARCHAR(9),"
+ " USER_NO VARCHAR(16),"
+ " OS_NO VARCHAR(20),"
+ " MODEL_SERIES_CD VARCHAR(24),"
+ " FJ_MODEL_NAME VARCHAR(10),"
+ " ENTRY_TIMESTAMP TIMESTAMP,"
+ " COMPLETE_DATE VARCHAR(8),"
+ " LAST_TIMESTAMP TIMESTAMP,"
+ " LAST_USER_NO VARCHAR(16),"
+ " LAST_HOST_NAME VARCHAR(32),"
+ " UPDATE_VERSION NUMERIC(10, 0),"
+ " PRIMARY KEY(WORK_NO));"
);
pstmt.execute();
conn.close();
}
static void executeSql1() throws Exception {
outerConn = getConnection();
PreparedStatement pstmt = null;
outerConn.setAutoCommit(false);
pstmt = outerConn.prepareStatement(
"INSERT INTO DIP (WORK_NO, REPORT_NO, USER_NO, OS_NO,
MODEL_SERIES_CD, FJ_MODEL_NAME, ENTRY_TIMESTAMP, COMPLETE_DATE,
LAST_TIMESTAMP, LAST_USER_NO, LAST_HOST_NAME, UPDATE_VERSION) VALUES
('00001', 1, '00001', 1, 'TRUE', 1, '2008-09-06 16:27:14', 20080901,
'2008-09-05 12:00:00', 1, 'Takashima', 1);"
+ "INSERT INTO DIP (WORK_NO, REPORT_NO, USER_NO, OS_NO,
MODEL_SERIES_CD, FJ_MODEL_NAME, ENTRY_TIMESTAMP, COMPLETE_DATE,
LAST_TIMESTAMP, LAST_USER_NO, LAST_HOST_NAME, UPDATE_VERSION) VALUES
('00002', 1, '00001', 1, 'FALSE', 1, '2008-09-06 16:27:14', 20080901,
'2008-09-05 12:00:00', 1, 'Takashima', 1)"
);
pstmt.executeUpdate();
}
static void executeSql2() throws Exception {
Connection conn = getConnection();
PreparedStatement pstmt = conn.prepareStatement("UPDATE DIP SET
MODEL_SERIES_CD = '2' WHERE WORK_NO = '00001'");
pstmt.executeUpdate();
conn.close();
}
static void roolBackExecuteSql1() throws Exception {
outerConn.rollback();
outerConn.close();
}
static void executeSql3() throws Exception {
Connection conn = getConnection();
PreparedStatement pstmt = conn.prepareStatement("DELETE from DIP
WHERE WORK_NO = '00001'");
pstmt.execute();
conn.close();
}
static void executeSql4() throws Exception {
Connection conn = getConnection();
conn.setAutoCommit(false);
PreparedStatement pstmt = conn.prepareStatement(
"INSERT INTO DIP (WORK_NO, REPORT_NO, USER_NO,
OS_NO,
MODEL_SERIES_CD, FJ_MODEL_NAME, ENTRY_TIMESTAMP, COMPLETE_DATE,
LAST_TIMESTAMP, LAST_USER_NO, LAST_HOST_NAME, UPDATE_VERSION) VALUES
('W0000202', 13, 'user2', 'osno20', 'a', 'fj1', null, null, null, 0,
null, 5);"
+ "INSERT INTO DIP (WORK_NO, REPORT_NO,
USER_NO, OS_NO,
MODEL_SERIES_CD, FJ_MODEL_NAME, ENTRY_TIMESTAMP, COMPLETE_DATE,
LAST_TIMESTAMP, LAST_USER_NO, LAST_HOST_NAME, UPDATE_VERSION) VALUES
('W0000203', 14, 'user3', 'osno20', 'b', 'fj1', null, null, null, 0,
null, 5);"
+ "INSERT INTO DIP (WORK_NO, REPORT_NO,
USER_NO, OS_NO,
MODEL_SERIES_CD, FJ_MODEL_NAME, ENTRY_TIMESTAMP, COMPLETE_DATE,
LAST_TIMESTAMP, LAST_USER_NO, LAST_HOST_NAME, UPDATE_VERSION) VALUES
('W0000204', 15, 'user4', 'osno20', 'c', 'fj1', null, 20040404, null,
0, null, 5);"
+ "INSERT INTO DIP (WORK_NO, REPORT_NO,
USER_NO, OS_NO,
MODEL_SERIES_CD, FJ_MODEL_NAME, ENTRY_TIMESTAMP, COMPLETE_DATE,
LAST_TIMESTAMP, LAST_USER_NO, LAST_HOST_NAME, UPDATE_VERSION) VALUES
('W0000205', 16, 'user5', 'osno20', 'a', 'fj1', null, null, null, 0,
null, 1);"
+ "INSERT INTO DIP (WORK_NO, REPORT_NO,
USER_NO, OS_NO,
MODEL_SERIES_CD, FJ_MODEL_NAME, ENTRY_TIMESTAMP, COMPLETE_DATE,
LAST_TIMESTAMP, LAST_USER_NO, LAST_HOST_NAME, UPDATE_VERSION) VALUES
('W0000206', 17, 'user6', 'osno20', 'b', 'fj1', null, null, null, 0,
null, 2);"
+ "INSERT INTO DIP (WORK_NO, REPORT_NO,
USER_NO, OS_NO,
MODEL_SERIES_CD, FJ_MODEL_NAME, ENTRY_TIMESTAMP, COMPLETE_DATE,
LAST_TIMESTAMP, LAST_USER_NO, LAST_HOST_NAME, UPDATE_VERSION) VALUES
('W0000207', 18, 'user7', 'osno20', 'c', 'fj1', null, null, null, 0,
null, 2);"
+ "INSERT INTO DIP (WORK_NO, REPORT_NO,
USER_NO, OS_NO,
MODEL_SERIES_CD, FJ_MODEL_NAME, ENTRY_TIMESTAMP, COMPLETE_DATE,
LAST_TIMESTAMP, LAST_USER_NO, LAST_HOST_NAME, UPDATE_VERSION) VALUES
('W0000208', 19, 'user8', 'osno20', 'a', 'fj1', null, null, null, 0,
null, 3);"
+ "INSERT INTO DIP (WORK_NO, REPORT_NO,
USER_NO, OS_NO,
MODEL_SERIES_CD, FJ_MODEL_NAME, ENTRY_TIMESTAMP, COMPLETE_DATE,
LAST_TIMESTAMP, LAST_USER_NO, LAST_HOST_NAME, UPDATE_VERSION) VALUES
('W0000209', 20, 'user9', 'osno20', 'b', 'fj1', null, null, null, 0,
null, 3);"
+ "INSERT INTO DIP (WORK_NO, REPORT_NO,
USER_NO, OS_NO,
MODEL_SERIES_CD, FJ_MODEL_NAME, ENTRY_TIMESTAMP, COMPLETE_DATE,
LAST_TIMESTAMP, LAST_USER_NO, LAST_HOST_NAME, UPDATE_VERSION) VALUES
('W0000210', 21, 'user0', 'osno21', 'c', 'fj1', '2008-09-06 16:27:14',
20080901, '2008-09-05 12:00:00', 0, null, 3);"
+ "INSERT INTO DIP (WORK_NO, REPORT_NO,
USER_NO, OS_NO,
MODEL_SERIES_CD, FJ_MODEL_NAME, ENTRY_TIMESTAMP, COMPLETE_DATE,
LAST_TIMESTAMP, LAST_USER_NO, LAST_HOST_NAME, UPDATE_VERSION) VALUES
('W0000211', 22, 'user1', 'osno21', 'a', 'fj1', null, null, null, 0,
null, 4);"
+ "INSERT INTO DIP (WORK_NO, REPORT_NO,
USER_NO, OS_NO,
MODEL_SERIES_CD, FJ_MODEL_NAME, ENTRY_TIMESTAMP, COMPLETE_DATE,
LAST_TIMESTAMP, LAST_USER_NO, LAST_HOST_NAME, UPDATE_VERSION) VALUES
('W0000212', 23, 'user2', 'osno21', 'b', 'fj1', null, null, null, 0,
null, 4);"
+ "INSERT INTO DIP (WORK_NO, REPORT_NO,
USER_NO, OS_NO,
MODEL_SERIES_CD, FJ_MODEL_NAME, ENTRY_TIMESTAMP, COMPLETE_DATE,
LAST_TIMESTAMP, LAST_USER_NO, LAST_HOST_NAME, UPDATE_VERSION) VALUES
('W0000213', 24, 'user3', 'osno21', 'c', 'fj1', null, null, null, 0,
null, 4);"
+ "INSERT INTO DIP (WORK_NO, REPORT_NO,
USER_NO, OS_NO,
MODEL_SERIES_CD, FJ_MODEL_NAME, ENTRY_TIMESTAMP, COMPLETE_DATE,
LAST_TIMESTAMP, LAST_USER_NO, LAST_HOST_NAME, UPDATE_VERSION) VALUES
('W0000214', 25, 'user4', 'osno21', 'a', 'fj1', null, 20040404, null,
0, null, 4);"
+ "INSERT INTO DIP (WORK_NO, REPORT_NO,
USER_NO, OS_NO,
MODEL_SERIES_CD, FJ_MODEL_NAME, ENTRY_TIMESTAMP, COMPLETE_DATE,
LAST_TIMESTAMP, LAST_USER_NO, LAST_HOST_NAME, UPDATE_VERSION) VALUES
('W0000215', 26, 'user5', 'osno21', 'b', 'fj1', null, null, null, 0,
null, 5);"
+ "INSERT INTO DIP (WORK_NO, REPORT_NO,
USER_NO, OS_NO,
MODEL_SERIES_CD, FJ_MODEL_NAME, ENTRY_TIMESTAMP, COMPLETE_DATE,
LAST_TIMESTAMP, LAST_USER_NO, LAST_HOST_NAME, UPDATE_VERSION) VALUES
('W0000216', 27, 'user6', 'osno21', 'c', 'fj1', null, null, null, 0,
null, 5);"
+ "INSERT INTO DIP (WORK_NO, REPORT_NO,
USER_NO, OS_NO,
MODEL_SERIES_CD, FJ_MODEL_NAME, ENTRY_TIMESTAMP, COMPLETE_DATE,
LAST_TIMESTAMP, LAST_USER_NO, LAST_HOST_NAME, UPDATE_VERSION) VALUES
('W0000217', 28, 'user7', 'osno21', 'a', 'fj1', null, null, null, 0,
null, 5);"
+ "INSERT INTO DIP (WORK_NO, REPORT_NO,
USER_NO, OS_NO,
MODEL_SERIES_CD, FJ_MODEL_NAME, ENTRY_TIMESTAMP, COMPLETE_DATE,
LAST_TIMESTAMP, LAST_USER_NO, LAST_HOST_NAME, UPDATE_VERSION) VALUES
('W0000218', 29, 'user8', 'osno21', 'b', 'fj1', null, null, null, 0,
null, 5);"
+ "INSERT INTO DIP (WORK_NO, REPORT_NO,
USER_NO, OS_NO,
MODEL_SERIES_CD, FJ_MODEL_NAME, ENTRY_TIMESTAMP, COMPLETE_DATE,
LAST_TIMESTAMP, LAST_USER_NO, LAST_HOST_NAME, UPDATE_VERSION) VALUES
('W0000219', 30, 'user9', 'osno21', 'c', 'fj1', null, null, null, 0,
null, 5);"
+ "INSERT INTO DIP (WORK_NO, REPORT_NO,
USER_NO, OS_NO,
MODEL_SERIES_CD, FJ_MODEL_NAME, ENTRY_TIMESTAMP, COMPLETE_DATE,
LAST_TIMESTAMP, LAST_USER_NO, LAST_HOST_NAME, UPDATE_VERSION) VALUES
('W0000220', 31, 'user0', 'osno22', 'a', 'fj1', '2008-09-06 16:27:14',
20080901, '2008-09-05 12:00:00', 0, null, 1);"
+ "INSERT INTO DIP (WORK_NO, REPORT_NO,
USER_NO, OS_NO,
MODEL_SERIES_CD, FJ_MODEL_NAME, ENTRY_TIMESTAMP, COMPLETE_DATE,
LAST_TIMESTAMP, LAST_USER_NO, LAST_HOST_NAME, UPDATE_VERSION) VALUES
('W0000221', 32, 'user1', 'osno22', 'b', 'fj1', null, null, null, 0,
null, 2);"
+ "INSERT INTO DIP (WORK_NO, REPORT_NO,
USER_NO, OS_NO,
MODEL_SERIES_CD, FJ_MODEL_NAME, ENTRY_TIMESTAMP, COMPLETE_DATE,
LAST_TIMESTAMP, LAST_USER_NO, LAST_HOST_NAME, UPDATE_VERSION) VALUES
('W0000222', 33, 'user2', 'osno22', 'c', 'fj1', null, null, null, 0,
null, 2);"
+ "INSERT INTO DIP (WORK_NO, REPORT_NO,
USER_NO, OS_NO,
MODEL_SERIES_CD, FJ_MODEL_NAME, ENTRY_TIMESTAMP, COMPLETE_DATE,
LAST_TIMESTAMP, LAST_USER_NO, LAST_HOST_NAME, UPDATE_VERSION) VALUES
('W0000223', 34, 'user3', 'osno22', 'a', 'fj1', null, null, null, 0,
null, 3);"
+ "INSERT INTO DIP (WORK_NO, REPORT_NO,
USER_NO, OS_NO,
MODEL_SERIES_CD, FJ_MODEL_NAME, ENTRY_TIMESTAMP, COMPLETE_DATE,
LAST_TIMESTAMP, LAST_USER_NO, LAST_HOST_NAME, UPDATE_VERSION) VALUES
('W0000224', 35, 'user4', 'osno22', 'b', 'fj1', null, 20040404, null,
0, null, 3);"
+ "INSERT INTO DIP (WORK_NO, REPORT_NO,
USER_NO, OS_NO,
MODEL_SERIES_CD, FJ_MODEL_NAME, ENTRY_TIMESTAMP, COMPLETE_DATE,
LAST_TIMESTAMP, LAST_USER_NO, LAST_HOST_NAME, UPDATE_VERSION) VALUES
('W0000225', 36, 'user5', 'osno22', 'c', 'fj1', null, null, null, 0,
null, 3);"
+ "INSERT INTO DIP (WORK_NO, REPORT_NO,
USER_NO, OS_NO,
MODEL_SERIES_CD, FJ_MODEL_NAME, ENTRY_TIMESTAMP, COMPLETE_DATE,
LAST_TIMESTAMP, LAST_USER_NO, LAST_HOST_NAME, UPDATE_VERSION) VALUES
('W0000226', 37, 'user6', 'osno22', 'a', 'fj1', null, null, null, 0,
null, 4);"
+ "INSERT INTO DIP (WORK_NO, REPORT_NO,
USER_NO, OS_NO,
MODEL_SERIES_CD, FJ_MODEL_NAME, ENTRY_TIMESTAMP, COMPLETE_DATE,
LAST_TIMESTAMP, LAST_USER_NO, LAST_HOST_NAME, UPDATE_VERSION) VALUES
('W0000227', 38, 'user7', 'osno22', 'b', 'fj1', null, null, null, 0,
null, 4);"
+ "INSERT INTO DIP (WORK_NO, REPORT_NO,
USER_NO, OS_NO,
MODEL_SERIES_CD, FJ_MODEL_NAME, ENTRY_TIMESTAMP, COMPLETE_DATE,
LAST_TIMESTAMP, LAST_USER_NO, LAST_HOST_NAME, UPDATE_VERSION) VALUES
('W0000228', 39, 'user8', 'osno22', 'c', 'fj1', null, null, null, 0,
null, 4);"
+ "INSERT INTO DIP (WORK_NO, REPORT_NO,
USER_NO, OS_NO,
MODEL_SERIES_CD, FJ_MODEL_NAME, ENTRY_TIMESTAMP, COMPLETE_DATE,
LAST_TIMESTAMP, LAST_USER_NO, LAST_HOST_NAME, UPDATE_VERSION) VALUES
('W0000229', 40, 'user9', 'osno22', 'a', 'fj1', null, null, null, 0,
null, 4);"
+ "INSERT INTO DIP (WORK_NO, REPORT_NO,
USER_NO, OS_NO,
MODEL_SERIES_CD, FJ_MODEL_NAME, ENTRY_TIMESTAMP, COMPLETE_DATE,
LAST_TIMESTAMP, LAST_USER_NO, LAST_HOST_NAME, UPDATE_VERSION) VALUES
('W0000230', 41, 'user0', 'osno23', '1', 'fj1', '2008-09-06 16:27:14',
20080901, '2008-09-05 12:00:00', 0, null, 5);"
+ "INSERT INTO DIP (WORK_NO, REPORT_NO,
USER_NO, OS_NO,
MODEL_SERIES_CD, FJ_MODEL_NAME, ENTRY_TIMESTAMP, COMPLETE_DATE,
LAST_TIMESTAMP, LAST_USER_NO, LAST_HOST_NAME, UPDATE_VERSION) VALUES
('W0000231', 42, 'user1', 'osno23', '3', 'fj1', null, null, null, 0,
null, 5);"
+ "INSERT INTO DIP (WORK_NO, REPORT_NO,
USER_NO, OS_NO,
MODEL_SERIES_CD, FJ_MODEL_NAME, ENTRY_TIMESTAMP, COMPLETE_DATE,
LAST_TIMESTAMP, LAST_USER_NO, LAST_HOST_NAME, UPDATE_VERSION) VALUES
('W0000232', 43, 'user2', 'osno23', '1', 'fj1', null, null, null, 0,
null, 5);"
+ "INSERT INTO DIP (WORK_NO, REPORT_NO,
USER_NO, OS_NO,
MODEL_SERIES_CD, FJ_MODEL_NAME, ENTRY_TIMESTAMP, COMPLETE_DATE,
LAST_TIMESTAMP, LAST_USER_NO, LAST_HOST_NAME, UPDATE_VERSION) VALUES
('W0000233', 44, 'user3', 'osno23', '3', 'fj1', null, null, null, 0,
null, 5);"
+ "INSERT INTO DIP (WORK_NO, REPORT_NO,
USER_NO, OS_NO,
MODEL_SERIES_CD, FJ_MODEL_NAME, ENTRY_TIMESTAMP, COMPLETE_DATE,
LAST_TIMESTAMP, LAST_USER_NO, LAST_HOST_NAME, UPDATE_VERSION) VALUES
('W0000234', 45, 'user4', 'osno23', '1', 'fj1', null, 20040404, null,
0, null, 5);"
+ "INSERT INTO DIP (WORK_NO, REPORT_NO,
USER_NO, OS_NO,
MODEL_SERIES_CD, FJ_MODEL_NAME, ENTRY_TIMESTAMP, COMPLETE_DATE,
LAST_TIMESTAMP, LAST_USER_NO, LAST_HOST_NAME, UPDATE_VERSION) VALUES
('W0000235', 46, 'user5', 'osno23', '3', 'fj1', null, null, null, 0,
null, 1);"
+ "INSERT INTO DIP (WORK_NO, REPORT_NO,
USER_NO, OS_NO,
MODEL_SERIES_CD, FJ_MODEL_NAME, ENTRY_TIMESTAMP, COMPLETE_DATE,
LAST_TIMESTAMP, LAST_USER_NO, LAST_HOST_NAME, UPDATE_VERSION) VALUES
('W0000236', 47, 'user6', 'osno23', '1', 'fj1', null, null, null, 0,
null, 2);"
+ "INSERT INTO DIP (WORK_NO, REPORT_NO,
USER_NO, OS_NO,
MODEL_SERIES_CD, FJ_MODEL_NAME, ENTRY_TIMESTAMP, COMPLETE_DATE,
LAST_TIMESTAMP, LAST_USER_NO, LAST_HOST_NAME, UPDATE_VERSION) VALUES
('W0000237', 48, 'user7', 'osno23', '3', 'fj1', null, null, null, 0,
null, 2);"
+ "INSERT INTO DIP (WORK_NO, REPORT_NO,
USER_NO, OS_NO,
MODEL_SERIES_CD, FJ_MODEL_NAME, ENTRY_TIMESTAMP, COMPLETE_DATE,
LAST_TIMESTAMP, LAST_USER_NO, LAST_HOST_NAME, UPDATE_VERSION) VALUES
('W0000238', 49, 'user8', 'osno23', '1', 'fj1', null, null, null, 0,
null, 3);"
+ "INSERT INTO DIP (WORK_NO, REPORT_NO,
USER_NO, OS_NO,
MODEL_SERIES_CD, FJ_MODEL_NAME, ENTRY_TIMESTAMP, COMPLETE_DATE,
LAST_TIMESTAMP, LAST_USER_NO, LAST_HOST_NAME, UPDATE_VERSION) VALUES
('W0000239', 50, 'user9', 'osno23', '3', 'fj1', null, null, null, 0,
null, 3);"
+ "INSERT INTO DIP (WORK_NO, REPORT_NO,
USER_NO, OS_NO,
MODEL_SERIES_CD, FJ_MODEL_NAME, ENTRY_TIMESTAMP, COMPLETE_DATE,
LAST_TIMESTAMP, LAST_USER_NO, LAST_HOST_NAME, UPDATE_VERSION) VALUES
('Z0000190', 51, 'user0', null, null, 'fj1', '2008-09-06 16:27:14',
20080901, '2008-09-05 12:00:00', 0, 'Hito', 3);"
+ "INSERT INTO DIP (WORK_NO, REPORT_NO,
USER_NO, OS_NO,
MODEL_SERIES_CD, FJ_MODEL_NAME, ENTRY_TIMESTAMP, COMPLETE_DATE,
LAST_TIMESTAMP, LAST_USER_NO, LAST_HOST_NAME, UPDATE_VERSION) VALUES
('Z0000191', 52, 'user1', null, null, 'fj1', null, null, null, 0,
'Inu', 4);"
+ "INSERT INTO DIP (WORK_NO, REPORT_NO,
USER_NO, OS_NO,
MODEL_SERIES_CD, FJ_MODEL_NAME, ENTRY_TIMESTAMP, COMPLETE_DATE,
LAST_TIMESTAMP, LAST_USER_NO, LAST_HOST_NAME, UPDATE_VERSION) VALUES
('Z0000192', 53, 'user2', null, null, 'fj1', null, null, null, 0,
'Neko', 4);"
+ "INSERT INTO DIP (WORK_NO, REPORT_NO,
USER_NO, OS_NO,
MODEL_SERIES_CD, FJ_MODEL_NAME, ENTRY_TIMESTAMP, COMPLETE_DATE,
LAST_TIMESTAMP, LAST_USER_NO, LAST_HOST_NAME, UPDATE_VERSION) VALUES
('Z0000193', 54, 'user3', null, null, 'fj1', null, 20030303, null, 0,
'Sakana', 4);"
+ "INSERT INTO DIP (WORK_NO, REPORT_NO,
USER_NO, OS_NO,
MODEL_SERIES_CD, FJ_MODEL_NAME, ENTRY_TIMESTAMP, COMPLETE_DATE,
LAST_TIMESTAMP, LAST_USER_NO, LAST_HOST_NAME, UPDATE_VERSION) VALUES
('Z0000194', 55, 'user4', null, null, 'fj1', null, null, null, 0,
'Usagi', 4);"
+ "INSERT INTO DIP (WORK_NO, REPORT_NO,
USER_NO, OS_NO,
MODEL_SERIES_CD, FJ_MODEL_NAME, ENTRY_TIMESTAMP, COMPLETE_DATE,
LAST_TIMESTAMP, LAST_USER_NO, LAST_HOST_NAME, UPDATE_VERSION) VALUES
('Z0000195', 56, 'user5', null, null, 'fj1', null, null, null, 0,
'Kame', 4);"
+ "INSERT INTO DIP (WORK_NO, REPORT_NO,
USER_NO, OS_NO,
MODEL_SERIES_CD, FJ_MODEL_NAME, ENTRY_TIMESTAMP, COMPLETE_DATE,
LAST_TIMESTAMP, LAST_USER_NO, LAST_HOST_NAME, UPDATE_VERSION) VALUES
('Z0000196', 57, 'user6', null, null, 'fj1', null, null, null, 0,
'Zarigani', 5);"
+ "INSERT INTO DIP (WORK_NO, REPORT_NO,
USER_NO, OS_NO,
MODEL_SERIES_CD, FJ_MODEL_NAME, ENTRY_TIMESTAMP, COMPLETE_DATE,
LAST_TIMESTAMP, LAST_USER_NO, LAST_HOST_NAME, UPDATE_VERSION) VALUES
('Z0000197', 58, 'user7', null, null, 'fj1', null, null, null, 0,
'Yadokari', 5);"
+ "INSERT INTO DIP (WORK_NO, REPORT_NO,
USER_NO, OS_NO,
MODEL_SERIES_CD, FJ_MODEL_NAME, ENTRY_TIMESTAMP, COMPLETE_DATE,
LAST_TIMESTAMP, LAST_USER_NO, LAST_HOST_NAME, UPDATE_VERSION) VALUES
('Z0000198', 59, 'user8', null, null, 'fj1', null, 20080808, null, 0,
'Kaburomushi', 5);"
+ "INSERT INTO DIP (WORK_NO, REPORT_NO,
USER_NO, OS_NO,
MODEL_SERIES_CD, FJ_MODEL_NAME, ENTRY_TIMESTAMP, COMPLETE_DATE,
LAST_TIMESTAMP, LAST_USER_NO, LAST_HOST_NAME, UPDATE_VERSION) VALUES
('Z0000199', 60, 'user9', null, null, 'fj1', null, null, null, 0,
null, 5);"
);
pstmt.executeUpdate();
conn.rollback();
conn.close();
}
}
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en
-~----------~----~----~----~------~----~------~--~---
