The combination of cursor type and parallelism is not supported

30 Views Asked by At

I'm use next code in method run of some thread:

RowSetFactory rowSetFactory = RowSetProvider.newFactory();
@Cleanup CachedRowSet rowSet = rowSetFactory.createCachedRowSet();
...
...
...
rowSet.setCommand(execSql);
rowSet.setPageSize(100);
rowSet.execute(sourceConnection);

when i set page size into cachedRowSet i've got exception:

The combination of cursor type and parallelism is not supported.

if i use code without it, i have;nt exception.

in this case i make select from table with 20k rows it was take some time. I think if I'll use batch processing I reduce it.

0

There are 0 best solutions below