Zeoslib Portal

Bugtracker ticket created.

I know, it was not my intention to hijack the topic. I just got happy as it MIGHT have been the solution to one of mine but yeah, that's not the case. An obfuscated dump was created and "published" and as I promised I DMed you and Jan with the details. The offer for a beer is still valid! ...

I can confirm that the large dataset + lcmOnLoad issue is 64-bit related too; issue does not appear if I make a 32-bit version of my program. It is NOT ASLR-related though, as the issue pops up ever if ASLR is turned off in linking.

Codepage UTF16 is broken on 32 and 64 bit as well.

Welcome to the club. Even with the dumps at hand I can not find the source of the "User requested abort of operation" error with string fields if LobCacheMode is onLoad.

There's definetly something wrong with Oracle's buffer size calculation.

Well, both of us are right. You are right that there might be more to preparation than just setting up internal properties. But, this preparation takes place automatically, somewhere else and not at the Query component. You can verify this; TZQuery.Prepare actually leads you to ZAbstractRODataSet.pa...

I think preparing a statement is mostly an internal thing. What it does is it basically creates the actual SQL query which will be executed and created the internal statement object. This can be done without talking to the RDBMS system. As far as I know there is no client-side parsing done in Zeos, ...

Hello,

I made some minor changes so Zeos compiles without errors and warnings. Pull request is available on GitHub as usual :)

Happy new year!

Hello and welcome to the forum! As far as I recall I saw array type in parameter values but I'm not sure if any protocols acutally support that. You can give that a try, that would be the best soltuion. What should work however is multiple parameters, like SELECT * FROM MyTable WHERE MyField IN (:pP...

Hello, I'm not sure how a failed execution can cause a deadlock. Are you sure it's a deadlock, or simply the OnClose event is interrupted by the exception and therefore your form never coses...? I'd also reconsider the way how you are saving the data. If it takes only a second for your queries to ex...

So far all my attempts failed to pinpoint the root cause.

I guess they did change something between version 19 and later as the issue is still present in OCI 21.12.
LobCacheMode: OnLoad throws an instant nullpointer AV (at least in 64 bit) if the resultset has a CLOB field, even in AL32UTF8 codepage.

That modification is in the pull request as well. The "ZCompatibility." prefix mefore Max is included if NATIVEINT_WEAK_REFERENCE is defined.
Same had to be done in ZDbcOracleUtils : 1433, ZDbcInterbaseFirebirdMetaData : 2000 and ZAbstractRODataSet : 9417 as well.

Long story short, the issue is caused by the weak NativeInt alias introduced in Delphi 12 and the proposed solution is available as a pull request on GitHub :)

Hello,

Known issue, a hotfix is already on it's way.

More info here.

"INVALID VARIANT TYPE CAST" I think the issue won't be the identity column, but something else. Try to debug on which column it gives this error? We'll also need a table create script and a small program which the issue occurs on. I execute it with Tzquery.execsql and the value is updated...

If it works with the DCU location but not the source it means you didn't include all sorce folders in the library location: $(ZEOS)\src $(ZEOS)\src\component $(ZEOS)\src\core $(ZEOS)\src\dbc $(ZEOS)\src\parsesql $(ZEOS)\src\plain $(ZEOS)\src\webservice where $(ZEOS) is the root of your local Zeos co...