Sun Java System Application Server 9.1 Developer's Guide

Restrictions and Optimizations

This section discusses restrictions and performance optimizations that affect using the JDBC API.

Disabling Stored Procedure Creation on Sybase

By default, DataDirect and Sun Java System JDBC drivers for Sybase databases create a stored procedure for each parameterized PreparedStatement. On the Application Server, exceptions are thrown when primary key identity generation is attempted. To disable the creation of these stored procedures, set the property PrepareMethod=direct.