MS Access connection 2.13.0

[KBoersch]

Hello community,

before I add an issue, I wanted to make sure, that I didn't overlook something.

I tried to open a connection for ms access. As for every version before, I placed the ucanaccess driver in the associated database folder.

Then I started HOP and tested the connection and.. I got the error message, that the driver can't be found. Then I took a look into the docs and saw, that apparently the ucanaccess driver is included in the lib/jdbc folder of HOP. So I deleted the driver and tried again, with the same result.

Am I missing something here?

Thanks and greetings
Kai

[bamaer]

there were some updates for #4918. The MS Access implementation uses ucanaccess through jackcess, and it looks like we now have 2 jackcess versions in 2.13 (lib/core/jackcess-4.0.4.jar and lib/core/jackcess-5.1.0.jar). Can you try removing the 4.0.4 jar and see if that makes a difference?

[KBoersch]

Unfortunately no. I tested with both but I still get this:

Error connecting to database [test] :org.apache.hop.core.exception.HopDatabaseException: 
Error occurred while trying to connect to the database

Driver class 'net.ucanaccess.jdbc.UcanaccessDriver' could not be found, make sure the 'Microsoft Access database' driver (jar file) is installed.
Unable to load class 'net.ucanaccess.jdbc.UcanaccessDriver' in this classloader or in the parent


org.apache.hop.core.exception.HopDatabaseException: 
Error occurred while trying to connect to the database

Driver class 'net.ucanaccess.jdbc.UcanaccessDriver' could not be found, make sure the 'Microsoft Access database' driver (jar file) is installed.
Unable to load class 'net.ucanaccess.jdbc.UcanaccessDriver' in this classloader or in the parent
	at org.apache.hop.core.database.Database.normalConnect(Database.java:383)
	at org.apache.hop.core.database.Database.connect(Database.java:314)
	at org.apache.hop.core.database.DatabaseFactory.getConnectionTestReport(DatabaseFactory.java:49)
	at org.apache.hop.core.database.DatabaseFactory.getConnectionTestResults(DatabaseFactory.java:74)
	at org.apache.hop.core.database.DatabaseMeta.testConnectionSuccess(DatabaseMeta.java:2113)
	at org.apache.hop.ui.core.database.DatabaseMetaEditor.testConnection(DatabaseMetaEditor.java:903)
	at org.apache.hop.ui.core.database.DatabaseMetaEditor.test(DatabaseMetaEditor.java:766)
	at org.apache.hop.ui.core.database.DatabaseMetaEditor.lambda$createButtonsForButtonBar$6(DatabaseMetaEditor.java:958)
	at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:91)
	at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4321)
	at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1208)
	at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4119)
	at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3707)
	at org.apache.hop.ui.hopgui.HopGui.open(HopGui.java:481)
	at org.apache.hop.ui.hopgui.HopGui.main(HopGui.java:359)
Caused by: org.apache.hop.core.exception.HopDatabaseException: 
Driver class 'net.ucanaccess.jdbc.UcanaccessDriver' could not be found, make sure the 'Microsoft Access database' driver (jar file) is installed.
Unable to load class 'net.ucanaccess.jdbc.UcanaccessDriver' in this classloader or in the parent
	at org.apache.hop.core.database.Database.connectUsingClass(Database.java:427)
	at org.apache.hop.core.database.Database.normalConnect(Database.java:368)
	... 14 more
Caused by: java.lang.ClassNotFoundException: Unable to load class 'net.ucanaccess.jdbc.UcanaccessDriver' in this classloader or in the parent
	at org.apache.hop.core.plugins.HopURLClassLoader.loadClass(HopURLClassLoader.java:97)
	at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:526)
	at org.apache.hop.core.database.Database.connectUsingClass(Database.java:402)
	... 15 more
Caused by: java.lang.ClassNotFoundException: net.ucanaccess.jdbc.UcanaccessDriver
	at java.base/java.net.URLClassLoader.findClass(URLClassLoader.java:445)
	at org.apache.hop.core.plugins.HopURLClassLoader.loadClassFromThisLoader(HopURLClassLoader.java:67)
	at org.apache.hop.core.plugins.HopURLClassLoader.loadClass(HopURLClassLoader.java:92)
	... 17 more

[bamaer]

I don't have any access db files locally so can't test try to reproduce right now.
Can you try moving the ucanaccess jar file from lib/jdbc to lib/core?

[KBoersch]

That results in this:

Error connecting to database [cegedim] :org.apache.hop.core.exception.HopDatabaseException: 
Error occurred while trying to connect to the database

Driver class 'net.ucanaccess.jdbc.UcanaccessDriver' could not be found, make sure the 'Microsoft Access database' driver (jar file) is installed.
Could not initialize class net.ucanaccess.jdbc.UcanaccessDriver


org.apache.hop.core.exception.HopDatabaseException: 
Error occurred while trying to connect to the database

Driver class 'net.ucanaccess.jdbc.UcanaccessDriver' could not be found, make sure the 'Microsoft Access database' driver (jar file) is installed.
Could not initialize class net.ucanaccess.jdbc.UcanaccessDriver


	at org.apache.hop.core.database.Database.normalConnect(Database.java:383)
	at org.apache.hop.core.database.Database.connect(Database.java:314)
	at org.apache.hop.core.database.DatabaseFactory.getConnectionTestReport(DatabaseFactory.java:49)
	at org.apache.hop.core.database.DatabaseFactory.getConnectionTestResults(DatabaseFactory.java:74)
	at org.apache.hop.core.database.DatabaseMeta.testConnectionSuccess(DatabaseMeta.java:2113)
	at org.apache.hop.ui.core.database.DatabaseMetaEditor.testConnection(DatabaseMetaEditor.java:903)
	at org.apache.hop.ui.core.database.DatabaseMetaEditor.test(DatabaseMetaEditor.java:766)
	at org.apache.hop.ui.core.database.DatabaseMetaEditor.lambda$createButtonsForButtonBar$6(DatabaseMetaEditor.java:958)
	at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:91)
	at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4321)
	at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1208)
	at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4119)
	at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3707)
	at org.apache.hop.ui.hopgui.HopGui.open(HopGui.java:481)
	at org.apache.hop.ui.hopgui.HopGui.main(HopGui.java:359)
Caused by: org.apache.hop.core.exception.HopDatabaseException: 
Driver class 'net.ucanaccess.jdbc.UcanaccessDriver' could not be found, make sure the 'Microsoft Access database' driver (jar file) is installed.
Could not initialize class net.ucanaccess.jdbc.UcanaccessDriver

	at org.apache.hop.core.database.Database.connectUsingClass(Database.java:427)
	at org.apache.hop.core.database.Database.normalConnect(Database.java:368)
	... 14 more
Caused by: java.lang.NoClassDefFoundError: Could not initialize class net.ucanaccess.jdbc.UcanaccessDriver
	at java.base/java.lang.Class.forName0(Native Method)
	at java.base/java.lang.Class.forName(Class.java:421)
	at java.base/java.lang.Class.forName(Class.java:412)
	at org.apache.hop.core.database.Database.connectUsingClass(Database.java:422)
	... 15 more
Caused by: java.lang.ExceptionInInitializerError: Exception net.ucanaccess.exception.UcanaccessRuntimeException: org.hsqldb.jdbc.JDBCDriver [in thread "main"]
	at net.ucanaccess.jdbc.UcanaccessDriver.<clinit>(UcanaccessDriver.java:42)
	... 19 more

[bamaer]

definitely ticket material in that case.

[hansva]

As a workaround you can do the following:

I'm taking a look why it isn't working anymore because driver class is still the same as before