Zeoslib Portal

It won't leak, it's an interface: private FDriversCS: TCriticalSection; // thread-safety for FDrivers collection. Not the drivers themselves! FLogCS: TCriticalSection; // thread-safety for logging listeners FDrivers: IZCollection; FLoggingListeners: IZCollection; FGarbageCollector: IZCollection;

Have you checked if your errors persist after disabling ASLR and rebuilding the entire ZEOS and application? I reproduced an issue in a 32-bit test application which is not affected by ASLR. Mark's right and it might be related to record field alignment - this can be easily confirmed by changing it...

Is this the record alignment we are talking about? RecordAlignment.PNG If this can be changed from project options it's not a bug, it was a decision by Embarcadero and we should use conditional directives to readjust our buffers accordingly - IF this is the only problem it is raising. In the mean ti...

If even special characters can be read back correctly after updating I'm wondering if it's an initial encoding issue.
What is the result of Field.AsBytes (I hope FPC has it...?)

Delphi 11.2 defaulted to the wrong DCP folder afaik which could be manually fixed (https://en.delphipraxis.net/topic/7434- ... ment=62811).

I had that issue fixed by hand, currently I'm on 11.3 where this was already fixed.

The problem is not the application - it's the data. From what I saw a large amount of VarChar fields in a large amount of records will trigger it however - the data I'm using for testing is however obfuscated it's still proprietary and might still resemble to real-world data... exporting and sharing...

Either MadExpect's buffer underrun / overrun protection does not work or FastMM's is faulty. First time in my life I tried FastMM with FullDebugMode and I'm getting popup after popup when connecting to an Oracle database using UTF16. That has nothing to do with the x64 issue we both discovered but y...

This won't fix the AV. I already tried with 10000 the size of the whole equation, still being thrown. Btw, I suspect that instead of multiplying by 2 here, ub4 has to be NativeUInt instead of Cardinal. Changing that requires changing half of Zeos, though (including other protocols) so I'm either uns...

Confirmed in viewtopic.php?f=50&t=179882 that this is indeed a x64 issue.

I can confirm, that building a 32bit application and using the 32 bit 21.7 oci.dll no AV and no "user requested..." exception is being raised when using LobCacheMode = lcmOnLoad when opening the exact same dataset.

I can see lcmOnLoad handled in TZOracleRowAccessor (which is created by TZOracleCachedResultSet) so I attempted to get rid of creating a native TZCachedResultSet in TZAbstractOracleStatement.CreateResultSet... no success. However, before receiving the "User requested to abort" exception, D...

Welcome to the club. Something is definitely not right with Oracle. https://zeoslib.sourceforge.io/viewtopic.php?f=37&t=175546 https://zeoslib.sourceforge.io/viewtopic.php?f=37&t=152220 https://zeoslib.sourceforge.io/viewtopic.php?f=37&t=137189 https://zeoslib.sourceforge.io/viewtopic.ph...

21.9 is also affected. EZSQLException was raised with the message SQL Error: ORA-01013: user requested cancel of current operation Code: 1013 SQL: OCILobClose Stack trace: 00d71152 MyApplication.exe ZDbcOracle 1388 TZOracleConnection.HandleErrorOrWarning 00d4468c MyApplication.exe ZDbcOracleResultSe...

Compiles just fine with 11.3 Alexandria.
Basic stuff (establishing a connection, executing SELECT queries) also successful on MySQL, MSSQL and Oracle.

I don't know if it actually worth it, but PK name can also be determined with a single join in imported, exported keys and cross reference. I included them just for the heck of it, but they always return 'PRIMARY' so idk :) If you wish to include it, it's in a new pull request . And now I stop with ...