oracle - Having trouble debugging a Java/DB error where data is being put into wrong record -
this happens infrequently , unable reproduce problem because of it. running jave ee web app on weblogic oracle backend. store pdf records in database blobs. happening sometimes--very rarely--when pdf blob being saved, being saved wrong user's row. not has original user's pdf not been saved, user's pdf has been overwritten wrong information! stored procedure called update/insert table.
does seem might session-related error? records in pdf table have unique id serves primary key. pk referenced when adding or updating row in pdf table. can make operation more thread-safe? assume happening because multiple users updating @ same time , somehow uids mixed up. said, happens , haven't been able reproduce or find easy solution while looking @ source code. on right track? suggestions?
Comments
Post a Comment