This week's giveaway is in the EJB and other Java EE Technologies forum.
We're giving away four copies of EJB 3 in Action and have Debu Panda, Reza Rahman, Ryan Cuprak, and Michael Remijan on-line!
See this thread for details.
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 EJB 3 in Action this week in the EJB and other Java EE Technologies 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
 
Don't get me started about those stupid light bulbs.
 
subject: Multiple processors running same update more than once
 
Similar Threads
struts2 CreateQurey
Hibernate StackOverflowError: bidirectional many-to-many
Will tomcat creates a new session for every forward to a jsp page
Oracle JDBC Thin Client behaviour concerning date data types and it's format.
HowTo Disable Logging Output for classes using commons.logging