JDBC/ESQL
The following tips are applicable to JDBC so they affect both DatabaseBridge and ESQL.
Driver configuration
• If you're working on Microsoft SQL Server with either the official driver from Microsoft or JTDS, then add the JDBC option sendStringParametersAsUnicode=false to your connection URL. Example:
iscobol.jdbc.url=jdbc:sqlserver://localhost:1433\\SQLEXPRESS;databasename=master;encrypt=false;sendStringParametersAsUnicode=false |
• While JTDS is discontinued, Microsoft continues to improve their driver. If you choose the Microsoft driver instead of JTDS, be sure to download and use the latest release of the driver.
SQL syntax
• If you’re working on Oracle, consider using Optimizer Hints in your queries in order to direct the optimizer to choose the best query execution plan.
• If you’re working on either MySQL or PostgreSQL, consider using the LIMIT clause in your queries in order to generate lighter cursors and save memory.