Zeos 7.3 testers-thread

The offical for ZeosLib 7.3 Report problems, ask for help, post proposals for the new version of Zeoslib 7.3/v8
Quick Info:
-We made two new drivers: odbc(raw and unicode version) and oledb
-GUID domain/field-defined support for FB
-extended error infos of Firebird
-performance ups are still in queue
In future some more feature will arrive, so stay tuned and don't hassitate to help
miab3
Zeos Test Team
Zeos Test Team
Posts: 1310
Joined: 11.05.2012, 12:32
Location: Poland

Re: Zeos 7.3 testers-thread

Post by miab3 »

@EgonHugeist, @Jan, @Fr0sT, @mdaems, All

ZEOS 7.3.x svn 6461:

http://sourceforge.net/p/zeoslib/code-0 ... sting-7.3/

Compiles:

- Lazarus 2.0.8(fpc 3.0.4)-Win32,
- Lazarus 2.0.8(fpc 3.0.4)-Win64,
- Delphi 7,
- RAD Studio 2007-Win32/C++32 with small hpp fixes,
- RAD Studio XE2 -Win32/Win64/C++32 with small hpp fixes,
- Delphi 10.3.3 Rio-Win32/Win64/Android/Android64.

My mORMot PerfTest passes(Delphi 10.3.3 Rio Win32/Win64; D2007)

Michal
tkamphuis
Junior Boarder
Junior Boarder
Posts: 30
Joined: 18.01.2009, 09:20
Contact:

Re: Zeos 7.3 testers-thread

Post by tkamphuis »

I did a test with Zeos-7.3 rev 6462 on Lazarus 2.08 fpc 3.2.0 beta-4480 64 and I got a problem when compiling the package. I get the error:

Compile package zdbc 7.3: Exit code 1, Errors: 1, Hints: 3

ZDbcOracleStatement.pas(958,13) Error: Can't determine which overloaded function to call
ZCompatibility.pas(956,10) Hint: Found declaration: Max(const NativeUInt;const NativeUInt):QWord;
math.pp(2069,10) Hint: Found declaration: Max(QWord;QWord):QWord;
ZDbcOracleStatement.pas(1891,30) Hint: Variable "OraPreparableTokens" of a managed type does not seem to be initialized

Max(Descriptor.DataSize, Descriptor.Precision), Descriptor.Scale);
miab3
Zeos Test Team
Zeos Test Team
Posts: 1310
Joined: 11.05.2012, 12:32
Location: Poland

Re: Zeos 7.3 testers-thread

Post by miab3 »

@EgonHugeist, @Jan, @Fr0sT, @mdaems, All

ZEOS 7.3.x svn 6467:
https://sourceforge.net/p/zeoslib/code- ... sting-7.3/

Compiles:

- Lazarus 2.0.0(fpc 3.3.1) - Raspbian32 Buster for Raspberry Pi https://www.getlazarus.org/setup/?download#raspberry_pi,
- Lazarus 2.0.8(fpc 3.0.4)-Win32,
- Lazarus 2.0.8(fpc 3.0.4)-Win64,
- Delphi 7,
- RAD Studio 2007-Win32/C++32 with small hpp fixes,
- RAD Studio XE2 -Win32/Win64/C++32 with small hpp fixes,
- Delphi 10 Seattle-Win32/Win64,
- Delphi 10.3.3 Rio-Win32/Win64/Android/Android64.

mORMot PerfTest r5960 passes(Delphi 10.3.3 Rio Win32/Win64; Delphi 2007)

Michal
Last edited by miab3 on 24.04.2020, 08:33, edited 2 times in total.
marsupilami
Platinum Boarder
Platinum Boarder
Posts: 1956
Joined: 17.01.2011, 14:17

Re: Zeos 7.3 testers-thread

Post by marsupilami »

Hello tkamphuis,

this problem should be fixed with Rev. 6364. Could you please check if it compiles now?

Best regards,

Jan
tkamphuis wrote: 21.04.2020, 09:16 I did a test with Zeos-7.3 rev 6462 on Lazarus 2.08 fpc 3.2.0 beta-4480 64 and I got a problem when compiling the package. I get the error:

Compile package zdbc 7.3: Exit code 1, Errors: 1, Hints: 3

ZDbcOracleStatement.pas(958,13) Error: Can't determine which overloaded function to call
ZCompatibility.pas(956,10) Hint: Found declaration: Max(const NativeUInt;const NativeUInt):QWord;
math.pp(2069,10) Hint: Found declaration: Max(QWord;QWord):QWord;
ZDbcOracleStatement.pas(1891,30) Hint: Variable "OraPreparableTokens" of a managed type does not seem to be initialized

Max(Descriptor.DataSize, Descriptor.Precision), Descriptor.Scale);
tkamphuis
Junior Boarder
Junior Boarder
Posts: 30
Joined: 18.01.2009, 09:20
Contact:

Re: Zeos 7.3 testers-thread

Post by tkamphuis »

I tried version 7.3 version 6468 and still got problems, this time oracle statements. I also tried 7.2.8 and that version works

Compile package zdbc 7.3: Exit code 1, Errors: 6, Hints: 17
ZDbcOracleStatement.pas(882,17) Error: Can't determine which overloaded function to call
ZCompatibility.pas(792,10) Hint: Found declaration: Max(const NativeUInt;const NativeUInt):QWord;
math.pp(2069,10) Hint: Found declaration: Max(QWord;QWord):QWord;
ZDbcOracleStatement.pas(886,17) Error: Can't determine which overloaded function to call
ZCompatibility.pas(792,10) Hint: Found declaration: Max(const NativeUInt;const NativeUInt):QWord;
math.pp(2069,10) Hint: Found declaration: Max(QWord;QWord):QWord;
ZDbcOracleStatement.pas(889,17) Error: Can't determine which overloaded function to call
ZCompatibility.pas(792,10) Hint: Found declaration: Max(const NativeUInt;const NativeUInt):QWord;
math.pp(2069,10) Hint: Found declaration: Max(QWord;QWord):QWord;
ZDbcOracleStatement.pas(1361,22) Hint: Local variable "OraLobs" of a managed type does not seem to be initialized
ZDbcOracleStatement.pas(1490,28) Hint: Local variable "ClientStrings" of a managed type does not seem to be initialized
ZDbcOracleStatement.pas(2467,40) Hint: Local variable "tmp" of a managed type does not seem to be initialized
ZDbcOracleStatement.pas(2630,40) Hint: Local variable "tmp" of a managed type does not seem to be initialized
ZDbcOracleStatement.pas(2890,17) Error: Can't determine which overloaded function to call
ZCompatibility.pas(792,10) Hint: Found declaration: Max(const NativeUInt;const NativeUInt):QWord;
math.pp(2069,10) Hint: Found declaration: Max(QWord;QWord):QWord;
ZDbcOracleStatement.pas(2894,17) Error: Can't determine which overloaded function to call
ZCompatibility.pas(792,10) Hint: Found declaration: Max(const NativeUInt;const NativeUInt):QWord;
math.pp(2069,10) Hint: Found declaration: Max(QWord;QWord):QWord;
ZDbcOracleStatement.pas(2897,17) Error: Can't determine which overloaded function to call
ZCompatibility.pas(792,10) Hint: Found declaration: Max(const NativeUInt;const NativeUInt):QWord;
math.pp(2069,10) Hint: Found declaration: Max(QWord;QWord):QWord;
ZDbcOracleStatement.pas(2940,30) Hint: Variable "OraPreparableTokens" of a managed type does not seem to be initialized

Max(Descriptor.DataSize, Descriptor.Precision), Descriptor.Scale)
marsupilami
Platinum Boarder
Platinum Boarder
Posts: 1956
Joined: 17.01.2011, 14:17

Re: Zeos 7.3 testers-thread

Post by marsupilami »

Hello tkamphuis,

I can confirm, the bug existed in Rev. 6468. The current revision (6478) compiles for me on Lazarus 2.0-fixes (62945) and FPC 3.2-fixes (45049).

Best regards,

Jan
tkamphuis
Junior Boarder
Junior Boarder
Posts: 30
Joined: 18.01.2009, 09:20
Contact:

Re: Zeos 7.3 testers-thread

Post by tkamphuis »

Hello Jan,

It compiles fine now (6478), but now there is a problem when I use it with SQLite. It can't find the driver for SQLite in the executable folder. That is for Lazarus 2.08 FPC 3.04 and also for Lazarus 2.08 and FPC 3.2

Zeos 7.2 does not have that problem

With Regards,

Theo
marsupilami
Platinum Boarder
Platinum Boarder
Posts: 1956
Joined: 17.01.2011, 14:17

Re: Zeos 7.3 testers-thread

Post by marsupilami »

Hello Theo,
tkamphuis wrote:It can't find the driver for SQLite in the executable folder.
I am not 100% sure what you mean. Do you get an error or are you missing files that you expect to be generated?

Best regards,

Jan
tkamphuis
Junior Boarder
Junior Boarder
Posts: 30
Joined: 18.01.2009, 09:20
Contact:

Re: Zeos 7.3 testers-thread

Post by tkamphuis »

When I develop a database application with SQLite I put the sqlite dll files in my executable folder ( sqlite3.dll). The TZconnection always was able to find that labrary. Version 7.2.6 and also version 7.3 in the past was ok. But the last build of 7.3 does not find the dll anymore. I get the error: Requested database driver not found:
error.png
You do not have the required permissions to view the files attached to this post.
marsupilami
Platinum Boarder
Platinum Boarder
Posts: 1956
Joined: 17.01.2011, 14:17

Re: Zeos 7.3 testers-thread

Post by marsupilami »

Hello Theo,

erm - this problem means that Zeos was not able to locate the Zeos internal driver you request. Did you remove the version numers from the protocol name in TZConnection? Make sure, you use the protocol "sqlite" there. "sqlite-3" doesn't exist on Zeos 7.3 anymore. We announced that change in the release notes for Zeos 7.2.4 - basically in the last sentence of the chapter "The future development of Zeos".

Maybe Zeos creates ambiguity there by talking about a driver in the error message and not a protocol...

Best regards,

Jan
tkamphuis
Junior Boarder
Junior Boarder
Posts: 30
Joined: 18.01.2009, 09:20
Contact:

Re: Zeos 7.3 testers-thread

Post by tkamphuis »

Hello Jan,

Exelent, that was the problem, I did not change the protocol from sqlite-3 to sqlite. I think I missed the release notes for version 7.2.4.

Everything works fine now. Thank you for quick answer. You make my day.

Kind regards,

Theo
tkamphuis
Junior Boarder
Junior Boarder
Posts: 30
Joined: 18.01.2009, 09:20
Contact:

Re: Zeos 7.3 testers-thread

Post by tkamphuis »

Hello Jan,

I tried several applications in Lazarus 2.0.8, SQLite and zeos 7.3 build 6486 and I see some errors. One of the errors is a strange behaviour of the date field when I paste the fields in the query editor. The dates are sometimes not visble, or only when I click in the field to edit the value.

I met also some other errors, I try to find out.

Version 2.6 has no problems and also not the older 7.3 versions. I also tried version 'testing-7.3-aehimself' and that version is also ok (what are the differences?).

Best Regards,

Theo
User avatar
aehimself
Zeos Dev Team
Zeos Dev Team
Posts: 798
Joined: 18.11.2018, 17:37
Location: Hungary

Re: Zeos 7.3 testers-thread

Post by aehimself »

testing-7.3-aehimself is obsolete, not updated for a really long time and the branch should be deleted from the (un)official Zeos git repository.
We used that to test how exactly patches can be pushed the easiest; but abandoned the idea a long time ago.
Delphi 12.2, Zeos 8 from latest GIT snapshot
Using:
- MySQL server 8.0.18; libmysql.dll 8.0.40 x64 5.7.19 x68, libmariadb.dll 3.3.11
- Oracle server 11.2.0, 12.1.0, 19.0.0; oci.dll 21.15
- MSSQL 2012, 2019; sybdb.dll FreeTDS_3102
- SQLite 3.47
marsupilami
Platinum Boarder
Platinum Boarder
Posts: 1956
Joined: 17.01.2011, 14:17

Re: Zeos 7.3 testers-thread

Post by marsupilami »

Hello Theo,

I do have some questions:
tkamphuis wrote: 30.04.2020, 14:10 I tried several applications in Lazarus 2.0.8, SQLite and zeos 7.3 build 6486 and I see some errors.
For any errors you see we are interested in finding out what happens. This is what this thread is about ;) It also might make sense to use the bug tracker on sourceforge. There we can discuss each error separately. Sometimes it gets hard to track things in a single thread. It will be good if we have only one unstable factor in the equation - Zeos. So it will be good if everything else - Lazarus, FPC and sqlite stay the same. So I assume the following: Lazarus 2.0.8, FPC 3.0.4. Do you use SQLite 3.31.1? Are you on Windows or Linux?
tkamphuis wrote: 30.04.2020, 14:10One of the errors is a strange behaviour of the date field when I paste the fields in the query editor. The dates are sometimes not visble, or only when I click in the field to edit the value.
In the query editor? I assume you mean the DBGrid? This sounds strange. Can you reproduce this problem in a predictable way? Or does it only happen from time to time? Do you have the time to test different revisions of Zeos to see when the problem was introduced? From experience I do know that the last bit is very time consuming.
tkamphuis wrote: 30.04.2020, 14:10I met also some other errors, I try to find out.
Ok. Maybe together we can find the root of the problem.
tkamphuis wrote: 30.04.2020, 14:10Version 2.6 has no problems and also not the older 7.3 versions.
Which older 7.3 versions did you test? I assume with "Version 2.6" you mean that you don't get that problem when compiling with FPC 2.6? Which version of Lazarus do you use there?
tkamphuis wrote: 30.04.2020, 14:10I also tried version 'testing-7.3-aehimself' and that version is also ok (what are the differences?).
As aehimself said - this version was very old. It was part of a test to see how we can integrate users that use git. I deleted that branch now.

Best regards,

Jan
tkamphuis
Junior Boarder
Junior Boarder
Posts: 30
Joined: 18.01.2009, 09:20
Contact:

Re: Zeos 7.3 testers-thread

Post by tkamphuis »

Hello Jan,

I did some tests with an existing project.

I use Windows 64 bits (1909 - 18363.778)
Lazaus 64 bits 2.08 R62944
fpc 3.,04
SQLite version x64 3310100

zeos version 7.3 - 5939 everything works ok
zeos version 7.3 - 6069 The problem with the date fields arises
zeos version 7.3 - 6491 I now get the error again 'requested databasedriver not found for SQLite protocol (i used sqlite in the conection component)

By pasting the fields in the query edito I mean dubbeclick the zeos query component and add all queru fields:
query editor.png
I have a quick demo to demonstrate (reproduce) the datefield problem, but is is too huge to submit as attachment

Best regards,

Theo
You do not have the required permissions to view the files attached to this post.
Post Reply