AnsweredAssumed Answered

5.10 Invalid column type: 1111

Question asked by tunney on Jun 6, 2014
Latest reply on Jun 17, 2014 by jbarrez
I'm upgrading my application to run on 5.10, was on 5.9

On startup I am getting the below exception and I am lost. Any suggestions?

### Error querying database.  Cause: org.hibernate.exception.GenericJDBCException: Invalid column type: 1111
### The error may involve org.activiti.engine.impl.persistence.entity.JobEntity.selectJobsByConfiguration-Inline
### The error occurred while setting parameters
### Cause: org.hibernate.exception.GenericJDBCException: Invalid column type: 1111
   at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:8)
   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:61)
   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:53)
   at org.activiti.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:210)
   at org.activiti.engine.impl.persistence.entity.JobManager.findJobsByConfiguration(JobManager.java:144)
   at org.activiti.engine.impl.bpmn.deployer.BpmnDeployer.removeObsoleteTimers(BpmnDeployer.java:192)
   at org.activiti.engine.impl.bpmn.deployer.BpmnDeployer.deploy(BpmnDeployer.java:148)
   at org.activiti.engine.impl.persistence.deploy.DeploymentCache.deploy(DeploymentCache.java:38)
   at org.activiti.engine.impl.persistence.entity.DeploymentManager.insertDeployment(DeploymentManager.java:42)
   at org.activiti.engine.impl.cmd.DeployCmd.execute(DeployCmd.java:59)
   at org.activiti.engine.impl.cmd.DeployCmd.execute(DeployCmd.java:31)
   at org.activiti.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:24)
   at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:42)
   at org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:42)
   at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)
   at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:40)
   at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33)
   at org.activiti.engine.impl.RepositoryServiceImpl.deploy(RepositoryServiceImpl.java:54)
   at org.activiti.engine.impl.repository.DeploymentBuilderImpl.deploy(DeploymentBuilderImpl.java:106)
   at com.pm.pdm.process.impl.activiti.init.ProcessUpdater.deploy(ProcessUpdater.java:86)
   at com.pm.pdm.service.process.ProcessImportProcessor.doImport(ProcessImportProcessor.java:35)
   at com.pm.pdm.service.impexp.ImportExportServiceImpl.importObjects(ImportExportServiceImpl.java:90)
   at com.pm.pdm.service.impexp.ImportExportServiceImpl.importObjectsFromUri(ImportExportServiceImpl.java:125)
   … 43 more
Caused by: org.hibernate.exception.GenericJDBCException: Invalid column type: 1111
   at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54)
   at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)
   at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)
   at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:129)
   at org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81)
   at com.sun.proxy.$Proxy93.setNull(Unknown Source)
   at org.apache.ibatis.type.BaseTypeHandler.setParameter(BaseTypeHandler.java:15)
   at org.apache.ibatis.executor.parameter.DefaultParameterHandler.setParameters(DefaultParameterHandler.java:73)
   at org.apache.ibatis.executor.statement.PreparedStatementHandler.parameterize(PreparedStatementHandler.java:61)
   at org.apache.ibatis.executor.statement.RoutingStatementHandler.parameterize(RoutingStatementHandler.java:43)
   at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:56)
   at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:40)
   at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:94)
   at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:72)
   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:59)
   … 64 more
Caused by: java.sql.SQLException: Invalid column type: 1111
   at oracle.jdbc.driver.OracleStatement.getInternalType(OracleStatement.java:3916)
   at oracle.jdbc.driver.OraclePreparedStatement.setNullCritical(OraclePreparedStatement.java:4541)
   at oracle.jdbc.driver.OraclePreparedStatement.setNull(OraclePreparedStatement.java:4523)
   at oracle.jdbc.driver.OraclePreparedStatementWrapper.setNull(OraclePreparedStatementWrapper.java:1281)
   at com.jolbox.bonecp.PreparedStatementHandle.setNull(PreparedStatementHandle.java:884)
   at sun.reflect.GeneratedMethodAccessor71.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:122)
   … 75 more
06-Jun-2014 17:32:46 org.apache.catalina.core.ApplicationContext log

Outcomes