Setting Network Timeout for JDBC connection

by

setNetworkTimeout() was introduced in JDBC 4.1 and was not present in JDBC 4.0.

You will want ojdbc7 since JDBC 4.1 only came in with Java 7 if you want to use setNetworkTimeout() method.

The underlying issue is that adding methods to interfaces in later specifications can cause older implementations of those interfaces to break with errors. One of the new features of the upcoming Java 8, default methods, will hopefully make this slightly less of a problem.

Apparently there is also a JDBC driver property for Oracle that can modify socket timeouts.

You can also try using this Oracle JDBC property to set the socket timeout if you are using the thin driver:

Properties props = new Properties();
props.setProperty("user", "dbuser");
props.setProperty("password", "dbpassword");
props.setProperty(OracleConnection.CONNECTION_PROPERTY_THIN_NET_CONNECT_TIMEOUT, "2000");

Connection con = DriverManager.getConnection("<JDBC connection string>", props);

More Related Contents:

  1. having an exception when saving oracle type object in some entity
  2. Is java.sql.Timestamp timezone specific?
  3. Using setDate in PreparedStatement
  4. How to connect to Oracle using Service Name instead of SID
  5. Is it possible to specify the schema when connecting to postgres with JDBC?
  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. java.sql.SQLException: Exhausted Resultset
  9. How to get all table names from a database?
  10. How to get a value from the last inserted row? [duplicate]
  11. How to enable logging for SQL statements when using JDBC
  12. Difference between Oracle jdbc driver classes?
  13. PLSQL JDBC: How to get last row ID?
  14. How is driver class located in JDBC4
  15. Getting output from dbms_output.get_lines using JDBC
  16. JDBC ResultSet get columns with table alias
  17. How to write / update Oracle blob in a reliable way?
  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. how to get list of Databases “Schema” names of MySql using java JDBC
  21. Call an Oracle function from Java
  22. How to simulate a DB for testing (Java)?
  23. Cannot use a LIKE query in a JDBC PreparedStatement?
  24. how to copy data from file to PostgreSQL using JDBC?
  25. Does a ResultSet load all data into memory or only when requested?
  26. Connection timeout for DriverManager getConnection
  27. How do I unit test jdbc code in java? [closed]
  28. Oracle JDBC : invalid username/password (ora-01017)
  29. PreparedStatement and setTimestamp in oracle jdbc
  30. Iterating a ResultSet using the JDBC for Oracle takes a lot of time about 16s?

Leave a Comment