SQL Settings tab

Configure these properties on the SQL Settings tab:

Use Quoted Identifiers If you select this option, SQL identifiers are quoted. The configuration property name is useQuotedIdentifiers.

Disable Prefetch Prefetch optimizes container-managed persistence by batching queries from a parent to its children (for example, customer to orders), to reduce the calls from the application server to the database. The configuration property name is disablePrefetch.

Batch Delimiter A delimiter; for example, a semicolon, which can be used to separate multiple SQL statements within a statement batch. The configuration property name is batchDelimiter.

BLOB Updater The name of a class that can be used for updating database BLOB (long binary) objects when the BLOB size is greater than psMaximumBlobLength. The class must implement the com.sybase.djc.sql.BlobUpdater interface. The configuration property name is blobUpdater. A sample implementation for Oracle is documented in the html/en/com.sybase.djc.sql.DatabaseType.html file, in your EAServer installation.

CLOB Updater The name of a class that can be used for updating database CLOB (long string) objects when the CLOB size is greater than psMaximumClobLength. The class must implement the com.sybase.djc.sql.ClobUpdater interface. The configuration property name is clobUpdater. For an Oracle sample implementation, see html/en/com.sybase.djc.sql.DatabaseType.html, in your EAServer installation.

After Insert SQL If the database requires “insert into” for database inserts, instead of the abbreviated form “insert,” enter into. The configuration property name is afterInsert.

Check Update SQL Not currently used.

Check Delete SQL Not currently used.

Compact Column Alias Prefix An expression that uses the nested variables “${index}” and “${column}” for shortening column names in result sets. This can reduce the data transmitted between the database server and the application server. For example:
```
 _${index}=${column}
${column} AS _${index}
```
The configuration property name is compactColumnAlias.
Select With Shared Lock (SQL Template) A template SQL statement for selecting rows and acquiring a shared lock. The configuration property name is selectWithSharedLock. If your database server does not support shared locks, specify a template for acquiring exclusive locks. For example, the following is defined for the Sybase_ASA database type:
```
${selectList}${intoClause}${fromClause} holdlock${whereClause}
```
Select With Update Lock (SQL Template) A template SQL statement for selecting rows and acquiring an exclusive lock. The configuration property name is selectWithUpdateLock. If your database server does not support exclusive locks, specify a template for acquiring shared locks. For example, the following is defined for the Sybase_ASA database type:
```
update ${mainTable} set ${touchColumn} = 
1 -${touchColumn}${fromClause}${whereClause};;
${selectList}${intoClause}${fromClause}${whereClause}
```
Serializable Select (SQL Template) A template SQL statement for selecting rows and acquiring a lock that ensures strict serializability, in terms of equivalence with serial schedules. For example, for a Sybase database:
```
${selectList}${intoClause}${fromClause} holdlock${whereClause}
```
. The configuration property name is serializableSelect.

Some databases do not provide the syntax to acquire this type of lock (for example, Oracle). Therefore, it is impossible to support the serializable persistent object isolation level for all database types.