Friday, May 26, 2017

Carbonated Java & JavaScript Stored Procedures

Carbonated Java Stored Procedures

For accessing JSON Collections and documents without any knowledge of SQL, Oracle furnishes the SODA for Java API. It allows a convenient access and navigation using the dot notation.

How to use SODA for Java in Java Stored Procedures? I have posted the steps, the code samples and scripts on GitHub.

Carbonated JavaScript Stored Procedures 

Nashorn allows interoperability between Java and javaScript. By leveraging such interoperability, I've bee able to reuse SODA for Java with JavaScript Stored Procedures.

How to use SODA for Java in JavaScript Stored Procedures? I have posted the steps, the code samples and scripts on GitHub.

Enjoy!

Thursday, March 02, 2017

What's in Oracle Database 12c Release 2 for Java & JavaScript Developers?

Here is the summary of New Java & JavaScript Features in Oracle Database 12c Release 2 on Cloud and on-Premise

  • Java 8: Java 8 in JDBC/UCP and OJVM; JDBC 4.2
  • JavaScript with Nashorn: JDBC/UCP, OJVM
  • Performance: JIT (OJVM), Network Compression over WAN (JDBC), Configurable connection health check frequency (UCP), PL/SQL Callback interface (JDBC)
  • Scalability: Shared Pool for Multi-Tenant Database (UCP), Shared Pool for Sharded database (UCP), Sharding Key APIs (JDBC, UCP), DRCP Proxy session sharing, DRCP support for  multiple labels
  • High-Availability: Java APIs for FAN events (SimpleFan.jar), Planned Maintenance in the driver (JDBC), Application Continuity for XA Datasources, Transaction Guard for XA Datasource
  • Security: SSL v1.2 / TLS v 1.2 (JDBC)
  • Manageability: XMLconfiguration (UCP), Enable/disable/suspend/resume feature level logging (JDBC), MAX_THINK_TIME for Transactions in progress (DRCP), new statistics view and AWR reports  
  • Ease of Use : Web Services Callout (OJCM), Long Identifiers (OJVM), PL/SQL Boolean (JDBC), Debugger for OJVM (Java Debug Wire Protocol)
See our latest white paper for more details.