An error occured [getFetchSize()] is not supported

[crina]

Hi,

I try to. execute an select function on a table from database of amazon dynamodb, but this error occured:

An error occured [getFetchSize()] is not supported

I have installed ready api trial version 3.2.5 on macos pc. on 64 biti

also i have java installed on 64 bit vs. 1.8.0_251

i have JDBC driver for dynamodb from CDATA company 

Also the connection to the database is succesful

[richie]

Hi @crina,

I dont have any experience of querying a NoSQL database and i understand theres various ways of querying....using SQL, XQUERY, etc., but id suggest if you have a successful db connection, then the issue is with the command you executed.

Does dynsamodb support SQL? If yes, are you using SQL to query?

Have you tried the simplest query possible? E.g. SELECT * FROM TABLE;

Did you include a fetch in the command you executed?

Ta

Rich

[nmrao]

Like to specify full select statement?

[sonya_m]

Rao, Richie - thank you!

Hi @crina , have you tried the suggestions above? Did they work?

[crina · Accepted solution]

hi, so i contact CDATA provider for jar file, maybe is because of JDBC jar file.

I also found a solution to automate connection with dynamodb with java, amazon gives an sdk for java 

[sonya_m]

So you found a solution @crina ! I am glad to hear that. Thank you for sharing - I am sure this info will help some community members in the future.