[Bug]: Não consigo conectar no jdbc openedge.jar

[saulosilveiradasilva]

Apache Hop version?

2.9.0

Java version?

17

Operating system

Windows

What happened?

O jdbc openedge.jar funciona no squirrel no mesmo servidor onde roda o apache hop. Coloquei o opendedge.jar na pasta ..\hop\lib\jdbc e usei a opção Metadata - Relational Database Connection. E no connection type utilizei Generic Database e mostra o erro abaixo:

Obs.: A conexão utilizada na opção Manual Connection URL funciona no Squirrel

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

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

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

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

at org.apache.hop.core.database.Database.normalConnect(Database.java:373)
at org.apache.hop.core.database.Database.connect(Database.java:304)
at org.apache.hop.core.database.DatabaseFactory.getConnectionTestReport(DatabaseFactory.java:47)
at org.apache.hop.core.database.DatabaseFactory.getConnectionTestResults(DatabaseFactory.java:72)
at org.apache.hop.core.database.DatabaseMeta.testConnectionSuccess(DatabaseMeta.java:2127)
at org.apache.hop.ui.core.database.DatabaseMetaEditor.testConnection(DatabaseMetaEditor.java:901)
at org.apache.hop.ui.core.database.DatabaseMetaEditor.test(DatabaseMetaEditor.java:764)
at org.apache.hop.ui.core.database.DatabaseMetaEditor.lambda$createButtonsForButtonBar$6(DatabaseMetaEditor.java:956)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:89)
at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4256)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1066)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4054)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3642)
at org.apache.hop.ui.hopgui.HopGui.open(HopGui.java:475)
at org.apache.hop.ui.hopgui.HopGui.main(HopGui.java:352)

Caused by: org.apache.hop.core.exception.HopDatabaseException:
Driver class '' could not be found, make sure the 'Generic database' driver (jar file) is installed.
Unable to load class '' in this classloader or in the parent

at org.apache.hop.core.database.Database.connectUsingClass(Database.java:417)
at org.apache.hop.core.database.Database.normalConnect(Database.java:358)
... 14 more

Caused by: java.lang.ClassNotFoundException: Unable to load class '' 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:525)
at org.apache.hop.core.database.Database.connectUsingClass(Database.java:392)
... 15 more
Caused by: java.lang.ClassNotFoundException:
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

Custom URL: jdbc:datadirect:openedge://172.22.52.222:51616;databaseName=ems2cad
Custom Driver Class: null

Issue Priority

Priority: 0

Issue Component

Component: Metadata

[bamaer]

you need to specify the openedge jdbc driver classname (try com.ddtek.jdbc.openedge.OpenEdgeDriver) when using a generic connection.