import java.sql.*;

class OracleCon {
	public static void main(String args[]) {
		try {
			Class.forName("oracle.jdbc.driver.OracleDriver");
			long start = System.currentTimeMillis();
			Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe", "system", "system");
			Statement stmt = con.createStatement();
			String dropTableSQL = "DROP TABLE request_notification";
			String createTableSQL = "CREATE TABLE request_notification(\n" + "    servername VARCHAR2(100),\n"
					+ "    host VARCHAR2(100),\n" + "    port VARCHAR2(10),\n" + "    id NUMBER(19),\n"
					+ "    databasename VARCHAR2(100) NOT NULL,\n" + "    username VARCHAR2(100) NOT NULL,\n"
					+ "    notificationtype VARCHAR2(30) NOT NULL,\n" + "    sessionid NUMBER(19),\n"
					+ "    starttime TIMESTAMP,\n" + "    endtime TIMESTAMP,\n" + "    duration NUMBER(19),\n"
					+ "    waitingtime NUMBER(19),\n" + "    numrows INTEGER,\n" + "    state VARCHAR2(30),\n"
					+ "    completed INTEGER,\n" + "    cache INTEGER,\n" + "    query VARCHAR2(4000) NOT NULL,\n"
					+ "    requesttype VARCHAR2(50) NOT NULL,\n" + "    elements VARCHAR2(4000),\n"
					+ "    truncateddata INTEGER,\n" + "    useragent VARCHAR2(100),\n"
					+ "    accessinterface VARCHAR2(100),\n" + "    clientip VARCHAR2(50), \n"
					+ "    transactionid NUMBER(19)\n" + ")";

			String insertSQL = "INSERT INTO REQUEST_NOTIFICATION (SERVERNAME, HOST, PORT, ID, DATABASENAME, USERNAME, NOTIFICATIONTYPE, SESSIONID, STARTTIME, ENDTIME, DURATION, WAITINGTIME, NUMROWS, STATE, COMPLETED, CACHE, QUERY, REQUESTTYPE, ELEMENTS, TRUNCATEDDATA, USERAGENT, ACCESSINTERFACE, CLIENTIP, TRANSACTIONID) VALUES ('TEST', 'TEST', '9999', 17, 'TEST', 'TEST', 'TEST', 7, TIMESTAMP '2016-08-08 17:38:21', TIMESTAMP '2016-08-08 17:38:21', 10, 0, 1, 'TEST', 1, 0, 'SELECT 1 FROM DUAL()', 'SELECT VIEW', 'dual()', 0, 'Denodo-VDP-AdminTool', 'VDP-AdminTool', '10.0.75.1', null)";
			stmt.executeUpdate(dropTableSQL);
			stmt.executeUpdate(createTableSQL);
			int returnCode = stmt.executeUpdate(insertSQL);
			System.out.println("Return Code: " + returnCode);
			System.out.println("Executed in: " + (System.currentTimeMillis()-start) +" ms");
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
}