I'm using the sql20 class to do some simple database stuff. It seems nice and simple so I decided to give it a go. Here is a simple class I created with sql2o and when I call the method to update the table, I get this error from the compiler:
Could not acquire a connection from DataSource - No suitable driver found for jdbc:mysql://localhost:3306/Downloads
I can connect to the database just fine with MySql Workbench as well as execute SELECT and UPDATE queries. The problem is strictly with sql2o
posted 7 months ago
Have you got a MySQL JDBC driver jar file on your runtime path?
That looks like the Connector/J connection string.