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 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









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
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
Advertisements
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
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
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 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
ModuleNotFoundError: No module named 'multithreaded_chicken'
ModuleNotFoundError: No module named 'multithreaded_chicken'  Hi...: No module named 'multithreaded_chicken' How to remove the ModuleNotFoundError: No module named 'multithreaded_chicken' error? Thanks   Hi
ModuleNotFoundError: No module named 'multithreaded_chicken'
ModuleNotFoundError: No module named 'multithreaded_chicken'  Hi...: No module named 'multithreaded_chicken' How to remove the ModuleNotFoundError: No module named 'multithreaded_chicken' error? Thanks   Hi
ModuleNotFoundError: No module named 'multithreaded_chicken'
ModuleNotFoundError: No module named 'multithreaded_chicken'  Hi...: No module named 'multithreaded_chicken' How to remove the ModuleNotFoundError: No module named 'multithreaded_chicken' error? Thanks   Hi
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
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
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
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
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
database
database  dateofbirth is not save into the database while i am enter from html browser.it shows as null.whats the reason
while and do while
while and do while  hello, What is the difference between a while statement and a do statement?   hello,ADS_TO_REPLACE_1 A while statement checks at the beginning of a loop to see whether the next loop iteration
While and do-while
While and do-while       Nested classes Here is another advantage of the Java, object-oriented programming language that allows us to define a class within another
The while and do
While and do-while       Lets try to find out what a while statement does. In a simpler language, the while statement continually executes a block of statements while
database
database  how to get information about database like, what are the names of tables that database includes ? what are the names of fields in corresponding tables ? in mysql database on linux environment   Here is a code
database
database  database
database
database  database application
database
database  How can i get combo box values from database?? or how... of combo box in java - from database? you had given me the answer <%@page...("Select * from country"); while(rs.next()){ %> <option value="<
database
database  the code for initializing the database connection
Erron while
Erron while   Hi, i'm doing a project regarding xml. I want to extract all nodes from body of existing xml doc to make another xml with that data.Here is my coding and error showing on that coding.Could anybody help to know my
database
database  i want to let the user select the name of database and then delete that database.......im doing project in swings netbeans
while & do..while Loop
while & do..while Loop while loop The while loop iterate until provided condition is true. Given below the syntax : while (condition)  ...; <?php $j=1; while($j<=3) { echo "Value of j" . $j . "<
database
database  use of hyperlink to show the data from database
database
database  i need to insert time in my database. i need a code to insert time in my database. its very urgent
database
database  i am created one table in mysql database with one... or not. If it is already exist in database, then show a message 'Already exists...+"'"); int count=0; while(rs.next()) { count
database
database  im doing my project in netbeans swings...wn a user wants to create a database from the gui...i want to display an error msg if a database with that name already exists and if it does not exist new database should
database
database  tell me use about database and give me a small program.   It is secure and can easily be accessed, managed, and updated. Moreover... links: Connect JSP with database Mysql Connect Java with database Mysql
database
database  tell me use about database and give me a small program.   It is secure and can easily be accessed, managed, and updated. Moreover... links: Connect JSP with database Mysql Connect Java with database Mysql
database
database  tell me use about database and give me a small program.   It is secure and can easily be accessed, managed, and updated. Moreover... links: Connect JSP with database Mysql Connect Java with database Mysql
database
database  I wanted to know if it is possible to create a database in mysql by letting the user enter the name of the database in swing gui..im doing my project in netbeans...Thank You
database
database  I wanted to know if it is possible to establish database connection on a remote pc with mysql using java swings from netbeans and then create a database on the remote pc.... Kindly help me
DATABASE
DATABASE  How can i get combo box values from database?? or how can i get values in the drop down menu of the html which is similar to dat of combo box in java - from database
Database
Database  How to represent data from database in a tree?   Please visit the following link: Retrieve data from database in tree using Java Swing
Database
Database  I am working in jsf2.Fro a demo i created database in ms access.no wi want to retrive a record from database for a particular data.I need help as I am stuck
Database
Database  from java code i have to retrieve some data from a database, which is present in a different timezone. Scenario :- My database... in database timezone is 9PM 15APR2012. I want to retrieve something from database
DATABASE
DATABASE  I can't send different information from different form into a single table in my database
Database
Database  Can i get a code for database connectivity Myeclipse 3.3 to MySql manager 2005
database
database  sir.. how we can uplaod the database in the data file(ms access)please send me a solution
database
database  how we ca upload the data in the database file(ms access
database
database  hi i want to develop one patient database can any one provide me the guide
database
database  In my project where u helped me to display the databases present im mysql database on the Jlist and then the respective tables in that database on another jlist and then the column names on another jlist I dont want
database
database  In my project,i want the user to specify the name of the database he wants to create in mysql and then also the name of the table along with the column names he wants in that database....Im doing my project in netbeans
database
database  Im doing my project in java swings...netbeans I wanted java source code to establish connection to postgresql_8.1 using jdbc and create a user defined database and a table in that database and insert values Plz help me
database
database  Can you please help me to establish database connection to ms sql 2000 from java swing in netbeans
database
database  i need optimised searching algorithm to retrieve the data from the database and optimised ranking algorithm to display the reults into the user

Ads