Oracle 11 DRCP and ODAC Pooling
Posted: Thu 21 Jun 2012 15:23
Hello,
I am trying to use ODAC's pooling with Oracle 11 Database Resident Connection Pooling (DRCP).
I am setting up my TOraSession like this:
and I have a "ConnectionLost" event like this:
The problem is that when connection times out, there is an infinite loop because the reconnnect attempt fails. The SessionConnectionLost proc just gets called again and again. ConnLostCause is always clExecute. When it tries to reconnect, an "ORA-24416: Invalid session Poolname was specified." is thrown and the loop continues.
Does ODAC support DRCP or am I doing something wrong?
Thanks,
John
I am trying to use ODAC's pooling with Oracle 11 Database Resident Connection Pooling (DRCP).
I am setting up my TOraSession like this:
Code: Select all
Session.Pooling := True;
Session.PoolingOptions.PoolType := optOCI;
Session.Server := '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=....)(PORT=1521))(CONNECT_DATA=(SERVER=POOLED)(SERVICE_NAME=...)))';
Code: Select all
procedure TMainForm.SessionConnectionLost(Sender: TObject; Component: TComponent;
ConnLostCause: TConnLostCause; var RetryMode: TRetryMode);
begin
Case ConnLostCause of
clExecute,
clOpen,
clRefresh,
clApply,
clServiceQuery,
clTransStart,
clConnectionApply: RetryMode := rmReconnectExecute;
clConnect, clUnknown: RetryMode := rmReconnect;
end;
end;
Does ODAC support DRCP or am I doing something wrong?
Thanks,
John