vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| HI All, I have a problem with calling stored procedure in multithreaded environment. This procedure utilizes session table to collect data and cursor to return it back to java application . When 10 threads are trying to use the same stored procedure, once one of the thread finishes up and returns connection back to the pool I'm getting exception from all other 9 stored procedures : com.ibm.db2.jdbc.app.DB2DBException: SC_PE00003 in QTEMP type *FILE not found. SC_PE00003 is my temporary table within the stored procedure. I've even tried to establish new connection from each thread thinking that session table will be unique within the connection, but looks like they are still sharing temporary table probably because my application runs as a batch job. I'm stuck. I can't figure out what to do ?. How I can make these session tables be unique within the stored procedure, or if it's impossible at least within the connection. Thanks, Roman |
| Thread Tools | |
| Display Modes | |
|
|