Eclipselink jpa black belt training oracle db
Download
1 / 9

EclipseLink JPA Black Belt Training: Oracle DB - PowerPoint PPT Presentation


  • 144 Views
  • Uploaded on

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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' EclipseLink JPA Black Belt Training: Oracle DB' - eryk


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”


ad