Note that there are some explanatory texts on larger screens.

plurals
  1. USDima R.
    primarykey
    data
    text
    plurals
    1. COJeff, Thanks a lot. I did all this, and here is what I came up with : "Current Consumers =1" and "Consumers High" and "Consumers total" all =1. Now, You say that I "should see a count >1 if your application that is supposed to read the message is listening on the queue. " Does it mean, that there is something wrong, since I see =1, not > 1? ???
      singulars
    2. COZeus, what I meant was if the result of a stored procedure has not one, but 10 results set. Imagine a 10 selects in a stored procedure - than you get multiple result sets. I know q.list() would bring a result, but my question was how to "navigate" between those 10 results set - not each individual one. That is how to know that one result was processed and go to another. I know how to do it with plain JDBC. wanted to know how in Hibernate, without turning to JDBC.
      singulars
    3. COSantiago, thanks. Our DBA in a "friendly" manner strongly urged NOT to pass in the string of comma-separated values. I went with another way - I run a small stored procedure first, that takes a list of ALL of the ids I need, places them into stationary temp table. Then in the stored Procedure that is in question here, I take top 1000 from that and put into a #temp table, this way I run the 2nd stored procedure N/1000+1 number of times called form Java loop. This take a little time, but it is of no issue to us. No memory leaks and results match to what is expected. Everyone is happy. Thanks
      singulars
 

Querying!

 
Guidance

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload