[HOP-4612] Generic database connection not working with DBMaker database in Hop version 2.1.0

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.1.0
• Fix Version/s: Migrated to GHI
• Component/s: Database
• Labels: DBMaker Database
• Environment: Linux Pop!_OS 20.04 LTS, java version "11.0.15" 2022-04-19 LTS
• Assignee: Hans Van Akelyen
• Reporter: Alexinaldo Santos Costa
• Created: 19/Nov/22 15:25
• Updated: 20/Mar/23 09:10
• Resolved: 20/Mar/23 09:10

Description

I use a database called DBMaker with Apache Hop since version 1.0.0 and up to version 1.2.0 it works perfectly. But in version 2.1.0 I could no longer connect to DBMaker, the following error occurs when trying to connect:

Error connecting to database [dbmaker ] :org.apache.hop.core.exception.HopDatabaseException: 
Error occurred while trying to connect to the databaseError connecting to database: (using class dbmaker.sql.JdbcOdbcDriver)
[DBMaker] fail to establish a connection,  (1503, [DBMaker] cannot connect to server [netconn. 1116],115,0,0)
org.apache.hop.core.exception.HopDatabaseException: 
Error occurred while trying to connect to the databaseError connecting to database: (using class dbmaker.sql.JdbcOdbcDriver)
[DBMaker] fail to establish a connection,  (1503, [DBMaker] cannot connect to server [netconn. 1116],115,0,0)
    at org.apache.hop.core.database.Database.normalConnect(Database.java:330)
    at org.apache.hop.core.database.Database.connect(Database.java:261)
    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:2042)
    at org.apache.hop.ui.core.database.DatabaseMetaEditor.testConnection(DatabaseMetaEditor.java:832)
    at org.apache.hop.ui.core.database.DatabaseMetaEditor.test(DatabaseMetaEditor.java:719)
    at org.apache.hop.ui.core.database.DatabaseMetaEditor.lambda$createButtonsForButtonBar$6(DatabaseMetaEditor.java:887)
    at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:89)
    at org.eclipse.swt.widgets.Display.sendEvent(Display.java:5796)
    at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1529)
    at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:5025)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:4477)
    at org.apache.hop.ui.core.dialog.ShowMessageDialog.open(ShowMessageDialog.java:252)
    at org.apache.hop.ui.core.database.DatabaseMetaEditor.testConnection(DatabaseMetaEditor.java:853)
    at org.apache.hop.ui.core.database.DatabaseMetaEditor.test(DatabaseMetaEditor.java:719)
    at org.apache.hop.ui.core.database.DatabaseMetaEditor.lambda$createButtonsForButtonBar$6(DatabaseMetaEditor.java:887)
    at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:89)
    at org.eclipse.swt.widgets.Display.sendEvent(Display.java:5796)
    at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1529)
    at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:5025)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:4477)
    at org.apache.hop.ui.hopgui.HopGui.open(HopGui.java:404)
    at org.apache.hop.ui.hopgui.HopGui.main(HopGui.java:305)
Caused by: org.apache.hop.core.exception.HopDatabaseException: 
Error connecting to database: (using class dbmaker.sql.JdbcOdbcDriver)
[DBMaker] fail to establish a connection,  (1503, [DBMaker] cannot connect to server [netconn. 1116],115,0,0)    at org.apache.hop.core.database.Database.connectUsingClass(Database.java:425)
    at org.apache.hop.core.database.Database.normalConnect(Database.java:315)
    ... 23 more
Caused by: java.sql.SQLException: [DBMaker] fail to establish a connection,  (1503, [DBMaker] cannot connect to server [netconn. 1116],115,0,0)
    at dbmaker.sql.JdbcOdbc.JDBCError(JdbcOdbc.java:260)
    at dbmaker.sql.JdbcOdbcConnection.initialize(JdbcOdbcConnection.java:255)
    at dbmaker.sql.JdbcOdbcConnection.<init>(JdbcOdbcConnection.java:128)
    at dbmaker.sql.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:208)
    at org.apache.hop.core.database.DelegatingDriver.connect(DelegatingDriver.java:45)
    at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677)
    at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:189)
    at org.apache.hop.core.database.Database.connectUsingClass(Database.java:409)
    ... 24 moreHostname:    
Port:    
Database name:    
Url:    jdbc:DBMaker://${DBMAKER_HOST}:${DBMAKER_PORT}/${DBMAKER_DATABASE} 

Steps to reproduce the behavior:

# DBMaker

• Download and install DBMaker -> DBMaker 5.4.4 Linux - Platform x64: Linux2.x86_64
• Add environment variable -> export LD_LIBRARY_PATH=/home/dbmaker/5.4/lib/so:$LD_LIBRARY_PATH
• Create a new database or use the default DBSAMPLE5 database (without password) to connect (Server Address: 127.0.0.1 / Port Number: 2453 / Username: SYSADM / Database: DBSAMPLE5)

# Hop

• Add environment variable -> export LIBPATH=/home/dbmaker/5.4/lib/so:$LIBPATH 
• Add environment variable -> export HOP_SHARED_JDBC_FOLDER=/opt/hop-jdbc
• Copy DBMaker JDBC driver dmjdbc30.jar from /home/dbmaker/5.4/lib/java folder to /opt/hop-jdbc folder

# Hop Gui

• Create a Relational Database Connection of type Generic Database according to the following image:

• Click the Test button to view the error

 Remembering that in Hop version 1.2.0 it works perfectly.