Account Balance verification with Java and Hibernate HQL?

Question

I have following properties in my current Account Balance object: long id; // Database ID Date date; // date when this balance object was created boolean currentBalanceFlag; // indicates this is the most recent balance float amount; // the total sum currently in the account balance float depositAmount; // amount deposited that resulted in this objects amount float withdrawalAmount; // amount withdrawn that resulted in this objects amount Balance lastBalance; // last balance object for traversing User user; // owner of the balance String note; // detailed description of transaction that resulted in current blanace There are only two actions performed on the balance. Deposits and withdrawals. ###The question is: ###How do I create HQL query that will: -sum all the `depositAmount` for `user` -sum all `withdrawalAmount` for `user` -subtract result of the first summation from second summation -compare result of subtraction with the `amount` for `user` in `Balance` object that has `currentBalanceFlag` equal to `true` in pseudo code: resultAmount = select ( sum(depositAmount) - sum(withdrawalAmount) ) from Balance where user=user amount = select amount from Balance where user=user and currentBalanceFlag=true And the final boolean result I'd like to get from single call to the database with HQL query: resultAmount == amount

Answer 1

Hello, this is really difficult to read due to formatting. The interface provides a way to input code directly into the question text. If you look at the buttons above the text box, the 13th button in my toolbar is the code button.

If you click it, it will give you a formatted area that allows you to put your code in for others to view. You can even choose the language that the code is in so that it will properly format and I believe probably provide at least a somewhat passable amount of syntax highlighting.