Skip to content

Instantly share code, notes, and snippets.

@krisrice
Created December 4, 2017 20:59
Show Gist options
  • Save krisrice/f6a774fad55de61f902180391985ea59 to your computer and use it in GitHub Desktop.
Save krisrice/f6a774fad55de61f902180391985ea59 to your computer and use it in GitHub Desktop.
// npm install java
var java = require("java");
java.classpath.push("ojdbc8.jar");
java.classpath.push("oracle.dbtools-common.jar");
java.classpath.push("oracle.dbtools.http.jar");
java.classpath.push("oracle.dbtools.jdbcrest.jar");
java.classpath.push("oracle.sqldeveloper.sqlcl.jar");
java.classpath.push("xmlparserv2.jar");
var ScriptExecutor = java.import("oracle.dbtools.raptor.newscriptrunner.ScriptExecutor");
var ScriptRunnerContext = java.import("oracle.dbtools.raptor.newscriptrunner.ScriptRunnerContext");
var DriverManager = java.import("java.sql.DriverManager");
var conn = java.callStaticMethodSync("java.sql.DriverManager", "getConnection", 'jdbc:oracle:thin:@//localhost:1521/orcl','klrice','klrice');
//
var sqlcl = new ScriptExecutor(conn);
var ctx = new ScriptRunnerContext();
ctx.setBaseConnection(conn);
sqlcl.setScriptRunnerContext(ctx);
sqlcl.setStmt('set sqlformat json \n select * from user_objects;');
sqlcl.run();
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment