Very odd problem. I am getting logs with "No suitable driver found for jdbc:ucanaccess://var/www/mnt/myhome/mydatabase.mdb'
Try again an hour later and it is working again. Seems to stop working for a session maybe and then comes back again???
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
The issue for me is the intermittent nature. Refresh the same URL a couple hours later and it works fine. The same REST call should execute exactly the same code.
if (!connected) {
String connection = dataClass.getConnection();
if ( connection != null) {
Class.forName("net.ucanaccess.jdbc.UcanaccessDriver");
Properties connectionProps = new Properties();
String user = dataClass.getUsername();
String pwd = dataClass.getPassword();
conn = DriverManager.getConnection(dataClass.getConnection(), user, pwd); <== error here
connected = true;
Last edit: Phil Scadden 2018-05-11
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Yes but the url passed to UCanAccess it's not the same. Sometime it is malformed (and it's not UCanAccess but java that detects it). Log it down for evidence.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Very odd problem. I am getting logs with "No suitable driver found for jdbc:ucanaccess://var/www/mnt/myhome/mydatabase.mdb'
Try again an hour later and it is working again. Seems to stop working for a session maybe and then comes back again???
If one can't lift a weight the root cause isn't in the weight.
Something wrong in the classloading? What's the context?
The issue for me is the intermittent nature. Refresh the same URL a couple hours later and it works fine. The same REST call should execute exactly the same code.
Last edit: Phil Scadden 2018-05-11
Yes but the url passed to UCanAccess it's not the same. Sometime it is malformed (and it's not UCanAccess but java that detects it). Log it down for evidence.