Problems with temporary tables created in callable functions - Mailing list pgsql-jdbc

Hi
I have a an application that uses a lot of stored functions, some of them which create temporary tables and refcursors that point to the tables. Something that comes up occasionally are errors like

This is when we have some code in the function to delete existing temporary tables.
ERROR: relation with OID xxxxx does not exist.
ERROR: relation "TEMPSTOCKVALUEALERT" already exists

When we comment that code we get errors like
ERROR: relation "TEMPSTOCKANALYSIS" already exists. This happens every second call to the function.

In the jdbc call code we have setAutoCommit to false, And I have tried a couple of options when preparing the call  like

        CallableStatement proc = con.prepareCall("{ ? = call \"queryStockAnalysisSingle\" ( ?,?,?,? ) }"
        ,ResultSet.CONCUR_READ_ONLY,ResultSet.CLOSE_CURSORS_AT_COMMIT);

        CallableStatement proc = con.prepareCall("{ ? = call \"queryStockAnalysisSingle\" ( ?,?,?,? ) }"
        ,ResultSet.CONCUR_READ_ONLY,ResultSet.HOLD_CURSORS_OVER_COMMIT);

None of them seem to work. Has anybody faced this problem? And hopefully cone up with a usable fix.
The application has a commons-dbcp maintaining a connection pool to the database server. The jdbc driver used is the jdbc3. THe database version is 7.4.x. It has been deployed on a Debian Linux system with kernel version 2.6.8.

Thanks
Akhil Srinivasan