import java.text.*;
import java.sql.*;
import oracle.jdbc.driver.*;
class TestThinPerfDeleteRow {
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);
Statement stmt = conn.createStatement();
stmt.executeUpdate("delete testxxxperf where id = 1");
conn.commit();
stmt.close();
conn.close();
}
}
|