sql2o is a small library, which makes it easy to convert the result of your sql-statements into objects. No resultset hacking required. Kind of like an orm, but without the sql-generation capabilities. Supports named parameters.
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.
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.