-
Type: Bug
-
Resolution: Fixed
-
Priority: Major
-
Affects Version/s: 0.7.2
-
Component/s: None
-
None
session timeout後にブラウザで、Ajaxに関する処理を行うと、
例外が多数発生。
一部抜粋
ErrorCode=0, SQLState=42601)が発生しました
at org.seasar.framework.util.PreparedStatementUtil.executeQuery(PreparedStatementUtil.java:37)
at org.seasar.extension.jdbc.impl.BasicResultSetFactory.createResultSet(BasicResultSetFactory.java:36)
at org.seasar.extension.jdbc.impl.BasicSelectHandler.createResultSet(BasicSelectHandler.java:173)
at org.seasar.extension.jdbc.impl.BasicSelectHandler.execute(BasicSelectHandler.java:162)
at org.seasar.extension.jdbc.impl.BasicSelectHandler.execute(BasicSelectHandler.java:133)
at org.seasar.extension.jdbc.impl.BasicSelectHandler.execute(BasicSelectHandler.java:120)
at org.seasar.dao.impl.SelectDynamicCommand.execute(SelectDynamicCommand.java:55)
at org.seasar.dao.interceptors.S2DaoInterceptor.invoke(S2DaoInterceptor.java:53)
at org.seasar.dao.pager.PagerS2DaoInterceptorWrapper.invoke(PagerS2DaoInterceptorWrapper.java:64)
at org.seasar.tugboat.gtd.contents.task.dao.TaskRelationsDao$$EnhancedByS2AOP$$149f041$$MethodInvocation$$getDefau ltFolderTasks5.proceed(MethodInvocationClassGenerator.java)
at org.seasar.framework.aop.interceptors.TraceInterceptor.invoke(TraceInterceptor.java:59)
at org.seasar.tugboat.gtd.contents.task.dao.TaskRelationsDao$$EnhancedByS2AOP$$149f041$$MethodInvocation$$getDefau ltFolderTasks5.proceed(MethodInvocationClassGenerator.java)
at org.seasar.tugboat.gtd.contents.task.dao.TaskRelationsDao$$EnhancedByS2AOP$$149f041.getDefaultFolderTasks(TaskR elationsDao$$EnhancedByS2AOP$$149f041.java)
at org.seasar.tugboat.gtd.contents.task.service.impl.TaskServiceImpl.getDefaultFoloderTasks(TaskServiceImpl.java:2 56)
at org.seasar.tugboat.gtd.contents.task.service.impl.TaskServiceImpl$$EnhancedByS2AOP$$11402c4.$$getDefaultFoloder Tasks$$invokeSuperMethod$$(TaskServiceImpl$$EnhancedByS2AOP$$11402c4.java)
at org.seasar.tugboat.gtd.contents.task.service.impl.TaskServiceImpl$$EnhancedByS2AOP$$11402c4$$MethodInvocation$$ getDefaultFoloderTasks3.proceed(MethodInvocationClassGenerator.java)
at org.seasar.framework.aop.impl.NestedMethodInvocation.proceed(NestedMethodInvocation.java:45)
at org.seasar.extension.tx.RequiredInterceptor.invoke(RequiredInterceptor.java:40)
at org.seasar.framework.aop.impl.NestedMethodInvocation.proceed(NestedMethodInvocation.java:43)
at org.seasar.framework.aop.interceptors.TraceInterceptor.invoke(TraceInterceptor.java:59)
at org.seasar.framework.aop.impl.NestedMethodInvocation.proceed(NestedMethodInvocation.java:43)
at org.seasar.framework.aop.interceptors.ThrowsInterceptor.invoke(ThrowsInterceptor.java:64)
at org.seasar.framework.aop.impl.NestedMethodInvocation.proceed(NestedMethodInvocation.java:43)
at org.seasar.framework.aop.interceptors.InterceptorChain.invoke(InterceptorChain.java:42)
at org.seasar.tugboat.gtd.contents.task.service.impl.TaskServiceImpl$$EnhancedByS2AOP$$11402c4$$MethodInvocation$$ getDefaultFoloderTasks3.proceed(MethodInvocationClassGenerator.java)
at org.seasar.tugboat.gtd.contents.task.service.impl.TaskServiceImpl$$EnhancedByS2AOP$$11402c4.getDefaultFoloderTa sks(TaskServiceImpl$$EnhancedByS2AOP$$11402c4.java)
at org.seasar.tugboat.gtd.contents.task.page.impl.TaskAjaxImpl.getDefaultFolderTasks(TaskAjaxImpl.java:501)
at org.seasar.tugboat.gtd.contents.task.page.impl.TaskAjaxImpl$$EnhancedByS2AOP$$114d18f.$$getDefaultFolderTasks$$ invokeSuperMethod$$(TaskAjaxImpl$$EnhancedByS2AOP$$114d18f.java)
at org.seasar.tugboat.gtd.contents.task.page.impl.TaskAjaxImpl$$EnhancedByS2AOP$$114d18f$$MethodInvocation$$getDef aultFolderTasks0.proceed(MethodInvocationClassGenerator.java)
at org.seasar.tugboat.gtd.container.interceptor.AjaxMethodInterceptor.invoke(AjaxMethodInterceptor.java:54)
at org.seasar.tugboat.gtd.contents.task.page.impl.TaskAjaxImpl$$EnhancedByS2AOP$$114d18f$$MethodInvocation$$getDef aultFolderTasks0.proceed(MethodInvocationClassGenerator.java)
at org.seasar.tugboat.gtd.contents.task.page.impl.TaskAjaxImpl$$EnhancedByS2AOP$$114d18f.getDefaultFolderTasks(Tas kAjaxImpl$$EnhancedByS2AOP$$114d18f.java)
at sun.reflect.GeneratedMethodAccessor440.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.seasar.framework.util.MethodUtil.invoke(MethodUtil.java:49)
at org.seasar.framework.beans.impl.BeanDescImpl.invoke(BeanDescImpl.java:207)
at org.seasar.teeda.ajax.AjaxServlet.doAjax(AjaxServlet.java:112)
at org.seasar.teeda.ajax.AjaxServlet.doGet(AjaxServlet.java:65)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.seasar.extension.filter.EncodingFilter.doFilter(EncodingFilter.java:62)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.seasar.framework.container.filter.S2ContainerFilter.doFilter(S2ContainerFilter.java:63)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:261)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:767)
at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:697)
at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:889)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:686)
at java.lang.Thread.run(Thread.java:595)
Caused by: org.seasar.framework.exception.SSQLException: [ESSR0072]SQLで例外(SQL=[--
– select task library info
–
SELECT
A.RECS AS INBOX_TASKS
,B.RECS AS TODAY_TASKS
,C.RECS AS WEEK_TASKS
,D.RECS AS HOLD_TASKS
,E.RECS AS SOMEDAY_TASKS
,F.RECS AS TODAY_TODO_TASKS
,G.RECS AS TODAY_DOING_TASKS
,H.RECS AS TODAY_DONE_TASKS
,I.RECS AS ARCHIVE_TASKS
,J.RECS AS TRASH_BOX_TASKS
FROM
(
SELECT
COUNT AS RECS
FROM
task_relations R
INNER JOIN tasks T ON R.TASK_ID = T.ID
AND T.DEL_FLAG = '0'
WHERE
R.CLASSIFICATION_ID = 9
AND PERSON_ID = ?
AND R.ACTIVITY_ID IN
) A
,(
SELECT
COUNT AS RECS
FROM
task_relations R
INNER JOIN tasks T ON R.TASK_ID = T.ID
AND T.DEL_FLAG = '0'
WHERE
R.CLASSIFICATION_ID = 1
AND PERSON_ID = ?
AND R.ACTIVITY_ID IN
) B
,(
SELECT
COUNT AS RECS
FROM
task_relations R
INNER JOIN tasks T ON R.TASK_ID = T.ID
AND T.DEL_FLAG = '0'
WHERE
R.CLASSIFICATION_ID = 2
AND PERSON_ID = ?
AND R.ACTIVITY_ID IN
) C
,(
SELECT
COUNT AS RECS
FROM
task_relations R
INNER JOIN tasks T ON R.TASK_ID = T.ID
AND T.DEL_FLAG = '0'
WHERE
R.CLASSIFICATION_ID = 4
AND PERSON_ID = ?
AND R.ACTIVITY_ID IN
) D
,(
SELECT
COUNT AS RECS
FROM
task_relations R
INNER JOIN tasks T ON R.TASK_ID = T.ID
AND T.DEL_FLAG = '0'
WHERE
R.CLASSIFICATION_ID = 5
AND PERSON_ID = ?
AND R.ACTIVITY_ID IN
) E
,(
SELECT
COUNT AS RECS
FROM
task_relations R
INNER JOIN tasks T ON R.TASK_ID = T.ID
AND T.DEL_FLAG = '0'
WHERE
R.CLASSIFICATION_ID = 1
AND R.STATUS_ID = 1
AND PERSON_ID = ?
AND R.ACTIVITY_ID IN
) F
,(
SELECT
COUNT AS RECS
FROM
task_relations R
INNER JOIN tasks T ON R.TASK_ID = T.ID
AND T.DEL_FLAG = '0'
WHERE
R.CLASSIFICATION_ID = 1
AND R.STATUS_ID = 2
AND PERSON_ID = ?
AND R.ACTIVITY_ID IN
) G
,(
SELECT
COUNT AS RECS
FROM
task_relations R
INNER JOIN tasks T ON R.TASK_ID = T.ID
AND T.DEL_FLAG = '0'
WHERE
R.CLASSIFICATION_ID = 1
AND R.STATUS_ID = 3
AND PERSON_ID = ?
AND R.ACTIVITY_ID IN
) H
,(
SELECT
COUNT AS RECS
FROM
task_relations R
INNER JOIN tasks T ON R.TASK_ID = T.ID
AND T.DEL_FLAG = '0'
WHERE
R.CLASSIFICATION_ID = 21
AND PERSON_ID = ?
AND R.ACTIVITY_ID IN
) I
,(
SELECT
COUNT AS RECS
FROM
task_relations R
INNER JOIN tasks T ON R.TASK_ID = T.ID
AND T.DEL_FLAG = '0'
WHERE
R.CLASSIFICATION_ID = 99
AND PERSON_ID = ?
AND R.ACTIVITY_ID IN
) J], ErrorCode=0, SQLState=42601)が発生しました
at org.seasar.extension.jdbc.impl.PreparedStatementWrapper.wrapException(PreparedStatementWrapper.java:62)
at org.seasar.extension.jdbc.impl.PreparedStatementWrapper.wrapException(PreparedStatementWrapper.java:57)
at org.seasar.extension.jdbc.impl.PreparedStatementWrapper.executeQuery(PreparedStatementWrapper.java:73)
at org.seasar.framework.util.PreparedStatementUtil.executeQuery(PreparedStatementUtil.java:35)
... 61 more
Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near ")"
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:351)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:255)
at org.seasar.extension.jdbc.impl.PreparedStatementWrapper.executeQuery(PreparedStatementWrapper.java:71)
... 62 more
DEBUG 2007-06-29 12:08:31,317 [TP-Processor8] 132
DEBUG 2007-06-29 12:08:31,317 [TP-Processor8]