In my latest application I am using 3 tier architecture.
1.Glassfish(V2) as the app server
2. frontend is a web application (JSF)
3. enterprisedb database
also using ejb as business components.
In my application i have written a stored procedure to calculate the interest of all existing customers. Also i used a return parameter inside the procedure. Procedure is working well.
But when i am calling the stored procedure from my ejb, some time is gives 'NullPointer Exception' but the procedure is excuted and the interest calulated successfully.
Here i am using connetion pool to connct to the database.
It is never occour all the time. but sometime it will occour.