ksql-jdbc-driver icon indicating copy to clipboard operation
ksql-jdbc-driver copied to clipboard

jdbc query tool - Feature not supported: getMoreResult

Open joefromct opened this issue 5 years ago • 4 comments

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]

joefromct avatar May 23 '19 20:05 joefromct

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 avatar May 23 '19 20:05 mmolimar

Can you try it with the new version?

mmolimar avatar Aug 05 '19 15:08 mmolimar

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.

holgerbrandl avatar Oct 02 '19 10:10 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.

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

AndreaTosti avatar Mar 02 '20 12:03 AndreaTosti