Dan, I did as recommended and still got no good result. I will try and upload the entire project to Github. But here is the dependency tree [INFO] Scanning for projects... [INFO] [INFO] ------------------------------------------------------------------------ [INFO] Building Isis Addons ToDoApp Webapp 1.9.0-SNAPSHOT [INFO] ------------------------------------------------------------------------ [INFO] [INFO] --- maven-dependency-plugin:2.8:tree (default-cli) @ todoapp-webapp --- [INFO] org.isisaddons.app:todoapp-webapp:war:1.9.0-SNAPSHOT [INFO] +- org.isisaddons.app:todoapp-dom:jar:1.9.0-SNAPSHOT:compile [INFO] | +- org.isisaddons.app:todoapp-canonical:jar:1.9.0-SNAPSHOT:compile [INFO] | +- org.apache.isis.core:isis-core-applib:jar:1.9.0-SNAPSHOT:compile [INFO] | | +- joda-time:joda-time:jar:2.3:compile [INFO] | | +- org.apache.geronimo.specs:geronimo-atinject_1.0_spec:jar:1.0:compile [INFO] | | +- javax.validation:validation-api:jar:1.1.0.Final:compile [INFO] | | +- org.apache.geronimo.specs:geronimo-jcdi_1.0_spec:jar:1.0:compile [INFO] | | +- javax.jdo:jdo-api:jar:3.1-rc1:compile [INFO] | | | \- javax.transaction:transaction-api:jar:1.1:compile [INFO] | | \- org.datanucleus:datanucleus-jdo-query:jar:4.0.4:compile [INFO] | +- org.isisaddons.module.audit:isis-module-audit-dom:jar:1.9.0-SNAPSHOT:compile [INFO] | +- org.isisaddons.module.command:isis-module-command-dom:jar:1.9.0-SNAPSHOT:compile [INFO] | +- org.isisaddons.module.devutils:isis-module-devutils-dom:jar:1.9.0-SNAPSHOT:compile [INFO] | +- org.isisaddons.module.docx:isis-module-docx-dom:jar:1.8.1:compile [INFO] | | +- org.docx4j:docx4j:jar:3.2.1:compile [INFO] | | | +- org.plutext:jaxb-svg11:jar:1.0.2:compile [INFO] | | | +- org.plutext:jaxb-xslfo:jar:1.0.1:compile [INFO] | | | +- org.plutext:jaxb-xmldsig-core:jar:1.0.0:compile [INFO] | | | +- net.engio:mbassador:jar:1.1.10:compile [INFO] | | | +- org.slf4j:jcl-over-slf4j:jar:1.7.10:compile [INFO] | | | +- commons-lang:commons-lang:jar:2.4:compile [INFO] | | | +- org.apache.xmlgraphics:xmlgraphics-commons:jar:1.5:compile [INFO] | | | +- org.apache.xmlgraphics:fop:jar:1.1:compile [INFO] | | | | +- org.apache.xmlgraphics:batik-svg-dom:jar:1.7:compile [INFO] | | | | | +- org.apache.xmlgraphics:batik-anim:jar:1.7:compile [INFO] | | | | | +- org.apache.xmlgraphics:batik-css:jar:1.7:compile [INFO] | | | | | +- org.apache.xmlgraphics:batik-dom:jar:1.7:compile [INFO] | | | | | +- org.apache.xmlgraphics:batik-parser:jar:1.7:compile [INFO] | | | | | \- org.apache.xmlgraphics:batik-util:jar:1.7:compile [INFO] | | | | +- org.apache.xmlgraphics:batik-bridge:jar:1.7:compile [INFO] | | | | | +- org.apache.xmlgraphics:batik-script:jar:1.7:compile [INFO] | | | | | | \- org.apache.xmlgraphics:batik-js:jar:1.7:compile [INFO] | | | | | \- org.apache.xmlgraphics:batik-xml:jar:1.7:compile [INFO] | | | | +- org.apache.xmlgraphics:batik-awt-util:jar:1.7:compile [INFO] | | | | +- org.apache.xmlgraphics:batik-gvt:jar:1.7:compile [INFO] | | | | +- org.apache.xmlgraphics:batik-transcoder:jar:1.7:compile [INFO] | | | | | \- org.apache.xmlgraphics:batik-svggen:jar:1.7:compile [INFO] | | | | +- org.apache.xmlgraphics:batik-extension:jar:1.7:compile [INFO] | | | | \- org.apache.xmlgraphics:batik-ext:jar:1.7:compile [INFO] | | | +- org.apache.avalon.framework:avalon-framework-api:jar:4.3.1:compile [INFO] | | | +- org.apache.avalon.framework:avalon-framework-impl:jar:4.3.1:compile [INFO] | | | +- xalan:xalan:jar:2.7.1:compile [INFO] | | | | \- xalan:serializer:jar:2.7.1:compile [INFO] | | | +- net.arnx:wmf2svg:jar:0.9.0:compile [INFO] | | | +- org.apache.poi:poi-scratchpad:jar:3.8:compile [INFO] | | | +- org.antlr:antlr-runtime:jar:3.3:compile [INFO] | | | \- org.antlr:stringtemplate:jar:3.2.1:compile [INFO] | | | \- antlr:antlr:jar:2.7.7:compile [INFO] | | \- org.jdom:jdom2:jar:2.0.5:compile [INFO] | +- org.isisaddons.module.security:isis-module-security-dom:jar:1.9.0-SNAPSHOT:compile [INFO] | +- org.isisaddons.module.sessionlogger:isis-module-sessionlogger-dom:jar:1.9.0-SNAPSHOT:compile [INFO] | +- org.isisaddons.module.settings:isis-module-settings-dom:jar:1.9.0-SNAPSHOT:compile [INFO] | +- org.isisaddons.module.publishing:isis-module-publishing-dom:jar:1.9.0-SNAPSHOT:compile [INFO] | +- org.isisaddons.wicket.excel:isis-wicket-excel-cpt:jar:1.9.0-SNAPSHOT:compile [INFO] | | +- org.apache.poi:poi:jar:3.9:compile [INFO] | | +- org.apache.poi:poi-ooxml:jar:3.9:compile [INFO] | | \- org.apache.poi:poi-ooxml-schemas:jar:3.9:compile [INFO] | | \- org.apache.xmlbeans:xmlbeans:jar:2.3.0:compile [INFO] | | \- stax:stax-api:jar:1.0.1:compile [INFO] | +- org.isisaddons.wicket.fullcalendar2:isis-wicket-fullcalendar2-cpt:jar:1.9.0-SNAPSHOT:compile [INFO] | | \- net.ftlines.wicket-fullcalendar:wicket-fullcalendar-core:jar:2.2.0:compile [INFO] | +- org.isisaddons.wicket.gmap3:isis-wicket-gmap3-cpt:jar:1.9.0-SNAPSHOT:compile [INFO] | | +- org.wicketstuff:wicketstuff-gmap3:jar:6.17.0:compile [INFO] | | | \- commons-logging:commons-logging:jar:1.1.2:compile [INFO] | | +- org.apache.httpcomponents:httpclient:jar:4.4:compile [INFO] | | | \- org.apache.httpcomponents:httpcore:jar:4.4:compile [INFO] | | \- org.jdom:jdom:jar:2.0.2:compile [INFO] | +- ma.glasnost.orika:orika-core:jar:1.4.5:compile [INFO] | | +- com.thoughtworks.paranamer:paranamer:jar:2.3:compile [INFO] | | +- com.googlecode.concurrentlinkedhashmap:concurrentlinkedhashmap-lru:jar:1.2_jdk5:compile [INFO] | | \- com.carrotsearch:java-sizeof:jar:0.0.4:compile [INFO] | +- org.togglz:togglz-core:jar:2.1.0.Final:compile [INFO] | +- org.datanucleus:datanucleus-core:jar:4.0.6:compile [INFO] | +- org.datanucleus:datanucleus-jodatime:jar:4.0.6:compile [INFO] | \- org.datanucleus:datanucleus-api-jdo:jar:4.0.5:compile [INFO] +- org.isisaddons.app:todoapp-fixture:jar:1.9.0-SNAPSHOT:compile [INFO] +- org.apache.isis.viewer:isis-viewer-wicket-impl:jar:1.9.0-SNAPSHOT:compile [INFO] | +- org.apache.isis.viewer:isis-viewer-wicket-ui:jar:1.9.0-SNAPSHOT:compile [INFO] | | +- org.apache.isis.viewer:isis-viewer-wicket-model:jar:1.9.0-SNAPSHOT:compile [INFO] | | | \- org.apache.isis.viewer:isis-viewer-wicket-applib:jar:1.9.0-SNAPSHOT:compile [INFO] | | +- org.apache.wicket:wicket-core:jar:6.17.0:compile [INFO] | | | +- org.apache.wicket:wicket-util:jar:6.17.0:compile [INFO] | | | \- org.apache.wicket:wicket-request:jar:6.17.0:compile [INFO] | | +- org.apache.wicket:wicket-extensions:jar:6.17.0:compile [INFO] | | +- org.apache.wicket:wicket-guice:jar:6.17.0:compile [INFO] | | | \- org.apache.wicket:wicket-ioc:jar:6.17.0:compile [INFO] | | +- com.vaynberg.wicket.select2:wicket-select2:jar:2.2.3:compile [INFO] | | | \- org.json:json:jar:20090211:compile [INFO] | | +- org.webjars:select2:jar:3.5.1:compile [INFO] | | | \- org.webjars:jquery:jar:1.11.1:compile [INFO] | | +- org.webjars:jquery-ui:jar:1.10.4:compile [INFO] | | +- de.agilecoders.wicket.webjars:wicket-webjars:jar:0.4.3:compile [INFO] | | +- de.agilecoders.wicket:wicket-bootstrap-extensions:jar:0.9.7:compile [INFO] | | \- de.agilecoders.wicket:wicket-bootstrap-themes:jar:0.9.7:compile [INFO] | +- org.apache.wicket:wicket-auth-roles:jar:6.17.0:compile [INFO] | +- com.google.guava:guava:jar:16.0.1:compile [INFO] | +- net.ftlines.wicket-source:wicket-source:jar:6.0.0.8:compile [INFO] | | \- org.apache.wicket:wicket:pom:6.17.0:compile [INFO] | +- com.google.inject:guice-parent:pom:3.0:compile [INFO] | +- de.agilecoders.wicket:wicket-bootstrap-core:jar:0.9.7:compile [INFO] | | +- de.agilecoders.wicket:jquery-selectors:jar:0.1.3:compile [INFO] | | | +- com.fasterxml.jackson.core:jackson-core:jar:2.5.0:compile [INFO] | | | \- com.fasterxml.jackson.core:jackson-databind:jar:2.5.0:compile [INFO] | | +- org.webjars:bootstrap:jar:3.2.0:compile [INFO] | | +- org.webjars:modernizr:jar:2.7.1:compile [INFO] | | +- org.apache.commons:commons-lang3:jar:3.3.2:compile [INFO] | | \- de.agilecoders.maven:maven-parent-config:jar:0.3.5:compile [INFO] | +- org.hamcrest:hamcrest-library:jar:1.3:compile [INFO] | | \- org.hamcrest:hamcrest-core:jar:1.3:compile [INFO] | \- org.slf4j:slf4j-api:jar:1.7.10:compile [INFO] +- org.apache.isis.core:isis-core-viewer-restfulobjects-server:jar:1.9.0-SNAPSHOT:compile [INFO] | +- org.apache.isis.core:isis-core-viewer-restfulobjects-rendering:jar:1.9.0-SNAPSHOT:compile [INFO] | | +- org.jboss.resteasy:resteasy-jaxb-provider:jar:3.0.11.Final:compile [INFO] | | | \- com.sun.xml.bind:jaxb-impl:jar:2.2.7:compile [INFO] | | | +- com.sun.xml.bind:jaxb-core:jar:2.2.7:compile [INFO] | | | | +- javax.xml.bind:jaxb-api:jar:2.2.7:compile [INFO] | | | | \- com.sun.istack:istack-commons-runtime:jar:2.16:compile [INFO] | | | \- com.sun.xml.fastinfoset:FastInfoset:jar:1.2.12:compile [INFO] | | | \- javax.xml.bind:jsr173_api:jar:1.0:compile [INFO] | | +- org.jboss.resteasy:resteasy-jackson-provider:jar:3.0.11.Final:compile [INFO] | | | +- org.codehaus.jackson:jackson-core-asl:jar:1.9.12:compile [INFO] | | | +- org.codehaus.jackson:jackson-mapper-asl:jar:1.9.12:compile [INFO] | | | +- org.codehaus.jackson:jackson-jaxrs:jar:1.9.12:compile [INFO] | | | \- org.codehaus.jackson:jackson-xc:jar:1.9.12:compile [INFO] | | \- org.apache.isis.core:isis-core-viewer-restfulobjects-applib:jar:1.9.0-SNAPSHOT:compile [INFO] | | +- org.jboss.resteasy:resteasy-jaxrs:jar:3.0.11.Final:compile [INFO] | | | +- org.jboss.resteasy:jaxrs-api:jar:3.0.11.Final:compile [INFO] | | | +- org.jboss.spec.javax.annotation:jboss-annotations-api_1.1_spec:jar:1.0.1.Final:compile [INFO] | | | \- net.jcip:jcip-annotations:jar:1.0:compile [INFO] | | \- com.fasterxml.jackson.core:jackson-annotations:jar:2.5.0:compile [INFO] | +- org.apache.geronimo.specs:geronimo-annotation_1.0_spec:jar:1.1.1:compile [INFO] | \- org.apache.geronimo.specs:geronimo-activation_1.1_spec:jar:1.1:compile [INFO] +- org.apache.isis.core:isis-core-security-shiro:jar:1.9.0-SNAPSHOT:compile [INFO] | +- org.apache.shiro:shiro-core:jar:1.2.3:compile [INFO] | | \- commons-beanutils:commons-beanutils:jar:1.8.3:compile [INFO] | \- org.apache.shiro:shiro-web:jar:1.2.3:compile [INFO] +- org.apache.isis.core:isis-core-runtime:jar:1.9.0-SNAPSHOT:compile [INFO] | +- org.apache.isis.core:isis-core-log4j:jar:1.9.0-SNAPSHOT:compile [INFO] | +- org.apache.isis.core:isis-core-metamodel:jar:1.9.0-SNAPSHOT:compile [INFO] | | +- commons-codec:commons-codec:jar:1.9:compile [INFO] | | +- commons-cli:commons-cli:jar:1.2:compile [INFO] | | +- com.google.inject:guice:jar:3.0:compile [INFO] | | | +- javax.inject:javax.inject:jar:1:compile [INFO] | | | \- aopalliance:aopalliance:jar:1.0:compile [INFO] | | \- org.datanucleus:datanucleus-rdbms:jar:4.0.11:compile [INFO] | +- dom4j:dom4j:jar:1.6.1:compile [INFO] | | \- xml-apis:xml-apis:jar:1.0.b2:compile [INFO] | +- org.slf4j:slf4j-log4j12:jar:1.7.10:compile [INFO] | +- log4j:log4j:jar:1.2.17:compile [INFO] | +- org.reflections:reflections:jar:0.9.9:compile [INFO] | | \- com.google.code.findbugs:annotations:jar:2.0.1:compile [INFO] | +- org.javassist:javassist:jar:3.19.0-GA:compile [INFO] | +- org.apache.commons:commons-email:jar:1.3.3:compile [INFO] | +- javax.mail:mail:jar:1.4.7:compile [INFO] | +- javax.activation:activation:jar:1.1.1:compile [INFO] | \- org.axonframework:axon-core:jar:2.4:compile [INFO] | +- com.lmax:disruptor:jar:3.2.0:compile [INFO] | +- cglib:cglib-nodep:jar:2.2.2:compile [INFO] | +- commons-io:commons-io:jar:2.4:compile [INFO] | +- com.thoughtworks.xstream:xstream:jar:1.4.7:compile [INFO] | | +- xmlpull:xmlpull:jar:1.1.3.1:compile [INFO] | | \- xpp3:xpp3_min:jar:1.1.4c:compile [INFO] | \- commons-collections:commons-collections:jar:3.2.1:compile [INFO] +- org.apache.isis.core:isis-core-wrapper:jar:1.9.0-SNAPSHOT:compile [INFO] | \- org.objenesis:objenesis:jar:1.4:compile [INFO] +- org.apache.isis.core:isis-core-security:jar:1.9.0-SNAPSHOT:compile [INFO] +- org.isisaddons.metamodel.paraname8:isis-metamodel-paraname8-dom:jar:1.9.0-SNAPSHOT:compile [INFO] +- org.apache.isis.core:isis-core-webserver:jar:1.9.0-SNAPSHOT:runtime [INFO] | \- org.eclipse.jetty.aggregate:jetty-all-server:jar:8.1.16.v20140903:runtime [INFO] | +- org.eclipse.jetty.orbit:javax.security.auth.message:jar:1.0.0.v201108011116:runtime [INFO] | +- org.eclipse.jetty.orbit:javax.mail.glassfish:jar:1.4.1.v201005082020:runtime [INFO] | +- org.eclipse.jetty.orbit:javax.activation:jar:1.1.0.v201105071233:runtime [INFO] | \- org.eclipse.jetty.orbit:javax.annotation:jar:1.1.0.v201108011116:runtime [INFO] +- org.apache.geronimo.specs:geronimo-servlet_3.0_spec:jar:1.0:compile [INFO] +- org.hsqldb:hsqldb:jar:2.3.1:compile [INFO] +- org.lazyluke:log4jdbc-remix:jar:0.2.7:compile [INFO] | \- junit:junit:jar:4.12:compile [INFO] +- org.mindrot:jbcrypt:jar:0.3m:compile [INFO] +- org.isisaddons.module.togglz:isis-module-togglz-glue:jar:1.9.0-SNAPSHOT:compile [INFO] | \- com.google.code.gson:gson:jar:2.3.1:compile [INFO] +- org.togglz:togglz-servlet:jar:2.1.0.Final:compile [INFO] \- org.togglz:togglz-console:jar:2.1.0.Final:compile [INFO] ------------------------------------------------------------------------ [INFO] BUILD SUCCESS [INFO] ------------------------------------------------------------------------ [INFO] Total time: 1.823 s [INFO] Finished at: 2015-06-13T20:04:39+01:00 [INFO] Final Memory: 21M/220M [INFO] ------------------------------------------------------------------------
James Agada Chief Technology Officer [cid:03079D33-D6EF-43C4-BC68-409961ED49D7][cid:0A85BA30-39DD-4C9D-AF4D-6ECD6761CB96] On Jun 8, 2015, at 7:17 AM, Dan Haywood <d...@haywood-associates.co.uk<mailto:d...@haywood-associates.co.uk>> wrote: 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 <mgrigo...@apache.org<mailto:mgrigo...@apache.org>> 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 <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. 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.
