Informix Error -79748: Can't lock the connection.
Cause and resolution
Can't lock the connection.
Informix JDBC Driver Driver normally locks the connection object just before beginning the data exchange with the database server. The driver could not obtain the lock.
Only one thread at a time should use the connection object.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-79748 fires when the driver can't obtain the connection object's lock — per the official guidance, the driver normally locks the connection just before starting data exchange with the server.
- Concurrent use of the same connection object from more than one thread, per the official guidance — the direct, only cause; only one thread at a time should use a connection object.
Solutions / Resolution
- Restrict the connection object to one thread at a time, per the official guidance.
Examples
N/A
No specific triggering statement is documented beyond a failed connection-lock attempt.
Diagnostic Checks
- Check the program for concurrent thread access to the same connection object, and serialize access or use separate connections per thread.
Related Errors / Related Topics
No closely related error codes are cross-referenced for -79748 in this set yet.
The driver couldn't lock the connection, likely due to concurrent thread access — restrict the connection to one thread at a time.