oradb.conn.setAutoCommit(false); // If some fail, we want to rollback the rest
PreparedStatement stmt = oradb.conn.prepareStatement(
"INSERT INTO product_tmp VALUES (?,?,?,?)"
try {
// Create an oracle.sql.ARRAY object to hold the values
// java.lang.Stringname
oracle.sql.ArrayDescriptor arrayDesc1 =
oracle.sql.ArrayDescriptor.createDescriptor("number_array",
oradb.conn);
oracle.sql.ArrayDescriptor arrayDesc2 =
oracle.sql.ArrayDescriptor.createDescriptor("string_array",
oradb.conn);
oracle.sql.ArrayDescriptor arrayDesc3 =
oracle.sql.ArrayDescriptor.createDescriptor("string_array",
oradb.conn);
oracle.sql.ArrayDescriptor arrayDesc4 =
oracle.sql.ArrayDescriptor.createDescriptor("STRING_ARRAY",
oradb.conn);
int array1[] = new int[30000];
String array2[] = new String[30000];
String array3[] = new String[30000];
String array4[] = new String[30000];
Array t[] = new Array[30000];
for (int i = 0; i < 30000; i++) {
array1 = 444;
array2 = "115S0003A";
array3 = "ic";
array4 = "136";
}
ora_array1 = new oracle.sql.ARRAY(arrayDesc1, oradb.conn, array1);
ora_array2 = new oracle.sql.ARRAY(arrayDesc2, oradb.conn, array2);
ora_array3 = new oracle.sql.ARRAY(arrayDesc3, oradb.conn, array3);
ora_array4 = new oracle.sql.ARRAY(arrayDesc4, oradb.conn, array4);