How to set by code the SQLLockWaitTimeout parameter for a given JDBC connection - Forum - OpenEdge General - Progress Community

How to set by code the SQLLockWaitTimeout parameter for a given JDBC connection

 Forum

How to set by code the SQLLockWaitTimeout parameter for a given JDBC connection

This question is answered

KBase says we can set an OS env variable PROSQL_LOCKWAIT_TIMEOUT to alter the default lock wait time out of a JDBC client  (default seems to be of 5 seconds).

The official doc (https://documentation.progress.com/output/OpenEdge117/pdfs/dpspr/dpspr.pdf) mentions a SQLLockWaitTimeout  startup param that seems to be a Database Server startup param, that may define the default for all client.

 

I would like to find a way todefine that setting in my java code to alter some connection. Any suggestions?

Verified Answer
  • In your Java code, when getting your connection to the OE server, in the string containing  your URL,  append a string like this:    ";lockWaitTimeout=60"

    That is, this "connection property" will then be in the same string containing the URL.

    The ";" separates the URL from the "connection properties" that follow.

    hope this helps,          ...steve pittman

All Replies
  • In your Java code, when getting your connection to the OE server, in the string containing  your URL,  append a string like this:    ";lockWaitTimeout=60"

    That is, this "connection property" will then be in the same string containing the URL.

    The ";" separates the URL from the "connection properties" that follow.

    hope this helps,          ...steve pittman