Uploaded image for project: 'Apache Hop (Retired)'
  1. Apache Hop (Retired)
  2. HOP-4612

Generic database connection not working with DBMaker database in Hop version 2.1.0

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 2.1.0
    • Migrated to GHI
    • Database
    • Linux Pop!_OS 20.04 LTS, java version "11.0.15" 2022-04-19 LTS

    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.

       

      Attachments

        1. image-2022-11-19-12-19-31-458.png
          36 kB
          Alexinaldo Santos Costa
        2. image-2022-11-23-00-57-25-422.png
          100 kB
          Alexinaldo Santos Costa
        3. image-2022-11-23-01-00-15-150.png
          160 kB
          Alexinaldo Santos Costa

        Activity

          People

            hansva Hans Van Akelyen
            ayronmax Alexinaldo Santos Costa
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: