Hi Mustafa,
You can't set fetch type for flexiblesearch queries. But you can use FlexibleSearchService to translate flexiblesearch queries to SQL Query and you can execute with hybris' jdbc wrapper. here is a code example:
final FlexibleSearchQuery flexibleSearchQuery = new FlexibleSearchQuery("SELECT {pk} from {Product}");
final TranslationResult result = flexibleSearchService.translate(flexibleSearchQuery);
final String sqlQuery = result.getSQLQuery();
final List<Object> params = result.getSQLQueryParameters();
final Connection connection = Registry.getCurrentTenant().getDataSource().getConnection();
PreparedStatement stmt = connection.prepareStatement(sqlQuery);
for (int i = 0; i < params.size(); ++i) {
stmt.setString(i + 1, params.get(i).toString());
}
final ResultSet resultSet = stmt.executeQuery();
Now you have a result set based on flexiblesearch query.
But you have to use it carefully. if your query retrieves 1 million rows, the JVM heap memory may not be good enough to hold that large amount of data. You may want to set fetch size for the result set.
stmt.setFetchSize(1000);
You may also want to look at https://docs.oracle.com/javase/8/docs/api/java/sql/ResultSet.html#setFetchSize-int- and please note that the JDBC drivers have different default fetch size.
regards, Seref
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.