Jump to: navigation, search

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

m
Line 7: Line 7:
 
|apis=
 
|apis=
 
*[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/package-summary.html org.eclipse.persistence.platform.database package]
 
*[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/package-summary.html org.eclipse.persistence.platform.database package]
*[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/converters/package-summary.html org.eclipse.persistence.platform.database.converters package]
 
*[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/jdbc/package-summary.html org.eclipse.persistence.platform.database.jdbc package]
 
*[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/oracle/jdbc/package-summary.html org.eclipse.persistence.platform.database.oracle.jdbc package]
 
*[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/oracle/plsql/package-summary.html org.eclipse.persistence.platform.database.oracle.plsql package]
 
 
}}
 
}}
  
Line 17: Line 13:
  
 
==Database Support==
 
==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.  These platform classes are in the [[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/package-summary.html package.
+
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.  These platform 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 following databases are supported. Click the names below to see the Javadoc that describes the support for that platform:
 +
 +
<table>
 +
<caption>Supported Database Platforms</caption>
 +
<tr>
 +
<td>'''Database'''</td>
 +
<td>'''JavaDoc (in <tt>org.eclipse.persistence.platform.database</tt> package)'''</td>
 +
<td>'''See Also'''</td>
 +
</tr>
 +
<tr>
 +
<td>Access</td>
 +
<td>[[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/AccessPlatform.html <tt>AccessPlatformPlatform</tt>]]</td>
 +
<td></td>
 +
</tr>
 +
<tr>
 +
<td>Attunity
 +
</td>
 +
<td>[[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/AttunityPlatform.html <tt>AttunityPlatform</tt>]]</td>
 +
<td>
 +
</td>
 +
</tr>
 +
<tr>
 +
<td>Cloudscape
 +
</td>
 +
<td>[[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/CloudscapePlatform.html <tt>CloudscapePlatform</tt>]]</td>
 +
<td>
 +
</td>
 +
</tr>
 +
<tr>
 +
<td>DB2 Mainframe
 +
</td>
 +
<td>[[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/DB2MainframePlatform.html <tt>DB2MainframePlatform</tt>]]
 +
</td>
 +
<td>
 +
</td>
 +
</tr>
 +
<tr>
 +
<td>DB2
 +
</td>
 +
<td>[[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/DB2Platform.html <tt>DB2Platform</tt>]]
 +
</td>
 +
<td>
 +
</td>
 +
</tr>
 +
<tr>
 +
<td>dBASE
 +
</td>
 +
<td>[[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/DBasePlatform.html <tt>DBasePlatform</tt>]]
 +
</td>
 +
<td>
 +
</td>
 +
</tr>
 +
<tr>
 +
<td>Derby
 +
</td>
 +
<td>[[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/DerbyPlatform.html <tt>DerbyPlatform</tt>]]
 +
</td>
 +
<td>
 +
</td>
 +
</tr>
 +
<tr>
 +
<td>Firebird
 +
</td>
 +
<td>[[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/FirebirdPlatform.html <tt>FirebirdPlatform</tt>]]
 +
</td>
 +
<td>
 +
</td>
 +
</tr>
 +
<tr>
 +
<td>H2
 +
</td>
 +
<td>[[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/H2Platform.html <tt>H2Platform</tt>]]
 +
</td>
 +
<td>
 +
</td>
 +
</tr>
 +
<tr>
 +
<td>HSQL
 +
</td>
 +
<td>[[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/HSQLPlatform.html <tt>HSQLPlatform</tt>]]
 +
</td>
 +
<td>
 +
</td>
 +
</tr>
 +
<tr>
 +
<td>Informix
 +
</td>
 +
<td>[[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/InformixPlatform.html <tt>InformixPlatform</tt>]]
 +
</td>
 +
<td>
 +
</td>
 +
</tr>
 +
<tr>
 +
<td>JavaDB
 +
</td>
 +
<td>[[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/JavaDBPlatform.html <tt>JavaDBPlatform</tt>]]
 +
</td>
 +
<td>
 +
</td>
 +
</tr>
 +
<tr>
 +
<td>MaxDB
 +
</td>
 +
<td>[[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/MaxDBPlatform.html <tt>MaxDBPlatform</tt>]]
 +
</td>
 +
<td>
 +
</td>
 +
</tr>
 +
<tr>
 +
<td>MySQL
 +
</td>
 +
<td>[[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/MySQLPlatform.html <tt>MySQLPlatform</tt>]]
 +
</td>
 +
<td>
 +
</td>
 +
</tr>
 +
<tr>
 +
<td>Oracle
 +
</td>
 +
<td>[[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/OraclePlatform.html <tt>OraclePlatform</tt>]]
 +
</td>
 +
<td>
 +
</td>
 +
</tr>
 +
<tr>
 +
<td>PointBase
 +
</td>
 +
<td>[[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/PointBasePlatform.html <tt>PointBasePlatform</tt>]]
 +
</td>
 +
<td>
 +
</td>
 +
</tr>
 +
<tr>
 +
<td>PostgreSQL
 +
</td>
 +
<td>[[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/PostgreSQLPlatform.html <tt>PostgreSQLPlatform</tt>]]
 +
</td>
 +
<td>[[/PostgreSQL|PostgreSQL]]
 +
</td>
 +
</tr>
 +
<tr>
 +
<td>SQLAnywhere
 +
</td>
 +
<td>[[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/SQLAnywherePlatform.html <tt>SQLAnywherePlatform</tt>]]
 +
</td>
 +
<td>
 +
</td>
 +
</tr>
 +
<tr>
 +
<td>SQLServer
 +
</td>
 +
<td>[[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/SQLServerPlatform.html <tt>SQLServerPlatform</tt>]]
 +
</td>
 +
<td>
 +
</td>
 +
</tr>
 +
<tr>
 +
<td>Sybase
 +
</td>
 +
<td>[[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/SybasePlatform.html <tt>SybasePlatform</tt>]]
 +
</td>
 +
<td>
 +
</td>
 +
</tr>
 +
<tr>
 +
<td>Symfoware
 +
</td>
 +
<td>[[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/SymfowarePlatform.html <tt>SymfowarePlatform</tt>]]
 +
</td>
 +
<td>
 +
</td>
 +
</tr>
 +
<tr>
 +
<td>TimesTen7
 +
</td>
 +
<td>[[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/TimesTen7Platform.html <tt>TimesTen7Platform</tt>]]
 +
</td>
 +
<td>
 +
</td>
 +
</tr>
 +
<tr>
 +
<td>TimesTen
 +
</td>
 +
<td>[[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/TimesTenPlatform.html <tt>TimesTenPlatform</tt>]]
 +
</td>
 +
<td>
 +
</td>
 +
</tr>
 +
</table>
 +
 +
 +
 +
 +
 +
 +
 +
 +
<!-- 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/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/AttunityPlatform.html Attunity]]
Line 43: Line 237:
 
* [[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/TimesTen7Platform.html TimesTen7]]
 
* [[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/TimesTenPlatform.html TimesTen]]
 
* [[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
 
<!-- This is the list from http://wiki.eclipse.org/index.php?title=EclipseLink/FAQ/JPA&action=edit
 
These include:
 
These include:

Revision as of 10:49, 25 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. These platform classes are in the [org.eclipse.persistence.platform.database] package.

The following databases are supported. Click the names below to see the Javadoc that describes the support for that platform:

Supported Database Platforms
Database JavaDoc (in org.eclipse.persistence.platform.database package) 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]
PointBase [PointBasePlatform]
PostgreSQL [PostgreSQLPlatform] 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.

EclipseLink has extended support for Oracle JDBC drivers. Including:

  • LOB's
  • NChar's
  • XMLType's
  • TIMESTAMP (TZ, LTZ)'s
  • Native batch writing
  • Structured object-relational data-types
  • PLSQL data-types and stored procedures
  • VPD, RAC, proxy authentication
  • XDK XML parser


Application Server Support

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

There is EclipseLink-specific integration support for the following servers:


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