aikar / db

Aikar's Intuitive JDBC Database Wrapper - A clean and intuitive API for Java to remove JDBC boilerplate.
https://idb.emc.gs
MIT License
65 stars 20 forks source link

MariaDB Wont work with Recommended Options #22

Open james090500 opened 1 year ago

james090500 commented 1 year ago

When using recommend options, MariaDB will not work due to:

[01:50:16 ERROR]: [com.zaxxer.hikari.util.PropertyElf] Property cacheCallableStmts does not exist on target class org.mariadb.jdbc.MariaDbDataSource

Which is set here:

https://github.com/aikar/db/blob/master/core/src/main/java/co/aikar/idb/HikariPooledDatabase.java#L38

To resolve this, I manually changed the DSN in my code to start with mariadb:// which skips where it's being set here:

https://github.com/aikar/db/blob/master/core/src/main/java/co/aikar/idb/HikariPooledDatabase.java#L33

but it seems here:

https://github.com/aikar/db/blob/master/core/src/main/java/co/aikar/idb/DatabaseOptions.java#L63

Is expected MariaDB to work like MySQL. I can only assume something is missing in MariaDB or not implemented.