cancel
Showing results for 
Search instead for 
Did you mean: 

getFetchSize() is not supported.

Highlighted
Contributor

getFetchSize() is not supported.

I know this issue is probably a duplicate, but I am asked to post it anyway. I am trying to connect to a cosmos DB via SoapUI by using a JDBC driver that I have downloaded from Cdata, and here are the results:

1- The Build Sql Query works fine - please see the attached file 'buildSqlQuery.png'

2- When I try to run the step in the test case, then I get the "getFetchSize() is not supported." message. - please see the attached 'testStepError'. 

 

My question is whether any one knows the cause of the error 'getFetchSize() is not supported.', and what can I do to solve it. 

 

 

7 REPLIES 7
Highlighted
Community Hero

Re: getFetchSize() is not supported.

Hey @tech321,

@crina found a workaround late in 2019 ....please see
https://community.smartbear.com/t5/SoapUI-Pro/An-error-occured-getFetchSize-is-not-supported/m-p/202...

I actually knew this so dont know why i didnt suggest this last time this popped up, but cosmosdb has exposed REST APIs that allows you to query via REST rather than jdbc. This looks like its due to a driver issue so querying via REST would get you round this rather than using the amazon sdk option i linked to.

Cheers,

Rich
if this helped answer the post, could you please mark it as 'solved'? Also if you consider whether the title of your post is relevant? Perhaps if the post is solved, it might make sense to update the Subject header field of the post to something more descriptive? This will help people when searching for problems. Ta
Highlighted
Contributor

Re: getFetchSize() is not supported.

Thanks richie for the link. Sorry it is probably me that can not find the solution in the link you have suggested. I am not sure whether the solution is supposed to be in the "1 ACCEPTED SOLUTION" section or in the replies or some where else. I appriciate more elaborate answer.

Highlighted
Community Hero

Re: getFetchSize() is not supported.

Hey @tech123,

I googled "amazon sdk java jdbc connection dynamodb" and there are a number of links that might help.

I believe that the previous forum user who resolved this issue did something like this.

I cant be more help i'm afraid cos ive never tried setting up a cosmos/dynamodb connection before.
To be honest, i think the REST request option is probably easier.

Nice one

Rich
if this helped answer the post, could you please mark it as 'solved'? Also if you consider whether the title of your post is relevant? Perhaps if the post is solved, it might make sense to update the Subject header field of the post to something more descriptive? This will help people when searching for problems. Ta
Highlighted
Contributor

Re: getFetchSize() is not supported.

And how does that REST request option work? 

Highlighted
Contributor

Re: getFetchSize() is not supported.

Can @crina help with explaining how the work around works?

Highlighted
Community Manager

Re: getFetchSize() is not supported.

@tech321 the REST option Richie mentions they describe earlier as this:

>>

I actually knew this so dont know why i didnt suggest this last time this popped up, but cosmosdb has exposed REST APIs that allows you to query via REST rather than jdbc. This looks like its due to a driver issue so querying via REST would get you round this

<<

 

Thank you @richie for suggesting this! Also, is there anything you could clarify more for tech321?


Sonya Mihaljova
Community and Education Specialist

Learn SmartBear products in a fun and easy way and prove your knowledge!
>>Participate in the TechCorner Challenge today
Highlighted
Contributor

Re: getFetchSize() is not supported.

Thanks, I am not sure how to use the Rest option instead of of the JDBC. Is there any example of that? Or is there any documentation from SoapUI about that?  please advise

New Here?
Join us and watch the welcome video:
Announcements
Top Kudoed Authors