java.sql.SQLException

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

Solutions on the web12164

  • Vincoli di colonna inaccettabili in statement \[ALTER TABLE CAR ADD COLUMN USED BOOLEAN NOT NULL\]
  • Column already exists in statement \[alter table items add column version integer default 0 not null before type\]
  • Could not run raw execute statement ALTER TABLE bm_player_mutes ADD COLUMN `soft` TINYINT(1), ADD KEY `bm_player_mutes_soft_idx` (`soft`)
  • Stack trace

    • java.sql.SQLException: Vincoli di colonna inaccettabili in statement \[ALTER TABLE CAR ADD COLUMN USED BOOLEAN NOT NULL\] at org.datanucleus.jdo.NucleusJDOHelper.getJDOExceptionForNucleusException(NucleusJDOHelper.java:289) at org.datanucleus.ObjectManagerImpl.getExtent(ObjectManagerImpl.java:3741) at org.datanucleus.jdo.JDOPersistenceManager.getExtent(JDOPersistenceManager.java:1515) at org.romaframework.aspect.persistence.datanucleus.jdo.JDOPersistenceHelper.getQuery(JDOPersistenceHelper.java:79) Caused by: 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) ... 4 more

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 2 years ago
    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    12 more bugmates