Skip Headers

# Using Java

Previous

Next

To enable parameterized SQL and prepared statement caching for all queries, configure at the `Login` level, as Example: Parameterized SQL and Binding at the Login Level shows. For more information, see "Parameterized SQL (Binding) and Prepared Statement Caching".

Parameterized SQL and Binding at the Login Level

    databaseLogin.bindAllParameters();
    databaseLogin.cacheAllStatements();
    databaseLogin.setStatementCacheSize(100);

To enable JDBC batch writing, use `Login` method `useBatchWriting` as Example: Using JDBC Batch Writing shows:

Using JDBC Batch Writing

    project.getLogin().useBatchWriting();
    project.getLogin().bindAllParameters();
    project.getLogin().setMaxBatchWritingSize(100);