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

romaframework | nobody | 7 years ago
  1. 0

    Deleting instances of old version of a class

    romaframework | 7 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 | 2 years ago | Gleeb
    java.sql.SQLException: Table already exists: DATABASECHANGELOGLOCK in statement [CREATE TABLE PUBLIC.DATABASECHANGELOGLOCK]
  3. 0

    JDBC config ignored

    Google Groups | 6 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 | 5 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 | 5 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
      JDOPersistenceManager.getExtent
      1. org.datanucleus.jdo.JDOPersistenceManager.getExtent(JDOPersistenceManager.java:1515)
      1 frame
    10. org.romaframework.aspect
      JDOBasePersistenceAspect.query
      1. org.romaframework.aspect.persistence.datanucleus.jdo.JDOPersistenceHelper.getQuery(JDOPersistenceHelper.java:79)
      2. org.romaframework.aspect.persistence.datanucleus.jdo.JDOPersistenceHelper.queryByFilter(JDOPersistenceHelper.java:223)
      3. org.romaframework.aspect.persistence.datanucleus.jdo.JDOPersistenceHelper.queryByExample(JDOPersistenceHelper.java:195)
      4. org.romaframework.aspect.persistence.datanucleus.jdo.JDOBasePersistenceAspect.query(JDOBasePersistenceAspect.java:309)
      4 frames
    11. org.romaframework.core
      PersistenceAspectRepository.findByCriteria
      1. org.romaframework.core.repository.PersistenceAspectRepository.findByCriteria(PersistenceAspectRepository.java:48)
      1 frame
    12. org.romaframework.frontend
      CRUDMain.search
      1. org.romaframework.frontend.domain.crud.CRUDMain.executeQuery(CRUDMain.java:280)
      2. org.romaframework.frontend.domain.crud.CRUDMain.executePagingQuery(CRUDMain.java:258)
      3. org.romaframework.frontend.domain.crud.CRUDMain.searchByExample(CRUDMain.java:199)
      4. org.romaframework.frontend.domain.crud.CRUDMain.search(CRUDMain.java:185)
      4 frames
    13. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
      4. java.lang.reflect.Method.invoke(Unknown Source)
      4 frames
    14. org.romaframework.core
      Controller.executeAction
      1. org.romaframework.core.schema.reflection.SchemaActionReflection.invoke(SchemaActionReflection.java:46)
      2. org.romaframework.core.flow.Controller.executeAction(Controller.java:66)
      2 frames
    15. org.romaframework.aspect
      EntityForm.actionPerformed
      1. org.romaframework.aspect.view.echo2.form.EntityForm.executeAction(EntityForm.java:377)
      2. org.romaframework.aspect.view.echo2.form.EntityForm.actionPerformed(EntityForm.java:213)
      2 frames
    16. nextapp.echo2.app
      UpdateManager.processClientUpdates
      1. nextapp.echo2.app.button.AbstractButton.fireActionPerformed(AbstractButton.java:135)
      2. nextapp.echo2.app.button.AbstractButton$1.actionPerformed(AbstractButton.java:100)
      3. nextapp.echo2.app.button.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:70)
      4. nextapp.echo2.app.button.DefaultButtonModel.doAction(DefaultButtonModel.java:58)
      5. nextapp.echo2.app.button.AbstractButton.doAction(AbstractButton.java:121)
      6. nextapp.echo2.app.button.AbstractButton.processInput(AbstractButton.java:506)
      7. nextapp.echo2.app.update.ClientUpdateManager.process(ClientUpdateManager.java:116)
      8. nextapp.echo2.app.update.UpdateManager.processClientUpdates(UpdateManager.java:89)
      8 frames
    17. nextapp.echo2.webcontainer
      ContainerSynchronizeService.renderUpdate
      1. nextapp.echo2.webcontainer.ContainerSynchronizeService.renderUpdate(ContainerSynchronizeService.java:471)
      1 frame
    18. nextapp.echo2.webrender
      WebRenderServlet.process
      1. nextapp.echo2.webrender.service.SynchronizeService.service(SynchronizeService.java:279)
      2. nextapp.echo2.webrender.WebRenderServlet.process(WebRenderServlet.java:273)
      2 frames
    19. org.romaframework.aspect
      Echo2StartupServlet.process
      1. org.romaframework.aspect.view.echo2.Echo2StartupServlet.process(Echo2StartupServlet.java:52)
      1 frame
    20. nextapp.echo2.webrender
      WebRenderServlet.doPost
      1. nextapp.echo2.webrender.WebRenderServlet.doPost(WebRenderServlet.java:189)
      1 frame
    21. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
      2. javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
      2 frames
    22. Jetty Server
      ServletHandler$CachedChain.doFilter
      1. org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:502)
      2. org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1148)
      2 frames
    23. org.romaframework.web
      RomaWebFilter.doFilter
      1. org.romaframework.web.RomaWebFilter.doFilter(RomaWebFilter.java:77)
      1 frame
    24. Jetty Server
      SelectChannelEndPoint.run
      1. org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1139)
      2. org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:378)
      3. org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
      4. org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
      5. org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)
      6. org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:417)
      7. org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
      8. org.mortbay.jetty.Server.handle(Server.java:324)
      9. org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:535)
      10. org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:880)
      11. org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:747)
      12. org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218)
      13. org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
      14. org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:409)
      14 frames
    25. Jetty Util
      QueuedThreadPool$PoolThread.run
      1. org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:520)
      1 frame