Connection timeout for DriverManager getConnection

by

You can set the Timeout on the DriverManager like this:

 DriverManager.setLoginTimeout(10);
 Connection c = DriverManager.getConnection(url, username, password);

Which would imply that if the connection cannot open within the given time that it times out.

In terms of keeping a connection open forever, it is possible if you do not close the connection but it may not be a good idea. Connections should be closed as soon as you are finished with them.

If you want to optimise the opening and closing of connections then you can use a connection pool.

More Related Contents:

  1. having an exception when saving oracle type object in some entity
  2. Is java.sql.Timestamp timezone specific?
  3. java.sql.SQLException: – ORA-01000: maximum open cursors exceeded
  4. Using setDate in PreparedStatement
  5. How to connect to Oracle using Service Name instead of SID
  6. Where’s my invalid character (ORA-00911)
  7. Why do I get java.lang.AbstractMethodError when trying to load a blob in the db?
  8. How to call oracle stored procedure which include user-defined type in java?
  9. java.sql.SQLException: Exhausted Resultset
  10. How to enable logging for SQL statements when using JDBC
  11. Difference between Oracle jdbc driver classes?
  12. PLSQL JDBC: How to get last row ID?
  13. Oracle JDBC intermittent Connection Issue
  14. Getting output from dbms_output.get_lines using JDBC
  15. JDBC ResultSet get columns with table alias
  16. How to write / update Oracle blob in a reliable way?
  17. Setting Network Timeout for JDBC connection
  18. Getting an exception ORA-00942: table or view does not exist – when inserting into an existing table
  19. Java JDBC – How to connect to Oracle using tnsnames.ora
  20. Call an Oracle function from Java
  21. Cannot use a LIKE query in a JDBC PreparedStatement?
  22. ojdbc14.jar vs. ojdbc6.jar
  23. When my app loses connection, how should I recover it?
  24. com.mysql.jdbc.PacketTooBigException
  25. Oracle’s RETURNING INTO usage in Java (JDBC, Prepared Statement)
  26. Connection cannot be cast to oracle.jdbc.OracleConnection
  27. Oracle JDBC : invalid username/password (ora-01017)
  28. PreparedStatement and setTimestamp in oracle jdbc
  29. The Network Adapter could not establish the connection when connecting with Oracle DB
  30. Iterating a ResultSet using the JDBC for Oracle takes a lot of time about 16s?

Leave a Comment