Oracle Node.js Developer Center

Node-oracledb version 2.3 with Continuous Query Notifications is now available on npm.

The node-oracledb add-on for Node.js powers high performance Oracle Database applications. Node.js is an open source, cross-platform runtime environment for writing mid-tier and networking applications in JavaScript. The node-oracledb driver connects to Oracle Database for fast and functional applications. It is an open source project with Apache 2.0 license. It is maintained by Oracle and is under active development.

node-oracledb Add-on for Node.js is Cloud Ready

Node-oracledb version 2 with pre-built binaries

Node-oracledb Features

 

  • Install with standard npm infrastructure
  • Open Source under the Apache 2 license
  • Maintained by Oracle
  • Hosted on GitHub
  • Async/Await, Promises, Callbacks and Streams
  • SQL and PL/SQL execution
  • Batch Statement execution
  • Statement metadate
  • REF CURSORs
  • Large Objects: CLOBs and BLOBs as Streams or Strings and Buffers

 

  • Oracle Database 12.1 JSON datatype
  • Query results as JavaScript objects or arrays
  • Smart mapping between JavaScript and Oracle types with manual override available
  • Data binding using JavaScript objects or arrays
  • Transaction management
  • Inbuilt connection pool with queueing, aliasing and liveness checking
  • Database Resident Connection Pooling (DRCP)
  • Privileged connections

 

  • External authentication
  • Connection health checking
  • Password changing
  • Array fetches
  • Statement caching
  • Client Result Caching
  • End-to-end tracing, mid-tier authentication, and auditing
  • Oracle Database High Availability features
  • Oracle Net features including encryption