int i;
long startTime;
long stopTime;
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
Connection conn =
DriverManager.getConnection("jdbc:oracle:thin:@devdb02:1521:ohsdb","zxvi01","donaldj8");
CallableStatement stmt = null;
// Use Oracle syntax
stmt = conn.prepareCall(
"begin oehr.testxxxperf$.settestxxxperf( :1, :2, :3, :4, :5 ); end;");
conn.setAutoCommit(false);
startTime = System.currentTimeMillis();
for (i=1;i<1001;i++) {
stmt.setInt(1,i);
stmt.setString(2,"123456789012345678901234567890");
stmt.setString(3,"12345678901234567890123456789012345678901234567890123456789012345678901234567890");
stmt.setString(4,"ZXVI01");
stmt.setDate(5,new java.sql.Date(System.currentTimeMillis()));
stmt.execute();
}
conn.commit();
stopTime = System.currentTimeMillis();
Statement dstmt = conn.createStatement();
dstmt.executeUpdate("delete oehr.testxxxperf");
conn.commit();
dstmt.close();
stmt.close();
conn.close();
System.out.println( "Elapsed time in milliseconds: " + Long.toString( stopTime - startTime ) );
