Connection

The following table lists the properties available in the Connection page of the persistence.xml Editor.

Properties of the Connection Page

Property Description Default

Transaction Type

Specify if the connection for this persistence unit uses one of the following transaction types:

  • Default -- Select to use the container used by the container.

  • JTA (Java Transaction API) -- Transactions of the Java EE server.

  • Resource Local -- Native actions of a JDBC driver that are referenced by a persistence unit.


Batch Writing

Specify the use of batch writing to optimize transactions with multiple write operations.

Set the value of this property into the session at deployment time.

Note: This property applies when used both in a Java SE and Java EE environment.

The following are the valid values for oracle.toplink.config.BatchWriting:

  • JDBC–Use JDBC batch writing.

  • Buffered–Do not use either JDBC batch writing nor native platform batch writing.

  • OracleJDBC–Use both JDBC batch writing and Oracle native platform batch writing.

  • None–Do not use batch writing (turn it off).

None

JTA Data Source Name

If you selected JTA as the transaction type, then enter the name of the default JTA data source for the persistence unit.


Non-JTA Data Source Name

If you selected Resource Local as the transaction type, then enter the name of the non-JTA data source.

This property is not available for projects using the Generic platform.


  Bind Parameters

Control whether or not the query uses parameter binding.

Note: This property applies when used in a Java SE environment.

This property is not available for projects using the Generic platform.


EclipseLink Connection Pool

Define the connection pool driver, URL, user name and password.

These properties are note available for projects using the Generic platform.


  Read Connection

The maximum and minimum number of connections allowed in the JDBC read connection pool.

Note: These properties apply when used in a Java SE environment.

These properties are not available for projects using the Generic platform


  Write Connection

The maximum and minimum number of connections allowed in the JDBC write connection pool.

Note: These properties apply when used in a Java SE environment.

These properties are not available for projects using the Generic platform