How to modify SELECT LOB_TIMEOUT

[Sandro Mosdzinski]

The default value of SELECT LOB_TIMEOUT is 30000. I want to increase the timeout. Does anyone know how to do it?

[Evgenij Ryazanov]

Hello.

You can add ;LOB_TIMEOUT=your_value to JDBC URL.

[Sandro Mosdzinski]

Hi,

I want to change the timeout only for using the H2 console. So I think I have to adapt the command in the h2.bat. At the moment the command is

@java -cp "h2-1.4.200.jar;%H2DRIVERS%;%CLASSPATH%" org.h2.tools.Console %*
@if errorlevel 1 pause

How do I have do modify the command to set the timeout

[Evgenij Ryazanov]

You cannot specify any connection options in this file.

You need to change JDBC URL in Login window of H2 Console itself.

[Sandro Mosdzinski]

I set LOB_TIMEOUT to 3600000 and expected the console to hold the connection for 1 hour. But I tried to run a SQL command 30 minutes after starting the h2 console and the connection was lost. Did I set the wrong parameter?

[Evgenij Ryazanov]

Yes, this setting is not related to timeout of web sessions.

You need

java -Dh2.consoleTimeout=3600000 …

[Sandro Mosdzinski]

Would the timeout counter be resetted if I execute a new sql?

[Evgenij Ryazanov]

Yes, execution of any SQL command and also actions on toolbar (refresh, commit, rollback, command history, etc.) reset the timeout.

[Sandro Mosdzinski]

Thank you very much Evgenij for you quick support