Java Persistence API (JPA) Extensions Reference for EclipseLink, Release 2.5
  Go To Table Of Contents


Use the property to specify the database to use, controlling custom operations and SQL generation for the specified database.


Table 5-89 describes this persistence property's values.

Table 5-89 Valid Values for target-database

Value Description

Defined in the TargetDatabase class or a fully qualified class name that extends DatabasePlatform

Specify your database:

  • Attunity

  • Auto (Default): EclipseLink attempts to access the database and the JDBC metadata to determine the target database.

  • Cloudscape

  • Database: Use a generic database, if your target database is not listed and your JDBC driver does not support the metadata required for Auto.

  • DB2

  • DB2Mainframe

  • DBase

  • Derby

  • HSQL

  • Informix

  • JavaDB

  • MaxDB

  • MySQL

  • MySQL4

  • Oracle

  • Oracle10

  • Oracle11

  • Oracle8

  • Oracle9

  • PointBase

  • PostgreSQL

  • SQLAnywhere

  • SQLServer

  • Sybase

  • Symfoware

  • TimesTen


If eclipselink.validation-only = true, you must cannot use an Auto class name or short name.


Example 5-93 shows how to use this property in the persistence.xml file.

Example 5-93 Using target-database in persistence.xml

<property name="" value="Oracle"/>


<property name="" value="org.eclipse.persistence.platform.database.HSQLPlatform"/>

Example 5-94 shows how to use this property in the persistence.xml file.

Example 5-94 Using target-database in a Property Map

import org.eclipse.persistence.config.TargetDatabase;
import org.eclipse.persistence.config.PersistenceUnitProperties;
propertiesMap.put(PersistenceUnitProperties.TARGET_DATABASE, TargetDatabase.Oracle);

See Also

For more information, see: