java.sql.SQLException: Unknown system variable ‘tx_read_only’ failure because driver is newer than what Mathematica is configured for. Mathematica on Mac at version 12.0.0.0 and mysql at 8.0.1.4, with JDBC driver at 8.0.1.8, but last time tx_read_only switch was supported was in driver 5.1.23 - 5.1.46
How can more recent mysql DB with java connector to database be used in Mathematica?
Thx
D
Hi Dennis,
Does this MSE answer help?
Thx; Will try this.
D
The mentioned solution actually provides good information but does not solve the problem. I had a similar issue with Matlab and only after Matlab updated their code did the problem get solved. Their update required re-basing onto a version of MySQL connector that was ‘modern’ for MySQL 8, and also to remove the code that used tx_read_only from an earlier MySQL pattern. I don’t know where the parameter is being used in Mathematica so cannot eliminate that usage. Specifying read only is not appropriate, and neither is specifying read only = false or a default (no specification), since both generate that parameter to the java connector.
More investigation continues.
Thx
D