1

I am trying to connect to Crate as a Streamsets Data collector pipeline origin ( JDBC Consumer ). However I get this error: "JDBC_00 - Cannot connect to specified database: com.streamsets.pipeline.api.StageException: JDBC_06 - Failed to initialize connection pool: com.zaxxer.hikari.pool.PoolInitializationException: Exception during pool initialization: ERROR: SQLParseException: line 1:13: no viable alternative at input 'CHARACTERISTICS' " Why am I getting this error ? The Crate JDBC Driver version is 2.1.5 and Streamsets Data collector version is 2.4.0.0.

gashey
  • 13
  • 2
  • Could you post the full stack trace to the StreamSets sdc-user Google Group? See https://streamsets.com/community for details. You could also try the Crate Google Group: https://groups.google.com/forum/#!forum/crateio – metadaddy Mar 13 '17 at 04:22
  • 1
    I have done so. – gashey Mar 14 '17 at 05:07
  • 1
    Problem solved. Within Streamsets DC I had to uncheck Enforce Read-only Connection on the Advanced tab of my JDBC query consumer configuration. – gashey Mar 14 '17 at 15:32
  • Great! You should add this as the answer to the question! – metadaddy Mar 15 '17 at 04:53

1 Answers1

1

@gashey already solved the issue. Within Streamsets DC uncheck Enforce Read-only Connection on the Advanced tab of my JDBC query consumer configuration (see https://groups.google.com/forum/?utm_medium=email&utm_source=footer#!msg/crateio/hBexxel2KQw/kU34mrsJBgAJ).

We will update the streamsets-documentation with the workaround. https://crate.io/docs/tools/streamsets/

Michael Beer
  • 96
  • 4