Kindly find below steps of execution: Single-Threading Environment: 1. Dao execute procedure by calling org.springframework.jdbc.object.StoredProcedure.execute(Map inParams) which is inside StoredProcedureForCreate which extends org.springframework.jdbc.object.StoredProcedure 2. Then above execute call createTypeValue() of my custom Model class which extends org.springframework.jdbc.core.support.AbstractSqlTypeValue. 3. Here Model class is nothing but preparing STRUCT[] object which has all the inputs parameter for procedure. 4. It works fine and got return result in Dao .
Multi-Threading Environment: 5. Now I have create one class which extend Thread and calling Dao from Threads’s run() method. 6. Same steps as above. (from 1-3) 7. Getting below exception in execute method in StoredProcedureForCreate class:
org.springframework.jdbc.UncategorizedSQLException: CallableStatementCallback; uncategorized SQLException for SQL [{call PKG_LOAD.sp_bulk_trx(?, ?, ?, ?)}]; SQL state [72000]; error code [8103]; ORA-08103: object no longer exists
; nested exception is java.sql.SQLException: ORA-08103: object no longer exists
java.sql.SQLException: ORA-08103: object no longer exists
CallableStatementCallback; uncategorized SQLException for SQL [{call PKG_LOAD.sp_bulk_trx(?, ?, ?, ?)}]; SQL state [72000]; error code [8103]; ORA-08103: object no longer exists
{call PKG_LOAD.sp_bulk_trx(?, ?, ?, ?)}Null
Kindly suggest what's wrong with my multi-threading implementation.
Thanks in Advance
Don't get me started about those stupid light bulbs.