Wednesday Jul 16, 2014

Oracle Critical Patch Advisory -- July 15, 2014

ATTN: Oracle DBAs: Oracle has published its Critical Patch Advisory dated July 15, 2014.  Get the advisory Here

Here's what you need to know:

This Critical Patch Update provides 113 new security fixes across a wide range of product families including: Oracle Database, Oracle Fusion Middleware, Oracle Java SE, Oracle Linux and Virtualization, Oracle MySQL, Oracle Hyperion, Oracle Enterprise Manager Grid Control, Oracle E-Business Suite, and Oracle Business Applications and more.

REMEMBER: Critical Patch Update fixes are intended to address significant security vulnerabilities in Oracle products and also include code fixes that are prerequisites for the security fixes. As a result, Oracle recommends that this Critical Patch Update be applied as soon as possible. 

Read more about the specific fixes here.

Get the Critical Patch Advisory on  OTN here.

Ciao for Now!

LKR 


Tuesday Jul 08, 2014

What's New in Oracle JDBC?

 If you're talking database connectivity, JDBC deserves a good look.

According to Sun's JDBC page, the Java Database Connectivity (JDBC) API is the industry standard for database-independent connectivity between the Java programming language and a wide range of databases—SQL databases and other tabular data sources, such as spreadsheets or flat files. The JDBC API provides a call-level API for SQL-based database access. JDBC technology allows you to use the Java programming language to exploit "Write Once, Run Anywhere" capabilities for applications that require access to enterprise data. With a JDBC technology-enabled driver, you can connect all corporate data even in a heterogeneous environment.

Which version of JDBC drivers support which version of Oracle database?

Check out this table for the Oracle database versions supported by JDBC drivers.  Best Practice that we recommend is, JDBC driver version should always be either same as or higher than the Oracle database version being used in order to leverage the latest capabilities of the JDBC driver. 


Interoperability Matrix Database 12.1.0.x Database 11.2.0.x Database 11.1.0.x

Database10.2.0.x

JDBC 12.1.0.x
Yes
Yes
Yes
Yes
JDBC 11.2.0.x
Yes
Yes
Yes
Yes
JDBC 11.1.0.x
Yes
Yes
Yes
Yes
JDBC 10.2.0.x
Yes
Yes
Yes
Yes

Whats New in JDBC?


  • Support for Latest Java Standards:  Oracle JDBC and UCP now support JSE 7 with JDBC 4.1 specification. 

  • Support for Multitenant Container Support:The Oracle database 12c introduces a new multitenant architecture consisting of a root infrastructure called Container Database(CDB) which contains exclusively Oracle provided metadata, then a set of pluggable databases(PDBs), which are full fledged databases containing customers, applications data and metadata. Oracle JDBC and UCP furnish the Multitenant Datasource for Java by allowing sharing a single pool of connections across multiple PDBs i.e., tenants.  

  • Support for New SQL DataTypes: Java pplications may leverage new data types including: 32K VARCHAR, NVARCHAR, and RAW, invisible/hidden columns, implicit results, auto-increment or IDENTITY columns, PL/SQL packaged types and AS parameters, larger row count data type, and XStream enhancements. 

  • Improved Performance and Scalability:New performance and scalability enhancements include: New JDBC memory managemen, Database Resident Connection Pool (DRCP), very large network buffers(SDU), and RuntimeConnections Load Balancing across geographies (Global Data Services). 

  • Transaction Guard and Application Continuity for Java: When a database outage occurs, four problems confront applications:(1) hangs, (2) errors, (3) determining the outcome of in-flight work and (4) the resubmission of in-flight work.  Oracle database 12c handles these outages better throughTransaction Guard for a reliable outcome of in-flight work and Application Continuity for capturing and replaying in-flight transactions.

  • Better Manageability, Ease of use:Oracle database 12c furnishes row count per iteration for array DML,monitoring and tracing database operations, intelligent client connectivity and faster dead connection detection. 

  • Advanced Security:With Oracle database 12c, JDBC now supports SHA-2 hashing algorithms(including:SHA-256, SHA-384,and SHA-512) to generate secure message digests. Overall,Java applications can use the following hashing algorithms:MD5, SHA1, SHA-256, SHA-384 or SHA-512. 

  • Easier Applications Migration: Solves the problem for migrating Java applications built against non Oracle RDBMS.  Oracle 12c provides a framework for translating foreign SQL syntax into Oracle SQL syntax before being submitted to the Oracle RDBMS, SQL engine for compilation and execution. 

    Get the whole story from the JDBC page on OTN.

    Download JDBC Drivers and Documentation HERE.

    Ciao for now!

    LKR 

About

The OTN DBA/DEV Watercooler is your official source of news covering Oracle Database technology topics and community activities from throughout the OTN Database and Developer Community. Find tips and in-depth technology information you need to master Oracle Database Administration or Application Development here. This Blog is compiled by @oracledbdev, the Oracle Database Community Manager for OTN, and features insights, tech tips and news from throughout the OTN Database Community.

Search

Archives
« March 2015
SunMonTueWedThuFriSat
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
    
       
Today