Jump to: navigation, search

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

Line 15: Line 15:
 
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.   
 
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 [[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/package-summary.html <tt>org.eclipse.persistence.platform.database</tt>]] package.
+
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 [http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/package-summary.html <tt>org.eclipse.persistence.platform.database</tt>] package.
  
 
<table>
 
<table>
Line 110: Line 110:
 
<td>JavaDB
 
<td>JavaDB
 
</td>
 
</td>
<td>[[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/JavaDBPlatform.html <tt>JavaDBPlatform</tt>]]
+
<td>[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/JavaDBPlatform.html <tt>JavaDBPlatform</tt>]
 
</td>
 
</td>
 
<td>
 
<td>
Line 118: Line 118:
 
<td>MaxDB
 
<td>MaxDB
 
</td>
 
</td>
<td>[[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/MaxDBPlatform.html <tt>MaxDBPlatform</tt>]]
+
<td>[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/MaxDBPlatform.html <tt>MaxDBPlatform</tt>]
 
</td>
 
</td>
 
<td>
 
<td>
Line 126: Line 126:
 
<td>MySQL
 
<td>MySQL
 
</td>
 
</td>
<td>[[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/MySQLPlatform.html <tt>MySQLPlatform</tt>]]
+
<td>[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/MySQLPlatform.html <tt>MySQLPlatform</tt>]
 
</td>
 
</td>
 
<td>
 
<td>
Line 134: Line 134:
 
<td>Oracle
 
<td>Oracle
 
</td>
 
</td>
<td>[[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/OraclePlatform.html <tt>OraclePlatform</tt>]]
+
<td>[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/OraclePlatform.html <tt>OraclePlatform</tt>]
 
</td>
 
</td>
<td>[[EclipseLink/UserGuide/JPA/Advanced_JPA_Development/Platform Specific Configurations/Oracle|Oracle Database Support]]
+
<td>[EclipseLink/UserGuide/JPA/Advanced_JPA_Development/Platform Specific Configurations/Oracle|Oracle Database Support]
 
</td>
 
</td>
 
</tr>
 
</tr>
Line 142: Line 142:
 
<td>PointBase
 
<td>PointBase
 
</td>
 
</td>
<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>
Line 150: Line 150:
 
<td>PostgreSQL
 
<td>PostgreSQL
 
</td>
 
</td>
<td>[[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/PostgreSQLPlatform.html <tt>PostgreSQLPlatform</tt>]]
+
<td>[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/PostgreSQLPlatform.html <tt>PostgreSQLPlatform</tt>]
 
</td>
 
</td>
<td>[[EclipseLink/FAQ/JPA/PostgreSQL|PostgreSQL]]
+
<td>[EclipseLink/FAQ/JPA/PostgreSQL|PostgreSQL]
 
</td>
 
</td>
 
</tr>
 
</tr>
Line 158: Line 158:
 
<td>SQLAnywhere
 
<td>SQLAnywhere
 
</td>
 
</td>
<td>[[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/SQLAnywherePlatform.html <tt>SQLAnywherePlatform</tt>]]
+
<td>[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/SQLAnywherePlatform.html <tt>SQLAnywherePlatform</tt>]
 
</td>
 
</td>
 
<td>
 
<td>
Line 166: Line 166:
 
<td>SQLServer
 
<td>SQLServer
 
</td>
 
</td>
<td>[[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/SQLServerPlatform.html <tt>SQLServerPlatform</tt>]]
+
<td>[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/SQLServerPlatform.html <tt>SQLServerPlatform</tt>]
 
</td>
 
</td>
 
<td>
 
<td>
Line 174: Line 174:
 
<td>Sybase
 
<td>Sybase
 
</td>
 
</td>
<td>[[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/SybasePlatform.html <tt>SybasePlatform</tt>]]
+
<td>[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/SybasePlatform.html <tt>SybasePlatform</tt>]
 
</td>
 
</td>
 
<td>
 
<td>
Line 182: Line 182:
 
<td>Symfoware
 
<td>Symfoware
 
</td>
 
</td>
<td>[[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/SymfowarePlatform.html <tt>SymfowarePlatform</tt>]]
+
<td>[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/SymfowarePlatform.html <tt>SymfowarePlatform</tt>]
 
</td>
 
</td>
 
<td>
 
<td>
Line 190: Line 190:
 
<td>TimesTen7
 
<td>TimesTen7
 
</td>
 
</td>
<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>
Line 198: Line 198:
 
<td>TimesTen
 
<td>TimesTen
 
</td>
 
</td>
<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>
Line 207: Line 207:
 
It also possible to extend EclipseLink to add extended support for additional platforms.
 
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 [[EclipseLink/Development/Incubator/Platform|Platform Incubator]].
 
There are also several user contributed platforms in the EclipseLink incubator project. See [[EclipseLink/Development/Incubator/Platform|Platform Incubator]].
<!-- 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]]
 
-->
 
  
 
==Application Server Support==
 
==Application Server Support==
Line 328: Line 271:
 
|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}}
 
|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]]
 +
-->

Revision as of 08:40, 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 See Also
Access AccessPlatformPlatform
Attunity AttunityPlatform
Cloudscape CloudscapePlatform
DB2 Mainframe DB2MainframePlatform
DB2 DB2Platform
dBASE DBasePlatform
Derby DerbyPlatform
Firebird FirebirdPlatform
H2 H2Platform
HSQL HSQLPlatform
Informix InformixPlatform
JavaDB JavaDBPlatform
MaxDB MaxDBPlatform
MySQL MySQLPlatform
Oracle OraclePlatform [EclipseLink/UserGuide/JPA/Advanced_JPA_Development/Platform Specific Configurations/Oracle|Oracle Database Support]
PointBase PointBasePlatform
PostgreSQL PostgreSQLPlatform [EclipseLink/FAQ/JPA/PostgreSQL|PostgreSQL]
SQLAnywhere SQLAnywherePlatform
SQLServer SQLServerPlatform
Sybase SybasePlatform
Symfoware SymfowarePlatform
TimesTen7 TimesTen7Platform
TimesTen TimesTenPlatform

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