Jump to: navigation, search

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

Line 29: Line 29:
 
<td>[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/DerbyPlatform.html <tt>DerbyPlatform</tt>]
 
<td>[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/DerbyPlatform.html <tt>DerbyPlatform</tt>]
 
</td>
 
</td>
<td>
+
<td>.
 
</td>
 
</td>
 
</tr>
 
</tr>
Line 36: Line 36:
 
</td>
 
</td>
 
<td>[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/AttunityPlatform.html <tt>AttunityPlatform</tt>]</td>
 
<td>[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/AttunityPlatform.html <tt>AttunityPlatform</tt>]</td>
<td>
+
<td>.
</td>
+
<td>
+
 
</td>
 
</td>
 
</tr>
 
</tr>
Line 54: Line 52:
 
<td>[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/FirebirdPlatform.html <tt>FirebirdPlatform</tt>]
 
<td>[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/FirebirdPlatform.html <tt>FirebirdPlatform</tt>]
 
</td>
 
</td>
<td>
+
<td>.
 
</td>
 
</td>
 
</tr>
 
</tr>
Line 62: Line 60:
 
<td>[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/H2Platform.html <tt>H2Platform</tt>]
 
<td>[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/H2Platform.html <tt>H2Platform</tt>]
 
</td>
 
</td>
<td>
+
<td>.
 
</td>
 
</td>
 
</tr>
 
</tr>
Line 82: Line 80:
 
</td>
 
</td>
 
<td>[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/CloudscapePlatform.html <tt>CloudscapePlatform</tt>]</td>
 
<td>[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/CloudscapePlatform.html <tt>CloudscapePlatform</tt>]</td>
<td>
+
<td>.
 
</td>
 
</td>
 
</tr>
 
</tr>
Line 123: Line 121:
 
<td>Microsoft Access</td>
 
<td>Microsoft Access</td>
 
<td>[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/AccessPlatform.html <tt>AccessPlatformPlatform</tt>]</td>
 
<td>[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/AccessPlatform.html <tt>AccessPlatformPlatform</tt>]</td>
<td></td>
+
<td>.
<td>
+
</td>
 +
<td>.
 
</td>
 
</td>
 
</tr>
 
</tr>
Line 187: Line 186:
 
<td>[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/TimesTenPlatform.html <tt>TimesTenPlatform</tt>]
 
<td>[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/TimesTenPlatform.html <tt>TimesTenPlatform</tt>]
 
</td>
 
</td>
<td>
+
<td>.
 
</td>
 
</td>
 
</tr>
 
</tr>
Line 195: Line 194:
 
<td>[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/TimesTen7Platform.html <tt>TimesTen7Platform</tt>]
 
<td>[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/TimesTen7Platform.html <tt>TimesTen7Platform</tt>]
 
</td>
 
</td>
<td>
+
<td>.
 
</td>
 
</td>
 
</tr>
 
</tr>
Line 203: Line 202:
 
<td>[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/PointBasePlatform.html <tt>PointBasePlatform</tt>]
 
<td>[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/PointBasePlatform.html <tt>PointBasePlatform</tt>]
 
</td>
 
</td>
<td>
+
<td>.
 
</td>
 
</td>
 
</tr>
 
</tr>
Line 228: Line 227:
 
<td>See [http://wiki.eclipse.org/EclipseLink/Development/DatabasePlatform/MaxDBPlatform MaxDBPlatform].
 
<td>See [http://wiki.eclipse.org/EclipseLink/Development/DatabasePlatform/MaxDBPlatform MaxDBPlatform].
 
</td>
 
</td>
<td>
+
<td>.
 
</td>
 
</td>
 
</tr>
 
</tr>
Line 293: Line 292:
 
<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/jboss/package-summary.html org.eclipse.persistence.platform.server.jboss]</td>
<td></td>
+
<td>.
 +
</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
Line 306: Line 306:
 
<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>[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></td>
+
<td>.
 +
</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
Line 312: Line 313:
 
</td>
 
</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/2.2/org/eclipse/persistence/platform/server/sap/package-summary.html org.eclipse.persistence.platform.server.sap]</td>
<td></td>
+
<td>.
 +
</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
Line 318: Line 320:
 
</td>
 
</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/2.2/org/eclipse/persistence/platform/server/was/package-summary.html org.eclipse.persistence.platform.server.was]</td>
<td></td>
+
<td>.
 +
</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
Line 324: Line 327:
 
</td>
 
</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>[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>
+
<td>.
 +
</td>
 
</tr>
 
</tr>
  

Revision as of 14:14, 26 April 2011

EclipseLink JPA


Database and Application Server Support

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

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 .
Attunity AttunityPlatform .
dBASE DBasePlatform Writing Time & Timestamp as strings (because they are not supported)
Firebird FirebirdPlatform .
H2 H2Platform .
HyperSQL DataBase (HSQL) HSQLPlatform
  • DDL creation
  • IDENTITY sequencing
  • SEQUENCE objects
  • Functions
  • Pagination
IBM Cloudscape CloudscapePlatform .
IBM DB2 Mainframe DB2MainframePlatform Specialized CONCAT syntax
IBM DB2 DB2Platform
  • 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
  • Types for schema creation.
  • Native sequencing using @@SERIAL.
Microsoft Access AccessPlatformPlatform . .
Microsoft SQLServer SQLServerPlatform
  • Native SQL for byte[], Date, Time, & Timestamp.
  • Native sequencing using @@IDENTITY.
MySQL MySQLPlatform
  • 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
  • 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 .
Oracle TimesTen7 TimesTen7Platform .
PointBase PointBasePlatform .
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.

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.

Server Name Javadoc See Also
JBoss Application Server org.eclipse.persistence.platform.server.jboss .
Oracle Containers for J2EE (OC4J) org.eclipse.persistence.platform.server.oc4j
Oracle WebLogic Server org.eclipse.persistence.platform.server.wls .
SAP NetWeaver Application Server org.eclipse.persistence.platform.server.sap .
IBM WebSphere Application Server org.eclipse.persistence.platform.server.was .
Sun Application Server org.eclipse.persistence.platform.server.sunas .


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