Enable via ifxDataSource.setIfxStatementCacheSize(50); . Reduces parse time for repeated SQL.
Informix drivers offer several key features that make them an attractive choice for developers: informix driver
| SQLCODE | Meaning | Driver Action | |---------|---------|----------------| | -201 | Syntax error | Check SQL string, driver escaping | | -243 | Column not found | Verify metadata mapping | | -284 | Invalid character conversion | Set correct CLIENT_LOCALE | | -908 | Attempt to connect to database server failed | Check host/port/service name | | -931 | Cannot locate database server | Verify INFORMIXSQLHOSTS entry | Enable via ifxDataSource