Jboss AS 7.0.2 issue with RedHat 64 bits linux

sharma.vijay16 Feb 10, 2012 10:55 AM

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)

I have the same question (0)