Zeoslib Portal

Hello, marsupilami. The driver manager should be protected, but the only protection I found (v7.2.4) is in ZdbcPooled.pas line 348: // I had a strong feeling that DriverManager is not thread-safe, because i // had random access violations on high load operations at this point. // For now, i will ser...

Dear community, I was having access violations on TZConnection.Connect: :0044e0a6 TStringList.InsertItem + $56 :0044dc2d TStringList.AddObject + $59 ZURL.TZURLStringList.SetTextStr('application_name=nFormer'#$D#$A) ZDbcIntfs.TZDriverManager.ConstructURL('postgresql-9','localhost','npoint','postgres'...

Hmmm honestly I don't care if components change behaviour for Zeos 7.3. For Zeos 7.2 it is a different story. Your proposed code just swallows all exceptions that happen - at least all EZSQLExceptions. So if I don't install an error handler everything will look as if it works although it doesn't. M...

Fr0sT, marsupilami, miab3 Thank You for your quick and valuable feedback. There's a;ready ZIBEventAlerter unit with error handling so the change should be done accordingly. Some code style suggestions: - const ErrorMessage in TZPgErrorEvent. In 7.3 all ref-counted types in parameters made const or v...

I've noticed, that TZPgEventAlerter does not detect seerver disconnects. This seems like a big issue as you can't trust the OnNotify event to be fired. The only way would be to periodically execute SQL statements to see if connection still active. The cause was there was no handling of error returne...

Hello, The Name? Actually there are NO behavior changes. Just a hint "we support PG9+". Are you sure? For some unknown reason we get range check errors on some computers when using postgresql-8 and they are gone if we use postgres-9... I was unable to reproduce it on my computer, but the p...

Hello marsupilami,

Thank You for the explanation.

Best regards,
Wild Pointer

Hello, marsupilami I thought about that too, like replacing all ZQuery.Open with OpenDataSet(ZQuery) where procedure OpenDataSet(ADataSet: TZQuery) begin ADataSet.Connection.ShowSQLHourGlass; try ADataSet.Open; finally ADataSet.Connection.HideSQLHourGlass; end; end; After thinking about that a bit l...

Hello mdaems, it took me some time :). As usual, when a temporary solution is made, the proper fix is postponed. Anyway after switching to Zeos 7.0.6 we faced the same decrease in performance so here I am sending a patch. It speeds things up for me. I've used git on 7.0.6 version of ZeosLib. If I sh...

hello, I've noticed that error messages for SQLite are useless. What can you say when you get error "SQL logic error or missing database" when you have the name of table misspelled in the SQL statement you want to execute? So I made error messages more detail using sqlite_errstr function. ...

Hello,

the other solution is to change the SQL to: That should increase the speed of your application.

Good luck!

EgonHugeist , ProstgreSQL doesn't convert the characters to your current client encoding? Well, it tries but because the byte-sequences are incompatible it gives an exception "SQL Error: ERROR: character with byte sequence 0xc5 0xa1 in encoding "UTF8" has no equivalent in encoding &q...

Hello, in ZDbcPostgreSqlMetadata.pas I see the table of DB comments (pg_description) is used when getting column information : function TZPostgreSQLDatabaseMetadata.UncachedGetColumns(const Catalog: string; const SchemaPattern: string; const TableNamePattern: string; const ColumnNamePattern: string)...

Not strange at all :) This is how Data Aware component TDbGrid works. It does not show the value for the memo fields. Someone should correct me if I'm mistaken but it is the libpq that tells the Zeos lib that the column is memo. You could try selecting value from the column that is varchar(N) where ...

Hello elidorio2 , the problem is the Postgresql server presumes the result of case command is text. Text type fields are used as memo fields in Zeos. Try casting the result of case command to character varying (20) and you'll get what you want. example SELECT ..., CAST( case when .... then .... end ...