ZPlainPostgreSqlDriver bug?

In this forum we will discuss things relating the ZEOSLib 6.6.x stable versions

Moderators: gto, EgonHugeist

Post Reply
martinrame
Junior Boarder
Junior Boarder
Posts: 25
Joined: 24.10.2006, 18:29
Location: Córdoba, Argentina
Contact:

ZPlainPostgreSqlDriver bug?

Post by martinrame »

Hi, I updated my Zeos to 6.6.6-stable and found an exception that didn't appear in previous versions.

To reproduce it you have to create a program following the next steps:

1) Connect to a PG-8.x database and do some queries.
2) Disconnect the network cable on the client machine.
3) Try to do a new query. This will raise the exception "SQL Error: server closed the connection unexpectedly...". This is ok.
4) From your program do an FConnection.Close.

In the step 4, on ZPlainPostgreSqlDriver, method TZPostgreSQL8PlainDriver.Finish(Handle: PZPostgreSQLConnect); I got an Access Violation on ZPlainPostgreSql8.PQfinish(Handle);

Any hint?

P.D.: I'm using libpq.dll version 8.2.6.8004 and Delphi 7.
martinrame
Junior Boarder
Junior Boarder
Posts: 25
Joined: 24.10.2006, 18:29
Location: Córdoba, Argentina
Contact:

Post by martinrame »

I downloaded ZEOSLIB_STABLE_REV840.zip and this seems to be fixed.
Wild_Pointer
Expert Boarder
Expert Boarder
Posts: 164
Joined: 18.03.2008, 13:03
Contact:

Post by Wild_Pointer »

Hello, martinrame,

this error was because of improper use of connection handle in statements. Please read http://zeos.firmos.at/viewtopic.php?t=2599&highlight=

Good luck!
Post Reply