James, My *guess* is that the "user" column is not being escaped correctly in the version of HSQLDB being used; I have a distant memory about that.
Not sure what the cause is, but because this is running against -SNAPSHOT (of both Isis and various isisaddons) - that perhaps your mvn dependencies are resolving to a version of HSQLDB that is different to mine, say. A suggestion: remove ~/.m2/repository/org/apache/isis and also ~/.m2/repository/org/isisaddons to force mvn to download these all from our -SNAPSHOT repo, and see what you get. Also, you could run mvn dependency:tree in the webapp project, and post the result here (or as an issue in the todoapp's repo). Thx Dan On 7 June 2015 at 22:09, Martin Grigorov <[email protected]> wrote: > 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 <[email protected] > > > 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" <[email protected]> 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 <[email protected]> > > > 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 <[email protected]> > > > 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 <[email protected]> > > > 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. > > > > > > > > > >
