0 Replies Latest reply on Feb 10, 2012 10:55 AM by vijay sharma

    Jboss AS 7.0.2 issue with RedHat 64 bits linux

    vijay sharma Newbie

      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)