Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Multiple processors running same update more than once

 
Ishan Shekhar
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic