Search found 10 matches

by dcoun
19.07.2024, 09:19
Forum: ZeosLib 7.3/8.0 Forum
Topic: exception in TZMariaDBBatchDMLPreparedStatement
Replies: 1
Views: 128

Re: exception in TZMariaDBBatchDMLPreparedStatement

I updated the libmariadb.dll to latest version from here (https://dlm.mariadb.com/browse/c_connector/) and I can not reproduce it for the moment.
So, I will report back if it continues
by dcoun
19.07.2024, 07:40
Forum: ZeosLib 7.3/8.0 Forum
Topic: exception in TZMariaDBBatchDMLPreparedStatement
Replies: 1
Views: 128

exception in TZMariaDBBatchDMLPreparedStatement

I am using the last 8.0-patches from Github for zeos (https://github.com/marsupilami79/zeoslib) I am getting exception in the following zeos code in a connection to a mariadb database from a TRestBatch in mormot2: File ZDbcMySqlStatement, line 3201 (in a gist as cloudflare does not allow to post it)...
by dcoun
26.10.2022, 13:04
Forum: ZeosLib 7.3/8.0 Forum
Topic: Exception in releaseimmediate
Replies: 6
Views: 255

Re: Exception in releaseimmediate

I will try to debug it a bit. Do you have something to propose for that?
by dcoun
25.10.2022, 20:20
Forum: ZeosLib 7.3/8.0 Forum
Topic: parameters wrongly in the sql's beginning
Replies: 2
Views: 211

Re: parameters wrongly in the sql's beginning

The problem is that this seldom happens and usually after an other exception (like a duplicate primary index or a field insert with out of range value).
Do you propose to add somewhere in the source a log point to find more info?
by dcoun
25.10.2022, 20:15
Forum: ZeosLib 7.3/8.0 Forum
Topic: Exception in releaseimmediate
Replies: 6
Views: 255

Re: Exception in releaseimmediate

I found the reason why this exception happens. If mariadb servers restarts or disconnects, it results to this error
by dcoun
23.10.2022, 11:47
Forum: ZeosLib 7.3/8.0 Forum
Topic: parameters wrongly in the sql's beginning
Replies: 2
Views: 211

parameters wrongly in the sql's beginning

After an exception in a previous query I am getting the following error using Zeos8.0-fixes last trunk and mormot2 with Delphi 11.2 win32: Exception: 20221023 07461843 * EXC EZSQLException {Message:"SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your Maria...
by dcoun
22.10.2022, 09:35
Forum: ZeosLib 7.3/8.0 Forum
Topic: Exception in releaseimmediate
Replies: 6
Views: 255

Exception in releaseimmediate

With last commit in 8.0-fixes trunk I seldom get this Exception Error Stack: Exception: 20221022 07071001 + EXC EListError {Message:"List index out of bounds (4)"} [] at 3f2c98 System.Classes.pas TList.Get (5109) System.Classes.pas TList.Get (5109) System.Classes.pas TList.Get (5109) ZDbcC...
by dcoun
21.10.2022, 08:10
Forum: ZeosLib 7.3/8.0 Forum
Topic: Wrong field type if extra info is included in field's type name by MariaDB
Replies: 3
Views: 194

Re: Wrong field type if extra info is included in field's type name by MariaDB

I apologize for the delay in my answer as zeos's was bypassed by mormot's code as you can see in this thread: https://synopse.info/forum/viewtopic.php?id=6353 To have a compressed field in any mariadb's db table please check the following page: https://mariadb.com/kb/en/create-table/#compressed CREA...
by dcoun
21.10.2022, 07:57
Forum: ZeosLib 7.3/8.0 Forum
Topic: Wrong field type if extra info is included in field's type name by MariaDB
Replies: 3
Views: 194

Re: Wrong field type if extra info is included in field's type name by MariaDB

I apologize for the delay in my answer as zeos's was bypassed by mormot's code as you can see in this thread:
https://synopse.info/forum/viewtopic.php?id=6353

To have a compressed field in any mariadb's db table please check the following page:
https://mariadb.com/kb/en/create-table/#compressed
by dcoun
16.09.2022, 08:58
Forum: ZeosLib 7.3/8.0 Forum
Topic: Wrong field type if extra info is included in field's type name by MariaDB
Replies: 3
Views: 194

Wrong field type if extra info is included in field's type name by MariaDB

I am using Mormot with ZEOS 8.0 and in a table the database definition as returned by Mariadb is longblob /*!100301 compressed*/ the above defination causes problem to ZEOS and from function TZRowAccessor.GetInt(ColumnIndex: Integer; out IsNull: Boolean): Integer; in ZDBCcache it returns that this f...