Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- // myscript.js
- var oracledb = require('oracledb');
- oracledb.createPool(
- {
- queueRequests : false,
- user: "c##api",
- password: "vdmtl",
- connectString : "localhost:1521/jeremie"
- },
- function(err,pool){
- pool.getConnection(
- {
- proxyUser: "c##api[c##jeremie]",
- proxyUserPassword: "vdmtl"
- },
- function(err,connection)
- {
- connection.execute(
- `SELECT *
- FROM sys.people`,
- function(err, result)
- {
- if (err) {
- console.error(err.message);
- doRelease(connection);
- return;
- }
- console.log(result.rows);
- doRelease(connection);
- });
- });
- });
- function doRelease(connection)
- {
- connection.close(
- function(err) {
- if (err)
- console.error(err.message);
- });
- }
Add Comment
Please, Sign In to add comment