James sent me directly his Maven output. What I find interesting is that there is a check for existence of the table that says "no such table" and then immediately fails:
15:14:23,706 [Schema Thread-3 DEBUG] Check of existence of isissettings."UserSetting" returned no table 15:14:23,706 [Schema Thread-3 DEBUG] Creating table isissettings."UserSetting" 15:14:23,706 [Schema Thread-3 DEBUG] CREATE TABLE isissettings."UserSetting" ( "key" NVARCHAR(128) NOT NULL, "user" NVARCHAR(50) NOT NULL, "description" NVARCHAR(254) NULL, "type" NVARCHAR(20) NOT NULL, "valueRaw" NVARCHAR(255) NOT NULL, CONSTRAINT "UserSetting_PK" PRIMARY KEY ("key","user") ) 15:14:23,707 [Datastore Thread-3 ERROR] Error thrown executing CREATE TABLE isissettings."UserSetting" ( "key" NVARCHAR(128) NOT NULL, "user" NVARCHAR(50) NOT NULL, "description" NVARCHAR(254) NULL, "type" NVARCHAR(20) NOT NULL, "valueRaw" NVARCHAR(255) NOT NULL, CONSTRAINT "UserSetting_PK" PRIMARY KEY ("key","user") ) : object name already exists: UserSetting in statement [CREATE TABLE isissettings."UserSetting" ( "key" NVARCHAR(128) NOT NULL, "user" NVARCHAR(50) NOT NULL, "description" NVARCHAR(254) NULL, "type" NVARCHAR(20) NOT NULL, "valueRaw" NVARCHAR(255) NOT NULL, CONSTRAINT "UserSetting_PK" PRIMARY KEY ("key","user") )] java.sql.SQLSyntaxErrorException: object name already exists: UserSetting in statement [CREATE TABLE isissettings."UserSetting" ( "key" NVARCHAR(128) NOT NULL, "user" NVARCHAR(50) NOT NULL, "description" NVARCHAR(254) NULL, "type" NVARCHAR(20) NOT NULL, "valueRaw" NVARCHAR(255) NOT NULL, CONSTRAINT "UserSetting_PK" PRIMARY KEY ("key","user") )] at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source) at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source) at org.datanucleus.store.rdbms.datasource.dbcp.DelegatingStatement.execute(DelegatingStatement.java:246) at org.datanucleus.store.rdbms.datasource.dbcp.DelegatingStatement.execute(DelegatingStatement.java:246) at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:864) at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:815) at org.datanucleus.store.rdbms.table.AbstractTable.create(AbstractTable.java:531) at org.datanucleus.store.rdbms.table.AbstractTable.exists(AbstractTable.java:594) at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.performTablesValidation(RDBMSStoreManager.java:3355) at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.run(RDBMSStoreManager.java:2871) at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:119) at org.datanucleus.store.rdbms.RDBMSStoreManager.createSchemaForClasses(RDBMSStoreManager.java:3838) at org.apache.isis.objectstore.jdo.datanucleus.DataNucleusApplicationComponents.createSchema(DataNucleusApplicationComponents.java:142) at org.apache.isis.objectstore.jdo.datanucleus.DataNucleusApplicationComponents.initialize(DataNucleusApplicationComponents.java:121) at org.apache.isis.objectstore.jdo.datanucleus.DataNucleusApplicationComponents.<init>(DataNucleusApplicationComponents.java:106) at org.apache.isis.objectstore.jdo.datanucleus.DataNucleusPersistenceMechanismInstaller.createDataNucleusApplicationComponentsIfRequired(DataNucleusPersistenceMechanismInstaller.java:119) at org.apache.isis.objectstore.jdo.datanucleus.DataNucleusPersistenceMechanismInstaller.createObjectStore(DataNucleusPersistenceMechanismInstaller.java:97) at org.apache.isis.core.runtime.system.persistence.PersistenceSessionFactory.createPersistenceSession(PersistenceSessionFactory.java:94) at org.apache.isis.core.runtime.system.session.IsisSessionFactoryDefault.openSession(IsisSessionFactoryDefault.java:217) at org.apache.isis.core.runtime.system.context.IsisContextStatic.openSessionInstance(IsisContextStatic.java:70) at org.apache.isis.core.runtime.system.context.IsisContext.openSession(IsisContext.java:275) at org.apache.isis.core.runtime.system.IsisSystemFixturesHookAbstract.shutdownServices(IsisSystemFixturesHookAbstract.java:230) at org.apache.isis.core.runtime.system.IsisSystemFixturesHookAbstract.shutdown(IsisSystemFixturesHookAbstract.java:219) at org.apache.isis.core.integtestsupport.IsisSystemForTest.shutdown(IsisSystemForTest.java:429) at org.apache.isis.core.integtestsupport.IsisSystemForTest.access$100(IsisSystemForTest.java:67) at org.apache.isis.core.integtestsupport.IsisSystemForTest$Builder$1.run(IsisSystemForTest.java:265) Caused by: org.hsqldb.HsqlException: object name already exists: UserSetting at org.hsqldb.error.Error.error(Unknown Source) at org.hsqldb.error.Error.error(Unknown Source) at org.hsqldb.SchemaObjectSet.checkAdd(Unknown Source) at org.hsqldb.SchemaManager.checkSchemaObjectNotExists(Unknown Source) at org.hsqldb.StatementSchema.setOrCheckObjectName(Unknown Source) at org.hsqldb.StatementSchema.getResult(Unknown Source) at org.hsqldb.StatementSchema.execute(Unknown Source) at org.hsqldb.Session.executeCompiledStatement(Unknown Source) at org.hsqldb.Session.executeDirectStatement(Unknown Source) at org.hsqldb.Session.execute(Unknown Source) ... 26 more I've recommended him to open an issue at isis-todo-app with instructions. Martin Grigorov Wicket Training and Consulting https://twitter.com/mtgrigorov On Sun, Jun 7, 2015 at 11:56 PM, Dan Haywood <d...@haywood-associates.co.uk> wrote: > Yes, need a bit more info to help you debug this. > > Perhaps you could upload your app (since it's based on the todoapp) to a > github repo with instructions how to reorientation the issue? > > Thx, > Dan > On 7 Jun 2015 20:09, "Martin Grigorov" <mgrigo...@apache.org> wrote: > > > Hi, > > > > Please paste the stacktrace so we can see where and why it happens. > > Thanks! > > > > Martin Grigorov > > Wicket Training and Consulting > > https://twitter.com/mtgrigorov > > > > On Sun, Jun 7, 2015 at 3:35 PM, James Agada <james.ag...@cwg-plc.com> > > wrote: > > > > > Any one with an idea of how to fix this? > > > James Agada > > > Chief Technology Officer > > > > > > > > > On Jun 6, 2015, at 6:46 PM, James Agada <james.ag...@cwg-plc.com> > > wrote: > > > > > > If I add another domain object to the todoapp I get the error. But > when > > > i build the todoapp by itself it builds. is there a way to add an > > > additional domain class to extend the todoapp? Why is it repeatedly > > > creating isissettings.UserSetting and then failing with complaint that > > > table already exists? > > > James Agada > > > Chief Technology Officer > > > > > > > > > On Jun 5, 2015, at 6:56 PM, James Agada <james.ag...@cwlgroup.com> > > wrote: > > > > > > I am trying to build the today but I am getting this error > > > 18:40:20,299 [Datastore Thread-12 ERROR] Error thrown > > > executing CREATE TABLE isissettings."UserSetting" > > > ( > > > "key" NVARCHAR(128) NOT NULL, > > > "user" NVARCHAR(50) NOT NULL, > > > "description" NVARCHAR(254) NULL, > > > "type" NVARCHAR(20) NOT NULL, > > > "valueRaw" NVARCHAR(255) NOT NULL, > > > CONSTRAINT "UserSetting_PK" PRIMARY KEY ("key","user") > > > ) : object name already exists: UserSetting in statement [CREATE TABLE > > > isissettings."UserSetting" > > > ( > > > "key" NVARCHAR(128) NOT NULL, > > > "user" NVARCHAR(50) NOT NULL, > > > "description" NVARCHAR(254) NULL, > > > "type" NVARCHAR(20) NOT NULL, > > > "valueRaw" NVARCHAR(255) NOT NULL, > > > CONSTRAINT "UserSetting_PK" PRIMARY KEY ("key","user") > > > )] > > > java.sql.SQLSyntaxErrorException: object name already exists: > UserSetting > > > in statement [CREATE TABLE isissettings."UserSetting" > > > ( > > > "key" NVARCHAR(128) NOT NULL, > > > "user" NVARCHAR(50) NOT NULL, > > > "description" NVARCHAR(254) NULL, > > > "type" NVARCHAR(20) NOT NULL, > > > "valueRaw" NVARCHAR(255) NOT NULL, > > > CONSTRAINT "UserSetting_PK" PRIMARY KEY ("key","user") > > > )] > > > at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) > > > > > > I did not make any changes. I am using 1.9.0-snapshot. > > > Rgds > > > James Agada > > > Chief Technology Officer > > > > > > <PastedGraphic-3.png><www.openshopen.ng.jpg> > > > > > > > > > This email and any attachment thereto are confidential and priviledged. > > if > > > you have received it in error, please delete immediately and notify the > > > sender. Do not disclose, copy, circulate or in any way use it. The > > > information contained therein is for the address only, if you reply on > > it, > > > its at your own risk. Emails are not guaranteed to be secure or error > > free, > > > the message and any attachment could be intercepted, corrupted, lost, > > > delayed, incomplete or ammended. Computer warehouse group and its > > divisions > > > do not accept liability for damage caused by this email or any > > attachment. > > > The message you tried to print is protected with Information Rights > > > Management. You don't have the necessary user rights to print the > > message. > > > This email and any attachment thereto are confidential and priviledged. > > if > > > you have received it in error, please delete immediately and notify the > > > sender. Do not disclose, copy, circulate or in any way use it. The > > > information contained therein is for the address only, if you reply on > > it, > > > its at your own risk. Emails are not guaranteed to be secure or error > > free, > > > the message and any attachment could be intercepted, corrupted, lost, > > > delayed, incomplete or ammended. Computer warehouse group and its > > divisions > > > do not accept liability for damage caused by this email or any > > attachment. > > > The message you tried to print is protected with Information Rights > > > Management. You don't have the necessary user rights to print the > > message. > > > > > > > > > This email and any attachment thereto are confidential and priviledged. > > if > > > you have received it in error, please delete immediately and notify the > > > sender. Do not disclose, copy, circulate or in any way use it. The > > > information contained therein is for the address only, if you reply on > > it, > > > its at your own risk. Emails are not guaranteed to be secure or error > > free, > > > the message and any attachment could be intercepted, corrupted, lost, > > > delayed, incomplete or ammended. Computer warehouse group and its > > divisions > > > do not accept liability for damage caused by this email or any > > attachment. > > > The message you tried to print is protected with Information Rights > > > Management. You don't have the necessary user rights to print the > > message. > > > > > >