org.hibernate.exception.GenericJDBCException: Invalid column type: 1111

activiti.org | 4 months ago
  1. 0

    5.10 Invalid column type: 1111 | Activiti Forums

    activiti.org | 1 year ago
    org.hibernate.exception.GenericJDBCException: Invalid column type: 1111
  2. 0

    5.10 Invalid column type: 1111 | Activiti Forums

    activiti.org | 4 months ago
    org.hibernate.exception.GenericJDBCException: Invalid column type: 1111
  3. 0

    Trying to set a null value via JDBI and Oracle ojdbc6.jar

    GitHub | 3 years ago | spoon16
    java.sql.SQLException: Invalid column type: 1111
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    When running an analysis on a project containing reviews, the analysis fails with the following error: {noformat} [INFO] ------------------------------------------------------------------------ [ERROR] BUILD ERROR [INFO] ------------------------------------------------------------------------ [INFO] Can not execute Sonar Embedded error: Fail to decorate 'com.secutix.tnac.facade.list.ListServiceBean' Invalid column type: 1111 [INFO] ------------------------------------------------------------------------ [INFO] Trace org.apache.maven.lifecycle.LifecycleExecutionException: Can not execute Sonar at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoals(DefaultLifecycleExecutor.java:719) at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeStandaloneGoal(DefaultLifecycleExecutor.java:569) at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoal(DefaultLifecycleExecutor.java:539) at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoalAndHandleFailures(DefaultLifecycleExecutor.java:387) at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeTaskSegments(DefaultLifecycleExecutor.java:284) at org.apache.maven.lifecycle.DefaultLifecycleExecutor.execute(DefaultLifecycleExecutor.java:180) at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:328) at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:138) at org.apache.maven.cli.MavenCli.main(MavenCli.java:362) at org.apache.maven.cli.compat.CompatibleMain.main(CompatibleMain.java:60) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.codehaus.classworlds.Launcher.launchEnhanced(Launcher.java:315) at org.codehaus.classworlds.Launcher.launch(Launcher.java:255) at org.codehaus.classworlds.Launcher.mainWithExitCode(Launcher.java:430) at org.codehaus.classworlds.Launcher.main(Launcher.java:375) Caused by: org.apache.maven.plugin.MojoExecutionException: Can not execute Sonar at org.codehaus.mojo.sonar.Bootstraper.executeMojo(Bootstraper.java:103) at org.codehaus.mojo.sonar.Bootstraper.start(Bootstraper.java:79) at org.codehaus.mojo.sonar.SonarMojo.execute(SonarMojo.java:88) at org.apache.maven.plugin.DefaultPluginManager.executeMojo(DefaultPluginManager.java:490) at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoals(DefaultLifecycleExecutor.java:694) ... 17 more Caused by: org.sonar.api.utils.SonarException: Fail to decorate 'com.secutix.tnac.facade.list.ListServiceBean' at org.sonar.batch.phases.DecoratorsExecutor.executeDecorator(DecoratorsExecutor.java:84) at org.sonar.batch.phases.DecoratorsExecutor.decorateResource(DecoratorsExecutor.java:70) at org.sonar.batch.phases.DecoratorsExecutor.decorateResource(DecoratorsExecutor.java:63) at org.sonar.batch.phases.DecoratorsExecutor.decorateResource(DecoratorsExecutor.java:63) at org.sonar.batch.phases.DecoratorsExecutor.execute(DecoratorsExecutor.java:55) at org.sonar.batch.phases.Phases.execute(Phases.java:94) at org.sonar.batch.bootstrap.ProjectModule.doStart(ProjectModule.java:143) at org.sonar.batch.bootstrap.Module.start(Module.java:83) at org.sonar.batch.bootstrap.BatchModule.analyze(BatchModule.java:115) at org.sonar.batch.bootstrap.BatchModule.analyze(BatchModule.java:110) at org.sonar.batch.bootstrap.BatchModule.doStart(BatchModule.java:105) at org.sonar.batch.bootstrap.Module.start(Module.java:83) at org.sonar.batch.bootstrap.BootstrapModule.doStart(BootstrapModule.java:102) at org.sonar.batch.bootstrap.Module.start(Module.java:83) at org.sonar.batch.bootstrapper.Batch.startBatch(Batch.java:71) at org.sonar.batch.bootstrapper.Batch.execute(Batch.java:58) at org.sonar.maven.SonarMojo.execute(SonarMojo.java:151) at org.apache.maven.plugin.DefaultPluginManager.executeMojo(DefaultPluginManager.java:490) at org.codehaus.mojo.sonar.Bootstraper.executeMojo(Bootstraper.java:98) ... 21 more Caused by: org.apache.ibatis.exceptions.PersistenceException: ### Error updating database. Cause: org.apache.ibatis.type.TypeException: Error setting null parameter. Most JDBC drivers require that the JdbcType must be specified for all nullable parameters. Cause: java.sql.SQLException: Invalid column type: 1111 ### The error may involve org.sonar.core.review.ReviewMapper.update-Inline ### The error occurred while setting parameters ### Cause: org.apache.ibatis.type.TypeException: Error setting null parameter. Most JDBC drivers require that the JdbcType must be specified for all nullable parameters. Cause: java.sql.SQLException: Invalid column type: 1111 at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:8) at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:124) at org.sonar.core.persistence.BatchSession.update(BatchSession.java:121) at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:62) at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:25) at $Proxy53.update(Unknown Source) at org.sonar.core.review.ReviewDao.update(ReviewDao.java:89) at org.sonar.plugins.core.sensors.ReviewWorkflowDecorator.persistUpdates(ReviewWorkflowDecorator.java:85) at org.sonar.plugins.core.sensors.ReviewWorkflowDecorator.decorate(ReviewWorkflowDecorator.java:79) at org.sonar.batch.phases.DecoratorsExecutor.executeDecorator(DecoratorsExecutor.java:79) ... 39 more Caused by: org.apache.ibatis.type.TypeException: Error setting null parameter. Most JDBC drivers require that the JdbcType must be specified for all nullable parameters. Cause: java.sql.SQLException: Invalid column type: 1111 at org.apache.ibatis.type.BaseTypeHandler.setParameter(BaseTypeHandler.java:17) 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.BatchExecutor.doUpdate(BatchExecutor.java:50) at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:88) at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:43) at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:122) ... 47 more Caused by: java.sql.SQLException: Invalid column type: 1111 at oracle.jdbc.driver.OracleStatement.getInternalType(OracleStatement.java:3900) at oracle.jdbc.driver.OraclePreparedStatement.setNullCritical(OraclePreparedStatement.java:4406) at oracle.jdbc.driver.OraclePreparedStatement.setNull(OraclePreparedStatement.java:4388) at oracle.jdbc.driver.OraclePreparedStatementWrapper.setNull(OraclePreparedStatementWrapper.java:1281) at org.apache.commons.dbcp.DelegatingPreparedStatement.setNull(DelegatingPreparedStatement.java:108) at org.apache.commons.dbcp.DelegatingPreparedStatement.setNull(DelegatingPreparedStatement.java:108) at org.apache.ibatis.type.BaseTypeHandler.setParameter(BaseTypeHandler.java:15) ... 54 more {noformat}

    SonarSource JIRA | 5 years ago | Reynald Borer
    org.apache.ibatis.type.TypeException: Error setting null parameter. Most JDBC drivers require that the JdbcType must be specified for all nullable parameters. Cause: java.sql.SQLException: Invalid column type: 1111

    2 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      Invalid column type: 1111

      at oracle.jdbc.driver.OracleStatement.getInternalType()
    2. Oracle jdbc
      OraclePreparedStatementWrapper.setNull
      1. oracle.jdbc.driver.OracleStatement.getInternalType(OracleStatement.java:3916)
      2. oracle.jdbc.driver.OraclePreparedStatement.setNullCritical(OraclePreparedStatement.java:4541)
      3. oracle.jdbc.driver.OraclePreparedStatement.setNull(OraclePreparedStatement.java:4523)
      4. oracle.jdbc.driver.OraclePreparedStatementWrapper.setNull(OraclePreparedStatementWrapper.java:1281)
      4 frames
    3. BoneCP :: Core Library
      PreparedStatementHandle.setNull
      1. com.jolbox.bonecp.PreparedStatementHandle.setNull(PreparedStatementHandle.java:884)
      1 frame
    4. Java RT
      Method.invoke
      1. sun.reflect.GeneratedMethodAccessor71.invoke(Unknown Source)
      2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      3. java.lang.reflect.Method.invoke(Method.java:597)
      3 frames
    5. org.hibernate.engine
      AbstractStatementProxyHandler.continueInvocation
      1. org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:122)
      1 frame
    6. Hibernate
      SqlExceptionHelper.convert
      1. org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54)
      2. org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)
      3. org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)
      3 frames
    7. org.hibernate.engine
      AbstractProxyHandler.invoke
      1. org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:129)
      2. org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81)
      2 frames
    8. com.sun.proxy
      $Proxy93.setNull
      1. com.sun.proxy.$Proxy93.setNull(Unknown Source)
      1 frame
    9. MyBatis
      DefaultSqlSession.selectList
      1. org.apache.ibatis.type.BaseTypeHandler.setParameter(BaseTypeHandler.java:15)
      2. org.apache.ibatis.executor.parameter.DefaultParameterHandler.setParameters(DefaultParameterHandler.java:73)
      3. org.apache.ibatis.executor.statement.PreparedStatementHandler.parameterize(PreparedStatementHandler.java:61)
      4. org.apache.ibatis.executor.statement.RoutingStatementHandler.parameterize(RoutingStatementHandler.java:43)
      5. org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:56)
      6. org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:40)
      7. org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:94)
      8. org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:72)
      9. org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:59)
      10. org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:8)
      11. org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:61)
      12. org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:53)
      12 frames
    10. Activiti - Engine
      CommandContextInterceptor.execute
      1. org.activiti.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:210)
      2. org.activiti.engine.impl.persistence.entity.JobManager.findJobsByConfiguration(JobManager.java:144)
      3. org.activiti.engine.impl.bpmn.deployer.BpmnDeployer.removeObsoleteTimers(BpmnDeployer.java:192)
      4. org.activiti.engine.impl.bpmn.deployer.BpmnDeployer.deploy(BpmnDeployer.java:148)
      5. org.activiti.engine.impl.persistence.deploy.DeploymentCache.deploy(DeploymentCache.java:38)
      6. org.activiti.engine.impl.persistence.entity.DeploymentManager.insertDeployment(DeploymentManager.java:42)
      7. org.activiti.engine.impl.cmd.DeployCmd.execute(DeployCmd.java:59)
      8. org.activiti.engine.impl.cmd.DeployCmd.execute(DeployCmd.java:31)
      9. org.activiti.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:24)
      10. org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:42)
      10 frames
    11. Activiti - Spring
      SpringTransactionInterceptor$1.doInTransaction
      1. org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:42)
      1 frame
    12. Spring Tx
      TransactionTemplate.execute
      1. org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)
      1 frame
    13. Activiti - Spring
      SpringTransactionInterceptor.execute
      1. org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:40)
      1 frame
    14. Activiti - Engine
      DeploymentBuilderImpl.deploy
      1. org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33)
      2. org.activiti.engine.impl.RepositoryServiceImpl.deploy(RepositoryServiceImpl.java:54)
      3. org.activiti.engine.impl.repository.DeploymentBuilderImpl.deploy(DeploymentBuilderImpl.java:106)
      3 frames
    15. com.pm.pdm
      ImportExportServiceImpl.importObjectsFromUri
      1. com.pm.pdm.process.impl.activiti.init.ProcessUpdater.deploy(ProcessUpdater.java:86)
      2. com.pm.pdm.service.process.ProcessImportProcessor.doImport(ProcessImportProcessor.java:35)
      3. com.pm.pdm.service.impexp.ImportExportServiceImpl.importObjects(ImportExportServiceImpl.java:90)
      4. com.pm.pdm.service.impexp.ImportExportServiceImpl.importObjectsFromUri(ImportExportServiceImpl.java:125)
      4 frames