JAMon will show that connections aren't being closed (as well as Statements, and ResultSets). It won't show precisely in your code this is happening though. JAMon has a
jdbc proxy driver that allows you to also measure performance of all queries, which is also useful, and it requires no code changes, so it is worth a try.
http://www.jamonapi.com