Batching SELECT statements in server-side code

[user316]

Hi,

Is it possible to batch multiple SELECT statements in server-side code, and get back each result set at the same time?

Thanks.

[Isomorphic]

If the results of each select have the same columns, you could do this via a UNION query using <customSQL>.

Outside of that, what did you have in mind? While JDBC has PreparedStatement.addBatch(), that's not valid for SELECT, only modifications and DDLs. However, if you are aware of JDBC-driver specific APIs that would let you do batching, the framework lets you write your own JDBC code directly and still participate in automatic transactions and other features.