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?
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
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