FileDocCategorySizeDatePackage
TestThinPerfInsertRow.javaAPI DocExample951Mon Apr 23 18:16:42 BST 2001None

TestThinPerfInsertRow.java

import java.text.*;
import java.sql.*;
import oracle.jdbc.driver.*;

class TestThinPerfInsertRow {
 public static void main (String args[]) throws SQLException {
  long startTime; 
  long stopTime;
  DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
  Connection conn = 
   DriverManager.getConnection("jdbc:oracle:thin:@dssnt01:1521:dssora01","scott","tiger");
  conn.setAutoCommit(false);
  SimpleDateFormat sdf = new SimpleDateFormat( "yyyyMMddHHmmss" );
  Statement stmt = conn.createStatement();
  stmt.executeUpdate("insert into testxxxperf ( id, code, descr, insert_user, insert_date ) " +
   "values ( 1, '123456789012345678901234567890', " + 
   "'12345678901234567890123456789012345678901234567890123456789012345678901234567890', " +
   "USER, to_date('" + sdf.format(new java.util.Date(System.currentTimeMillis())) + "', 'YYYYMMDDHH24MISS'))");
  conn.commit(); 
  stmt.close();
  conn.close();
 }
}