Menu

Intermittant "No suitable Driver messages"

Help
2018-05-09
2018-05-11
  • Phil Scadden

    Phil Scadden - 2018-05-09

    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???

     
  • Marco Amadei

    Marco Amadei - 2018-05-10

    If one can't lift a weight the root cause isn't in the weight.
    Something wrong in the classloading? What's the context?

     
  • Phil Scadden

    Phil Scadden - 2018-05-11

    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
  • Marco Amadei

    Marco Amadei - 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.

     

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.