Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Added information about JDBC 3 and Tomcat 8

...

  1. Is it safe to use JDBC-ODBC bridge in production environment?
  2. How to use Orache thin driver?
  3. How to use JDBC 3 driver with Tomcat 8?

Answers

Anchor
Q1
Q1

Is it safe to use JDBC-ODBC bridge in production environment?

...

If you use the oracle thin driver, be sure to rename it to a jar file from a zip file. Tomcat only auto-magically loads files ending in .jar placed in a lib directory. It ignores all other file extensions.

Anchor
Q3
Q3

How to use JDBC 3 driver with Tomcat 8 / DBCP 2?

One of the connection pool implementations in Tomcat 8 is DBCP 2, and DBCP 2 calls Connection.isValid(int) method when no validationQuery is specified. IsValid(int) method is introduced with JDBC 4. If you must use JDBC 3 driver with Tomcat 8 / DBCP 2, make sure that you specify validationQuery attribute in pool configuration.

...

CategoryFAQ