[CONNECTORS-808] Manifold web vs Oracle RAC

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: ManifoldCF 1.2
• Fix Version/s: ManifoldCF 1.5
• Component/s: JDBC connector

Environment

CentOS 6.4 with Apache Tomcat 8.0 and OpenJDK 1.7

• Assignee: Karl Wright
• Reporter: Marcello Lorenzi
• Created: 11/Nov/13 17:53
• Updated: 11/Nov/13 22:17
• Resolved: 11/Nov/13 22:17

Description

Hi,
on Manifold CF 1.2 web console, it isn't possible to set a connection pool for Oracle Database connector when you configure a Output Connection, although you put the latest version of ojdbc6.jar into the Tomcat classpath.

It's needed to have the possibility to configure a connection pool for instance:
"jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=rac01)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=rac02)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=rac03)(PORT=1521))(LOAD_BALANCE=yes)(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=test)(FAILOVER_MODE=(TYPE=select)(METHOD=session)(RETRIES=3)(DELAY=10))))"

This configuration permits high availability and redundancy into the connection to Oracle RAC database.

Issue Links

• is duplicated by: CONNECTORS-809 Manifold web vs Oracle RAC