AS400JDBCDriver connection timeout

[jem122974]

How can I set the timeout limit? I would like the database connections to timeout if they are inactive for say 1/2 hour. I'm not even sure what the default is.

Thank you,
Jon Mitchell

 

[Diancecht]

AFAIK, it's the database who controls the connection inactivity timeout.

Cheers,
Dian

 

[jem122974]

Hmmm... You are probably right. I was just hoping there as a way I could change it for just my application and not for all database connections.

 

[Diancecht]

Well, there's a way to set a inactivity timeout smaller than the database one.

The idea would be a class that manages all database accesses. The class would open the connection and set a timestamp for the last access. Then, another class in another thread would wait for the specified timeout and would close the connection.

But, IMHO, this is not an application issue. In fact, if you use an application server, you can define a timeout for each kind of connection.

Cheers,
Dian

 

[jem122974]

Interesting thought, Dian. In fact I am using an application server - Glassfish. Can I do something in the web.xml? If you could just point me in the right direction I'd appreciate it.