ZeosLib 7.1 testers-thread

[miab3]

@EgonHugeist, @mdaems,

Zeos 7.1 R2494.

I still have trouble with Oracle types NCLOB, CLOB and BFILE for this sample table:

CREATE TABLE "B types"
(
TFLOAT FLOAT,
TNCLOB NCLOB,
TCLOB CLOB,
TBLOB BLOB,
TBFILE BFILE
)

The errors occur when attempting to write or read ZTable record and are also related to the selected ClientCodepage.

Michal

[miab3]

@EgonHugeist, @mdaems,

Zeos7.1-(beta) branches_ testing_R2496:
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.40),
(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).

I see two problems as I mentioned:
- with the TableName for ado-sqlncli MSSQL,
- with Oracle types NCLOB, CLOB and BFILE.

Michal

[miab3]

@EgonHugeist, @mdaems,

Zeos7.1-(beta) branches_ testing_R2500:
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.40),
(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).

I see two problems as I mentioned:
- with the TableName with space for ado-sqlncli MSSQL,
- with Oracle types NCLOB, CLOB and BFILE.

Michal

[miab3]

@EgonHugeist, @mdaems,

Zeos7.1-(beta) branches_ testing_R2502:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.1/

ADO TableName with a space fixed.
I have tested on:
- DXE2 32/64 -> C++(32).
(The need to add ZAdoToken.pas to ZParseSql.dpk)

Remained these "B types" of ORACLE.

Michal

[miab3]

@EgonHugeist, @mdaems,

Zeos7.1-(beta) branches_ testing_R2506:
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.40),
(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).

(Now, with the appropriate settings CodePage no errors in ORACLE.)

Michal

[miab3]

@EgonHugeist

Zeos7.1_R2506 DXE2-32
This mistake I gets when try opening the table after INSERT BFILE.
(attached)

(Directory and file exist).

This is a bit of a BFILE:
http://www.idevelopment.info/data/Oracl ... S_30.shtml
http://docs.oracle.com/cd/B10501_01/app ... l12bfl.htm

Michal

[EgonHugeist]

miab3,

hint on creating the Directory oracle doesn't check if it exists.

I added a test with BFILE reading and updating it. It works perfectly. The raised error isn't related to Zeos in this case. Max size of the Directory is 60Bytes (a very low value novadays).

Just look to the diff of my test:

http://sourceforge.net/p/zeoslib/code-0 ... 01f0f:2504

I assing 'C:\temp' as Dir (in my test) and did copy the hourse.jpg to temp. than i run my tests.. No issues to see.

[miab3]

@EgonHugeist

It looks OK. I've found out that directory objects must be identified in upper case, and then it works.

Michal

[miab3]

@EgonHugeist, @mdaems,

Zeos7.1-(beta) branches_ testing_R2508:
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.40),
(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.1-(beta) branches_ testing_R2517:

Delphi2006:

ZDbcDbLibUtils.pas:line390:
Result := {$IFDEF WITH_UNITANSISTRINGS}AnsiStrings.{$ENDIF}AnsiQuotedStr(PlainDriver.ZPlainString(SoftVarManager.GetAsString(Value), ConSettings, zCP_UTF8), '''')

[Pascal Error] ZDbcDbLibUtils.pas(390): E2034 Too many actual parameters

Michal

[miab3]

@EgonHugeist, @mdaems,

Zeos7.1-(beta) branches_ testing_R2518:
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.40),
(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-(beta) branches_ testing.
It looks like that for SQLite commit doesn't happen.
After restarting applicatiaon there are no changes from previous session in database.

Michal

[miab3]

@EgonHugeist, @mdaems,

False alarm.
TransactIsolationLevel was set to tiReadCommitted.
If tiNone commit works.

Michal

[miab3]

@EgonHugeist, @mdaems,

However, I have a problem with Access-ADO in Delphi (XP2).
I put a simple example.
I can not enter a new record (blank field FILE or/and NOTE disturb).
How to avoid errors with blank fields?(And How to fill FILE and NOTE?)

Michal

[EgonHugeist]

miab3,

have no Access, Michal. But AFAIK is there no real support for binary Data with Access, Michal. Use Base64 or BinToHex falues instead. And convert them back on accessing the Fields.

Am i wrong?