Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
Clear All
new posts

    Batching SELECT statements in server-side code

    Hi,

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

    Thanks.

    #2
    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.

    Comment

    Working...
    X