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