Page 1 of 1

ZPlainPostgreSqlDriver bug?

Posted: 03.12.2010, 16:45
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.

Posted: 03.12.2010, 18:31
by martinrame
I downloaded ZEOSLIB_STABLE_REV840.zip and this seems to be fixed.

Posted: 12.12.2010, 21:11
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!