jdbc.native-sql

Use eclipselink.jdbc.native-sql to specify if EclipseLink uses generic SLQ or includes platform-specific (that is, "native") SQL statements.

Values

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

Table 5-46 Valid Values for jdbc.native-sql

Value	Description
`true`	(Default) Use platform-specific ("native" ) SQL.
`false`	Use generic SQL.

Usage

When using platform-specific SQL (eclipselink.jdbc.native-sql = true), EclipseLink uses platform-specific SQL to customize join syntax, date operators, using sequencing, and so on.

Examples

Example 5-42 Using jdbc.native-sql in persistence.xml

<property name="eclipselink.jdbc.native-sql" value="true"/>

Example 5-43 Using jdbc.native-sql in Property Map

import org.eclipse.persistence.config.PersistenceUnitProperties;
propertiesMap.put(PersistenceUnitProperties.NATIVE_SQL, "true");

See Also

For more information, see:

"Querying" in Understanding EclipseLink
"Query Languages" in Understanding EclipseLink