JDBC/ESQL
The following tips are applicable to JDBC so they affect both Database Bridge and ESQL.
Driver configuration
• If you're working on Microsoft SQL Server with either the official driver (sqljdbc.jar) or JTDS, then add the JDBC option sendStringParametersAsUnicode=false to your connection URL. Example:
iscobol.jdbc.url=jdbc:sqlserver://localhost:1433\SQLEXPRESS;databasename=master;sendStringParametersAsUnicode=false |
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.