I have following resource configuration for Oracle Data source Pool and trying 
to unwrap the connection object using:

OracleConnection conn = connection.unwrap(OracleConnection.class);

And getting following exception:

com.sun.proxy.$Proxy77.unwrap
exception : java.sql.SQLException: Not a wrapper of oracle.jdbc.OracleConnection

Anybody has any idea what is missing here?

<Resource name="jdbc/OracleDataSource"
              auth="Container"
              type="javax.sql.DataSource"
              factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
              driverClassName="oracle.jdbc.driver.OracleDriver"
              url="jdbc:oracle:thin:@(XYZ)"
              username="ABC"
              password="ABC"
              initialSize="10"
              maxActive="10"
              minIdle="10"
              maxIdle="10"
              maxWait="10000"
              timeBetweenEvictionRunsMillis="30000"
              minEvictableIdleTimeMillis="30000"
              testOnBorrow="true"
              validationQuery="select 1 from dual"
              validationInterval="30000"
              removeAbandoned="true"
              removeAbandonedTimeout="600"
              logAbandoned="true"
              testWhileIdle="false"
              testOnReturn="false"
              jmxEnabled="true"
              accessToUnderlyingConnectionAllowed="true"
              
jdbcInterceptors="org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer;org.apache.tomcat.jdbc.pool.interceptor.ResetAbandonedTimer"/>



Thanks,
Vishal

Reply via email to