Weblogic JDBC datasource provides "No resources currently available in the pool" with one active connection

Question

I am using weblogic JDBC datasource, and my DB is Oracle 10g, below is the configuration.

It worked fine, but suddenly it started giving problems, see exception below.

Weblogic JDBC DataSource, java.sql.SQLException: Unable to get XAConnection weblogic.common.resourcepool.ResourceLimitException: Resources currently available in the 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: OKI: @ abc.COM oracle.jdbc.driver.OracleDriver user DEV_260908 password dll password ocijdbc10 OCI protocol oracle.jdbc.V8Compatible true baseDriverClass oracle.jdbc.driver.OracleDriver               
    1 100 1 true SQL SELECT 1 FROM DUAL

    DataJndi OnePhaseCommit

This exception occurs in a dev environment where there is only one connected user.

I know that this is due to the maximum pool size, but I also suspect that it might be due to Oracle, maybe Oracle cannot create connections.

My questions:

• Is there any debug / logging option to enable data logging so that I can check the number of connections received, issued, and unused in the logs?
• How can I check the oracle connection restriction for a specific user?

Answer 1

, - , , , , JDBC max. , Oracle, ORA, .

WebLogic; - > JDBC- > , . ; environment- > , JDBC . . , , , .

Oracle , show parameters sessions, show parameters processes, ( , pmon). , - select count(*) from v$session where username = 'DEV_260908';. , , /, .

Answer 2

weblogic . , .

, !

Answer 3

WebLogic ServerTransactionTimeout.

• :