Weblogic JDBC datasource,java.sql.SQLException: Cannot obtain XAConnection weblogic.common.resourcep
- by gauravkarnatak
I am using weblogic JDBC datasource and my DB is oracle 10g,below is the configuration.
It used to work fine but suddenly it started giving problem,please see below exception.
Weblogic JDBC
datasource,java.sql.SQLException:
Cannot obtain XAConnection
weblogic.common.resourcepool.ResourceLimitException:
No resources currently available in
pool
<?xml version="1.0" encoding="UTF-8"?> <jdbc-data-source
xmlns="http://www.bea.com/ns/weblogic/90"
xmlns:sec="http://www.bea.com/ns/weblogic/90/security"
xmlns:wls="http://www.bea.com/ns/weblogic/90/security/wls"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.bea.com/ns/weblogic/920
http://www.bea.com/ns/weblogic/920.xsd"
XL-Reference-DS
jdbc:oracle:oci:@abc.COM
oracle.jdbc.driver.OracleDriver
user
DEV_260908
password
password
dll
ocijdbc10
protocol
oci
oracle.jdbc.V8Compatible
true
baseDriverClass
oracle.jdbc.driver.OracleDriver
1
100
1
true
SQL SELECT 1 FROM DUAL
DataJndi
OnePhaseCommit
This exception is coming on dev environment where connected user is only one.
I know, this is related to pool max size but I also suspect this could be due to oracle,might be oracle isn't able to create connections.
below are my queries
Is there any debug/logging parameter to enable datasource logging,so that I can check no of connections acquired,released and unused in logs ?
How to check oracle connection limit for a particular user ?