jdbc query tool - Feature not supported: getMoreResult

[joefromct]

Hi,

I'm happily connecting to ksql with a built/complied jar driver with a jdbc query tool.

I can run creates, shows, selects, describes, etc.

However, after I run anything at all, i seem to get the error message Feature not supported: getMoreResults.

Anyone else getting this?

Thanks,

show streams;

STREAM_NAME                             STREAM_TOPIC                     STREAM_FORMAT
--------------------------------------  -------------------------------  ----------------
my_stream                               my_topic                         JSON

1 record(s) selected [Fetch MetaData: 0ms] [Fetch Data: 2ms]

>[Error] Script lines: 1-2 --------------------------
Feature not supported: getMoreResults.

[Executed: 5/23/2019 3:37:32 PM] [Execution: 206ms]

[mmolimar]

Great @joefromct
All spec in JDBC isn't implemented. That's why.
Probably, in future versions we'll have more support to the spec.

[mmolimar]

Can you try it with the new version?

[holgerbrandl]

I'm having a similar issues. I've just built the current master and configured a JDBC data source in Intellij/Pycharm. The connection can be established, but no matter what statement I execute the error is always [2019-10-02 12:51:50] Feature not supported: setFetchSize.

Example query: SELECT * FROM pageviews LIMIT 5;

I'd happily test any workaround or new versions.

[AndreaTosti]

I'm having a similar issues. I've just built the current master and configured a JDBC data source in Intellij/Pycharm. The connection can be established, but no matter what statement I execute the error is always [2019-10-02 12:51:50] Feature not supported: setFetchSize.

Example query: SELECT * FROM pageviews LIMIT 5;

I'd happily test any workaround or new versions.

To get around the problem just add the following to the bottom of the KsqlStatement.scala code:
override def setFetchSize(rows: Int): Unit = {}