java.sql.SQLException: Vincoli di colonna inaccettabili in statement \[ALTER TABLE CAR ADD COLUMN USED BOOLEAN NOT NULL\]

romaframework | nobody | 8 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Deleting instances of old version of a class

    romaframework | 8 years ago | nobody
    java.sql.SQLException: Vincoli di colonna inaccettabili in statement \[ALTER TABLE CAR ADD COLUMN USED BOOLEAN NOT NULL\]
  2. 0

    HSQLDB and Liquibase, Table already exists: DATABASECHANGELOGLOCK

    Stack Overflow | 3 years ago | Gleeb
    java.sql.SQLException: Table already exists: DATABASECHANGELOGLOCK in statement [CREATE TABLE PUBLIC.DATABASECHANGELOGLOCK]
  3. 0

    JDBC config ignored

    Google Groups | 7 years ago | Matthew Smith
    java.sql.SQLException: Three part identifiers prohibited in statement [select * from portdb.dbo.]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    {noformat} 2011-09-05 12:22:23,443 ERROR [2-UpgradeTaskBackgroundThread:pool-8-thread-1] [AbstractStatementUpgradeTask] Unable to run ALTER TABLE USER_COMMIT DROP COLUMN BUILDRESULTSUMMARY_ID : Column is referenced in constraint or view: FKF8936C2BA958B29F in statement [ALTER TABLE USER_COMMIT DROP COLUMN BUILDRESULTSUMMARY_ID] java.sql.SQLException: Column is referenced in constraint or view: FKF8936C2BA958B29F in statement [ALTER TABLE USER_COMMIT DROP COLUMN BUILDRESULTSUMMARY_ID] at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source) at org.hsqldb.jdbc.jdbcStatement.execute(Unknown Source) at com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:1006) at com.atlassian.bamboo.upgrade.tasks.AbstractStatementUpgradeTask.doUpgrade(AbstractStatementUpgradeTask.java:42) at com.atlassian.bamboo.upgrade.tasks.AbstractInHibernateTransactionUpgradeTask$1.doInHibernateTransaction(AbstractInHibernateTransactionUpgradeTask.java:40) at com.atlassian.bamboo.persistence.BambooConnectionTemplate$1$1.doInHibernate(BambooConnectionTemplate.java:51) at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:370) at com.atlassian.bamboo.persistence.BambooConnectionTemplate$1.doInTransactionWithoutResult(BambooConnectionTemplate.java:44) at org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:33) at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:127) at com.atlassian.bamboo.persistence.BambooConnectionTemplate.execute(BambooConnectionTemplate.java:39) at com.atlassian.bamboo.upgrade.tasks.AbstractInHibernateTransactionUpgradeTask.doUpgrade(AbstractInHibernateTransactionUpgradeTask.java:36) at com.atlassian.bamboo.upgrade.AbstractUpgradeManager.runUpgradeTask(AbstractUpgradeManager.java:175) at com.atlassian.bamboo.upgrade.UpgradeManagerImpl.doUpgrade(UpgradeManagerImpl.java:92) at com.atlassian.bamboo.upgrade.UpgradeLauncher$1.call(UpgradeLauncher.java:115) at com.atlassian.bamboo.upgrade.UpgradeLauncher$1.call(UpgradeLauncher.java:112) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at com.atlassian.bamboo.build.pipeline.concurrent.NamedThreadFactory$2.run(NamedThreadFactory.java:50) at java.lang.Thread.run(Thread.java:619) {noformat}

    Atlassian JIRA | 6 years ago | Dariusz Kordonski [Atlassian]
    java.sql.SQLException: Column is referenced in constraint or view: FKF8936C2BA958B29F in statement [ALTER TABLE USER_COMMIT DROP COLUMN BUILDRESULTSUMMARY_ID]
  6. 0

    {noformat} 2011-09-05 12:22:23,443 ERROR [2-UpgradeTaskBackgroundThread:pool-8-thread-1] [AbstractStatementUpgradeTask] Unable to run ALTER TABLE USER_COMMIT DROP COLUMN BUILDRESULTSUMMARY_ID : Column is referenced in constraint or view: FKF8936C2BA958B29F in statement [ALTER TABLE USER_COMMIT DROP COLUMN BUILDRESULTSUMMARY_ID] java.sql.SQLException: Column is referenced in constraint or view: FKF8936C2BA958B29F in statement [ALTER TABLE USER_COMMIT DROP COLUMN BUILDRESULTSUMMARY_ID] at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source) at org.hsqldb.jdbc.jdbcStatement.execute(Unknown Source) at com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:1006) at com.atlassian.bamboo.upgrade.tasks.AbstractStatementUpgradeTask.doUpgrade(AbstractStatementUpgradeTask.java:42) at com.atlassian.bamboo.upgrade.tasks.AbstractInHibernateTransactionUpgradeTask$1.doInHibernateTransaction(AbstractInHibernateTransactionUpgradeTask.java:40) at com.atlassian.bamboo.persistence.BambooConnectionTemplate$1$1.doInHibernate(BambooConnectionTemplate.java:51) at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:370) at com.atlassian.bamboo.persistence.BambooConnectionTemplate$1.doInTransactionWithoutResult(BambooConnectionTemplate.java:44) at org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:33) at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:127) at com.atlassian.bamboo.persistence.BambooConnectionTemplate.execute(BambooConnectionTemplate.java:39) at com.atlassian.bamboo.upgrade.tasks.AbstractInHibernateTransactionUpgradeTask.doUpgrade(AbstractInHibernateTransactionUpgradeTask.java:36) at com.atlassian.bamboo.upgrade.AbstractUpgradeManager.runUpgradeTask(AbstractUpgradeManager.java:175) at com.atlassian.bamboo.upgrade.UpgradeManagerImpl.doUpgrade(UpgradeManagerImpl.java:92) at com.atlassian.bamboo.upgrade.UpgradeLauncher$1.call(UpgradeLauncher.java:115) at com.atlassian.bamboo.upgrade.UpgradeLauncher$1.call(UpgradeLauncher.java:112) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at com.atlassian.bamboo.build.pipeline.concurrent.NamedThreadFactory$2.run(NamedThreadFactory.java:50) at java.lang.Thread.run(Thread.java:619) {noformat}

    Atlassian JIRA | 6 years ago | Dariusz Kordonski
    java.sql.SQLException: Column is referenced in constraint or view: FKF8936C2BA958B29F in statement [ALTER TABLE USER_COMMIT DROP COLUMN BUILDRESULTSUMMARY_ID]

    3 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

      Vincoli di colonna inaccettabili in statement \[ALTER TABLE CAR ADD COLUMN USED BOOLEAN NOT NULL\]

      at org.hsqldb.jdbc.Util.sqlException()
    2. HSQLDB
      jdbcStatement.execute
      1. org.hsqldb.jdbc.Util.sqlException(Unknown Source)
      2. org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
      3. org.hsqldb.jdbc.jdbcStatement.execute(Unknown Source)
      3 frames
    3. c3p0:JDBC DataSources/Resource Pools
      NewProxyStatement.execute
      1. com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:1006)
      1 frame
    4. DataNucleus RDBMS plugin
      RDBMSManager.addClasses
      1. org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:730)
      2. org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:681)
      3. org.datanucleus.store.rdbms.table.TableImpl.validateColumns(TableImpl.java:261)
      4. org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.performTablesValidation(RDBMSManager.java:2794)
      5. org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:2595)
      6. org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2241)
      7. org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:113)
      8. org.datanucleus.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:994)
      9. org.datanucleus.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:960)
      9 frames
    5. DataNucleus Core
      AbstractStoreManager.addClass
      1. org.datanucleus.store.AbstractStoreManager.addClass(AbstractStoreManager.java:691)
      1 frame
    6. org.datanucleus.store
      MappedStoreManager.getDatastoreClass
      1. org.datanucleus.store.mapped.MappedStoreManager.getDatastoreClass(MappedStoreManager.java:358)
      1 frame
    7. DataNucleus RDBMS plugin
      RDBMSManager.getExtent
      1. org.datanucleus.store.rdbms.RDBMSManager.getExtent(RDBMSManager.java:1344)
      1 frame
    8. DataNucleus Core
      ObjectManagerImpl.getExtent
      1. org.datanucleus.ObjectManagerImpl.getExtent(ObjectManagerImpl.java:3736)
      1 frame
    9. DataNucleus Enhancer
      NucleusJDOHelper.getJDOExceptionForNucleusException
      1. org.datanucleus.jdo.NucleusJDOHelper.getJDOExceptionForNucleusException(NucleusJDOHelper.java:289)
      1 frame
    10. DataNucleus Core
      ObjectManagerImpl.getExtent
      1. org.datanucleus.ObjectManagerImpl.getExtent(ObjectManagerImpl.java:3741)
      1 frame
    11. DataNucleus Enhancer
      JDOPersistenceManager.getExtent
      1. org.datanucleus.jdo.JDOPersistenceManager.getExtent(JDOPersistenceManager.java:1515)
      1 frame
    12. org.romaframework.aspect
      JDOPersistenceHelper.getQuery
      1. org.romaframework.aspect.persistence.datanucleus.jdo.JDOPersistenceHelper.getQuery(JDOPersistenceHelper.java:79)
      1 frame