Problem with connectionPool configuration to Oracle
Hi
I am facing some problems with configuration of connectionPool with oracle.I am using J2EE app server 8.1.While configuring I am giving following details:
Datasource Classname:oracle.jdbc.pool.OracleConnectionPoolDataSource
Resource type: javax.sql.ConnectionPoolDataSource
PoolSettings,Connection Validation and Transaction Isolations settings are default.
In Prperties
DataSourceNameOracleConnectionPoolDataSource
ImplicitCachingEnabledfalse
NetworkProtocol tcp
FastConnectionFailoverEnabledfalse
LoginTimeout0
Passwordxxx
URLjdbc:oracle:thin:@localhost:1521:orcl (orcl is database name)
ConnectionCachingEnabledfalse
UserSYSTEM
ExplicitCachingEnabledfalse
PortNumber 0
MaxStatements0
ojdbc14.jar is placed in Appserver/lib directory and absolute path of this jar is added in classpath suffix in AppServer setting.
But when I ping the connection thru Appserver only , Iget following error
"Operation 'pingConnectionPool' failed in 'resources' Config Mbean. Target exception message: Access denied to execute this method : setConnectionCachingEnabled"
I dont understand what is the problem.
Please help me out....
Thanks a lot in advance
