How to apply Fetch Size in queries using Object Mapping?

[Angela Sun]

I'm trying to use Accessor annotated interface to do queries, which is part of the Object Mapping API.  Would it be possible to apply something similar to Set Fetch Size in Prepared Statement?

Thanks,

Angela

[Olivier Michallat]

Hi Angela,

One thing you can do is have your method return a Statement, on which you can set the fetch size before executing it. However you lose the ability to map your query results, so I agree that the mapper should have better support for this.

This is quite similar to JAVA-540, so I'm adding a comment there to remember to address fetch size.

--

Olivier Michallat

Driver & tools engineer, DataStax

To unsubscribe from this group and stop receiving emails from it, send an email to java-driver-us...@lists.datastax.com.

[Olivier Michallat]

On second thought, JAVA-540 is a bit different because it does not relate to accessors. I've created JAVA-762.

--

Olivier Michallat

Driver & tools engineer, DataStax

[Angela Sun]

Thank you!

Angela

[Alex Popescu]

On Tuesday, May 12, 2015 at 3:20:42 PM UTC-7, Angela Sun wrote:

Thank you!

Angela

Based on your use case would these options change at runtime or are they set once? 

-- 

Bests,

Alex Popescu | @al3xandru

Sen. Product Manager @ DataStax

[Angela Sun]

Hi,

The fetch size would be set once in my application.

Angela