ODAC 11.3.1 - TSmartquery freezes on 2nd Insert

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
heidenbluth
Posts: 51
Joined: Mon 08 Nov 2004 19:01
Location: Germany

ODAC 11.3.1 - TSmartquery freezes on 2nd Insert

Post by heidenbluth » Thu 03 Sep 2020 19:28

If you change some options as described below, a TSmartQuery component freezes when inserting two records.

Create a new VCL application and place the following components on the main form and connect them with each other
  • TOraSession
  • TConnectDialog
  • TSmartQuery
  • TOraDataSource
  • TDbGrid
  • TDbNavigator
  • TButton
Implement the OnClick method of the button as follows

Code: Select all

  OraSession.Options.StatementCache := True;
  OraSession.Options.EnableLargeint := True;
  OraSession.Options.EnableNumbers := True;
  OraSession.Options.UnicodeEnvironment := True;
  OraSession.Options.UseUnicode := True;
  OraSession.Connect;
  SmartQuery.DMLRefresh := True;
  SmartQuery.Options.ReturnParams := True;
  SmartQuery.KeyFields := 'COUNTRY_ID';
  SmartQuery.SQL.Text := 'SELECT COUNTRY_ID, COUNTRY_NAME, REGION_ID FROM COUNTRIES';

  SmartQuery.Options.CacheCalcFields := True;
  SmartQuery.Options.CacheLobs := True;
  SmartQuery.Options.DefaultValues := True;
  SmartQuery.Options.DeferredLobRead := True;
  SmartQuery.Options.StatementCache := True;
  SmartQuery.Active := True;
Now, run the application and
  • Click the button, connect to the HR sample schema
  • On the navigator, click the "+" button, enter some sample data into the data grid record, and post changes
  • On the navigator, click again the "+" button, enter some other sample data, and post changes
  • Now the application freezes.
I sent you a sample project using the contact form earlier this week and attached a sample project, but did not yet get an answer. I am afraid you did not get it.

MaximG
Devart Team
Posts: 1472
Joined: Mon 06 Jul 2015 11:34

Re: ODAC 11.3.1 - TSmartquery freezes on 2nd Insert

Post by MaximG » Fri 04 Sep 2020 15:41

We've successfully tested ODAC according to your description. Unfortunately, we haven't received any example from you. Could you send it to us again using the e-support form (https://www.devart.com/company/contactform.html) ?

heidenbluth
Posts: 51
Joined: Mon 08 Nov 2004 19:01
Location: Germany

Re: ODAC 11.3.1 - TSmartquery freezes on 2nd Insert

Post by heidenbluth » Sun 06 Sep 2020 08:47

Sample application has been sent again using contact form.

MaximG
Devart Team
Posts: 1472
Joined: Mon 06 Jul 2015 11:34

Re: ODAC 11.3.1 - TSmartquery freezes on 2nd Insert

Post by MaximG » Tue 08 Sep 2020 14:31

Thank you for the information. We have reproduced the issue and will investigate its origin. We will inform you about the results shortly.

Post Reply