Notice: this Wiki will be going read only early in 2024 and edits will no longer be possible. Please see: https://gitlab.eclipse.org/eclipsefdn/helpdesk/-/wikis/Wiki-shutdown-plan for the plan.
Difference between revisions of "EclipseLink/UserGuide/JPA/Advanced JPA Development/Platform Specific Configurations"
< EclipseLink | UserGuide | JPA | Advanced JPA Development
| Line 179: | Line 179: | ||
<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>Allows to use <tt>JavaDBPlatform</tt> as a synonym for <tt>DerbyPlatform</tt> |
</td> | </td> | ||
</tr> | </tr> | ||
| Line 186: | Line 186: | ||
</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 196: | Line 194: | ||
</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 206: | Line 202: | ||
</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 218: | Line 212: | ||
</td> | </td> | ||
<td> | <td> | ||
| − | + | * 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 [[EclipseLink/FAQ/JPA/PostgreSQL|PostgreSQL]] | ||
</td> | </td> | ||
</tr> | </tr> | ||
| Line 227: | Line 226: | ||
<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>See [http://wiki.eclipse.org/EclipseLink/Development/DatabasePlatform/MaxDBPlatform MaxDBPlatform]. |
</td> | </td> | ||
<td> | <td> | ||
| Line 237: | Line 236: | ||
<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>Provides SQL Anywhere specific behaviour. |
| − | + | ||
| − | + | ||
</td> | </td> | ||
</tr> | </tr> | ||
| Line 248: | Line 245: | ||
</td> | </td> | ||
<td> | <td> | ||
| − | + | * Native SQL for byte[], Date, Time, & Timestamp | |
| − | + | * Native sequencing using @@IDENTITY | |
</td> | </td> | ||
</tr> | </tr> | ||
| Line 258: | Line 255: | ||
</td> | </td> | ||
<td> | <td> | ||
| − | + | * 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 [[EclipseLink/Development/Incubator/Extensions/SymfowarePlatform|Fujitsu Symfoware Support]] | ||
</td> | </td> | ||
</tr> | </tr> | ||
Revision as of 14:11, 26 April 2011
EclipseLink JPA
| EclipseLink | |
| Website | |
| Download | |
| Community | |
| Mailing List • Forums • IRC • mattermost | |
| Issues | |
| Open • Help Wanted • Bug Day | |
| Contribute | |
| Browse Source |
Key API
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.
| 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 |
|
|
| IBM Cloudscape | CloudscapePlatform | ||
| IBM DB2 Mainframe | DB2MainframePlatform | Specialized CONCAT syntax | |
| IBM DB2 | DB2Platform |
|
|
| IBM Informix | InformixPlatform |
|
|
| Microsoft Access | AccessPlatformPlatform | ||
| Microsoft SQLServer | SQLServerPlatform |
|
|
| MySQL | MySQLPlatform |
|
|
| Oracle | OraclePlatform |
|
|
| Oracle JavaDB | JavaDBPlatform | Allows to use JavaDBPlatform as a synonym for DerbyPlatform | |
| Oracle TimesTen | TimesTenPlatform | ||
| Oracle TimesTen7 | TimesTen7Platform | ||
| PointBase | PointBasePlatform | ||
| PostgreSQL | PostgreSQLPlatform |
See also PostgreSQL |
|
| SAP MaxDB | MaxDBPlatform | See MaxDBPlatform. | |
| SAP SyBase SQLAnywhere | SQLAnywherePlatform | Provides SQL Anywhere specific behaviour. | |
| Sybase | SybasePlatform |
|
|
| Fujitsu Symfoware | SymfowarePlatform |
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 |
