Forum Discussion

crina's avatar
crina
Occasional Contributor
5 years ago

An error occured [getFetchSize()] is not supported

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

 

 

  • crina's avatar
    crina
    5 years ago

    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 

  • richie's avatar
    richie
    Community Hero
    5 years ago
    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's avatar
    nmrao
    Champion Level 3
    5 years ago
    Like to specify full select statement?
    • sonya_m's avatar
      sonya_m
      SmartBear Alumni (Retired)
      5 years ago

      Rao, Richie - thank you!

       

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

      • crina's avatar
        crina
        Occasional Contributor
        5 years ago

        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