My program calls an Oracle PL/SQL function which returns a ref cursor to a ResultSet object. I know that the function runs to completion relatively quickly when i run it in an anonymous block but when the call is made through my Java application the resultset takes about 30 mins to return. Below is a snippet of my code:
By adding the following line of code and putting the jamon jar in your class path you can get performance metrics for all of the method calls on Connections/Statements/ResultSets and the other jdbc interface method calls. In addtion you will get performance stats on all SQL issued. For a full accounting of what jamon can do for monitoring sql and jdbc look at the site mentioned below. If all goes well tonite I will release jamon 2.2.