search

alexradzin / aerospike-jdbc-driver

JDBC driver for Aerospike
Apache License 2.0
12 stars 3 forks source link

Fetch size other than 1 is not supported right now #7

Closed Sakiand closed 4 years ago

Sakiand commented 4 years ago

Hi,

On every query there is an exception of "Fetch size other than 1 is not supported right now". Which connection param should be set in order to make it work?

alexradzin commented 4 years ago

It is strange. Could you please submit more details? What kind of client are you using? What is the JDBC url you are using to connect? I suppose that you try to use the drive from java code and call setFetchSize() on your statement. At least this is the only place where this exception is thrown.

Sakiand commented 4 years ago

We want to be able to query the data from DataGrip. In your example Squirrel is used but i don't think its related. So i registered you driver: image And the connection string looks like: image

I able to view and navigate all metadata. But when i ran any query that for example supported in aql i'm getting the error: Fetch size other than 1 is not supported right now

Sakiand commented 4 years ago

Ok i tried with squirrel. There is another issue: returned number of rows is always 0. image

Running the same query from aql returns results: image

alexradzin commented 4 years ago

Thank you for details. The issue of setFetchSize() is fixed. Now it does not throw exception but just produces warning and ignores unsupported value. You can download the new version of the driver in order to get this feature.

However I do not really understand why squirel does not work for you. I thought that probably the problem is in your set name that consists of digits only. However I tried similar test and it worked fine for me. May I ask you to run the following commands and send me the result?

insert into ADITOR."200" (PK, value) values (1, 'one'),  (2, 'two'), (3, 'three')

select * from ADITOR."200"

select value from ADITOR."200"

Could you please send show me your jdbc URL? You sent me duplicate screen capture by mistake. If you connect to your namespace ADITOR you can omit its name in your queries and refer to the table directly: select * from "200". Could you also expand tables in Squirel and tell me whether you can see your table?

Thank you very much in advance for your help.

alexradzin commented 4 years ago

The original issue (fetchSize) have been fixed. Unfortunately author of the post stopped responding, so I cannot continue to help him. So, I am closing the issue because I have nothing to do here.

Sakiand commented 4 years ago

Hi, My apologies. I missed the before last one message.