The stored proc only does 1 thing: write a timestamp to a database table.
I can see the record being inserted but my webservice does not execute the next line after calling the stored procedure method.
What could be wrong?
Joined: Apr 13, 2009
You never close your connection.
In regards to the line:
1. How many open connections are you allowed to have?
2. Will .getConnection wait synchronously until it can get one, or will it eventually throw an error?
Joined: May 13, 2009
thanks for your reply. I was using the connection pool in glassfish. Anyway, after much troubleshooting, I found out that the problem was due to glassfish 2.1 not supporting jdk6 on AIX. Here's the thread which I posted on glassfish forum: