Understanding Exception Handling in Java: Best Practices and Common Pitfalls

Why does my SQL scalar function sometimes throws "Subquery returned more than 1 value. This is not permitted..."?