Jump to: navigation, search

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

Line 22: Line 22:
 
<td>'''Database'''</td>
 
<td>'''Database'''</td>
 
<td>'''JavaDoc'''</td>
 
<td>'''JavaDoc'''</td>
 +
<td>'''Features'''</td>
 
<td>'''See Also'''</td>
 
<td>'''See Also'''</td>
 
</tr>
 
</tr>
Line 31: Line 32:
 
<td>
 
<td>
 
</td>
 
</td>
</tr><tr>
+
<td>
 +
</td>
 +
</tr>
 +
<tr>
 
<td>Attunity
 
<td>Attunity
 
</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>
Line 42: Line 48:
 
</td>
 
</td>
 
<td>[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/DBasePlatform.html <tt>DBasePlatform</tt>]
 
<td>[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/DBasePlatform.html <tt>DBasePlatform</tt>]
 +
</td>
 +
<td>
 
</td>
 
</td>
 
<td>
 
<td>
Line 50: Line 58:
 
</td>
 
</td>
 
<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>
Line 58: Line 68:
 
</td>
 
</td>
 
<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>
Line 66: Line 78:
 
</td>
 
</td>
 
<td>[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/HSQLPlatform.html <tt>HSQLPlatform</tt>]
 
<td>[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/HSQLPlatform.html <tt>HSQLPlatform</tt>]
 +
</td>
 +
<td>
 
</td>
 
</td>
 
<td>
 
<td>
Line 74: Line 88:
 
</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>
 
</td>
 
</td>
Line 81: Line 97:
 
</td>
 
</td>
 
<td>[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/DB2MainframePlatform.html <tt>DB2MainframePlatform</tt>]
 
<td>[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/DB2MainframePlatform.html <tt>DB2MainframePlatform</tt>]
 +
</td>
 +
<td>
 
</td>
 
</td>
 
<td>
 
<td>
Line 89: Line 107:
 
</td>
 
</td>
 
<td>[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/DB2Platform.html <tt>DB2Platform</tt>]
 
<td>[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/DB2Platform.html <tt>DB2Platform</tt>]
 +
</td>
 +
<td>
 
</td>
 
</td>
 
<td>
 
<td>
Line 97: Line 117:
 
</td>
 
</td>
 
<td>[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/InformixPlatform.html <tt>InformixPlatform</tt>]
 
<td>[http://www.eclipse.org/eclipselink/api/latest/org/eclipse/persistence/platform/database/InformixPlatform.html <tt>InformixPlatform</tt>]
 +
</td>
 +
<td>
 
</td>
 
</td>
 
<td>
 
<td>
Line 105: Line 127:
 
<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>
 
<tr>
 
<tr>
Line 110: Line 136:
 
</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>
 
<td>
 
<td>
Line 118: Line 146:
 
</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>
 
<td>
 
<td>
 
</td>
 
</td>
 
</tr>
 
</tr>
<tr>
+
<tr valign="top">
 
<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>
 +
* 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
 
</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]]
Line 134: Line 181:
 
</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>
 
<td>
 
<td>
Line 142: Line 191:
 
</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>
 
<td>
 
<td>
Line 150: Line 201:
 
</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>
 
<td>
 
<td>
Line 158: Line 211:
 
</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>
 
<td>
 
<td>
Line 166: Line 221:
 
</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>
 
</td>
 
<td>[[EclipseLink/FAQ/JPA/PostgreSQL|PostgreSQL Support]]
 
<td>[[EclipseLink/FAQ/JPA/PostgreSQL|PostgreSQL Support]]
Line 174: Line 231:
 
</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>
 
<td>
 
<td>
Line 182: Line 241:
 
</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>
 
<td>
 
<td>
Line 190: Line 251:
 
</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>
 
<td>
 
<td>
Line 198: Line 261:
 
</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>
 
<td>[[EclipseLink/Development/Incubator/Extensions/SymfowarePlatform|Fujitsu Symfoware Support]]
 
<td>[[EclipseLink/Development/Incubator/Extensions/SymfowarePlatform|Fujitsu Symfoware Support]]

Revision as of 13:28, 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 See Also
Apache Derby DerbyPlatform
Attunity AttunityPlatform
dBASE DBasePlatform
Firebird FirebirdPlatform
H2 H2Platform
HyperSQL DataBase (HSQL) HSQLPlatform
IBM Cloudscape CloudscapePlatform
IBM DB2 Mainframe DB2MainframePlatform
IBM DB2 DB2Platform
IBM Informix InformixPlatform
Microsoft Access AccessPlatformPlatform
Microsoft SQLServer SQLServerPlatform
MySQL MySQLPlatform
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 Database Support
Oracle JavaDB JavaDBPlatform
Oracle TimesTen TimesTenPlatform
Oracle TimesTen7 TimesTen7Platform
PointBase PointBasePlatform
PostgreSQL PostgreSQLPlatform PostgreSQL Support
SAP MaxDB MaxDBPlatform
SAP SyBase SQLAnywhere SQLAnywherePlatform
Sybase SybasePlatform
Fujitsu Symfoware SymfowarePlatform 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...