eclipselink jpa black belt training oracle db
Download
Skip this Video
Download Presentation
EclipseLink JPA Black Belt Training: Oracle DB

Loading in 2 Seconds...

play fullscreen
1 / 9

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


  • 153 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 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