Connection cannot be cast to oracle.jdbc.OracleConnection

by

The connection you are retrieving is probably a wrapped connection.

If you really need to get the underlying Oracle connection you should use:

if (connection.isWrapperFor(OracleConnection.class)){
   OracleConnection oracleConnection= connection.unwrap(OracleConnection.class);  
}else{
   // recover, not an oracle connection
}

The isWrapperFor and unwrap methods are available since Java 1.6, and should be meaningfully implemented by the A/S connection wrappers.

More Related Contents:

  1. having an exception when saving oracle type object in some entity
  2. java.sql.SQLException: – ORA-01000: maximum open cursors exceeded
  3. Using setDate in PreparedStatement
  4. Why do I get java.lang.AbstractMethodError when trying to load a blob in the db?
  5. How to call oracle stored procedure which include user-defined type in java?
  6. java.sql.SQLException: Exhausted Resultset
  7. Getting Database connection in pure JPA setup
  8. How to enable logging for SQL statements when using JDBC
  9. Difference between Oracle jdbc driver classes?
  10. Getting output from dbms_output.get_lines using JDBC
  11. JDBC ResultSet get columns with table alias
  12. How to call Oracle Function or Procedure using Hibernate (EntityManager) or JPA
  13. Hibernate could not fetch the SequenceInformation from the database
  14. Need to reset the value of sequence in Oracle
  15. Getting an exception ORA-00942: table or view does not exist – when inserting into an existing table
  16. How to call an Oracle function from Hibernate with a return parameter?
  17. Adding jdbc driver to classpath
  18. Call an Oracle function from Java
  19. ojdbc14.jar vs. ojdbc6.jar
  20. SQL Error: 0, SQLState: 08S01 Communications link failure [duplicate]
  21. Configure hibernate to connect to database via JNDI Datasource
  22. Hibernate Criteria for Dates
  23. Oracle’s RETURNING INTO usage in Java (JDBC, Prepared Statement)
  24. Hibernate native query – char(3) column
  25. Oracle JDBC : invalid username/password (ora-01017)
  26. Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]
  27. PreparedStatement and setTimestamp in oracle jdbc
  28. The Network Adapter could not establish the connection when connecting with Oracle DB
  29. How to get jdbc connection from hibernate session? [duplicate]
  30. Getting Hibernate and SQL Server to play nice with VARCHAR and NVARCHAR

Leave a Comment