How to set by code the SQLLockWaitTimeout parameter for a gi

Posted by bmerlet90 on 11-Sep-2018 02:30

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?

Posted by steve pittman on 11-Sep-2018 11:45

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

Posted by steve pittman on 11-Sep-2018 11:45

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

This thread is closed