java (jdbc, ms sql server) how to get an indication that my query was executed? -

my application queries database (non-queries too).

i show user indeterminate progressbar while transaction.

the problem don't know when close progressbar, because have no indication or signal object of query completion.

if queries taking long need progress bar, i'd recommend taking hard @ database see how can speed them up.

since database operation blocks, know it's done when return.

the progress bar suggests need kind of polling mechanism check metric indicates how have , how many have been done. since don't give details, can guess might be.

but ajax call in jsp poll , update progress bar need.