Uploaded image for project: 'CloverDX'
  1. CloverDX
  2. CLO-6970

JDBC url in Designer: '\t' in path is interpreted as tab char

    XMLWordPrintable

    Details

    • Branch:
    • QA Testing:
      GUI manual test

      Description

      When connection url contains \t the connection stops working in GUI.

      E.g., connection with this url: jdbc:sqlite:C:\temp\tsqlite\sqlite3_test.db causes failure when used in DBInputTable and it's query dialog is opened.

      It probably fails in various places in the GUI. One of the stacktraces:

      java.lang.reflect.InvocationTargetException
      	at com.cloveretl.gui.wizard.metadata.db.ExtractSchemaOperation.run(ExtractSchemaOperation.java:62)
      	at com.cloveretl.gui.wizard.metadata.db.SchemaNode.run(SchemaNode.java:146)
      	at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:119)
      Caused by: org.jetel.exception.JetelRuntimeException: Can't connect to DB: path to 'C:/Users/user/workspace-runtime/escaping/data-in	sqlite\sqlite3_test.db': 'C:\Users\user\workspace-runtime\escaping\data-in	sqlite' does not exist
      	at org.jetel.connection.jdbc.DBConnectionImpl.createConnection(DBConnectionImpl.java:944)
      	at org.jetel.connection.jdbc.DBConnectionImpl.connect(DBConnectionImpl.java:969)
      	at org.jetel.connection.jdbc.DBConnectionImpl.getConnection(DBConnectionImpl.java:351)
      	at org.jetel.connection.jdbc.AbstractDBConnection.getConnection(AbstractDBConnection.java:92)
      	at com.cloveretl.gui.wizard.metadata.db.AbstractSchemaOperation.getSqlConnection(AbstractSchemaOperation.java:94)
      	at com.cloveretl.gui.wizard.metadata.db.ExtractSchemaOperation.run(ExtractSchemaOperation.java:40)
      	... 2 more
      Caused by: java.sql.SQLException: path to 'C:/Users/user/workspace-runtime/escaping/data-in	sqlite\sqlite3_test.db': 'C:\Users\user\workspace-runtime\escaping\data-in	sqlite' does not exist
      	at org.sqlite.Conn.open(Conn.java:103)
      	at org.sqlite.Conn.<init>(Conn.java:57)
      	at org.sqlite.JDBC.connect(JDBC.java:67)
      	at org.jetel.connection.jdbc.specific.impl.AbstractJdbcSpecific.connect(AbstractJdbcSpecific.java:112)
      	at org.jetel.connection.jdbc.DBConnectionImpl.createConnection(DBConnectionImpl.java:942)
      	... 7 more
      

      We should either escape backslashes or fix the gui.
      Attached project contains setup examples with sqlite and MSAccess connections.

      Validating the connection in Connection Wizard works and graph can use these connections in runtime.

        Attachments

          Activity

            People

            Assignee:
            slamam Martin Slama
            Reporter:
            salamonp Pavel Salamon
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: