Re: Accessing to two (or more) relational databases at the same time
Sounds ok... though what approach are you taking for transaction management? Normally Isis does the xactn mgmt for free. I guess you are doing that stuff yourself? And (since we don't provide any hooks) presumably there is no 2PC/XA stuff, so there are possibilities of data being committed to one database but not the other? Dan On 5 June 2015 at 20:36, Vladimir Nišević wrote: > Hi Dan, yes, I have created two domain services representing/managing > connections to those two databases. On PostConstrunct of each of them I > create two Datanucleus PersistenceManagerFactories and the domain service > methods use appropriate Dao's creating the PersistenceManager and managing > the transactions manually as needed. > I can gladly share my code if you wish to review it or give me some > feedback. > > BR,Vladimir > > > > Am 05.06.2015 um 18:24 schrieb Dan Haywood >: > > > > Hi Vladimir, > > > > sorry no-one ever got back to you on this... did you come up with a > > solution? > > > > otherwise, I have some thoughts... > > > > Cheers > > Dan > > > > > >> On 21 May 2015 at 05:51, Vladimir Nišević wrote: > >> > >> Hi guys, we have a situation where we need to access to two(or more) > oracle > >> and one ms-sql database and read/write data from/to this databases at > the > >> same time. > >> > >> I see that datanucleus supports (to some degree) JDO data federation > >> > http://www.datanucleus.org/products/datanucleus/jdo/data_federation.html > >> so > >> this could be the way. > >> > >> My question is, how to integrate this feature into Isis config files and > >> how to use it. It would be enough if I still use container > >> (DomainObjectContainer) for single database, but I need to read/write > data > >> somehow to another databases as well - so this another DB's are kind of > >> backend systems... > >> > >> Thanks > >> Vladimir Nisevic > >> >
Re: Property validation
I'm steadily working through the site and converting to use asciidoc... so
this typo should be fixed soon.
thx
On 6 June 2015 at 19:22, James Agada wrote:
> In the howto. I've fixed this.
>
> Sent from my iPhone
>
> > On Jun 6, 2015, at 5:45 PM, Martin Grigorov
> wrote:
> >
> > Right.
> > It should return String with the error description. Or TranslatableString
> > if you need to support several languages.
> > At which page did you see this example? We should fix it.
> >> On Jun 6, 2015 5:54 PM, "Kevin Meyer" wrote:
> >>
> >> At first glance, your validate method must have return type String.
> >> Cheers,
> >> Kevin
> >>
> >>
> >>> On 6 June 2015 15:11:53 CEST, James Agada
> wrote:
> >>> What is the correct way to put validation for property. The one from
> >>> the site is obviously not correct as the validateXxx does not have a
> >>> return type. I m continually having this error
> >>> 2: todoapp.dom.module.game.GameEntity#validateClosingDate: has prefix
> >>> validate, is probably a supporting method for a property, collection or
> >>> action. If the method is intended to be an action, then rename and use
> >>> @ActionLayout(named="...") or ignore completely using @Programmatic
> >>>
> >>>
> >>> public class Exam {
> >>> public int getMark() { ... }
> >>> public void setMark(int mark) { ... }
> >>> public validateMark(int mark) {
> >>> return !withinRange(mark)? "Mark must be in range 0 to 30":null;
> >>> }
> >>> private boolean withinRange(int mark) { return mark >= 0 && mark <= 30;
> >>> }
> >>> }
> >>>
> >>> 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.
> >>
> >> --
> >> Sent from my phone with K-9 Mail.
> >> Please excuse my brevity.
> > 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
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 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 [DatastoreThread-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.(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.IsisC
Re: Error when building todoapp
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 [DatastoreThread-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.(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.SchemaMa
Re: Error when building todoapp
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" 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
> 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
> 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
> wrote:
> >
> > I am trying to build the today but I am getting this error
> > 18:40:20,299 [DatastoreThread-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
> >
> >
> >
> >
> > 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
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 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 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 wrote:
>
> I am trying to build the today but I am getting this error
> 18:40:20,299 [DatastoreThread-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
>
>
>
>
> 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: create new object with mandaory properties, best method
On 6 June 2015 at 23:56, Stephen Cameron wrote: > Thanks for the detailed response Dan, I will study and come back with > thoughts. sure, please do. > What I am building will be open-sourced so I will try to document > the issues encountered and choices made. I look forward to seeing more than that. Cheers Dan
Re: Error when building todoapp
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
mailto: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
[cid:03079D33-D6EF-43C4-BC68-409961ED49D7][cid:0A85BA30-39DD-4C9D-AF4D-6ECD6761CB96]
On Jun 5, 2015, at 6:56 PM, James Agada
mailto:james.ag...@cwlgroup.com>> wrote:
I am trying to build the today but I am getting this error
18:40:20,299 [DatastoreThread-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
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.
