[ https://issues.jboss.org/browse/AS7-3707?page=com.atlassian.jira.plugin.s... ] vijay sharma updated AS7-3707: ------------------------------ Description: Hi- This is quite blocking for us because we are moving first time with jboss on Redhat linux. I have sqlserver 2008 R2 running on windows 2008 R2 and application is installed on RHEL. Deployment works fine on RHEL.Also Im running one use case which works fine with my windows 2008 server r2 but it gets failed on RHEL. Im using 64bits jdk 1.6.22: -------------- Current thread has not commited in more than [60] seconds and may incur unwanted blocking locks. Please refactor code to commit more frequently. 23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) while executing select TSL_ID from TIMESHEET_LOCK where TIMESHEET_LOCK.CLIENT_ID=1 AND EMP_ID=? and ? between TSL_START_DATE and TSL_END_DATE Parameters (1140,2012-02-06 00:00:00.0) 23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) [SQL] select TSL_ID from TIMESHEET_LOCK where TIMESHEET_LOCK.CLIENT_ID=1 AND EMP_ID='1140' and CAST('02/06/2012 00:00:00' AS DATETIME) between TSL_START_DATE and TSL_END_DATE 23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) com.workbrain.server.jsp.locale.LocalizedException: Current thread has not commited in more than [60] seconds and may incur unwanted blocking locks. Please refactor code to commit more frequently. 23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) while executing select TSL_ID from TIMESHEET_LOCK where TIMESHEET_LOCK.CLIENT_ID=1 AND EMP_ID=? and ? between TSL_START_DATE and TSL_END_DATE Parameters (1140,2012-02-06 00:00:00.0) 23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) [SQL] select TSL_ID from TIMESHEET_LOCK where TIMESHEET_LOCK.CLIENT_ID=1 AND EMP_ID='1140' and CAST('02/06/2012 00:00:00' AS DATETIME) between TSL_START_DATE and TSL_END_DATE 23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at com.workbrain.tool.jdbc.proxy.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:126) 23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at com.workbrain.app.jsp.action.dailytimesheet.TimesheetHelper.isTimesheetLocked(TimesheetHelper.java:1141) 23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at com.workbrain.app.jsp.action.dailytimesheet.TimesheetHelper.isTimesheetLocked(TimesheetHelper.java:1149) 23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at com.workbrain.app.jsp.action.dailytimesheet.TimesheetDayModel.displayLockColumn(TimesheetDayModel.java:1043) 23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at com.workbrain.app.jsp.action.dailytimesheet.TimesheetDayModel.displayBeforeWorkSummary(TimesheetDayModel.java:651) 23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at com.workbrain.app.jsp.action.dailytimesheet.TimesheetDayModel.displayDay(TimesheetDayModel.java:197) 23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at org.apache.jsp.dailytimesheet.dailyTimesheet_jsp._jspService(dailyTimesheet_jsp.java:1415) 23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) 23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) 23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:369) 23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:326) 23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:253) 23:20:48,836 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) 23:20:48,836 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329) 23:20:48,836 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) 23:20:48,836 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:734) 23:20:48,836 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:541) 23:20:48,836 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:479) 23:20:48,836 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:407) 23:20:48,836 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at org.apache.jasper.runtime.PageContextImpl.doForward(PageContextImpl.java:706) 23:20:48,836 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.java:677) was: Hi- This is quite blocking for us because we are moving first time with jboss on Redhat linux. I have sqlserver 2008 R2 running on windows 2008 R2 and application is installed on RHEL. Deployment and everything works fine on windows box but when when i run same scenerio on linux box then i get following error message: -------------- Current thread has not commited in more than [60] seconds and may incur unwanted blocking locks. Please refactor code to commit more frequently. 23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) while executing select TSL_ID from TIMESHEET_LOCK where TIMESHEET_LOCK.CLIENT_ID=1 AND EMP_ID=? and ? between TSL_START_DATE and TSL_END_DATE Parameters (1140,2012-02-06 00:00:00.0) 23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) [SQL] select TSL_ID from TIMESHEET_LOCK where TIMESHEET_LOCK.CLIENT_ID=1 AND EMP_ID='1140' and CAST('02/06/2012 00:00:00' AS DATETIME) between TSL_START_DATE and TSL_END_DATE 23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) com.workbrain.server.jsp.locale.LocalizedException: Current thread has not commited in more than [60] seconds and may incur unwanted blocking locks. Please refactor code to commit more frequently. 23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) while executing select TSL_ID from TIMESHEET_LOCK where TIMESHEET_LOCK.CLIENT_ID=1 AND EMP_ID=? and ? between TSL_START_DATE and TSL_END_DATE Parameters (1140,2012-02-06 00:00:00.0) 23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) [SQL] select TSL_ID from TIMESHEET_LOCK where TIMESHEET_LOCK.CLIENT_ID=1 AND EMP_ID='1140' and CAST('02/06/2012 00:00:00' AS DATETIME) between TSL_START_DATE and TSL_END_DATE 23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at com.workbrain.tool.jdbc.proxy.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:126) 23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at com.workbrain.app.jsp.action.dailytimesheet.TimesheetHelper.isTimesheetLocked(TimesheetHelper.java:1141) 23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at com.workbrain.app.jsp.action.dailytimesheet.TimesheetHelper.isTimesheetLocked(TimesheetHelper.java:1149) 23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at com.workbrain.app.jsp.action.dailytimesheet.TimesheetDayModel.displayLockColumn(TimesheetDayModel.java:1043) 23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at com.workbrain.app.jsp.action.dailytimesheet.TimesheetDayModel.displayBeforeWorkSummary(TimesheetDayModel.java:651) 23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at com.workbrain.app.jsp.action.dailytimesheet.TimesheetDayModel.displayDay(TimesheetDayModel.java:197) 23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at org.apache.jsp.dailytimesheet.dailyTimesheet_jsp._jspService(dailyTimesheet_jsp.java:1415) 23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) 23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) 23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:369) 23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:326) 23:20:48,835 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:253) 23:20:48,836 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) 23:20:48,836 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329) 23:20:48,836 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) 23:20:48,836 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:734) 23:20:48,836 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:541) 23:20:48,836 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:479) 23:20:48,836 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:407) 23:20:48,836 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at org.apache.jasper.runtime.PageContextImpl.doForward(PageContextImpl.java:706) 23:20:48,836 INFO [stdout] (http-usallperfapp02.infor.com-10.38.53.56-8080-5) at org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.java:677) -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira