標準編集モードでのテーブル新規作成・編集におけるバグ

１．何らかの型でカラムを作成
２．そのテーブルにデータを追加
３．１で作成したカラムを違う型・同じ名前で編集←ここではアプリケーションエラーは発生しない
４．テーブルのデータを閲覧しようとするとアプリケーションエラー発生

2006-08-04 21:36:25,187 ERROR JDBCExceptionReporter - Wrong data type: type: VARCHAR (12) expected: INTEGER value: 1996-01-03
org.hibernate.exception.SQLGrammarException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.doList(Loader.java:2148)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
at org.hibernate.loader.Loader.list(Loader.java:2024)
at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:94)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1533)
at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)
at org.seasar.tuigwaa.database.function.criteria.HibernateCriteria.list(HibernateCriteria.java:171)
at org.seasar.tuigwaa.database.function.InjectCriteriaExeFunction.evaluate(InjectCriteriaExeFunction.java:25)
at org.seasar.tuigwaa.database.function.InjectCriteriaExeFunction$$EnhancedByS2AOP$$166bfd8.evaluate$$invokeSuperMethod$$(InjectCriteriaExeFunction$$EnhancedByS2AOP$$166bfd8.java)
at org.seasar.tuigwaa.database.function.InjectCriteriaExeFunction$$EnhancedByS2AOP$$166bfd8$$MethodInvocation$$evaluate0.proceed(MethodInvocationClassGenerator.java)
at org.seasar.extension.tx.RequiredInterceptor.invoke(RequiredInterceptor.java:40)
at org.seasar.tuigwaa.database.function.InjectCriteriaExeFunction$$EnhancedByS2AOP$$166bfd8$$MethodInvocation$$evaluate0.proceed(MethodInvocationClassGenerator.java)
at org.seasar.tuigwaa.database.function.InjectCriteriaExeFunction$$EnhancedByS2AOP$$166bfd8.evaluate(InjectCriteriaExeFunction$$EnhancedByS2AOP$$166bfd8.java)
at org.seasar.tuigwaa.database.function.InjectCriteriaExeFunction.evaluate(InjectCriteriaExeFunction.java:12)
at org.seasar.tuigwaa.database.function.InjectCriteriaExeFunction$$EnhancedByS2AOP$$166bfd8.evaluate$$invokeSuperMethod$$(InjectCriteriaExeFunction$$EnhancedByS2AOP$$166bfd8.java)
at org.seasar.tuigwaa.database.function.InjectCriteriaExeFunction$$EnhancedByS2AOP$$166bfd8$$MethodInvocation$$evaluate1.proceed(MethodInvocationClassGenerator.java)
at org.seasar.extension.tx.RequiredInterceptor.invoke(RequiredInterceptor.java:40)
at org.seasar.tuigwaa.database.function.InjectCriteriaExeFunction$$EnhancedByS2AOP$$166bfd8$$MethodInvocation$$evaluate1.proceed(MethodInvocationClassGenerator.java)
at org.seasar.tuigwaa.database.function.InjectCriteriaExeFunction$$EnhancedByS2AOP$$166bfd8.evaluate(InjectCriteriaExeFunction$$EnhancedByS2AOP$$166bfd8.java)
at org.seasar.tuigwaa.model.DataServiceImpl.doFind(DataServiceImpl.java:142)
at org.seasar.tuigwaa.model.DataServiceImpl.find(DataServiceImpl.java:72)
at org.seasar.tuigwaa.model.DataServiceImpl$$EnhancedByS2AOP$$9b87f6.find$$invokeSuperMethod$$(DataServiceImpl$$EnhancedByS2AOP$$9b87f6.java)
at org.seasar.tuigwaa.model.DataServiceImpl$$EnhancedByS2AOP$$9b87f6$$MethodInvocation$$find11.proceed(MethodInvocationClassGenerator.java)
at org.seasar.tuigwaa.logic.aop.MethodDecorateInterceptorImpl.invoke(MethodDecorateInterceptorImpl.java:25)
at org.seasar.tuigwaa.model.DataServiceImpl$$EnhancedByS2AOP$$9b87f6$$MethodInvocation$$find11.proceed(MethodInvocationClassGenerator.java)
at org.seasar.tuigwaa.model.DataServiceImpl$$EnhancedByS2AOP$$9b87f6.find(DataServiceImpl$$EnhancedByS2AOP$$9b87f6.java)
at org.seasar.tuigwaa.controller.DatabaseAction.doFindTable(DatabaseAction.java:355)
at org.seasar.tuigwaa.controller.DatabaseAction.doFind(DatabaseAction.java:325)
at org.seasar.tuigwaa.controller.DatabaseAction.listRecord(DatabaseAction.java:65)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:270)
at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:187)
at org.apache.struts.actions.MappingDispatchAction.execute(MappingDispatchAction.java:169)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
at org.seasar.struts.processor.S2TilesRequestProcessor.processActionPerform(S2TilesRequestProcessor.java:122)
at org.seasar.struts.processor.AcceptorImpl.process(AcceptorImpl.java:126)
at org.seasar.struts.processor.S2TilesRequestProcessor.process(S2TilesRequestProcessor.java:61)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.seasar.tuigwaa.util.filter.TgwFilter.doFilter(TgwFilter.java:67)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.seasar.tuigwaa.util.filter.EncodingFilter.doFilter(EncodingFilter.java:65)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.seasar.tuigwaa.util.filter.ForwardFilter.doFilter(ForwardFilter.java:83)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.seasar.struts.filter.S2StrutsFilter.doFilter(S2StrutsFilter.java:45)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.seasar.framework.container.filter.S2ContainerFilter.doFilter(S2ContainerFilter.java:60)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:432)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:833)
at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:639)
at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1285)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: Wrong data type: type: VARCHAR (12) expected: INTEGER value: 1996-01-03
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcResultSet.getColumnInType(Unknown Source)
at org.hsqldb.jdbc.jdbcResultSet.getInt(Unknown Source)
at org.hsqldb.jdbc.jdbcResultSet.getInt(Unknown Source)
at org.hibernate.type.IntegerType.get(IntegerType.java:28)
at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:113)
at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:102)
at org.hibernate.type.AbstractType.hydrate(AbstractType.java:81)
at org.hibernate.persister.entity.AbstractEntityPersister.hydrate(AbstractEntityPersister.java:1899)
at org.hibernate.loader.Loader.loadFromResultSet(Loader.java:1372)
at org.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:1300)
at org.hibernate.loader.Loader.getRow(Loader.java:1197)
at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:569)
at org.hibernate.loader.Loader.doQuery(Loader.java:689)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
at org.hibernate.loader.Loader.doList(Loader.java:2145)
... 71 more
2006-08-04 21:36:25,187 ERROR [/tuigwaa] - Application Error Detected and Forwarded
org.hibernate.exception.SQLGrammarException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.doList(Loader.java:2148)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
at org.hibernate.loader.Loader.list(Loader.java:2024)
at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:94)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1533)
at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)
at org.seasar.tuigwaa.database.function.criteria.HibernateCriteria.list(HibernateCriteria.java:171)
at org.seasar.tuigwaa.database.function.InjectCriteriaExeFunction.evaluate(InjectCriteriaExeFunction.java:25)
at org.seasar.tuigwaa.database.function.InjectCriteriaExeFunction$$EnhancedByS2AOP$$166bfd8.evaluate$$invokeSuperMethod$$(InjectCriteriaExeFunction$$EnhancedByS2AOP$$166bfd8.java)
at org.seasar.tuigwaa.database.function.InjectCriteriaExeFunction$$EnhancedByS2AOP$$166bfd8$$MethodInvocation$$evaluate0.proceed(MethodInvocationClassGenerator.java)
at org.seasar.extension.tx.RequiredInterceptor.invoke(RequiredInterceptor.java:40)
at org.seasar.tuigwaa.database.function.InjectCriteriaExeFunction$$EnhancedByS2AOP$$166bfd8$$MethodInvocation$$evaluate0.proceed(MethodInvocationClassGenerator.java)
at org.seasar.tuigwaa.database.function.InjectCriteriaExeFunction$$EnhancedByS2AOP$$166bfd8.evaluate(InjectCriteriaExeFunction$$EnhancedByS2AOP$$166bfd8.java)
at org.seasar.tuigwaa.database.function.InjectCriteriaExeFunction.evaluate(InjectCriteriaExeFunction.java:12)
at org.seasar.tuigwaa.database.function.InjectCriteriaExeFunction$$EnhancedByS2AOP$$166bfd8.evaluate$$invokeSuperMethod$$(InjectCriteriaExeFunction$$EnhancedByS2AOP$$166bfd8.java)
at org.seasar.tuigwaa.database.function.InjectCriteriaExeFunction$$EnhancedByS2AOP$$166bfd8$$MethodInvocation$$evaluate1.proceed(MethodInvocationClassGenerator.java)
at org.seasar.extension.tx.RequiredInterceptor.invoke(RequiredInterceptor.java:40)
at org.seasar.tuigwaa.database.function.InjectCriteriaExeFunction$$EnhancedByS2AOP$$166bfd8$$MethodInvocation$$evaluate1.proceed(MethodInvocationClassGenerator.java)
at org.seasar.tuigwaa.database.function.InjectCriteriaExeFunction$$EnhancedByS2AOP$$166bfd8.evaluate(InjectCriteriaExeFunction$$EnhancedByS2AOP$$166bfd8.java)
at org.seasar.tuigwaa.model.DataServiceImpl.doFind(DataServiceImpl.java:142)
at org.seasar.tuigwaa.model.DataServiceImpl.find(DataServiceImpl.java:72)
at org.seasar.tuigwaa.model.DataServiceImpl$$EnhancedByS2AOP$$9b87f6.find$$invokeSuperMethod$$(DataServiceImpl$$EnhancedByS2AOP$$9b87f6.java)
at org.seasar.tuigwaa.model.DataServiceImpl$$EnhancedByS2AOP$$9b87f6$$MethodInvocation$$find11.proceed(MethodInvocationClassGenerator.java)
at org.seasar.tuigwaa.logic.aop.MethodDecorateInterceptorImpl.invoke(MethodDecorateInterceptorImpl.java:25)
at org.seasar.tuigwaa.model.DataServiceImpl$$EnhancedByS2AOP$$9b87f6$$MethodInvocation$$find11.proceed(MethodInvocationClassGenerator.java)
at org.seasar.tuigwaa.model.DataServiceImpl$$EnhancedByS2AOP$$9b87f6.find(DataServiceImpl$$EnhancedByS2AOP$$9b87f6.java)
at org.seasar.tuigwaa.controller.DatabaseAction.doFindTable(DatabaseAction.java:355)
at org.seasar.tuigwaa.controller.DatabaseAction.doFind(DatabaseAction.java:325)
at org.seasar.tuigwaa.controller.DatabaseAction.listRecord(DatabaseAction.java:65)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:270)
at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:187)
at org.apache.struts.actions.MappingDispatchAction.execute(MappingDispatchAction.java:169)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
at org.seasar.struts.processor.S2TilesRequestProcessor.processActionPerform(S2TilesRequestProcessor.java:122)
at org.seasar.struts.processor.AcceptorImpl.process(AcceptorImpl.java:126)
at org.seasar.struts.processor.S2TilesRequestProcessor.process(S2TilesRequestProcessor.java:61)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.seasar.tuigwaa.util.filter.TgwFilter.doFilter(TgwFilter.java:67)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.seasar.tuigwaa.util.filter.EncodingFilter.doFilter(EncodingFilter.java:65)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.seasar.tuigwaa.util.filter.ForwardFilter.doFilter(ForwardFilter.java:83)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.seasar.struts.filter.S2StrutsFilter.doFilter(S2StrutsFilter.java:45)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.seasar.framework.container.filter.S2ContainerFilter.doFilter(S2ContainerFilter.java:60)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:432)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:833)
at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:639)
at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1285)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: Wrong data type: type: VARCHAR (12) expected: INTEGER value: 1996-01-03
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcResultSet.getColumnInType(Unknown Source)
at org.hsqldb.jdbc.jdbcResultSet.getInt(Unknown Source)
at org.hsqldb.jdbc.jdbcResultSet.getInt(Unknown Source)
at org.hibernate.type.IntegerType.get(IntegerType.java:28)
at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:113)
at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:102)
at org.hibernate.type.AbstractType.hydrate(AbstractType.java:81)
at org.hibernate.persister.entity.AbstractEntityPersister.hydrate(AbstractEntityPersister.java:1899)
at org.hibernate.loader.Loader.loadFromResultSet(Loader.java:1372)
at org.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:1300)
at org.hibernate.loader.Loader.getRow(Loader.java:1197)
at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:569)
at org.hibernate.loader.Loader.doQuery(Loader.java:689)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
at org.hibernate.loader.Loader.doList(Loader.java:2145)
... 71 more