Download
eclipselink jpa black belt training oracle db n.
Skip this Video
Loading SlideShow in 5 Seconds..
EclipseLink JPA Black Belt Training: Oracle DB PowerPoint Presentation
Download Presentation
EclipseLink JPA Black Belt Training: Oracle DB

EclipseLink JPA Black Belt Training: Oracle DB

181 Vues Download Presentation
Télécharger la présentation

EclipseLink JPA Black Belt Training: Oracle DB

- - - - - - - - - - - - - - - - - - - - - - - - - - - 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”