Cast Exception Problem for MySQL driver 8.X possible

[mumitr0ll]

Using sql2o extensively on Ubuntu 16 and 18 with MySQL . No issues. However, all of the uses there are with mysql-connector-java 5.1.X - the standard for a while.

My colleague has a new Mac and is using the MySQL driver mysql-connector-java 8.0.13. Now the INSERT with sql2o work, but the objects returned from the reading of the just inserted objects fails. Specifically, the casts are failing for the auto-increment columns in Java with the message "Can't Cast BIGINTEGER to LONG". I looked at the Javadoc for sql2o and I don't see a BigInteger converter. Are we missing something or is this an actual worry? MySQL connector page recommends the use of connector 8.

**EDIT - I should mention that we are using auto-increment on INT Unsigned for the key. That appears to be the possible problem. Please let me know.