You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@griffin.apache.org by Youzha <yu...@gmail.com> on 2021/02/25 19:12:54 UTC

Error Read Oracle JDBC Source

Hi, I'm trying to do some PROFILING with Oracle JDBC Source but i've some
problem with this error message below

[image: image.png]

this is my config json :

{
  "name": "prof_batch",
  "process.type": "batch",
  "data.sources": [
    {
      "name": "source",
      "connector": {
        "type": "jdbc",
        "config": {
          "user": "user",
          "password": "pass",
          "tablename":"testing",
          "database": "databasetest",
          "url":"jdbc:oracle:thin:@//192.168.56.101:1521/databasetest",
          "driver": "oracle.jdbc.OracleDriver"
        }
      }
    }
  ],
  "evaluate.rule": {
    "rules": [
      {
        "dsl.type": "griffin-dsl",
        "dq.type": "PROFILING",
        "out.dataframe.name": "prof",
        "rule" : "source.IDENTITY_ID.count()",
        "out": [
          {
            "type": "record",
            "name": "tes.json"
          }
        ]
      }
    ]
  },
  "sinks": [
     "HDFSSink"
  ]
}

I've try to execute the query manual from dbeaver tools and it works. is
there any something that i've missed on griffin? please advice