Java News

 Events

Oracle Open World 2019

Get ready for this year's Oracle Open World and Oracle Code One 2019 in San Franscisco, September 15-20, 2019.

Video Recordings

Did you miss attending our conference? Don't worry, we have the videos that you can watch at your convenience and get the latest news about JDBC.

 New Features in 18.3 JDBC driver & Universal Connection Pool (UCP)

Whether on the cloud or on-premises, developing Java applications with Oracle Autonomous Databases is fast and simple. Java developers can take advantage of the latest features, such as Oracle Autonomous Database, performance self-tuning, high availability, in-memory processing, and pluggable databases to design and develop a high performant, scalable, and reliable applications. Oracle Database 18c JDBC driver introduces a new property file (ojdbc.properties) along with few other features that simplifies the connection to Autonomous Transaction Processing (ATP) and Autonomous Data Warehousing (ADW).

  • Java Standards: Supports JDK8, JDK9, JDK10, JDK11 and compliant to JDBC 4.2 by JDBC driver (ojdbc8.jar) and Universal Connection Pool (ucp.jar)
  • Performance features: New Oracle connection manager in traffic director mode, Universal Connection Pool (UCP), network compression over WAN (JDBC), and configurable connection health check frequency (UCP)
  • Scalability features: Oracle RAC data affinity, sharding APIs, shared pool for multitenant and sharded database, shard routing APIs for mid-tiers, and run time load balancing (RLB)
  • High Availability features: Transparent Application Continuity (TAC), support of concrete classes with AC, AC with DRCP, FAN support, and Transaction Guard (TG)
  • Connection and Security features: Supporting a file (e.g., ojdbc.properties) to set connection properties, multiple ways to set TNS_ADMIN (e.g., part of connection URL, connection property, environment variable), setting server's domain name (DN) cert as a connection property, automatic provider resolution for OraclePKIProvider, automatic key store service (KSS) resolution, HTTPS proxy support, TLSv1.2 Support, Kerberos, Oracle Wallets, and JKS
  • Datatypes: Accessibility to PL/SQL associate arrays, REF CURSOR as IN bind variable, and API for verifying JSON column