FAQs: WebLogic jDriver for Informix

 

• How do I use multibyte character sets with WebLogic jDriver for Informix?

• How do I allow multiuser access to my Informix database?

How do I use multibyte character sets with WebLogic jDriver for Informix?

Currently, multibyte character sets are not supported for the WebLogic jDriver for Informix driver. Support may be added in a future release. For more information, read about codeset support in Using WebLogic jDriver for Informix.

How do I allow multiuser access to my Informix database?

If you get errors 271(Could not insert new row into the table) and 243 (Could not position within a table table-name) when running a multiuser application using the WebLogic jDriver for Informix driver, first, confirm that your table file is not corrupted or truncated by using the bcheck or secheck utilities. If you have verified the file's integrity, then the most likely cause of your problem is that you have locked your table file or a record within the table. This is a normal event in multi user programs; generally you can recover by rolling back the current transaction, waiting a short time, and then re-executing the transaction. Here are some specific recovery procedures:

For interactive SQL, redo the operation.

• For C-ISAM programs, review the program logic and make sure that it can handle this situation. You can obtain exclusive access to a table by passing the ISEXCLLOCK flag to ISOPEN.

• For SQL programs, review the program logic and make sure that it can handle this situation. Use the statement SET LOCK MODE TO WAIT. For bulk updates, see the LOCK TABLE statement and the EXCLUSIVE clause of the DATABASE statement.