manifoldcf-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Karl Wright <daddy...@gmail.com>
Subject Re: Re: Manifold and Oracle RAC
Date Mon, 11 Nov 2013 14:14:18 GMT
Hi Marcello,

If you want this functionality supported, please create a ticket.

Karl


On Mon, Nov 11, 2013 at 9:11 AM, Marcello Lorenzi <mlorenzi@sorint.it>wrote:

>  Hi Karl,
> when you set a connection string into an application server with
> ojdbc6.jar, you can use a connection pool like the string reported below:
>
> url="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))))"
> commit-record-table-name=""/>
>
> It's a normal connection pool where you can balance the requests and have
> an H/A configuration between the RAC nodes.
>
> Marcello
>
> Replies:
>
>
>  Hi Marcello,
>
> The capabilities of the JDBC connector when used against Oracle are
> completely determined by the capabilities of the Oracle JDBC driver.� This
> may have changed, but when I last checked there was only one server per
> JDBC connection in the Oracle JDBC implementation.
>
> If you think there has been a change that we don't know about, please post
> the details.
>
>  Thanks,
> Karl
>
>
> On Mon, Nov 11, 2013 at 8:28 AM, Marcello Lorenzi <mlorenzi@sorint.it>wrote:
> Hi All,
> I have implemented some jobs on my Manifold Web console instance to
> retrieve some contents on a database hosted on Oracle RAC solution. I
> noticed that on the repository connection panel there isn't way to set more
> than one server for the connection.
>
> Is it possible to configure more than one server into this panel
> (separated by comma)?
>
> Thanks,
> Marcello
>
>

Mime
View raw message