We've pushed out a patch release of node-oracledb to GitHub and NPM. It has a bind fix that didn't land in time for 1.10.0. A memory leak regression with REF...
We've pushed out a patch release of node-oracledb to GitHub and NPM. It has a bind fix that didn't land in time for 1.10.0. A memory leak regression with REF CURSORs was also fixed, as was a pre-existing memory leak in the unexpected case of a REF CURSOR failure. The changes in node-oracledb 1.10.1 are: Fixed a bug that prevented a null value being passed from JavaScript into an IN OUT bind. Fixed a memory leak introduced in 1.10 with REF CURSORs. Fixed an existing memory...
We've pushed out a patch release of node-oracledb to GitHub and NPM. It has a bind fix that didn't land in time for 1.10.0. A memory leak regression with REF CURSORs was also fixed, as was...
Top feature: Enhanced Metadata The changes in node-oracledb 1.10 are: Enhanced query metadata thanks to a Pull Request from Leonardo. He kindly allowed us to...
Top feature: Enhanced Metadata The changes in node-oracledb 1.10 are: Enhanced query metadata thanks to a Pull Request from Leonardo. He kindly allowed us to take over and fine tune the implementation. Additional metadata for query and REF CURSOR columns is available in the metaData object when the new boolean oracledb.extendedMetaData attribute or corresponding execute() option attribute extendedMetaData are true. For example, if the DEPARTMENTS table is like: SQL> desc...
Top feature: Enhanced Metadata The changes in node-oracledb 1.10 are: Enhanced query metadata thanks to a Pull Request from Leonardo. He kindly allowed us to take over and fine tune...
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...
