The Oracle Database driver for Node.js has a new JavaScript layer

Node.js driver for Oracle Database

This is the driver that allows folks using Node.js to tap into Oracle Database – a very powerful combination. Since starting at Oracle, I’ve focused more on this project than any other. In fact, most of the posts in this blog involve this driver in one way or another.
Now the driver is sporting a new JavaScript layer! This new layer will allow JavaScript to be used over C where it’s more advantageous to do so. Additionally, the new layer will help make it easier for folks in the JavaScript community to contribute to the project without having to know C.

This first release of the JavaScript layer adds connection request queueing (no more ORA-24418: Cannot open further sessions!) and we have some pretty cool features planned for future releases.

Links:

1. https://blogs.oracle.com/opal/entry/node_oracledb_1_7_0
2. https://jsao.io/2016/02/an-update-on-javascript-and-oracle/
3. https://github.com/oracle/node-oracledb
4. http://www.oracle.com/technetwork/database/database-technologies/scripting-languages/node_js/

Wishing Happy Diwali

Application Express 4.2.6 is now available

Oracle Application Express Release 4.2.6.00.03 was released on September 24, 2014. This is a cumulative patch set for Application Express 4.2.0, Application Express 4.2.1, Application Express 4.2.2, Application Express 4.2.3, Application Express 4.2.4, and Application Express 4.2.5. The full download is available below.

Click the here to download the latest version of Oracle Application Express. Application Express 4.2.6 includes numerous bug fixes.

APEX Notes: RDS, The PluginRegion Display Selector - How I (Wo...

APEX Notes: RDS, The PluginRegion Display Selector - How I (Wo...: Update For the update on  ORA-06550  and  ORA-06502  please see the end of the post. The day has come and I have decided to write the RDS...

APEX Notes: Region Display Selector - How I (Would) Like It

APEX Notes: Region Display Selector - How I (Would) Like It: In APEX4 I welcomed very much the new region type - the Region Display Selector. The only thing I don't like is how it displays the regions....

Apex Tutorial - Form & Report sharing the same page

Apex Tutorial - Form & Report sharing the same page

Oracle Application Express - New Features in Release 4.1

Oracle Application Express
New Features in Release 4.1
	Error Handling Release 4.1 includes improved error handling and user-defined exception processing. You can now easily capture error messages generated by the Oracle database and replace the message text with user friendly text. For example, instead of an error message such as "ORA-00001 unique constraint (EMP_UK) violated" the developer can define a message such as "Employee Name must be unique".

Use of ROWID Application Express now supports the use of ROWID for updates, inserts and deletes as an alternative to specifying primary keys. Previously you could only specific two primary key columns. Therefore, if your table had more than two key columns then you could not use the default DML processes and had to manually write your own processes. Use of ROWID is now the default method for any new DML processes generated.

Data Upload Developers can now easily add the capability for end-users to load spreadsheet data into existing tables within an application. The developer can utilize a wizard to create a collection of pages that allow the end user to upload a file or cut and paste data into a table. Additionally the developer can define lookup columns and data transformations. End users are then led through a runtime wizard which allows them to load the data, map the columns, see whether the data will be inserted or updated, and review the results.

Calendar The calendar wizards have been enhanced to include the ability to create an Edit page as part of creating the calendar. Further calendars can now include drag and drop functionality which allows the end user to change the date and or time of a record by simply dragging it on the calendar itself.

Websheets Building on their initial introduction in Release 4.0, the look and feel of Websheets in Release 4.1 has been substantially improved and the controls redesigned to make it more intuitive for users. There are also new page section types, and enhanced data grid integration. Learn more >

Tabular Forms Tabular Forms now support all validation types. Depending on the validation type you can use bind variable syntax, substitution syntax, or just specify the tabular form column name. These enhancements allow developers to declaratively define complex validations instead of having to perform extensive manual PL/SQL coding.

Plug-Ins Plug-ins enable developers to enhance the existing built-in functionality by writing PL/SQL components for various components. This release expands the plug-in functionality and introduces the ability to create plug-ins for authentication and authorization schemes. View and Download Plug-Ins >

Dynamic Actions Dynamic Actions allow developers to declaritively define client-side functionality, without needing to master JavaScript and AJAX. With this release, a number of enhancements were added including the ability to define dynamic actions for buttons and also use dynamic actions to set multiple item values.

	Accessibility Release 4.1 includes dramatic improvement in the HTML generated by the Application Express engine, together with accessibility improvements in existing themes and HTML templates.
Mobile Applications Release 4.1 includes a number of key improvements to improve support for mobile frameworks, including form rendering without HTML tables.