Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
The moose likes Tomcat and the fly likes Multiple processors running same update more than once Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Products » Tomcat
Bookmark "Multiple processors running same update more than once" Watch "Multiple processors running same update more than once" New topic
Author

Multiple processors running same update more than once

Ishan Shekhar
Greenhorn

Joined: Jan 20, 2011
Posts: 1
Hi,

Below is my log in which i am making a insert on a table but the insert is having two times, please suggest.
as you can see from the logs
[http-8080-Processor22] and [http-8080-Processor24] are making the same insert more than once.


2011-01-20 22:33:34,203 [http-8080-Processor22] DEBUG com.vsnl.admin.dao.WorklistDAO - query executing select * from worklist_mst where worklist_id ='88'
2011-01-20 22:33:34,375 [http-8080-Processor24] DEBUG com.vsnl.admin.dao.WorklistDAO - query executing select * from worklist_mst where worklist_id ='88'
2011-01-20 22:33:36,015 [http-8080-Processor22] DEBUG com.vsnl.admin.dao.WorklistDAO - after executing the select query
2011-01-20 22:33:36,015 [http-8080-Processor22] DEBUG com.vsnl.admin.dao.WorklistDAO - after executing the select query 1
2011-01-20 22:33:36,015 [http-8080-Processor22] DEBUG com.vsnl.admin.dao.WorklistDAO - after executing the select query 1 plsssss
2011-01-20 22:33:36,187 [http-8080-Processor24] DEBUG com.vsnl.admin.dao.WorklistDAO - after executing the select query
2011-01-20 22:33:36,187 [http-8080-Processor24] DEBUG com.vsnl.admin.dao.WorklistDAO - after executing the select query 1
2011-01-20 22:33:36,187 [http-8080-Processor24] DEBUG com.vsnl.admin.dao.WorklistDAO - after executing the select query 1 plsssss
2011-01-20 22:33:36,609 [http-8080-Processor22] DEBUG com.vsnl.admin.dao.WorklistDAO - before executing update!
2011-01-20 22:33:36,609 [http-8080-Processor22] DEBUG com.vsnl.admin.dao.WorklistDAO - query executing insert into WORKLIST_HIST(WORKLIST_ID,START_DATE,PROP_END_DATE,OWNER,DEPARTMENT,COMMENTS,STATUS,DATE_MODIFIED) values(?,?,?,?,?,?,?,sysdate)
2011-01-20 22:33:36,781 [http-8080-Processor24] DEBUG com.vsnl.admin.dao.WorklistDAO - before executing update!
2011-01-20 22:33:36,796 [http-8080-Processor24] DEBUG com.vsnl.admin.dao.WorklistDAO - query executing insert into WORKLIST_HIST(WORKLIST_ID,START_DATE,PROP_END_DATE,OWNER,DEPARTMENT,COMMENTS,STATUS,DATE_MODIFIED) values(?,?,?,?,?,?,?,sysdate)
2011-01-20 22:33:37,218 [http-8080-Processor22] DEBUG com.vsnl.admin.dao.WorklistDAO - result of update statement: 1
2011-01-20 22:33:37,390 [http-8080-Processor24] DEBUG com.vsnl.admin.dao.WorklistDAO - result of update statement: 1
2011-01-20 22:33:39,609 [http-8080-Processor22] DEBUG com.vsnl.admin.dao.WorklistDAO - inside getwrklistdetails
2011-01-20 22:33:39,609 [http-8080-Processor22] DEBUG com.vsnl.admin.dao.WorklistDAO - inside getwrklistdetails department 1
2011-01-20 22:33:39,609 [http-8080-Processor22] DEBUG com.vsnl.admin.dao.WorklistDAO - inside getwrklistdetails owner 1
in try
2011-01-20 22:33:39,781 [http-8080-Processor24] DEBUG com.vsnl.admin.dao.WorklistDAO - inside getwrklistdetails
2011-01-20 22:33:39,781 [http-8080-Processor24] DEBUG com.vsnl.admin.dao.WorklistDAO - inside getwrklistdetails department 1
2011-01-20 22:33:39,781 [http-8080-Processor24] DEBUG com.vsnl.admin.dao.WorklistDAO - inside getwrklistdetails owner 1
 
 
subject: Multiple processors running same update more than once
 
Similar Threads
Oracle JDBC Thin Client behaviour concerning date data types and it's format.
Hibernate StackOverflowError: bidirectional many-to-many
Will tomcat creates a new session for every forward to a jsp page
HowTo Disable Logging Output for classes using commons.logging
struts2 CreateQurey