I am having a multithreaded process which replicates the data from many table to one table. My process runs on 4 threads and all are having different connection sessions. I am also handling transaction in such a way that I commit at the end of each transaction and rollback at the time of error. After each transaction I give back the connection to connection pool for re-use.
My problem is, from past 1month, I am facing one issue which is like: One of my thread get struct while inserting/updating to database. I dont know what is the issue but it was never coming for me for last 6 months but from past 1month, it is coming again n again. Above all there are no logs also in .ora of SQL. I rebuild all my indexes, updated my sequence cache but still problem exists.
I changed my process to run for 1 thread also, but still problem is coming. I dont know what is the issue and also I am not finding any proper answer. This problem is not coming at development site but its coming at deployment site only. I verified all database indexes. I am using ojdbc5.jar for jdbc connection.
Please help me out, its killing me. Thanks in advance.
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.