Type Exception Report
Message org.apache.ibatis.exceptions.PersistenceException:
Description The server encountered an unexpected condition that prevented it from fulfilling the request.
Exception
javax.servlet.ServletException: org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property='value', mode=IN, javaType=class java.lang.String, jdbcType=INTEGER, numericScale=null, resultMapId='null', jdbcTypeName='null', expression='null'}. Cause: org.apache.ibatis.type.TypeException: Error setting non null for parameter #1 with JdbcType INTEGER . Try setting a different JdbcType for this parameter or a different configuration property. Cause: com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][1091][10404][4.25.13] Invalid data conversion: Parameter instance is invalid for the requested conversion. ERRORCODE=-4461, SQLSTATE=42815 ### The error may exist in org/xenbase/gene/dto/gene-mapping.xml ### The error may involve org.xenbase.gene.dao.GeneDao.getXGeneIdFromXSpeciesGeneId-Inline ### The error occurred while setting parameters ### SQL: SELECT feature_id FROM feature f, feature_relationship fr WHERE f.feature_id=fr.object_id and f.type_id=1214 and f.organism_id=11 and fr.type_id=500 and fr.subject_id=CAST(? AS INTEGER) ### Cause: org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property='value', mode=IN, javaType=class java.lang.String, jdbcType=INTEGER, numericScale=null, resultMapId='null', jdbcTypeName='null', expression='null'}. Cause: org.apache.ibatis.type.TypeException: Error setting non null for parameter #1 with JdbcType INTEGER . Try setting a different JdbcType for this parameter or a different configuration property. Cause: com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][1091][10404][4.25.13] Invalid data conversion: Parameter instance is invalid for the requested conversion. ERRORCODE=-4461, SQLSTATE=42815 org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:508) org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:415) org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:225) org.apache.struts.action.ActionServlet.process(ActionServlet.java:1950) org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:469) javax.servlet.http.HttpServlet.service(HttpServlet.java:655) javax.servlet.http.HttpServlet.service(HttpServlet.java:764) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) org.xenbase.utility.filters.XSSFilter.doFilter(XSSFilter.java:18) org.xenbase.utility.filters.UmbrellaGeneFilter.doFilter(UmbrellaGeneFilter.java:38) org.xenbase.utility.filters.HTTPStoHTTP.doFilter(HTTPStoHTTP.java:171) org.xenbase.utility.filters.RetrieveUserFilter.doFilter(RetrieveUserFilter.java:96)
Root Cause
org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property='value', mode=IN, javaType=class java.lang.String, jdbcType=INTEGER, numericScale=null, resultMapId='null', jdbcTypeName='null', expression='null'}. Cause: org.apache.ibatis.type.TypeException: Error setting non null for parameter #1 with JdbcType INTEGER . Try setting a different JdbcType for this parameter or a different configuration property. Cause: com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][1091][10404][4.25.13] Invalid data conversion: Parameter instance is invalid for the requested conversion. ERRORCODE=-4461, SQLSTATE=42815 ### The error may exist in org/xenbase/gene/dto/gene-mapping.xml ### The error may involve org.xenbase.gene.dao.GeneDao.getXGeneIdFromXSpeciesGeneId-Inline ### The error occurred while setting parameters ### SQL: SELECT feature_id FROM feature f, feature_relationship fr WHERE f.feature_id=fr.object_id and f.type_id=1214 and f.organism_id=11 and fr.type_id=500 and fr.subject_id=CAST(? AS INTEGER) ### Cause: org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property='value', mode=IN, javaType=class java.lang.String, jdbcType=INTEGER, numericScale=null, resultMapId='null', jdbcTypeName='null', expression='null'}. Cause: org.apache.ibatis.type.TypeException: Error setting non null for parameter #1 with JdbcType INTEGER . Try setting a different JdbcType for this parameter or a different configuration property. Cause: com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][1091][10404][4.25.13] Invalid data conversion: Parameter instance is invalid for the requested conversion. ERRORCODE=-4461, SQLSTATE=42815 org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30) org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:156) org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147) org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:142) org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:75) org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:87) org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:141) org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86) jdk.proxy5/jdk.proxy5.$Proxy182.getXGeneIdFromXSpeciesGeneId(Unknown Source) org.xenbase.gene.dao.XGeneData.getXGeneIdFromXSpeciesGeneId(XGeneData.java:1028) org.xenbase.geneExpression.actions.ExpressionSourcesAction.displayExpressionSources(ExpressionSourcesAction.java:75) org.xenbase.geneExpression.actions.ExpressionSourcesAction.displayGenePageExpression(ExpressionSourcesAction.java:49) jdk.internal.reflect.GeneratedMethodAccessor10438.invoke(Unknown Source) java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) java.base/java.lang.reflect.Method.invoke(Method.java:568) org.apache.struts.extras.actions.DispatchAction.dispatchMethod(DispatchAction.java:273) org.apache.struts.extras.actions.DispatchAction.execute(DispatchAction.java:173) org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:413) org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:225) org.apache.struts.action.ActionServlet.process(ActionServlet.java:1950) org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:469) javax.servlet.http.HttpServlet.service(HttpServlet.java:655) javax.servlet.http.HttpServlet.service(HttpServlet.java:764) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) org.xenbase.utility.filters.XSSFilter.doFilter(XSSFilter.java:18) org.xenbase.utility.filters.UmbrellaGeneFilter.doFilter(UmbrellaGeneFilter.java:38) org.xenbase.utility.filters.HTTPStoHTTP.doFilter(HTTPStoHTTP.java:171) org.xenbase.utility.filters.RetrieveUserFilter.doFilter(RetrieveUserFilter.java:96)
Root Cause
org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property='value', mode=IN, javaType=class java.lang.String, jdbcType=INTEGER, numericScale=null, resultMapId='null', jdbcTypeName='null', expression='null'}. Cause: org.apache.ibatis.type.TypeException: Error setting non null for parameter #1 with JdbcType INTEGER . Try setting a different JdbcType for this parameter or a different configuration property. Cause: com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][1091][10404][4.25.13] Invalid data conversion: Parameter instance is invalid for the requested conversion. ERRORCODE=-4461, SQLSTATE=42815 org.apache.ibatis.scripting.defaults.DefaultParameterHandler.setParameters(DefaultParameterHandler.java:92) org.apache.ibatis.executor.statement.PreparedStatementHandler.parameterize(PreparedStatementHandler.java:97) org.apache.ibatis.executor.statement.RoutingStatementHandler.parameterize(RoutingStatementHandler.java:65) org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:91) org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:64) org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:336) org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:158) org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:110) org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:90) org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:154) org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147) org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:142) org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:75) org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:87) org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:141) org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86) jdk.proxy5/jdk.proxy5.$Proxy182.getXGeneIdFromXSpeciesGeneId(Unknown Source) org.xenbase.gene.dao.XGeneData.getXGeneIdFromXSpeciesGeneId(XGeneData.java:1028) org.xenbase.geneExpression.actions.ExpressionSourcesAction.displayExpressionSources(ExpressionSourcesAction.java:75) org.xenbase.geneExpression.actions.ExpressionSourcesAction.displayGenePageExpression(ExpressionSourcesAction.java:49) jdk.internal.reflect.GeneratedMethodAccessor10438.invoke(Unknown Source) java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) java.base/java.lang.reflect.Method.invoke(Method.java:568) org.apache.struts.extras.actions.DispatchAction.dispatchMethod(DispatchAction.java:273) org.apache.struts.extras.actions.DispatchAction.execute(DispatchAction.java:173) org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:413) org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:225) org.apache.struts.action.ActionServlet.process(ActionServlet.java:1950) org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:469) javax.servlet.http.HttpServlet.service(HttpServlet.java:655) javax.servlet.http.HttpServlet.service(HttpServlet.java:764) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) org.xenbase.utility.filters.XSSFilter.doFilter(XSSFilter.java:18) org.xenbase.utility.filters.UmbrellaGeneFilter.doFilter(UmbrellaGeneFilter.java:38) org.xenbase.utility.filters.HTTPStoHTTP.doFilter(HTTPStoHTTP.java:171) org.xenbase.utility.filters.RetrieveUserFilter.doFilter(RetrieveUserFilter.java:96)
Root Cause
org.apache.ibatis.type.TypeException: Error setting non null for parameter #1 with JdbcType INTEGER . Try setting a different JdbcType for this parameter or a different configuration property. Cause: com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][1091][10404][4.25.13] Invalid data conversion: Parameter instance is invalid for the requested conversion. ERRORCODE=-4461, SQLSTATE=42815 org.apache.ibatis.type.BaseTypeHandler.setParameter(BaseTypeHandler.java:76) org.apache.ibatis.scripting.defaults.DefaultParameterHandler.setParameters(DefaultParameterHandler.java:90) org.apache.ibatis.executor.statement.PreparedStatementHandler.parameterize(PreparedStatementHandler.java:97) org.apache.ibatis.executor.statement.RoutingStatementHandler.parameterize(RoutingStatementHandler.java:65) org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:91) org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:64) org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:336) org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:158) org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:110) org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:90) org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:154) org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147) org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:142) org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:75) org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:87) org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:141) org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86) jdk.proxy5/jdk.proxy5.$Proxy182.getXGeneIdFromXSpeciesGeneId(Unknown Source) org.xenbase.gene.dao.XGeneData.getXGeneIdFromXSpeciesGeneId(XGeneData.java:1028) org.xenbase.geneExpression.actions.ExpressionSourcesAction.displayExpressionSources(ExpressionSourcesAction.java:75) org.xenbase.geneExpression.actions.ExpressionSourcesAction.displayGenePageExpression(ExpressionSourcesAction.java:49) jdk.internal.reflect.GeneratedMethodAccessor10438.invoke(Unknown Source) java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) java.base/java.lang.reflect.Method.invoke(Method.java:568) org.apache.struts.extras.actions.DispatchAction.dispatchMethod(DispatchAction.java:273) org.apache.struts.extras.actions.DispatchAction.execute(DispatchAction.java:173) org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:413) org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:225) org.apache.struts.action.ActionServlet.process(ActionServlet.java:1950) org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:469) javax.servlet.http.HttpServlet.service(HttpServlet.java:655) javax.servlet.http.HttpServlet.service(HttpServlet.java:764) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) org.xenbase.utility.filters.XSSFilter.doFilter(XSSFilter.java:18) org.xenbase.utility.filters.UmbrellaGeneFilter.doFilter(UmbrellaGeneFilter.java:38) org.xenbase.utility.filters.HTTPStoHTTP.doFilter(HTTPStoHTTP.java:171) org.xenbase.utility.filters.RetrieveUserFilter.doFilter(RetrieveUserFilter.java:96)
Root Cause
com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][1091][10404][4.25.13] Invalid data conversion: Parameter instance is invalid for the requested conversion. ERRORCODE=-4461, SQLSTATE=42815 com.ibm.db2.jcc.am.b6.a(b6.java:810) com.ibm.db2.jcc.am.b6.a(b6.java:66) com.ibm.db2.jcc.am.b6.a(b6.java:116) com.ibm.db2.jcc.am.bg.a(bg.java:787) com.ibm.db2.jcc.am.bg.a(bg.java:693) com.ibm.db2.jcc.am.k4.a(k4.java:1687) com.ibm.db2.jcc.am.k4.setString(k4.java:1636) org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.setString(DelegatingPreparedStatement.java:615) org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.setString(DelegatingPreparedStatement.java:615) org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.setString(DelegatingPreparedStatement.java:615) org.apache.ibatis.type.StringTypeHandler.setNonNullParameter(StringTypeHandler.java:31) org.apache.ibatis.type.StringTypeHandler.setNonNullParameter(StringTypeHandler.java:26) org.apache.ibatis.type.BaseTypeHandler.setParameter(BaseTypeHandler.java:74) org.apache.ibatis.scripting.defaults.DefaultParameterHandler.setParameters(DefaultParameterHandler.java:90) org.apache.ibatis.executor.statement.PreparedStatementHandler.parameterize(PreparedStatementHandler.java:97) org.apache.ibatis.executor.statement.RoutingStatementHandler.parameterize(RoutingStatementHandler.java:65) org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:91) org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:64) org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:336) org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:158) org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:110) org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:90) org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:154) org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147) org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:142) org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:75) org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:87) org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:141) org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86) jdk.proxy5/jdk.proxy5.$Proxy182.getXGeneIdFromXSpeciesGeneId(Unknown Source) org.xenbase.gene.dao.XGeneData.getXGeneIdFromXSpeciesGeneId(XGeneData.java:1028) org.xenbase.geneExpression.actions.ExpressionSourcesAction.displayExpressionSources(ExpressionSourcesAction.java:75) org.xenbase.geneExpression.actions.ExpressionSourcesAction.displayGenePageExpression(ExpressionSourcesAction.java:49) jdk.internal.reflect.GeneratedMethodAccessor10438.invoke(Unknown Source) java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) java.base/java.lang.reflect.Method.invoke(Method.java:568) org.apache.struts.extras.actions.DispatchAction.dispatchMethod(DispatchAction.java:273) org.apache.struts.extras.actions.DispatchAction.execute(DispatchAction.java:173) org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:413) org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:225) org.apache.struts.action.ActionServlet.process(ActionServlet.java:1950) org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:469) javax.servlet.http.HttpServlet.service(HttpServlet.java:655) javax.servlet.http.HttpServlet.service(HttpServlet.java:764) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) org.xenbase.utility.filters.XSSFilter.doFilter(XSSFilter.java:18) org.xenbase.utility.filters.UmbrellaGeneFilter.doFilter(UmbrellaGeneFilter.java:38) org.xenbase.utility.filters.HTTPStoHTTP.doFilter(HTTPStoHTTP.java:171) org.xenbase.utility.filters.RetrieveUserFilter.doFilter(RetrieveUserFilter.java:96)
Note The full stack trace of the root cause is available in the server logs.