Is Oracle 12 PoolDataSource supported in EAP
Issue
- Since we follow an SOA architecture, we have a lot of services running under JBoss that have a connections to an Oracle database in a pool.
- We have 100 services, which have quickly 500 Oracle connections.
- Oracle 12 proposes a PoolDataSource to solve this Sharing Pooled Servers Across Multiple Connection Pools
- Is this feature via a JBoss connection pool? Can it be possible if we can put the DRCP elements in the JBoss datasource definition?
- How can we specify the following java in JBoss /subsystem=datasources CLI?
Properties prop = new Properties();
PoolDataSource pds = PoolDataSourceFactory.getPoolDataSource();
prop.put("oracle.jdbc.DRCPConnectionClass", "HR-Pool1");
pds.setConnectionProperties(prop);
Environment
- Red Hat JBoss Enterprise Application Platform(EAP)
- 6.1.1
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.