Zeoslib Portal

Hi, Using the revision 3952 (last) of svn://svn.code.sf.net/p/zeoslib/code-0/branches/testing-7.2 with delphi 2009 and postgresql 9.2 running on Windows, i identified 3 issues. In attach there is a project that simulates. I think that issues are introduced with the Postgresql+CAPI prepared statement...

Here another sample where Postgresql+CAPI are not working well. procedure TForm1.Button1Click(Sender: TObject); var QAux : TZQuery; ZConnection1: TZConnection; begin ZConnection1 := TZConnection.Create(Self); with ZConnection1 do begin Name := 'ZConnection1'; HostName := 'change_to_postgresql_ip'; P...

@mdaems I thought I'd add a variable of type "TDateTime" initializing with now() before method "TZQuery.InternalOpen" and after the end of the processing compare with current time and write to the log, only to objects TZQuery. And this only maded if the log is enabled to not slo...

@all in TZSQLMonitor, add time in miliseconds that was taken to execute query from prepare to fetch all rows. There is usefull when optimize the application querys. Sample: 2013-10-23 22:15:48 cat: Bind prepared, proto: postgresql-8, msg: Statement 455 : 1,1 2013-10-23 22:15:48 cat: exectime: 100ms...

@EgonHugeist

Solved!

thank you

@all In D2009, PostgreSQL 9.3, Zeos Testing 7.2 Rev. 2858 Issue 1: On open connection with no user name get Access Violation Issue 2: Error on get DateTime, sometimes returned date is '30/12/1899' In attachment a sample project that simulates the error, there is a video file recorded in ScreenToExe...

@all

On my tests, branch 7.2, using D2009, PostgreSQL version 8.4, 9.0, 9.1, 9.2 and 9.3 using blobs fields, date, strings, numeric.

Work better and faster in this version.

Someone could use the component TPgEventAlerter ? I tried to use without success, is there any example or some test case?

@EgonHugeist

on branches/testing-7.2 Revision 2858 works fine

problem solved

thank you

Sorry, tested again on Revision 2857 (testing-7.2) and there is fixed. but the log of TZSQLMonitor is without the prepare Statement. 2013-10-21 11:30:01 cat: Execute prepared, proto: postgresql-8, msg: Statement 238 2013-10-21 11:30:01 cat: Execute prepared, proto: postgresql-8, msg: Statement 239 2...

@EgonHugeist On Delphi 2009, PostgreSQL 9.3 2013-10-21 07:50:52 cat: Prepare, proto: postgresql-9, msg: PREPARE 'UPDATE public.s162car SET ins004=?,codemp=?,codfil=?,codcta=?,codcar=?,ins004=?,codemp=?,codfil=?,codcta=?,codcar=?,ins004=? WHERE codemp=? AND codfil=? AND codcta=? AND codcar=?', errco...

@EgonHugeist

well done!

a testcase will be a good idea, a long time ago when i move from zeos 6.6 to 7.0 was the same issue.

EgonHugeist wrote:@fhaut,

got the value logging running. Patch done R2841 \testing-7.2 (SVN)

Works fine on 7.2

Thank you

@EgonHugeist trying to convert my aplication from 7.0.6 to 7.1.2 in thread ( http://zeoslib.sourceforge.net/viewtopic.php?f=38&t=4942#p19285 ) i decide to do a test with 7.2 and i got the issue with postgresql 8.4 with Delphi 2009 with CHAR field. Sample definition table s010usu.corpan = CHAR(2...

@EgonHugeist I'm migrating my application from 7.0.6 to 7.1.2 and only this issue break the release. Another example of log TZSQLMonitor in english 2013-10-16 16:28:55 cat: Prepare, proto: postgresql-8, msg: PREPARE 'select * from table1 where codemp = $1 and codfil = $2 and numcha = $3 and codimp =...

on Delphi 2009 / Windows XP, PosgreSQL 9.2 (windows xp) using the svn://svn.code.sf.net/p/zeoslib/code-0/tags/7.1.2-stable revision 2835 a issue occurs when use parameters with same name "select * from test where ( id = :X0 or :X0 is null)" In version 7.0.6-stable that problem nor occurs S...