java.sql.SQLException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • Deleting instances of old version of a class
    via romaframework by nobody
    ,
  • JDBC config ignored
    via by Matthew Smith,
  • {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}
    via by Dariusz Kordonski [Atlassian],
  • {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}
    via by Dariusz Kordonski,
    • java.sql.SQLException: Vincoli di colonna inaccettabili in statement \[ALTER TABLE CAR ADD COLUMN USED BOOLEAN NOT NULL\] 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 org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:730) at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:681) at org.datanucleus.store.rdbms.table.TableImpl.validateColumns(TableImpl.java:261) at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.performTablesValidation(RDBMSManager.java:2794) at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:2595) at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2241) at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:113) at org.datanucleus.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:994) at org.datanucleus.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:960) at org.datanucleus.store.AbstractStoreManager.addClass(AbstractStoreManager.java:691) at org.datanucleus.store.mapped.MappedStoreManager.getDatastoreClass(MappedStoreManager.java:358) at org.datanucleus.store.rdbms.RDBMSManager.getExtent(RDBMSManager.java:1344) at org.datanucleus.ObjectManagerImpl.getExtent(ObjectManagerImpl.java:3736) at org.datanucleus.jdo.JDOPersistenceManager.getExtent(JDOPersistenceManager.java:1515) at org.romaframework.aspect.persistence.datanucleus.jdo.JDOPersistenceHelper.getQuery(JDOPersistenceHelper.java:79) at org.romaframework.aspect.persistence.datanucleus.jdo.JDOPersistenceHelper.queryByFilter(JDOPersistenceHelper.java:223) at org.romaframework.aspect.persistence.datanucleus.jdo.JDOPersistenceHelper.queryByExample(JDOPersistenceHelper.java:195) at org.romaframework.aspect.persistence.datanucleus.jdo.JDOBasePersistenceAspect.query(JDOBasePersistenceAspect.java:309) at org.romaframework.core.repository.PersistenceAspectRepository.findByCriteria(PersistenceAspectRepository.java:48) at org.romaframework.frontend.domain.crud.CRUDMain.executeQuery(CRUDMain.java:280) at org.romaframework.frontend.domain.crud.CRUDMain.executePagingQuery(CRUDMain.java:258) at org.romaframework.frontend.domain.crud.CRUDMain.searchByExample(CRUDMain.java:199) at org.romaframework.frontend.domain.crud.CRUDMain.search(CRUDMain.java:185) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.romaframework.core.schema.reflection.SchemaActionReflection.invoke(SchemaActionReflection.java:46) at org.romaframework.core.flow.Controller.executeAction(Controller.java:66) at org.romaframework.aspect.view.echo2.form.EntityForm.executeAction(EntityForm.java:377) at org.romaframework.aspect.view.echo2.form.EntityForm.actionPerformed(EntityForm.java:213) at nextapp.echo2.app.button.AbstractButton.fireActionPerformed(AbstractButton.java:135) at nextapp.echo2.app.button.AbstractButton$1.actionPerformed(AbstractButton.java:100) at nextapp.echo2.app.button.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:70) at nextapp.echo2.app.button.DefaultButtonModel.doAction(DefaultButtonModel.java:58) at nextapp.echo2.app.button.AbstractButton.doAction(AbstractButton.java:121) at nextapp.echo2.app.button.AbstractButton.processInput(AbstractButton.java:506) at nextapp.echo2.app.update.ClientUpdateManager.process(ClientUpdateManager.java:116) at nextapp.echo2.app.update.UpdateManager.processClientUpdates(UpdateManager.java:89) at nextapp.echo2.webcontainer.ContainerSynchronizeService.renderUpdate(ContainerSynchronizeService.java:471) at nextapp.echo2.webrender.service.SynchronizeService.service(SynchronizeService.java:279) at nextapp.echo2.webrender.WebRenderServlet.process(WebRenderServlet.java:273) at org.romaframework.aspect.view.echo2.Echo2StartupServlet.process(Echo2StartupServlet.java:52) at nextapp.echo2.webrender.WebRenderServlet.doPost(WebRenderServlet.java:189) at javax.servlet.http.HttpServlet.service(HttpServlet.java:709) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:502) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1148) at org.romaframework.web.RomaWebFilter.doFilter(RomaWebFilter.java:77) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1139) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:378) at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765) at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:417) at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) at org.mortbay.jetty.Server.handle(Server.java:324) at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:535) at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:880) at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:747) at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218) at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404) at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:409) at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:520)

    Users with the same issue

    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    12 more bugmates