Hi,
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.
Dhiraj.
Related Tutorials/Questions & Answers:
Lock while inserting/updating database in multithreaded.
Lock while inserting/
updating database in
multithreaded. Hi,
I am having a
multithreaded process which replicates the data from many table to one...
inserting/
updating to
database. I dont know what is the issue but it was never
multithreaded program help!!!!
multithreaded program help!!!! Write a
multithreaded program that calculates various statistical values for a list of numbers. This program will be passed a series of numbers on the command line and will then create three
Advertisements
getting error while inserting values in database
getting error
while inserting values in database AddUser.java
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import...) {
out.println("An Error Had occurred
while accessing the
database
lock on a class
lock on a class hello,
Can a
lock be acquired on a class?
hiii,,
Yes, a
lock can be acquired on a class. This
lock is acquired on the class's Class object
Java lock
Java lock Can a
lock be acquired on a class
Java lock
Java lock Can a
lock be acquired on a class
how to check dates while retrieving data from database
how to check dates
while retrieving data from database i want to update
database record based on delivery date i have tried this query but it wont work
b="update deliveryorder set prtnm='"+arr[1]+"',stn='"+arr[0]+"',sbston
Java file lock
,
it will not be prevented from accessing the file
while the file
lock is
mandatory on other...Java file
lock
In this section, you will learn how to
lock a file.
The behavior of the file
lock is platform-dependent. The file
lock is
advisory on some
difference between lock and synchronization
difference between
lock and synchronization Hi,
I am new in java please anyone tell me difference between
lock and synchronization in java.
its urgent.
Thank in advance
Please visit the following link:
Lock
Java lock file or folder.
Java
lock file or folder. Is it possible to create a desktop application to
lock or encrypt file or folder in windows by using java code??
if possible can provide some reference??
because i can't find it...
thanks
Java object's lock
Java object's lock What is an object's
lock and which object's have locks
Java thread lock
Java thread lock What happens when a thread cannot acquire a
lock on an object
Maven Dependency lock >> 1.0.0
You should include the dependency code given in this page to add Maven Dependency of com.auth0 >>
lock version1.0.0 in your project
while and do while
while and do while hello,
What is the difference between a
while statement and a do statement?
hello,
A
while statement checks at the beginning of a loop to see whether the next loop
iteration should occur. A do
database
database dateofbirth is not save into the
database while i am enter from html browser.it shows as null.whats the reason
Maven Dependency lock-sms >> 1.0.0
You should include the dependency code given in this page to add Maven Dependency of com.auth0 >>
lock-sms version1.0.0 in your project
Share on Google+