Eclipselink jpa black belt training oracle db
This presentation is the property of its rightful owner.
Sponsored Links
1 / 9

EclipseLink JPA Black Belt Training: Oracle DB PowerPoint PPT Presentation


  • 103 Views
  • Uploaded on
  • Presentation posted in: General

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

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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Eclipselink jpa black belt training oracle db

EclipseLink JPA Black Belt Training: Oracle DB

<PRESENTER>

<TITLE>


Eclipselink on oracle db

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, …


Oracledb continued

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


Advanced data types

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


Query extensions

Query Extensions

  • Oracle specific operators (DECODE, …)

  • Outer join support

  • HINT support

  • Hierarchical Querying

  • Flashback querying

  • Pessimistic locking

    SELECT … FOR UPDATE [NOWAIT]


Oracle vpd ols

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


Eclipselink in wls

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


Installing eclipselink in weblogic 10 3

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


Data sources

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”


  • Login