refresh, reopen error

[AlexP]

In the latest ODAC versions, on an attempt to insert equal values to a unique field, both in Direct and OCI modes, a correct error message is displayed.

[Valgardur]

(After monitoring, debugging whenever I found time..- DB monitor offers no information, and Delphi's debugger does not catch anything)

My best guess is that the database connection gets lost, but OnConnectionLost event is not triggered.

At least, calling "refresh" every 15 minutes seems to be enough to avoid this..

But not an acceptable solution.

[AlexP]

Please check whether the EXPIRE_TIME parameter is set on your server (in the sqlnet.ora file) and to what value.

[Valgardur]

I'll ask the DB admin, I don't have access to this..

But why would that make a difference? This problem did occur in ODAC version 9.5.18 with Delphi XE8.. building in 9.4.14 and Delphi XE2 solved this and this was never a problem... I have been using ODAC in this environment for years.

[AlexP]

We have encountered a problem in the latest ODAC version when using EXPIRE_TIME, and are now fixing this behavior. If you use this parameter, then the problem is most likely the same. So please check server settings, and if the parameter is used, we will send you a fixed build as soon as we fix the issue.

[Valgardur]

Hi, it was set to 15 minutes on our production database, but not set in our test or development database, explaining why it was difficult to replicate..

[AlexP]

We have already fixed the problem, and we can send you a night build in order for you to check this case on your sample. For this, please send your license number to alexp*devart*com .

[Valgardur]

thanks, I already circumvented this by having a timer that calls the database, I could not possibly have waited this long.. so for now, I will just wait for the build... I'll send my license number anyway

[AlexP]

Thank you. I have received your letter. Your subscription is active. Please specify the IDE version - and I will send you a fixed version.

[Valgardur]

Thanks, Delphi 10 Seattle

[AlexP]

I have sent you a link to the fixed version via email.

[Valgardur]

great thanks

[AlexP]

Please let us know whether the problem is solved in the version we sent you.

[Valgardur]

No, as I explained in an e-mail I got serious error message when opening Delphi after installing.

[AlexP]

I have received your email. Such error may occur if you haven't removed the previous version of ODAC completely or if you have the other DAC products installed.