Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How does implement AbstractSqlTypeValue in Multi-Threading environmnt

 
abhi chaturvedi
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic