1 / 9

EclipseLink JPA Black Belt Training: Oracle DB

EclipseLink JPA Black Belt Training: Oracle DB. <PRESENTER> <TITLE>. EclipseLink on Oracle DB. Generic and Native SQL support Extended type support and conversion functions {ts…} or to_date(…) Ability to supply custom SQL for any operation Leverage Stored Procedures and Functions

eryk
Download Presentation

EclipseLink JPA Black Belt Training: Oracle DB

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. EclipseLink JPA Black Belt Training: Oracle DB <PRESENTER> <TITLE>

  2. EclipseLink on Oracle DB • Generic and Native SQL support • Extended type support and conversion functions {ts…} or to_date(…) • Ability to supply custom SQL for any operation • Leverage Stored Procedures and Functions • Configurable use with: • Object CRUD operations • Projection queries (ReportQuery) • Stored procedure result sets & IN/OUT parameters • Optimistic locking use INT, DATE, TIMESTAMP, …

  3. OracleDB … continued • Sequencing • Oracle native, Multiple sequence table, single sequence table • Pre-allocation within middle-tier (performance) • Return from write • Set PK or calculated values returned from trigger via RETURNING clause • Optional Oracle specific (DDL) creation of schema • Leverage Hints within generated SQL

  4. Advanced Data Types • XDB XML Type • TIMESTAMP, TIMESTAMP_TZ, TIMESTAMP_LTZ • Optimized BLOB/CLOB and NCLOB • Oracle Spatial Data • Easily extensible for additional types (TEXT, user types, …) • Database Object Types Mappings Obj Ref, VArray, Nested Tables, and Structure

  5. Query Extensions • Oracle specific operators (DECODE, …) • Outer join support • HINT support • Hierarchical Querying • Flashback querying • Pessimistic locking SELECT … FOR UPDATE [NOWAIT]

  6. Oracle VPD/OLS • Use of generic connection pool / data source • Isolated L1 cache per client • Dedicated connections • Event callbacks for user context switching • Proxy authentication

  7. EclipseLink in WLS • WLS 10.0 • EclipseLink 11g with EclipseLink 1.0 is certified • WLS 10.3 • EclipseLink 11g with EclipseLink 1.0 is certified • WLS 10.4 • EclipseLink 11gR1 with EclipseLink 1.1 will be included and certified • Future • EclipseLink with EclipseLink is included, certified, and is the default persistence provider

  8. Installing EclipseLink in WebLogic 10.3 • Oracle TopLink 11g certified for and license included in WLS 10.3.0 including EclipseLink 1.0.2 • Oracle TopLink 11gR1 included as system module within WLS including EclipseLink 1.1.1 • Support for easily installing using Smart Update

  9. Data Sources • Global • Application • *-jdbc.xml in EAR • Register in weblogic-application.xml • Persistence unit properties: • name=“javax.persistence.jtaDataSource” value=“java:/app/jdbc/SimpleAppScopedDS”

More Related