da-soft - Data Access Technologies

Additional

dbCAP

AnyDAC

ThinDAC

NCOCI8

Topic: ORA-01012 after connection iddle time

Forum List » AnyDAC » v 1.x General English

Radek
User

Fresh Boarder

Posts: 2

Karma: 0

ORA-01012 after connection iddle time

Posted: 2008/02/22 01:04

What Can i do with this Error how to log on or restart connection?

Oracle 10
AnyDac: 1.12.2

Post edited by: Radek, at: 2008/02/22 01:07

Diman

Admin

Posts: 1460

Karma: 18

Re:ORA-01012 after connection iddle time

Posted: 2008/02/22 01:21

Hello

You must close connection - ADConnection1.Close, then connect again.
1.12 cannot reconnect transparently. 2.0 works can reconnect transparently.

Regards,
Dmitry

Radek
User

Fresh Boarder

Posts: 2

Karma: 0

Re:ORA-01012 after connection iddle time

Posted: 2008/02/22 08:14

It's dosn't work I use pool manager

procedure TSrvPrj.CheckConnectionManager;
var
LDefCon: IADStanConnectionDef;
begin
ADManager.Close;

ADManager.ConnectionDefFileName:='AnyDac.ini';
LDefCon:= ADManager.ConnectionDefs.FindConnectionDef(DEF_CON_NAME);

if not assigned(LDefCon) then
begin
LDefCon:=ADManager.ConnectionDefs.AddConnectionDef;
LDefCon.Name:=DEF_CON_NAME;
end;
LDefCon.DriverID:='ORA';
LDefCon.Database:=FProgConfig.DBSid;
LDefCon.UserName:=FProgConfig.DBLogin;
LDefCon.Password:=FProgConfig.DBPassword;
LDefCon.Pooled:=True;
LDefCon.MarkPersistent;
LDefCon.Apply;
ADManager.Open;
end;

and I create New connection

FDBConnection:=TADConnection.Create(nil);
FDBCOnnection.ConnectionDefName:=DEF_CON_NAME;
FDBConnection.Connected:=True;

Diman

Admin

Posts: 1460

Karma: 18

Re:ORA-01012 after connection iddle time

Posted: 2008/02/22 08:40

Hello

1) 1.12 does not have standard / simple way to resolve this issue.

2) Today is released v 2.0. You can download Trial verison from there -
http://www.remobjects.com/trialdownloads.asp?id={4EEDCAF3-4225-4E1E-A94B-960CD6A739AF}

There you will need to set ResourceOptions.AutoConnRestore to True. Then after each getting connection from the pool, AnyDAC will ping the server. If connection is losted, then AnyDAC will restore it transparently.

If that will work for you, then contact me directly at darefiev@da-soft.com regarding next steps.

Regards,
Dmitry

Forum List » AnyDAC » v 1.x General English