Is there any way to have the JBoss connection pool reconnect to Oracle when connections go bad?

by

Whilst you can use the old “select 1 from dual” trick, the downside with this is that it issues an extra query each and every time you borrow a connection from the pool. For high volumes, this is wasteful.

JBoss provides a special connection validator which should be used for Oracle:

<valid-connection-checker-class-name>
    org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker
</valid-connection-checker-class-name>

This makes use of the proprietary ping() method on the Oracle JDBC Connection class, and uses the driver’s underlying networking code to determine if the connection is still alive.

However, it’s still wasteful to run this each and every time a connection is borrowed, so you may want to use the facility where a background thread checks the connections in the pool, and silently discards the dead ones. This is much more efficient, but means that if the connections do go dead, any attempt to use them before the background thread runs its check will fail.

See the wiki docs for how to configure the background checking (look for background-validation-millis).

More Related Contents:

  1. HikariCP: What database level timeouts should be considered to set maxLifetime for Oracle 11g
  2. ANYONE CAN TELL ME THAT WHY THIS CODE IS GIVING ME AN ERROR OF TABLE OT CLUSTER KEY WORD IS MISSING? [closed]
  3. How are dates stored in Oracle?
  4. How do I escape a reserved word in Oracle?
  5. How to put more than 1000 values into an Oracle IN clause [duplicate]
  6. ORA-30926: unable to get a stable set of rows in the source tables
  7. ORA-12514 TNS:listener does not currently know of service requested in connect descriptor
  8. Fetch Oracle table type from stored procedure using JDBC
  9. TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
  10. “Safe” TO_NUMBER()
  11. When or Why to use a “SET DEFINE OFF” in Oracle Database
  12. error: ORA-65096: invalid common user or role name in oracle
  13. Oracle insert if not exists statement
  14. Error : ORA-01704: string literal too long
  15. Oracle client ORA-12541: TNS:no listener [closed]
  16. Does Oracle have an equivalent of SQL Server’s table variables?
  17. Create an Excel Spreadsheet from a Oracle Database
  18. How do I turn off Oracle password expiration?
  19. ORACLE IIF Statement
  20. Table-Valued Functions in ORACLE 11g ? ( parameterized views )
  21. Oracle date difference to get number of years
  22. How to increase performance for bulk INSERTs to ODBC linked tables in Access?
  23. Oracle Age calculation from Date of birth and Today
  24. Oracle: how to add minutes to a timestamp?
  25. How to drop multiple interval partitions based on date?
  26. ORA-01830: date format picture ends before converting entire input string / Select sum where date query
  27. How to call an Oracle function with a Ref Cursor as Out-parameter from C#?
  28. How to Register Pluggable Database(PDB) with new created LISTENER
  29. Grant Select on all Tables Owned By Specific User
  30. ORA-12704: character set mismatch

Leave a Comment