You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@isis.apache.org by James Agada <Ja...@CWG-PLC.COM> on 2015/06/05 18:57:32 UTC
Error when building todoapp
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
[cid:03079D33-D6EF-43C4-BC68-409961ED49D7][cid:0A85BA30-39DD-4C9D-AF4D-6ECD6761CB96]
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.
Re: Error when building todoapp
Posted by James Agada <Ja...@CWG-PLC.COM>.
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 <da...@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 <mg...@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 <dan@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" <mg...@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 <Ja...@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 <Ja...@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 <ja...@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.
Re: Error when building todoapp
Posted by Dan Haywood <da...@haywood-associates.co.uk>.
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 <mg...@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 <dan@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" <mg...@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 <Ja...@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 <Ja...@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 <ja...@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.
> > > >
> > >
> >
>
Re: Error when building todoapp
Posted by Martin Grigorov <mg...@apache.org>.
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 <da...@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" <mg...@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 <Ja...@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 <Ja...@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 <ja...@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.
> > >
> >
>
Re: Error when building todoapp
Posted by Dan Haywood <da...@haywood-associates.co.uk>.
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" <mg...@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 <Ja...@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 <Ja...@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 <ja...@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.
> >
>
Re: Error when building todoapp
Posted by Martin Grigorov <mg...@apache.org>.
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 <Ja...@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 <Ja...@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 <ja...@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.
>
Re: Error when building todoapp
Posted by James Agada <Ja...@CWG-PLC.COM>.
Any one with an idea of how to fix this?
James Agada
Chief Technology Officer
[cid:03079D33-D6EF-43C4-BC68-409961ED49D7][cid:0A85BA30-39DD-4C9D-AF4D-6ECD6761CB96]
On Jun 6, 2015, at 6:46 PM, James Agada <Ja...@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
[cid:03079D33-D6EF-43C4-BC68-409961ED49D7][cid:0A85BA30-39DD-4C9D-AF4D-6ECD6761CB96]
On Jun 5, 2015, at 6:56 PM, James Agada <ja...@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<http://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.
Re: Error when building todoapp
Posted by James Agada <Ja...@CWG-PLC.COM>.
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
[cid:03079D33-D6EF-43C4-BC68-409961ED49D7][cid:0A85BA30-39DD-4C9D-AF4D-6ECD6761CB96]
On Jun 5, 2015, at 6:56 PM, James Agada <ja...@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<http://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.