Sessions - Login Options

Use to enter additional database login options for the sessions.xml.

Parameterized SQL

Queries Should Bind All Parameters: Specify whether all queries should bind all parameters (the <should-bind-all-parameters> tag).
Cache All Statements: Specify whether TopLink caches all statements (the <should-cache-all-statements> tag).

Use

Byte Array Binding: Specify whether TopLink binds byte arrays (the <uses-byte-array-binding> tag).
String Binding: Specify whether TopLink binds strings (the <uses-string-binding> tag).
Streams for Binding: Specify whether TopLink uses streams when binding byte arrays (the <uses-streams-for-binding> tag).
Native SQL: Specify whether TopLink uses native SQL for the connection (the <uses-native-sql> tag).
Batch Writing: Specify whether the connection batches statements for writing (the <uses-batch-writing> tag).
JDBC 2.0 Batch Writing: Specify whether the connection uses JDBC 2.0 batch writing for statements (the <uses-jdbc20-batch-writing> tag).
External Connection Pool: Specify whether the connection uses external connection pooling (the <uses-external-connection-pool> tag).
External Transaction Controller: Specify whether the session uses an external transaction controller (the <uses-external-transaction-controller-pool> tag).

Advanced Options

Force Field Name to Uppercase: Specify whether TopLink converts all field names to uppercase when generating SQL (the <should-force-field-names-to-uppercase> tag).
Optimize Data Conversion: Specify whether TopLink optimizes data conversions (the <should-optimize-data-conversion> tag).
Note: Selecting this option may affect the how TopLink converts dates.
Trim Strings: Specify whether TopLink removes white space (blanks) from strings (the <should-trim-strings> tag).