Configuring JDBC Data Sources. JDBC Connection Pool disabling itself. Hi, During our stress performance test of OSB 10.3g we experience that the JDBC Connection Pool can disable itself, if many statement executions ends in some kind of exceptions (like TimoutException). As i understand this "disabling" is normal behavior, and eventually it will enable itself again after some time (we have seen this as taking ~10 mins. on an idle environment). In the downtime of the JDBC pool we see a ResourceDisabledException for all JDBC executions on that pool. Since our application correctly handles these exceptions under the XA scope, we would rather disable this "disabling behavior" and have the high availability instead, so the system is online at all time...
So my question is; is it possible to switch off this "JDBC Connection Pool disabling"? Searching the forum leads to some hints on older WLS 8sp4 where an "CountOfRefreshFailuresTillDisable" could be used, but is this option still supported or are there others ways to do it? ---- My DataSource ---- <? Optimize & Tuning JDBC Data Source Connection Pool. JDBC Tips. XA Transactions. Most developers have at least heard of XA, which describes the standard protocol that allows coordination, commitment, and recovery between transaction managers and resource managers. Products such as CICS, Tuxedo, and even BEA WebLogic Server act as transaction managers, coordinating transactions across different resource managers.
Typical XA resources are databases, messaging queuing products such as JMS or WebSphere MQ, mainframe applications, ERP packages, or anything else that can be coordinated with the transaction manager. XA is used to coordinate what is commonly called a two-phase commit (2PC) transaction. The classic example of a 2PC transaction is when two different databases need to be updated atomically.
Most people think of something like a bank that has one database for savings accounts and a different one for checking accounts. The problem is that most developers think, "Well, my application uses only one database, so I don't need to use XA on that database. "