posted 13 years ago
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