How to set jdbc connection lifetime and timeout?

Question

I want to set jdbc connection lifetime and lifespan how do i do it.

I tried using properties.

Properties info = new properties();
info.put(user,"username");
info.put(password,"password");
info.put(connection lifetime, 0);


DriverManager.getConnection(server,info)

But this didn't work please help.

maybe related http://stackoverflow.com/questions/1683949/connection-timeout-for-drivermanager-getconnection — rbntd, Oct 27 '16 at 11:12
The lifetime is not getting set it connection lifetime is still about 15minutes — Rahul Singh, Oct 27 '16 at 11:13

score 0 · Answer 1 · edited May 23 '17 at 10:30

0

Try this:

info.setProperty(OracleConnection.CONNECTION_PROPERTY_THIN_NET_CONNECT_TIMEOUT, "2000");

Reference: Setting Network Timeout for JDBC connection

Note that not all JDBC JARs support setting a timeout this way. Sometimes you have to do it programatically.

edited May 23 '17 at 10:30

Community

1
1

answered Oct 27 '16 at 11:14

Tim Biegeleisen

502,043
27
286
360

@RahulSingh Can you configure this from Oracle? This doesn't seem like a Java problem. – Tim Biegeleisen Oct 27 '16 at 11:20
I want to keep it open forever the same connection i donot want to use connection pooling – Rahul Singh Oct 27 '16 at 11:22
That sounds like a really bad idea. If Java drops the connection, scrap it and return it to the pool. – Tim Biegeleisen Oct 27 '16 at 11:24
But is that possible? – Rahul Singh Oct 27 '16 at 11:24
I'm not certain, read here: https://docs.oracle.com/cd/B28359_01/java.111/e10788/optimize.htm#CFHHCICE – Tim Biegeleisen Oct 27 '16 at 11:28
This is for the connection pool stream where as i want for a single connection object – Rahul Singh Oct 27 '16 at 11:30

How to set jdbc connection lifetime and timeout?

1 Answers1