1) Create connection
2) Create temp table
3) Insert into temp table
4) Call SP
5) Return from SP
6) Close connection
Is this code fool-proof against synchronization
are there chances of 2 threads using the same connection object
and hence the same temp tables ?
Is there a possibility of multiple temp tables being created ?
I think, therefore I exist -- Rene Descartes
"Two different client threads could access the same table through two different connections. ."
Every call to this method will try create/override the existing temp tables.
Every call to this method will try create/override the existing temp tables.
SCJP 1.4, SCWCD 1.3, SCBCD 1.3
Originally posted by PNS Subramanian:
The issue here is one of temp tables not getting dropped.
'Make everything as simple as possible, but not simpler.' --Albert Einstein
I think, therefore I exist -- Rene Descartes
This is about code that gets called from POJO. There is no EJB involved here. Its a Java to backend SP call.
SCJP 1.4, SCWCD 1.3, SCBCD 1.3
Don't get me started about those stupid light bulbs. |