Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- try {
- Class.forName("oracle.jdbc.driver.OracleDriver");
- //Creating a connection between Java program and Oracle database.
- Connection con;
- con = DriverManager.getConnection("jdbc:oracle:thin:@ora-******");
- result.forEach(record ->
- {
- String fpml = record.getPayload().get();
- Summary summary = SUMMARIZER.summarize(fpml);
- }
- String a1= (String) summary.getFields().get("xxx");
- String a2= (String) summary.getFields().get("yyy");
- String a3= (String) summary.getFields().get("zzz");
- //Loading and registering Oracle database thin driver
- //Creating a Statement object to excute SQL statements
- Statement sql;
- try {
- sql = con.createStatement();
- //Executing a SQL INSERT query using executeUpdate() method of Statement object.
- sql.executeUpdate("INSERT INTO Execution_TEMP VALUES("+"'"+a1+"'"+","+"'"+a2+"'"+","+"'"+a3+"'"+")");
- } catch (SQLException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- }
- });
- con.close(); }
- catch (SQLException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- } catch (ClassNotFoundException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- }
Add Comment
Please, Sign In to add comment