Top features: Promise support. Node 6 support. The new node-oracledb 1.9.1 release adds Promise support, it now supports the new Node 6 (as well as previous...
Top features: Promise support. Node 6 support. The new node-oracledb 1.9.1 release adds Promise support, it now supports the new Node 6 (as well as previous releases), and it has some welcome stability fixes. Other nice goodies are mentioned below. Thanks to everyone who gave feedback on our 1.9.0 development branch - we couldn't have done it without you. node-oracledb 1.9.1 is now available on NPM. Installation instructions are here. Documentation is here. The changes in...
Top features: Promise support. Node 6 support. The new node-oracledb 1.9.1 release adds Promise support, it now supports the new Node 6 (as well as previous releases), and it has some welcome...
A newer compiler is needed on Oracle Linux 6 when you want to use add-ons like node-oracledb with Node 4 or later. This is because add-ons for those versions...
A newer compiler is needed on Oracle Linux 6 when you want to use add-ons like node-oracledb with Node 4 or later. This is because add-ons for those versions need to be built with a C++11 compatibile compiler. The default compiler on OL 6 doesn't have this support. OL 7 does have such a compiler, so these instructions are not needed for that version. For OL 6 the easist way to get a new compiler is from the Software Collection Library (SCL). You enable the software collection...
A newer compiler is needed on Oracle Linux 6 when you want to use add-ons like node-oracledb with Node 4 or later. This is because add-ons for those versions need to be built with a C++11 compatibile...
Top features: Promise support node-oracledb 1.9.0-Development is now available only as a development-only branch on GitHub. It adds Promise support and some...
Top features: Promise support node-oracledb 1.9.0-Development is now available only as a development-only branch on GitHub. It adds Promise support and some other goodies mentioned below. The plan is to incorporate any user feedback, stabilize the features, improve documentation, improve test covereage, and run stress tests. Once this is all done, then a production release to npm will be made. Personally I think this will take 2-4 weeks, but it is totally dependent on what is...
Top features: Promise support node-oracledb 1.9.0-Development is now available only as a development-only branch on GitHub. It adds Promise support and some other goodies mentioned below. The plan...
Node-oracledb 1.8.0, the Node.js add-on for Oracle Database, is on NPM. Top new changes: New Query Result Streaming. Use DRCP connect strings only with a...
Node-oracledb 1.8.0, the Node.js add-on for Oracle Database, is on NPM. Top new changes: New Query Result Streaming. Use DRCP connect strings only with a connection pool. I want to start by saying thanks to all contributors past and current! It is the community that defines the product. Query Result Streaming Node Streams can now be used for queries after a pull request from Sagie Gur-Ari was merged. A new connection.queryStream() method returns a Readable Stream. Of course,...
Node-oracledb 1.8.0, the Node.js add-on for Oracle Database, is on NPM. Top new changes: New Query Result Streaming. Use DRCP connect strings only with a connection pool. I want to start by...
Node-oracledb 1.7.0, the Node.js add-on for Oracle Database, is on NPM. Top features: a new connection pool queue to make apps more resilient, and "Bind by...
Node-oracledb 1.7.0, the Node.js add-on for Oracle Database, is on NPM. Top features: a new connection pool queue to make apps more resilient, and "Bind by position" syntax for PL/SQL Index-by array binds. This release has a couple of interesting changes as well as some small bind fixes. A few reported build warnings with some compilers were also squashed. Extended PL/SQL Index-by Array Bind Syntax To start with, a followup PR from @doberkofler completes his PL/SQL Index-by...
Node-oracledb 1.7.0, the Node.js add-on for Oracle Database, is on NPM. Top features: a new connection pool queue to make apps more resilient, and "Bind by position" syntax for PL/SQL Index-by...
The node-oracledb driver is pre-installed on the Oracle Application Container Cloud when you create a Node service! Yay! I've posted a video on deploying a Node...
The node-oracledb driver is pre-installed on the Oracle Application Container Cloud when you create a Node service! Yay! I've posted a video on deploying a Node application to the cloud and connecting to Oracle Database Cloud Service. (Blatent plug: subscribe to the YouTube channel!) The brief summary is that I developed a Node application in my local environment. I then created a database service, I zipped all the JavaScript files along with a manifest telling the App...
The node-oracledb driver is pre-installed on the Oracle Application Container Cloud when you create a Node service! Yay! I've posted a video on deploying a Node application to the cloud and...
Developers starting out with Node have to get to grips with the 'different' programming style of JavaScript that seems to cause methods to be called when least...
Developers starting out with Node have to get to grips with the 'different' programming style of JavaScript that seems to cause methods to be called when least expected! While you are still in the initial hacking-around-with-node-oracledb phase you may sometimes encounter the error ORA-01000: maximum open cursors exceeded. A cursor is "a handle for the session-specific private SQL area that holds a parsed SQL statement and other processing information" Here are things to do...
Developers starting out with Node have to get to grips with the 'different' programming style of JavaScript that seems to cause methods to be called when least expected! While you are still in the...
Node-oracledb 1.6.0, the Node.js add-on for Oracle Database, is on NPM. In this release a comprehensive pull request by Dieter Oberkofler adds support for...
Node-oracledb 1.6.0, the Node.js add-on for Oracle Database, is on NPM. In this release a comprehensive pull request by Dieter Oberkofler adds support for binding PL/SQL Collection Associative Array (Index-by) types. Strings and numbers can now be bound and passed to and from PL/SQL blocks. Dieter tells us that nowadays he only gets to code for a hobby - keep it up Dieter! Using PL/SQL Associative Arrays can be a very efficient way of transferring database between an...
Node-oracledb 1.6.0, the Node.js add-on for Oracle Database, is on NPM. In this release a comprehensive pull request by Dieter Oberkofler adds support for binding PL/SQL Collection Associative Array...
Node-oracledb 1.5.0, the Node.js add-on for Oracle Database, is on NPM. A number of bugs have been squashed in this release. We now treat Oracle Database...
Node-oracledb 1.5.0, the Node.js add-on for Oracle Database, is on NPM. A number of bugs have been squashed in this release. We now treat Oracle Database 'Success With Info' warnings as success. Thanks to Francisco Trevino for his pull request. After investigating and discussing, we decided for 1.5 to pick up the straightforward fix proposed. In a future release we will revisit allowing these warnings to be caught and handled. Extended rollback-on-connection-release with 11g...
Node-oracledb 1.5.0, the Node.js add-on for Oracle Database, is on NPM. A number of bugs have been squashed in this release. We now treat Oracle Database 'Success With Info' warnings as...
