java.sql.SQLException: Invalid column type: sqlType=2003

Coderanch | Akshitha Mishra | 2 years ago
  1. 0

    Ibatis Exception: Invalid column type: sqlType=2003

    Coderanch | 2 years ago | Akshitha Mishra
    java.sql.SQLException: Invalid column type: sqlType=2003
  2. 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
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    The root cause of this issue is: https://ecosystem.atlassian.net/browse/AO-264 and is caused by the Active Objects plugin. JIRA 6.1 contains a version change in Active Objects and this issue is not present in JIRA 6.1 h2. Symptoms During a data restore - the following stack trace is present: {code} [INFO] [talledLocalContainer] com.atlassian.activeobjects.spi.ActiveObjectsImportExportException: There was an error during import/export with plugin JIRA Service Desk(com.atlassian.servicedesk) #1.0.1-SNAPSHOT (table AO_54307E_SERVICEDESK):There has been a SQL exception importing row #0 for table 'AO_54307E_SERVICEDESK' see the cause of this exception for more detail about it. [INFO] [talledLocalContainer] at com.atlassian.activeobjects.backup.ImportExportErrorServiceImpl.newRowImportSqlException(ImportExportErrorServiceImpl.java:36) [INFO] [talledLocalContainer] at com.atlassian.dbexporter.importer.DataImporter.importTable(DataImporter.java:131) [INFO] [talledLocalContainer] at com.atlassian.dbexporter.importer.DataImporter.access$000(DataImporter.java:33) [INFO] [talledLocalContainer] at com.atlassian.dbexporter.importer.DataImporter$1.call(DataImporter.java:73) [INFO] [talledLocalContainer] at com.atlassian.dbexporter.importer.DataImporter$1.call(DataImporter.java:62) [INFO] [talledLocalContainer] at com.atlassian.dbexporter.jdbc.JdbcUtils.withConnection(JdbcUtils.java:31) [INFO] [talledLocalContainer] at com.atlassian.dbexporter.importer.DataImporter.doImportNode(DataImporter.java:61) [INFO] [talledLocalContainer] at com.atlassian.dbexporter.importer.AbstractImporter.importNode(AbstractImporter.java:49) [INFO] [talledLocalContainer] at com.atlassian.dbexporter.DbImporter.importData(DbImporter.java:73) [INFO] [talledLocalContainer] at com.atlassian.activeobjects.backup.ActiveObjectsBackup.restore(ActiveObjectsBackup.java:158) [INFO] [talledLocalContainer] at com.atlassian.jira.bc.dataimport.DefaultDataImportService.restoreActiveObjects(DefaultDataImportService.java:439) [INFO] [talledLocalContainer] at com.atlassian.jira.bc.dataimport.DefaultDataImportService.performImport(DefaultDataImportService.java:627) [INFO] [talledLocalContainer] at com.atlassian.jira.bc.dataimport.DefaultDataImportService.doImport(DefaultDataImportService.java:251) [INFO] [talledLocalContainer] at com.atlassian.jira.web.action.setup.DataImportAsyncCommand.call(DataImportAsyncCommand.java:65) [INFO] [talledLocalContainer] at com.atlassian.jira.web.action.setup.DataImportAsyncCommand.call(DataImportAsyncCommand.java:28) [INFO] [talledLocalContainer] at com.atlassian.jira.task.ImportTaskManagerImpl$TaskCallableDecorator.call(ImportTaskManagerImpl.java:147) [INFO] [talledLocalContainer] at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) [INFO] [talledLocalContainer] at java.util.concurrent.FutureTask.run(FutureTask.java:138) [INFO] [talledLocalContainer] at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439) [INFO] [talledLocalContainer] at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) [INFO] [talledLocalContainer] at java.util.concurrent.FutureTask.run(FutureTask.java:138) [INFO] [talledLocalContainer] at com.atlassian.multitenant.impl.DefaultMultiTenantManager.runForTenant(DefaultMultiTenantManager.java:61) [INFO] [talledLocalContainer] at com.atlassian.multitenant.juc.MultiTenantExecutors$WrappedRunnable.run(MultiTenantExecutors.java:160) [INFO] [talledLocalContainer] at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) [INFO] [talledLocalContainer] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) [INFO] [talledLocalContainer] at java.lang.Thread.run(Thread.java:680) [INFO] [talledLocalContainer] Caused by: java.sql.SQLException: Invalid column type: 16 [INFO] [talledLocalContainer] at oracle.jdbc.driver.OracleStatement.getInternalType(OracleStatement.java:3879) [INFO] [talledLocalContainer] at oracle.jdbc.driver.OraclePreparedStatement.setNullCritical(OraclePreparedStatement.java:4406) [INFO] [talledLocalContainer] at oracle.jdbc.driver.OraclePreparedStatement.setNull(OraclePreparedStatement.java:4388) [INFO] [talledLocalContainer] at oracle.jdbc.driver.OraclePreparedStatementWrapper.setNull(OraclePreparedStatementWrapper.java:993) [INFO] [talledLocalContainer] at org.apache.commons.dbcp.DelegatingPreparedStatement.setNull(DelegatingPreparedStatement.java:108) [INFO] [talledLocalContainer] at org.apache.commons.dbcp.DelegatingPreparedStatement.setNull(DelegatingPreparedStatement.java:108) [INFO] [talledLocalContainer] at com.atlassian.dbexporter.importer.DataImporter$BaseInserter.setBoolean(DataImporter.java:344) [INFO] [talledLocalContainer] at com.atlassian.dbexporter.importer.DataImporter$BaseInserter.setValue(DataImporter.java:413) [INFO] [talledLocalContainer] at com.atlassian.dbexporter.importer.DataImporter.importTable(DataImporter.java:123) [INFO] [talledLocalContainer] ... 24 more {code} h3. Workaround This can be fixed with the instructions in our [Restore into Oracle database fails to import into AO table|https://confluence.atlassian.com/display/JIRAKB/Restore+into+Oracle+database+fails+to+import+into+AO+table] KB, or as per the below: # Locate the activeobjects.xml file in the backup data # Locate the line that contains: {code}<data tableName="AO_54307E_SERVICEDESK">{code} # Replace all instances of {code}<boolean xsi:nil="true"/>{code} in the rows with {code}<boolean>false</boolean>{code} # Rezip your backup files and import the backup

    Atlassian JIRA | 3 years ago | Edward Zhang [Atlassian]
    com.atlassian.activeobjects.spi.ActiveObjectsImportExportException: There was an error during import/export with plugin JIRA Service Desk(com.atlassian.servicedesk) #1.0.1-SNAPSHOT (table AO_54307E_SERVICEDESK):There has been a SQL exception importing row #0 for table 'AO_54307E_SERVICEDESK' see the cause of this exception for more detail about it.
  5. 0

    as mentionned by JIRA-38646, the exact same problem still occurs, depending of the content of your database at the moment you start the upgrade of Jira !!! This bug is NOT specific to MS SQL Server, and we reproduced it with Oracle 11g. We reproduced it during upgrade of our PROD evnironment, but the bug did not occurs during the repetition on our DEV environment!! Upgrade of DEV env worked fine... And we almost had to rollback our production release late in the evening .... until we dicovered a workaround! WORKAROUND: comment the section for the culprit class com.atlassian.jira.upgrade.tasks.UpgradeTask_Build6304 in file atlassian-jira/WEB-INF/classes/upgrades.xml {code} <!-- JIRA 6.3 --> <upgrade build="6301"> <class>com.atlassian.jira.upgrade.tasks.UpgradeTask_Build6301</class> </upgrade> <!-- <upgrade build="6302"> <class>com.atlassian.jira.upgrade.tasks.UpgradeTask_Build6302</class> </upgrade> --> <upgrade build="6304"> <class>com.atlassian.jira.upgrade.tasks.UpgradeTask_Build6304</class> </upgrade> {code} So please, - Tell what should be done for finishing the upgrade manually (what has to be inserted/updated/deleted in Quartz job trigger and details tables ? - re-open and FIX this bug JIRA-38646 !! For fun ... here is our stack trace on our Oracle JDBC Driver .... {code} ERROR [atlassian.jira.upgrade.UpgradeManagerImpl] Exception thrown during upgrade: while inserting: [GenericEntity:JQRTZJobDetails][jobName,TIMESHEET_SUBSCRIPTION][requestsRecovery,false][isVolatile,false][className,jira.timesheet.plugin.job.TimesheetJob][isDurable,true][jobG roup,TIMESHEET_SUBSCRIPTION][isStateful,false] (SQL Exception while setting value: (Invalid column type: 200 0)) org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:JQRTZJobDetails][jobName,TIMESH EET_SUBSCRIPTION][requestsRecovery,false][isVolatile,false][className,jira.timesheet.plugin.job.TimesheetJob] [isDurable,true][jobGroup,TIMESHEET_SUBSCRIPTION][isStateful,false] (SQL Exception while setting value: (Inv alid column type: 2000)) at org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:200) at org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:165) at org.ofbiz.core.entity.GenericHelperDAO.create(GenericHelperDAO.java:83) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:554) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:540) at org.ofbiz.core.entity.GenericValue.create(GenericValue.java:98) at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build6302.upgradeJobDetails(UpgradeTask_Build6302.jav a:93) at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build6302.doUpgrade(UpgradeTask_Build6302.java:61) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeTaskSuccess(UpgradeManagerImpl.java:693) at com.atlassian.jira.upgrade.UpgradeManagerImpl.runUpgradeTasks(UpgradeManagerImpl.java:542) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgrade(UpgradeManagerImpl.java:471) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeIfNeeded(UpgradeManagerImpl.java:413) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeIfNeededAndAllowed(UpgradeManagerImpl.java: 348) at com.atlassian.jira.upgrade.UpgradeLauncher.checkIfUpgradeNeeded(UpgradeLauncher.java:106) at com.atlassian.jira.upgrade.UpgradeLauncher.start(UpgradeLauncher.java:54) at com.atlassian.jira.startup.ActiveServicesLauncher.start(ActiveServicesLauncher.java:42) at com.atlassian.jira.startup.DefaultJiraLauncher$3.run(DefaultJiraLauncher.java:137) at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrEnqueue(DatabaseConfigu rationManagerImpl.java:324) at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrWhenDatabaseActivated(D atabaseConfigurationManagerImpl.java:214) at com.atlassian.jira.startup.DefaultJiraLauncher.postDbLaunch(DefaultJiraLauncher.java:118) at com.atlassian.jira.startup.DefaultJiraLauncher.access$100(DefaultJiraLauncher.java:32) at com.atlassian.jira.startup.DefaultJiraLauncher$1.run(DefaultJiraLauncher.java:81) at com.atlassian.jira.util.devspeed.JiraDevSpeedTimer.run(JiraDevSpeedTimer.java:34) at com.atlassian.jira.startup.DefaultJiraLauncher.start(DefaultJiraLauncher.java:76) at com.atlassian.jira.startup.LauncherContextListener.contextInitialized(LauncherContextListener.java:71) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4992) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5490) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1575) at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1565) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while setting value: (Invalid column type: 2000) at org.ofbiz.core.entity.jdbc.SqlJdbcUtil.setValue(SqlJdbcUtil.java:804) at org.ofbiz.core.entity.jdbc.SqlJdbcUtil.setValue(SqlJdbcUtil.java:714) at org.ofbiz.core.entity.jdbc.SqlJdbcUtil.setValues(SqlJdbcUtil.java:534) at org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:191) at org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:165) at org.ofbiz.core.entity.GenericHelperDAO.create(GenericHelperDAO.java:83) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:554) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:540) at org.ofbiz.core.entity.GenericValue.create(GenericValue.java:98) at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build6302.upgradeJobDetails(UpgradeTask_Build6302.java:93) at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build6302.doUpgrade(UpgradeTask_Build6302.java:61) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeTaskSuccess(UpgradeManagerImpl.java:693) at com.atlassian.jira.upgrade.UpgradeManagerImpl.runUpgradeTasks(UpgradeManagerImpl.java:542) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgrade(UpgradeManagerImpl.java:471) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeIfNeeded(UpgradeManagerImpl.java:413) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeIfNeededAndAllowed(UpgradeManagerImpl.java:348) at com.atlassian.jira.upgrade.UpgradeLauncher.checkIfUpgradeNeeded(UpgradeLauncher.java:106) at com.atlassian.jira.upgrade.UpgradeLauncher.start(UpgradeLauncher.java:54) at com.atlassian.jira.startup.ActiveServicesLauncher.start(ActiveServicesLauncher.java:42) at com.atlassian.jira.startup.DefaultJiraLauncher$3.run(DefaultJiraLauncher.java:137) at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrEnqueue(DatabaseConfigurationManagerImpl.java:324) at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrWhenDatabaseActivated(D atabaseConfigurationManagerImpl.java:214) at com.atlassian.jira.startup.DefaultJiraLauncher.postDbLaunch(DefaultJiraLauncher.java:118) at com.atlassian.jira.startup.DefaultJiraLauncher.access$100(DefaultJiraLauncher.java:32) at com.atlassian.jira.startup.DefaultJiraLauncher$1.run(DefaultJiraLauncher.java:81) at com.atlassian.jira.util.devspeed.JiraDevSpeedTimer.run(JiraDevSpeedTimer.java:34) at com.atlassian.jira.startup.DefaultJiraLauncher.start(DefaultJiraLauncher.java:76) at com.atlassian.jira.startup.LauncherContextListener.contextInitialized(LauncherContextListener.java:71) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4992) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5490) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1575) at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1565) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) java.sql.SQLException: Invalid column type: 2000 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 org.apache.commons.dbcp.DelegatingPreparedStatement.setNull(DelegatingPreparedStatement.java:108) at org.apache.commons.dbcp.DelegatingPreparedStatement.setNull(DelegatingPreparedStatement.java:108) at org.ofbiz.core.entity.jdbc.SQLProcessor.setBinaryStream(SQLProcessor.java:1103) at org.ofbiz.core.entity.jdbc.SqlJdbcUtil.setValue(SqlJdbcUtil.java:791) at org.ofbiz.core.entity.jdbc.SqlJdbcUtil.setValue(SqlJdbcUtil.java:714) at org.ofbiz.core.entity.jdbc.SqlJdbcUtil.setValues(SqlJdbcUtil.java:534) at org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:191) at org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:165) at org.ofbiz.core.entity.GenericHelperDAO.create(GenericHelperDAO.java:83) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:554) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:540) at org.ofbiz.core.entity.GenericValue.create(GenericValue.java:98) at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build6302.upgradeJobDetails(UpgradeTask_Build6302.java:93) at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build6302.doUpgrade(UpgradeTask_Build6302.java:61) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeTaskSuccess(UpgradeManagerImpl.java:693) at com.atlassian.jira.upgrade.UpgradeManagerImpl.runUpgradeTasks(UpgradeManagerImpl.java:542) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgrade(UpgradeManagerImpl.java:471) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeIfNeeded(UpgradeManagerImpl.java:413) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeIfNeededAndAllowed(UpgradeManagerImpl.java:348) at com.atlassian.jira.upgrade.UpgradeLauncher.checkIfUpgradeNeeded(UpgradeLauncher.java:106) at com.atlassian.jira.upgrade.UpgradeLauncher.start(UpgradeLauncher.java:54) at com.atlassian.jira.startup.ActiveServicesLauncher.start(ActiveServicesLauncher.java:42) at com.atlassian.jira.startup.DefaultJiraLauncher$3.run(DefaultJiraLauncher.java:137) at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrEnqueue(DatabaseConfigurationManagerImpl.java:324) at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrWhenDatabaseActivated(DatabaseConfigurationManagerImpl.java:214) at com.atlassian.jira.startup.DefaultJiraLauncher.postDbLaunch(DefaultJiraLauncher.java:118) at com.atlassian.jira.startup.DefaultJiraLauncher.access$100(DefaultJiraLauncher.java:32) at com.atlassian.jira.startup.DefaultJiraLauncher$1.run(DefaultJiraLauncher.java:81) at com.atlassian.jira.util.devspeed.JiraDevSpeedTimer.run(JiraDevSpeedTimer.java:34) at com.atlassian.jira.startup.DefaultJiraLauncher.start(DefaultJiraLauncher.java:76) at com.atlassian.jira.startup.LauncherContextListener.contextInitialized(LauncherContextListener.java:71) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4992) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5490) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1575) at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1565) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) {code}

    Atlassian JIRA | 2 years ago | Arnaud Nauwynck
    java.sql.SQLException: Invalid column type: 2000

    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: sqlType=2003

      at oracle.jdbc.driver.OraclePreparedStatement.setNullCritical()
    2. Oracle jdbc
      OraclePreparedStatementWrapper.setNull
      1. oracle.jdbc.driver.OraclePreparedStatement.setNullCritical(OraclePreparedStatement.java:4641)
      2. oracle.jdbc.driver.OraclePreparedStatement.setNull(OraclePreparedStatement.java:4523)
      3. oracle.jdbc.driver.OraclePreparedStatementWrapper.setNull(OraclePreparedStatementWrapper.java:1281)
      3 frames
    3. Commons DBCP
      DelegatingPreparedStatement.setNull
      1. org.apache.commons.dbcp.DelegatingPreparedStatement.setNull(DelegatingPreparedStatement.java:105)
      1 frame
    4. com.ibatis.sqlmap
      SqlMapClientImpl.queryForObject
      1. com.ibatis.sqlmap.engine.mapping.parameter.ParameterMap.setParameter(ParameterMap.java:172)
      2. com.ibatis.sqlmap.engine.mapping.parameter.ParameterMap.setParameters(ParameterMap.java:126)
      3. com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQueryProcedure(SqlExecutor.java:276)
      4. com.ibatis.sqlmap.engine.mapping.statement.ProcedureStatement.sqlExecuteQuery(ProcedureStatement.java:39)
      5. com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:189)
      6. com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryForObject(MappedStatement.java:120)
      7. com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:518)
      8. com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:493)
      9. com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java:106)
      10. com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForObject(SqlMapClientImpl.java:82)
      10 frames
    5. com.vzb.mss
      SearchAction.execute
      1. com.vzb.mss.signaturetool.persistence.ibatis.IbatisAbstractRepository.getList(IbatisAbstractRepository.java:75)
      2. com.vzb.mss.signaturetool.persistence.ibatis.IbatisWatchlistRepository.searchWatchlist(IbatisWatchlistRepository.java:167)
      3. com.vzb.mss.signaturetool.presentation.services.watchlist.SearchAction.execute(SearchAction.java:116)
      3 frames
    6. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      4. java.lang.reflect.Method.invoke(Method.java:601)
      4 frames
    7. XWork
      ValidationInterceptor.doIntercept
      1. com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:404)
      2. com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:267)
      3. com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:229)
      4. com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:221)
      5. com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:86)
      6. com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:224)
      7. com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:223)
      8. com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:455)
      9. com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:221)
      10. com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:150)
      10 frames
    8. Struts2
      AnnotationValidationInterceptor.doIntercept
      1. org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:48)
      1 frame
    9. XWork
      DefaultActionInvocation.invoke
      1. com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:86)
      2. com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:224)
      3. com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:223)
      4. com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:455)
      5. com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:221)
      6. com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:123)
      7. com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:224)
      8. com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:223)
      9. com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:455)
      10. com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:221)
      11. com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:184)
      12. com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:86)
      13. com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:224)
      14. com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:223)
      15. com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:455)
      16. com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:221)
      16 frames
    10. com.vzb.mss
      ModelDrivenInterceptor.intercept
      1. com.vzb.mss.commons.presentation.model.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:112)
      1 frame
    11. XWork
      DefaultActionInvocation.invoke
      1. com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:224)
      2. com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:223)
      3. com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:455)
      4. com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:221)
      4 frames
    12. Struts2
      ProfilingActivationInterceptor.intercept
      1. org.apache.struts2.interceptor.ProfilingActivationInterceptor.intercept(ProfilingActivationInterceptor.java:107)
      1 frame
    13. XWork
      DefaultActionInvocation.invoke
      1. com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:224)
      2. com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:223)
      3. com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:455)
      4. com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:221)
      4 frames
    14. Struts2
      DebuggingInterceptor.intercept
      1. org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:206)
      1 frame
    15. XWork
      DefaultActionInvocation.invoke
      1. com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:224)
      2. com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:223)
      3. com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:455)
      4. com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:221)
      5. com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:115)
      6. com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:224)
      7. com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:223)
      8. com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:455)
      9. com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:221)
      10. com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:143)
      11. com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:224)
      12. com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:223)
      13. com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:455)
      14. com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:221)
      15. com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:121)
      16. com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:86)
      17. com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:224)
      18. com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:223)
      19. com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:455)
      20. com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:221)
      20 frames
    16. Struts2
      ServletConfigInterceptor.intercept
      1. org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:170)
      1 frame
    17. XWork
      DefaultActionInvocation.invoke
      1. com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:224)
      2. com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:223)
      3. com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:455)
      4. com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:221)
      4 frames
    18. com.vzb.mss
      PersistanceInterceptor.intercept
      1. com.vzb.mss.signaturetool.presentation.persistence.PersistanceInterceptor.intercept(PersistanceInterceptor.java:72)
      1 frame
    19. XWork
      DefaultActionInvocation.invoke
      1. com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:224)
      2. com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:223)
      3. com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:455)
      4. com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:221)
      4 frames
    20. com.vzb.mss
      AuthenticatorInterceptor.intercept
      1. com.vzb.mss.commons.presentation.authentication.AuthenticatorInterceptor.intercept(AuthenticatorInterceptor.java:134)
      1 frame
    21. XWork
      DefaultActionInvocation.invoke
      1. com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:224)
      2. com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:223)
      3. com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:455)
      4. com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:221)
      5. com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:176)
      6. com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:224)
      7. com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:223)
      8. com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:455)
      9. com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:221)
      9 frames
    22. Struts2
      FilterDispatcher.doFilter
      1. org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:50)
      2. org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:504)
      3. org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:422)
      3 frames
    23. Glassfish Core
      CoyoteAdapter.service
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
      4. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
      5. org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:465)
      6. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
      7. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
      8. org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:421)
      9. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
      10. org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
      10 frames
    24. Grizzly HTTP
      JIoEndpoint$Worker.run
      1. org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
      2. org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
      3. org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
      3 frames
    25. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:722)
      1 frame