Lock while inserting/updating database in multithreaded.

Home Answers Viewqa JDBC Lock while inserting/updating database in multithreaded.

Dhiraj Jain

Lock while inserting/updating database in multithreaded.
0 Answer(s) a year and 4 months ago
Posted in : JDBC

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

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

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

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

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

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

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

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

database
database dateofbirth is not save into the database while i am enter from html browser.it shows as null.whats the reason

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 thread lock
Java thread lock What happens when a thread cannot acquire a lock on an object

Java object's lock
Java object's lock What is an object's lock and which object's have locks

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

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 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 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
= con.createStatement(); ResultSet rs = stmt.executeQuery("Select * from country"); while... * from state where countryid="+id+" "); while(rs.next()){ buffer

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

Database books
to synchronize data with your central database management system, while maintaining... Database books- Page 6 ...) increases. The probability of lock contention on data pages also increases

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

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

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

Truncating issue while parsing XML with SAX Parser.
Truncating issue while parsing XML with SAX Parser. I am Parsing one xml file and after parsing I have to enter the data into the database using hibernate. The problem is while parsing some elements, its not getting the complete

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

Error with Maven while deploying the war file
Error with Maven while deploying the war file Hi, I am new to maven... I created java spring hibernate project.. and i kept all .java files... and database. in beans i kept dispatch-servlet.xml and in database i kept

Isolation level is used by the DBMS.
Isolation level is used by the DBMS. What isolation level is used by the DBMS when inserting, updating and selecting rows from a database

Error with Maven while deploying the war file
Error with Maven while deploying the war file Hi, I am new to maven... I created java spring hibernate project.. and i kept all .java files..., config and database. in beans i kept dispatch-servlet.xml and in database i kept

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

How to make one waiting thread for lock - Java Beginners
can i force or acquire another thread for lock . Finally how to know thread is released from lock. Explain types of lock(like method level and block level

Handle Null Pointer Exception while text file upload
Handle Null Pointer Exception while text file upload I want the code... for null pointer exception. The cause for null pointer exception is while uploading text file into database if a different text file is selectedi.e...,my db

Fetch Records from SQL database and convert into XML file
stating that it will lock the view while accessing the database so that new..." Concept while implementing the code it means stating that it will lock the view while accessing the database so that new records will not get insert into the same

Hibernate Criteria Lockmode
Hibernate Criteria Lockmode setLockMode is a method of Hibernate Criteria API. You can use a lock mode in the following way Criteria criteria...(); Iterator iterator = list.iterator(); while (iterator.hasNext

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

Connection to Database
pages. Each page is configured to connect to my SQL database to query data... are using the same shared hosting packages with no such error while joomla... I manually make a connection to MySQL database in my web pages? How joomla

Database Error - Hibernate
Database Error Hi, I am working with Struts 1.2---- AJAX-----Hibernate 3.0 --- MySQL 5.0. At the time of inserting/fetching from Database by multiple/single users I am getting the following errors. Lock wait timeout

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

jComboBox with database
my database. But in my code its only get data from first item which... * from staffs where dept_name like'"+str+"'"); while(rs.next

Sorting data in a jsp using a servlet while implementing comparable - JSP-Servlet
Sorting data in a jsp using a servlet while implementing comparable Hi Sorry for being not so clear before. I have 3 records in my database. I want to sort them according to their respective headings. Here's the code I have

Database,Java
Database,Java help me for the following things if one customer... me the how to write the query in MySQL database and i want coding for this one...[] = new byte[formDataLength]; int byteRead = 0; int totalBytesRead = 0; while

database - SQL
while SQL Server offers full Transaction Support

MySQL Database Training
; Inserting, Updating and Deleting Records... MySQL Database Training ... MySQL data with SQL. How to create a simple MySQL database Table

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

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

While and do-while
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 a particular

read value from database & alert it is available in database or not
read value from database & alert it is available in database or not how to read value from text box and alert whether it is available in database... where username='"+name+"'"); int count=0; while(rs.next

java database connection - JDBC
java database connection sir i want to join my project with MS access database. i am making my project in netbeans.please tell me the coding to do... the data into the MS Access database and retrieve the data from the database table

Ask Questions?

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.

Tutorial Topics