Difference between revisions of "EclipseLink/UserGuide/JPA/Advanced JPA Development/Platform Specific Configurations"

From Eclipsepedia

Jump to: navigation, search
m
 
(7 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 +
----
 +
 +
 +
'''[[Image:Elug_draft_icon.png|Warning]] This page is now obsolete. '''
 +
 +
For current information, please see "Database Support" in the ''EclipseLink Concepts Guide'':
 +
http://www.eclipse.org/eclipselink/documentation/latest/concepts/app_tl_ext001.htm
 +
 +
 +
----
 +
 +
 +
 
{{EclipseLink_UserGuide
 
{{EclipseLink_UserGuide
 
|info=y
 
|info=y
Line 302: Line 315:
 
EclipseLink can be used with ''any'' Java EE application server that meets the [[#What Are the Software Requirements|software requirements]] through the EclipseLink API.  
 
EclipseLink can be used with ''any'' Java EE application server that meets the [[#What Are the Software Requirements|software requirements]] through the EclipseLink API.  
  
EclipseLink provides integration support for the following servers. See the Javadoc for more information.
+
EclipseLink provides integration support for the following servers. See the Javadoc for more information. These classes are concrete subclasses of [http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/server/ServerPlatformBase.html org.eclipse.persistence.platform.server.ServerPlatformBase] responsible for representing server-specific behavior. These classes provide the behavior for the following:
 +
* Which external transaction controller to use
 +
* Whether or not to enable JTA (external transaction control)
 +
* How to register/unregister for runtime services (JMX/MBean)
 +
* Whether or not to enable runtime services
 +
* How to launch container Threads
 +
 
  
 
<table>
 
<table>
Line 308: Line 327:
 
<td>'''Server Name'''</td>
 
<td>'''Server Name'''</td>
 
<td>'''Javadoc'''</td>
 
<td>'''Javadoc'''</td>
<td>'''See Also'''</td>
 
 
</tr>
 
</tr>
<tr>
+
 
<td>JBoss Application Server
+
<tr valign="top">
</td>
+
<td>IBM WebSphere Application Server</td>
 
<td>
 
<td>
[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/server/jboss/package-summary.html org.eclipse.persistence.platform.server.jboss]</td>
+
[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/server/was/WebSphere_6_1_Platform.html org.eclipse.persistence.platform.server.was.WebSphere_6_1_Platform]
<td>.
+
 
 +
[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/server/was/WebSphere_7_Platform.html org.eclipse.persistence.platform.server.was.WebSphere_7_Platform]
 +
 
 +
[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/server/was/WebSpherePlatform.html org.eclipse.persistence.platform.server.was.WebSpherePlatform]
 
</td>
 
</td>
 
</tr>
 
</tr>
<tr>
+
 
<td>Oracle Containers for J2EE (OC4J)
+
<tr valign="top">
 +
<td>JBoss Application Server
 
</td>
 
</td>
<td>[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/server/oc4j/package-summary.html org.eclipse.persistence.platform.server.oc4j]
 
</td>
 
</tr>
 
<tr>
 
 
<td>
 
<td>
Oracle WebLogic Server</td>
+
[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/server/oc4j/Oc4jPlatform.html org.eclipse.persistence.platform.server.jboss.JBossPlatform]</td>
<td>[http://www.eclipse.org/eclipselink/api/2.2/org/eclipse/persistence/platform/server/wls/package-summary.html org.eclipse.persistence.platform.server.wls]
+
</td>
+
<td>.
+
</td>
+
 
</tr>
 
</tr>
<tr>
+
 
<td>SAP NetWeaver Application Server
+
<tr valign="top">
</td>
+
<td>Oracle Containers for J2EE (OC4J)</td>
<td>[http://www.eclipse.org/eclipselink/api/2.2/org/eclipse/persistence/platform/server/sap/package-summary.html org.eclipse.persistence.platform.server.sap]</td>
+
<td>[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/server/oc4j/Oc4jPlatform.html org.eclipse.persistence.platform.server.oc4j.Oc4jPlatform]
<td>.
+
 
</td>
 
</td>
 
</tr>
 
</tr>
<tr>
+
 
<td>IBM WebSphere Application Server
+
<tr valign="top">
</td>
+
<td>Oracle Sun Application Server</td>
<td>[http://www.eclipse.org/eclipselink/api/2.2/org/eclipse/persistence/platform/server/was/package-summary.html org.eclipse.persistence.platform.server.was]</td>
+
<td>[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/server/sunas/package-summary.html org.eclipse.persistence.platform.server.sunas]</td>
 
<td>.
 
<td>.
 
</td>
 
</td>
 
</tr>
 
</tr>
<tr>
+
 
<td>Sun Application Server
+
<tr valign="top">
</td>
+
<td>Oracle WebLogic Server</td>
<td>[http://www.eclipse.org/eclipselink/api/2.2/org/eclipse/persistence/platform/server/sunas/package-summary.html org.eclipse.persistence.platform.server.sunas]</td>
+
<td>
<td>.
+
[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/server/wls/WebLogic_10_Platform.html org.eclipse.persistence.platform.server.wls.WebLogic_10_Platform]
 +
 
 +
[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/server/wls/WebLogic_9_Platform.html org.eclipse.persistence.platform.server.wls.WebLogic_9_Platform]
 +
 
 +
[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/server/wls/WebLogicPlatform.html org.eclipse.persistence.platform.server.wls.WebLogicPlatform]
 
</td>
 
</td>
 +
</tr>
 +
 +
<tr valign="top">
 +
<td>SAP NetWeaver Application Server</td>
 +
<td>[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/server/sap/SAPNetWeaver_7_1_Platform.html org.eclipse.persistence.platform.server.sap.SAPNetWeaver_7_1_Platform]</td>
 
</tr>
 
</tr>
  
 
</table>
 
</table>
  
<!--
 
* [[#Integrating EclipseLink with Oracle WebLogic Server|Oracle WebLogic Server]]
 
* [[#Integrating EclipseLink with Oracle Containers for J2EE (OC4J)|Oracle Containers for J2EE (OC4J)]]
 
* [[#Integrating EclipseLink with IBM WebSphere Application Server|IBM WebSphere Application Server]]
 
* [[#Integrating EclipseLink with Sun Application Server|Sun Application Server]]
 
* [[#Integrating EclipseLink with JBoss Application Server|JBoss Application Server]]
 
* [[#Integrating EclipseLink with SAP NetWeaver Application Server|SAP NetWeaver Application Server]]
 
 
-->
 
  
 
{{EclipseLink_JPA
 
{{EclipseLink_JPA
 
|previous=[[EclipseLink/UserGuide/JPA/Advanced_JPA_Development/Performance/Fetch Groups|Fetch Groups]]
 
|previous=[[EclipseLink/UserGuide/JPA/Advanced_JPA_Development/Performance/Fetch Groups|Fetch Groups]]
|next=    [[EclipseLink/UserGuide/JPA/Advanced_JPA_Development/Platform Specific Configurations/Oracle|Oracle Database Support]]
+
|next=    [[EclipseLink/UserGuide/JPA/Advanced_JPA_Development/Dynamic|Dynamic]]
 
|up=      [[EclipseLink/UserGuide/JPA/Advanced_JPA_Development|Advanced JPA Development]]
 
|up=      [[EclipseLink/UserGuide/JPA/Advanced_JPA_Development|Advanced JPA Development]]
|version=2.2.0 DRAFT}}
+
}}
 
+
<!-- the above info presented as a list:
+
* [[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/AccessPlatform.html Access]]
+
* [[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/AttunityPlatform.html Attunity]]
+
* [[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/CloudscapePlatform.html Cloudscape]]
+
* [[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/DB2MainframePlatform.html DB2 Mainframe]]
+
* [[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/DB2Platform.html DB2]]
+
* [[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/DBasePlatform.html DBase]]
+
* [[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/DerbyPlatform.html Derby]]
+
* [[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/FirebirdPlatform.html Firebird]]
+
* [[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/H2Platform.html H2]]
+
* [[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/HSQLPlatform.html HSQL]]
+
* [[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/InformixPlatform.html Informix]]
+
* [[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/JavaDBPlatform.html JavaDB]]
+
* [[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/MaxDBPlatform.html MaxDB]]
+
* [[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/MySQLPlatform.html MySQL]]
+
* [[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/OraclePlatform.html Oracle]]
+
* [[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/PointBasePlatform.html PointBase]]
+
* [[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/PostgreSQLPlatform.html PostgreSQL]]
+
* [[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/SQLAnywherePlatform.html SQLAnywhere]]
+
* [[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/SQLServerPlatform.html SQLServer]]
+
* [[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/SybasePlatform.html Sybase]]
+
* [[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/SymfowarePlatform.html Symfoware]]
+
* [[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/TimesTen7Platform.html TimesTen7]]
+
* [[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/TimesTenPlatform.html TimesTen]]
+
-->
+
<!-- This is the list from http://wiki.eclipse.org/index.php?title=EclipseLink/FAQ/JPA&action=edit
+
These include:
+
* Oracle
+
* Oracle JDBC (8, 9, 10, 11)
+
* MySQL
+
* [[/PostgreSQL|PostgreSQL]]
+
* Derby
+
* DB2
+
* DB2 (mainframe)
+
* Microsoft SQL Server
+
* Sybase
+
* Informix
+
* SQL Anywhere
+
* HSQL
+
* H2
+
* Firebird
+
* Microsoft Access
+
* Attunity
+
* Cloudscape
+
* DBase
+
* PointBase
+
* TimesTen
+
* Symfoware
+
* MaxDB
+
-->
+
 
+
 
+
<!--
+
*[[EclipseLink/UserGuide/JPA/Advanced JPA Development/Platform Specific Configurations/Oracle|Oracle]]
+
*[[EclipseLink/UserGuide/JPA/Advanced JPA Development/Platform Specific Configurations/DB2|DB2]]
+
*[[EclipseLink/UserGuide/JPA/Advanced JPA Development/Platform Specific Configurations/MySQL|MySQL]]
+
-->
+

Latest revision as of 07:59, 17 April 2013



Warning This page is now obsolete.

For current information, please see "Database Support" in the EclipseLink Concepts Guide: http://www.eclipse.org/eclipselink/documentation/latest/concepts/app_tl_ext001.htm





EclipseLink JPA


[edit] Database and Application Server Support

EclipseLink supports a number of database platforms and application servers, as described below.

[edit] Database Support

EclipseLink supports any relational database that is compliant with SQL and has a compliant JDBC driver. EclipseLink has extended support for several database platforms. The extended support mainly consists of providing native sequencing support, schema creation, and certain database functions.

The following databases are supported. Click the names below to see the Javadoc that describes the support for that platform. The classes are in the org.eclipse.persistence.platform.database package.

Supported Database Platforms
Database JavaDoc Features
Apache Derby DerbyPlatform Provides Derby specific behavior.
Attunity AttunityPlatform Platform class that works with Attunity's Connect JDBC driver.
dBASE DBasePlatform Provides dBASE specific behavior, including:
  • Writes Time & Timestamp as strings (because they are not supported)
Firebird FirebirdPlatform Provides Firebird specific behavior.
H2 H2Platform Provides H2 specific behavior.
HyperSQL DataBase (HSQL) HSQLPlatform Provides HSQL specific behavior. Supports HSQL functionality as of 1.8.1. Features include:
  • DDL creation
  • IDENTITY sequencing
  • SEQUENCE objects
  • Functions
  • Pagination
IBM Cloudscape CloudscapePlatform Provides CloudScape DBMS specific behavior.
IBM DB2 Mainframe DB2MainframePlatform Provides DB2 Mainframe specific behavior. This provides for some additional compatibility in certain DB2 versions on OS390. Features include:
  • Specialized CONCAT syntax
IBM DB2 DB2Platform Provides DB2 specific behavior, including:
  • Schema creation
  • Native SQL for byte[], Date, Time, & Timestamp
  • Table qualified names.
  • Stored procedures
  • Temporary tables
  • Casting
  • Database functions
  • Identity sequencing
  • SEQUENCE sequencing
IBM Informix InformixPlatform Provides Informix specific behavior, including:
  • Types for schema creation.
  • Native sequencing using @@SERIAL.
Microsoft Access AccessPlatformPlatform Provides Microsoft Access specific behavior. .
Microsoft SQLServer SQLServerPlatform Provides Microsoft SQL Server specific behavior, including:
  • Native SQL for byte[], Date, Time, & Timestamp.
  • Native sequencing using @@IDENTITY.
MySQL MySQLPlatform Provides MySQL specific behavior, including:
  • Native SQL for Date, Time, & Timestamp
  • Native sequencing
  • Mapping of class types to database types for the schema framework
  • Pessimistic locking
  • Platform specific operators
Oracle OraclePlatform Provides Oracle Database specific behavior, including:
  • LOB
  • NChar
  • XMLType
  • TIMESTAMP (TZ, LTZ)
  • Native batch writing
  • Structured object-relational data-types
  • PLSQL datatypes and stored procedures
  • VPD, RAC, proxy authentication
  • XDK XML parser
  • Hierarchical selects (Select by prior)
  • Returning clause
  • Flashback history and queries
  • Stored procedures, output parameters and output cursors
  • Stored functions
  • Oracle AQ
Oracle JavaDB JavaDBPlatform Allows to use JavaDBPlatform as a synonym for DerbyPlatform
Oracle TimesTen TimesTenPlatform Provides Oracle TimesTen database specific behavior.
Oracle TimesTen7 TimesTen7Platform Provides Oracle TimesTen 7 database specific behavior.
PointBase PointBasePlatform Provides PointBase database specific behavior.
PostgreSQL PostgreSQLPlatform
  • Native SQL for Date, Time, & Timestamp
  • Native sequencing
  • Mapping of class types to database types for the schema framework
  • Pessimistic locking
  • Platform specific operators
  • LIMIT/OFFSET query syntax for select statements

See also PostgreSQL

SAP MaxDB MaxDBPlatform See MaxDBPlatform. .
SAP SyBase SQLAnywhere SQLAnywherePlatform Provides SQL Anywhere specific behaviour.
Sybase SybasePlatform
  • Native SQL for byte[], Date, Time, & Timestamp
  • Native sequencing using @@IDENTITY
Fujitsu Symfoware SymfowarePlatform
  • DDL Generation
  • Outer Join
  • Subquery (with limitations)
  • Stored Procedure Calls
  • Stored Procedure Generation
  • Native Sequences/Identifier fields
  • JPA Bulk Update/Delete (with limitations)
  • Batch Reading
  • Batch Writing
  • Pessimistic Locking (with limitations)
  • First Result/Limit (with limitations)
  • Expression Framework (with limitations)
  • Delimiters
  • Auto Detection

See also Fujitsu Symfoware Support

It also possible to extend EclipseLink to add extended support for additional platforms. There are also several user contributed platforms in the EclipseLink incubator project. See Platform Incubator.

[edit] Application Server Support

EclipseLink can be used with any Java EE application server that meets the software requirements through the EclipseLink API.

EclipseLink provides integration support for the following servers. See the Javadoc for more information. These classes are concrete subclasses of org.eclipse.persistence.platform.server.ServerPlatformBase responsible for representing server-specific behavior. These classes provide the behavior for the following:

  • Which external transaction controller to use
  • Whether or not to enable JTA (external transaction control)
  • How to register/unregister for runtime services (JMX/MBean)
  • Whether or not to enable runtime services
  • How to launch container Threads


Server Name Javadoc
IBM WebSphere Application Server

org.eclipse.persistence.platform.server.was.WebSphere_6_1_Platform

org.eclipse.persistence.platform.server.was.WebSphere_7_Platform

org.eclipse.persistence.platform.server.was.WebSpherePlatform

JBoss Application Server org.eclipse.persistence.platform.server.jboss.JBossPlatform
Oracle Containers for J2EE (OC4J) org.eclipse.persistence.platform.server.oc4j.Oc4jPlatform
Oracle Sun Application Server org.eclipse.persistence.platform.server.sunas .
Oracle WebLogic Server

org.eclipse.persistence.platform.server.wls.WebLogic_10_Platform

org.eclipse.persistence.platform.server.wls.WebLogic_9_Platform

org.eclipse.persistence.platform.server.wls.WebLogicPlatform

SAP NetWeaver Application Server org.eclipse.persistence.platform.server.sap.SAPNetWeaver_7_1_Platform


Eclipselink-logo.gif
Version: DRAFT
Other versions...