"No suitable driver found for jdbc:h2:file"

Question

When trying to access JIRA's H2 embedded database, I get the error:

"No suitable driver found for >jdbc:h2:file:C:\Program Files\Atlassian\Application Data\JIRA/database/h2db 08001/0
java.sql.SQLException: No suitable driver found for >jdbc:h2:file:C:\Program Files\Atlassian\Application Data\JIRA/database/h2db 
    at java.sql.DriverManager.getConnection(Unknown Source) 
    at java.sql.DriverManager.getConnection(Unknown Source) 
    at org.h2.util.JdbcUtils.getConnection(JdbcUtils.java:282) 
    at org.h2.server.web.WebServer.getConnection(WebServer.java:759) 
    at org.h2.server.web.WebApp.login(WebApp.java:957) 
    at org.h2.server.web.WebApp.process(WebApp.java:211) 
    at org.h2.server.web.WebApp.processRequest(WebApp.java:170) 
    at org.h2.server.web.WebThread.process(WebThread.java:137) 
    at org.h2.server.web.WebThread.run(WebThread.java:93) 
    at java.lang.Thread.run(Unknown Source) "

Could someone help point me in the right direction to resolve this?

Audra · Answer

Good afternoon Andy,

This is actually what I'm trying to do now, but I'm experiencing a different issue, haha. It seems I'm just having problems with JIRA today.

Thank you.

Audra

Audra · Answer

Good afternoon Andy,

I am in a Windows environment and I was following the steps exact. Navigating to the appropriate directory, opening a command prompt there, and calling the java jar file (though mine wasn't java -jar h2-1.4.187.jar, it was java -jar h2-1.4.185.jar). From there, I went and found my dbconfig file and pasted exact (in this case: jdbc:h2:file:C:\Program Files\Atlassian\Application Data\JIRA/database/h2db) and tried to connect.

I have a feeling that was just the tip of the iceberg though as I got a new error of "General error: "java.lang.NullPointerException" [50000-185] HY000/50000". As stated above, I now believe it is database corruption.

Thank you though!

Audra

Andy Heinzer · Answer

If you are looking maintain your Jira data and migrate it off this potentially corrupted H2 database, I would recommend these steps: * Select a database type/version from our Supported platforms - Atlassian Documentation (it's important to find the correspond version of this page that meets your version of Jira) * Create a new blank database per Connecting JIRA to a database, (paying close attention to the correct collation for that database type) * Gather an XML backup of your JIRA instance. Even if you can't start JIRA, you can likely still find a recent one of these backups in the filesystem of the JIRA server. By default this is saved in /export/ folder. * Stop JIRA, * Run the JIRA Configuration tool to tell JIRA to use the new blank database, save these changes, (if you can't run this, then you can just directly edit the /dbconfig.xml file to make these changes) * Start JIRA up again (when JIRA starts with an empty database, it automatically launches the setup wizard) * Copy the export XML zip file from /export/ into /import/ * Then you can import the backup using the 'Import your data' link in the setup wizard By following these steps you can then import your previous data into a supported database with the correct database setup.