EclipseLink/UserGuide/JPA/Advanced JPA Development/Platform Specific Configurations

---

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

• EclipseLink Destinations:
• Documentation
• FAQ
• Examples
• Development

Key API

• org.eclipse.persistence.platform.database package

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	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.

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

Version: DRAFT
Other versions...

Fetch Groups	Advanced JPA Development	Dynamic
EclipseLink Home JPA User Guide: Table of Contents, Search
How to contribute to this guide...