JDBC Options

Use this table to enter data in the fields on the Options subtab to select the JDBC options to use with this session login:

Option | Description
--- | ---
Queries Should Bind All Parameters Foot 1 | Select this option to bind all of the query's parameters
Cache All Statements Footref 1 | When selected, TopLink caches each prepared statement so that when reexecuted, you avoid the SQL preparation time which improves performance.
Byte Array Binding Footref 1 | Select this option if you query binary large object (BLOB) data.
Streams for Binding Footref 1 | Select this option if you use a JDBC driver that is more efficient at handling BLOB data using `java.io.InputStream` and `java.io.OutputStream`.
Native SQL | By default, TopLink generates SQL using JDBC SQL grammar. Select this option if you want TopLink to use database specific SQL grammar, for example, if your database driver does not support the full JDBC SQL grammar.

Batch Writing Foot 2

Select this option if you use a JDBC driver that supports sending groups of `INSERT`, `UPDATE`, and `DELETE` statements to the database in a single transaction, rather than individually.

Select JDBC to use the batch writing capabilities of your JDBC driver.

Select TopLink to use the native batch writing capabilities that TopLink provides. Select this option if your JDBC driver does not support batch writing.

String Binding Footref 1 | Select this option if you query large `java.lang.String` objects. You can configure the maximum `String` length (default: 32000 characters).

Footnote 1 For more information, see "Parameterized SQL (Binding) and Prepared Statement Caching".

Footnote 2 If you are using the `MySQL4` database platform (see "Data Source Platform Types"), use JDBC batch writing (do not use TopLink batch writing). For more information, see "Batch Writing".

See Also

  Configuring JDBC Options