Zeoslib Portal

Hi all! I'm working on some changes to ZDbcMySqlMetadata (related to my ticket #15) and I wanted to check on a few things. #1. The MySQL databases that I have access to (5.7 and 8.0 all on Ubuntu) don't include the text 'mysql' in the "show variables" result and so IsMySQL is always false ...

Aha! Thanks for pointing that out! After switching to the MariaDB connector and adding the MYSQL_PLUGIN_DIR property I was able to connect to MySQL 8 without needing to turn off ssl and without having to change the default plugin. Nice!

-Mark

I finally got back to this and got connected. I ended up having to turn off ssl (ssl=0 in mysqld.cnf) but I also had to change the "identified with" clause in create user to mysql_native_password (apparently migrated databases will have this as the default for existing users.) Looking at t...

Hi all! I fixed some minor bugs recently in the time and datetime display for fractional seconds. I kept the code the same besides the fix, but it is a bit odd in the way that it works. Case 1: if your timeformat is "simple" (i.e. it ends with the fractional seconds), then they are concate...

Hi Michael,

I've done some testing on the new code and it looks great! The nested transaction support is quite nice as well. Thanks for your great work!

-Mark

Hi Michael, I was able to find and diagnose the problem using two separate connections and transactionally updating records, then reading them from the second session to test if autocommit had been turned back on. In my steps above, the autocommit flag was set, but SetAutoCommit was never called at ...

Hi Michael, Thanks. It appears that TZOleDBDatabaseInfo.InitilizePropertiesFromDBInfo works fine, or at least it seems to work the way I'd think and I've stepped through it many times and haven't seen any weird values or settings that seem out of place (though I don't know what all of them do.) Bypa...

Hi All! If MySQL is in autocommit mode, then if you call: StartTransaction Update/insert/delete Commit My understanding is that calling Commit will automatically put the driver back into autocommit mode, but it doesn't (or I should say that the Autocommit properties are set correctly, but the underl...

Update. I've also installed an Oracle ODBC driver for testing and that fails in exactly the same way as the MySQL ODBC driver. Both drivers support multiple result sets OleDB Protocol: Using MSOLEDBSQL: SupportsMultipleResultSets = True Works well Using MSDASQL and MySQL ODBC: SupportsMultipleResult...

Thanks! I went through my older versions and I don't believe I ever had it working with the MySQL ODBC driver, just the Firebird one. I'm going through the params to see if I can find anything that seems out of place, but so far nothing has stood out. Obviously this is a lower priority since it make...

Hi all! I've been testing the TZConnection.AbortOperation method which works great for the supported drivers. I'm also using SQL Server through the OleDB interface, and it doesn't support this method, however I notice it has a "Cancel" method on the statement objects. Is that in any way si...

I've hit an issue which I think may have changed recently (or at least I think I tested this last month with no issues.) I'm testing the OleDB protocol using the OleDb ODBC connector (provider MSDASQL) and a MySQL DSN/ODBC driver. Using this setup running any query returns a Debugger Exception Notif...

I've tested the fix and it seems to work perfectly. Thanks!

-Mark

Here's the TZTimeField patch: procedure TZTimeField.GetText(var Text: string; DisplayText: Boolean); var Frmt: string; Delim, Sep: Char; DT: TDateTime; T: TZTime; I,J: LengthInt; Fraction: Cardinal; B: Boolean; P: PChar; Millis: Word; begin if FilledValueWasNull(T) then Text := '' else begin B := Di...

Will do! I may be changing both, so I'll post them in user patches later today. Thanks.

-Mark