11:07 p.m.
vijay sharma created AS7-3707:
---------------------------------
Summary: AS 7.0.2 Final with 64bits redhat linux
Key: AS7-3707
URL: https://issues.jboss.org/browse/AS7-3707
Project: Application Server 7
Issue Type: Feature Request
Components: Server
Affects Versions: 7.0.2.Final
Environment: RHEL 5.4
Reporter: vijay sharma
Assignee: Jason Greene
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