Lock while inserting/updating database in multithreaded.
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.
View Answers
Ads
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
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
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
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
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
While creating a jar how to add MySQL database to project
While creating a jar how to add MySQL database to project Hi, Please tell me how to attach MySQL database to the Java project while building a jar or their is any other process
While creating a jar how to add MySQL database to project Hi, Please tell me how to attach MySQL database to the Java project while building a jar or their is any other process
a multithreaded program by creating a subclass of Thread
a multithreaded program by creating a subclass of Thread I want The threads will execute the following output in the suitable interface. like...; } } while(thread1IsAlive || thread2IsAlive
a multithreaded program by creating a subclass of Thread I want The threads will execute the following output in the suitable interface. like...; } } while(thread1IsAlive || thread2IsAlive
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
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
How to delete the row from the Database by using while loop in servlet
How to delete the row from the Database by using while loop in servlet ... server database by using Servlet program (Tomcat server). In Database table... details. While loop is not terminate, in while loop why If condition
How to delete the row from the Database by using while loop in servlet ... server database by using Servlet program (Tomcat server). In Database table... details. While loop is not terminate, in while loop why If condition
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
, 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
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 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
Adding image to database through jsp or HTML page ,while adding only image should show.
Adding image to database through jsp or HTML page ,while adding only image should show. Adding image to database through jsp or HTML page,while adding only image should show. After that i need view that uploaded image from
Adding image to database through jsp or HTML page ,while adding only image should show. Adding image to database through jsp or HTML page,while adding only image should show. After that i need view that uploaded image from
While retrieving text from database onto JSP, the alignment of line and paragraphs is not followed
While retrieving text from database onto JSP, the alignment of line and paragraphs is not followed I have stored text database through textarea box. While trying to retrieve the same text from db, the text displayed onto
While retrieving text from database onto JSP, the alignment of line and paragraphs is not followed I have stored text database through textarea box. While trying to retrieve the same text from db, the text displayed onto
show null point Exception """ while trying 2 load a JComboBox"" data is fetch from database ms-access
show null point Exception """ while trying 2 load a JComboBox"" data is fetch from database ms-access import javax.swing.*; import java.awt...."); JOptionPane.showMessageDialog(null,"connected to database
show null point Exception """ while trying 2 load a JComboBox"" data is fetch from database ms-access import javax.swing.*; import java.awt...."); JOptionPane.showMessageDialog(null,"connected to database
show null point Exception """ while trying 2 load a JComboBox"" data is fetch from database ms-access
show null point Exception """ while trying 2 load a JComboBox"" data is fetch from database ms-access import javax.swing.*; import java.awt...."); JOptionPane.showMessageDialog(null,"connected to database
show null point Exception """ while trying 2 load a JComboBox"" data is fetch from database ms-access import javax.swing.*; import java.awt...."); JOptionPane.showMessageDialog(null,"connected to database
show null point Exception """ while trying 2 load a JComboBox"" data is fetch from database ms-access
show null point Exception """ while trying 2 load a JComboBox"" data is fetch from database ms-access import javax.swing.*; import java.awt...."); JOptionPane.showMessageDialog(null,"connected to database
show null point Exception """ while trying 2 load a JComboBox"" data is fetch from database ms-access import javax.swing.*; import java.awt...."); JOptionPane.showMessageDialog(null,"connected to database
Version of com.auth0>lock-googleplus dependency
List of Version of com.auth0>lock-googleplus dependency
List of Version of com.auth0>lock-googleplus dependency
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
You should include the dependency code given in this page to add Maven Dependency of com.auth0 >> lock version1.0.0 in your project
What is an object's lock and which object's have locks?
What is an object's lock and which object's have locks? Hi, What is an object's lock and which object's have locks? Thanks
What is an object's lock and which object's have locks? Hi, What is an object's lock and which object's have locks? Thanks
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
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
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-facebook >> 1.0.0
You should include the dependency code given in this page to add Maven Dependency of com.auth0 >> lock-facebook version1.0.0 in your project
You should include the dependency code given in this page to add Maven Dependency of com.auth0 >> lock-facebook version1.0.0 in your project
Maven Dependency lock-googleplus >> 1.0.0
You should include the dependency code given in this page to add Maven Dependency of com.auth0 >> lock-googleplus version1.0.0 in your project
You should include the dependency code given in this page to add Maven Dependency of com.auth0 >> lock-googleplus version1.0.0 in your project
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
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
