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
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
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
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
database
database dateofbirth is not save into the
database while i am enter from html browser.it shows as null.whats the reason
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
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
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
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
database
database i want to let the user select the name of
database and then delete that
database.......im doing project in swings netbeans
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