ZeosLib 7.1 testers-thread

[miab3]

@EgonHugeist, @mdaems,

Zeos7.1-alpha branches_ testing_R2396:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.1/
compiles and runs on (I have tested):

- D2006,
- D2007 -> C++,
- DXE2 32/64 -> C++(32),
- Lazarus Windows7-64 1.1.0/fpc 2.7.1 32/64 (CodeTyphon ver 4.30),
(For Linux currently I have no way to test)

(Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.29, PostgreSQL 9.2.2, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, Oracle Database Express Edition 11g Release 2, SQLite 3.7.17).

Michal

[EgonHugeist]

miab3,

i had a look to http://blog.synopse.info/post/2013/06/1 ... for-mORMot

well Arnaud did nice speed tests again. I had not the time to check if he uses "Real" PreparedStatments for SQLite since (currently) the Emulated prepareds are default. And i couldn't check if his implementations a as optimal as possible (i made a benchmark for SQLite before and i could insert 10000 rows with the TZDataSet-Compoents in less than 2 secs) Accordingly his hints for string conversions:
http://svn.code.sf.net/p/zeoslib/code-0 ... esting-7.2

i've strarted the first approach. This times i fetch native raw strings from the providers except for charactersets which have a inconsitent codepage like FireBird "NONE". Then i cache UnicodeStrings. Only on accessing the data with a dataset i convert (if the options are set) something. The same happens to the statements. I've internaly (DBC-layer and below) introduced some more getters and setters for Ansi/UTF8/RawByte-Strings. Also the convertion routines are more optimized since i load them to a record. This design avoids a loads of if .. then or case checks i made before.

Well it's just a start. I'll optimize the API as best as possible but this happens 7.2 first, i'm sorry. We are going to set the RealPrepareds for PostgreSQL and SQLite as default. Than we'll freeze the 7.1 behavior and going beta.

[miab3]

@EgonHugeist, @mdaems,

Zeos7.1-alpha branches_ testing_R2410:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.1/
compiles and runs on (I have tested):

- D2006,
- D2007 -> C++,
- DXE2 32/64 -> C++(32),
- Lazarus Windows7-64 1.1.0/fpc 2.7.1 32/64 (CodeTyphon ver 4.30),
(For Linux currently I have no way to test)

(Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.29, PostgreSQL 9.2.2, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, Oracle Database Express Edition 11g Release 2, SQLite 3.7.17).

Michal

[miab3]

@EgonHugeist,

Zeos7.2-alpha branches_ testing_R2417:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.2/
compiles and runs on (I have tested):
- D2007 -> C++

I had to comment out line 77 in ZPlainDriver.pas:
// Function ZDbcUnicodeString (const Astra: RawByteString; const FromCP: Word): ZWideString; overload;

Can you open an new test thread for 7.2?

Michal

[miab3]

@EgonHugeist, @mdaems,

Zeos7.2-alpha branches_ testing_R2420:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.2/
compiles and runs on (I have tested):

- D2006,
- D2007 -> C++,
- DXE2 32/64 -> C++(32),
- Lazarus Windows7-64 1.1.0/fpc 2.7.1 32/64 (CodeTyphon ver 4.30),
(For Linux currently I have no way to test)

(Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.29, PostgreSQL 9.2.2, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, Oracle Database Express Edition 11g Release 2, SQLite 3.7.17).

Michal

[EgonHugeist]

miab3,

Can you open an new test thread for 7.2?

Done! Switch to 7.2, Michal. Thanks a lot for testing!

[miab3]

@EgonHugeist, @mdaems,

Zeos7.1-alpha branches_ testing_R2461:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.1/
compiles and runs on (I have tested):

- D2006,
- D2007 -> C++,
- DXE2 32/64 -> C++(32),
- Lazarus Windows7-64 1.1.0/fpc 2.7.1 32/64 (CodeTyphon ver 4.30),
(For Linux currently I have no way to test)

(Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.29, PostgreSQL 9.2.2, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, Oracle Database Express Edition 11g Release 2, SQLite 3.7.17).

Cool. The problem with read only for FreeTDS and mssql fixed.

Michal

[EgonHugeist]

miab3,

Cool. The problem with read only for FreeTDS and mssql fixed.

That's right. And this patch was not only a MSSQL issue. ASA had the same stupid behavior. The issue persits since introducing the IdentifierConverter for the Object-Names in the Property editors. Patch will be merged to 7.0, trunk, 7.2 in a periode of two weeks..

[miab3]

@EgonHugeist, @mdaems,

Zeos7.1-alpha branches_ testing_R2466:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.1/
compiles and runs on (I have tested):

- D2006,
- D2007 -> C++,
- DXE2 32/64 -> C++(32),
- Lazarus Windows7-64 1.1.0/fpc 2.7.1 32/64 (CodeTyphon ver 4.30),
(For Linux currently I have no way to test)

(Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.29, PostgreSQL 9.2.2, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, Oracle Database Express Edition 11g Release 2, SQLite 3.7.17).

Michal

[miab3]

@EgonHugeist, @mdaems,

Zeos7.1-alpha branches_ testing_R2472:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.1/
compiles and runs on (I have tested):

- D2006,
- D2007 -> C++,
- DXE2 32/64 -> C++(32),
- Lazarus Windows7-64 1.1.0/fpc 2.7.1 32/64 (CodeTyphon ver 4.30),
(For Linux currently I have no way to test)

(Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.29, PostgreSQL 9.2.2, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, Oracle Database Express Edition 11g Release 2, SQLite 3.7.17).

Michal

[miab3]

@EgonHugeist,

For ORACLE there are problems if NCLOB field appears:
http://www.orafaq.com/wiki/NCLOB
http://it.toolbox.com/wiki/index.php/NCLOB

Michal

[miab3]

@EgonHugeist,

For NCLOB I get:
ORA-24806: LOB form mismatch

and for BFILE type:
ORA-00932: inconsistent datatypes: expected NUMBER got BLOB

Michal

[EgonHugeist]

miab3,

I'll check it tonight.

[miab3]

@EgonHugeist,

Besides these two types in ORACLE: NCLOB and BFILE,
I missed yet a problem with the TableName for ado-sqlncli MSSQL,
It is a name with a space:

[dbo].[Quarterly Orders] - read only, <-- The defaul
"dbo".[Quarterly Orders] - read only,
[Quarterly Orders] - read only,


[dbo]."Quarterly Orders" - r/w
"dbo"."Quarterly Orders" - r/w
"Quarterly Orders" - r/w

Michal

[miab3]

@EgonHugeist,

R2483.
Error NCLOB looks fixed.

BFILE is still a problem.
When I try to post a NEW record of ZTable I get:

ORA-00932: inconsistent datatypes: expected NUMBER got BLOB

Michal