Geert,
Here is all of the executed SQL (obfuscated):
Aug 15, 2007 7:00:11 AM com.uwyn.rife.database.DbStatement outputTrace
INFO: 1ms : CREATE SEQUENCE SEQ_repositorycontainer
Aug 15, 2007 7:00:11 AM com.uwyn.rife.database.DbStatement outputTrace
INFO: 111ms : CREATE TABLE repositorycontainer (active CHAR(1) NOT
NULL, authzPath LONGVARCHAR NOT NULL, created TIMESTAMP NOT NULL,
description VARCHAR(256) NOT NULL, displayName VARCHAR(64) NOT NULL,
id INTEGER NOT NULL, path LONGVARCHAR NOT NULL, serverType VARCHAR(8)
NOT NULL, PRIMARY KEY (id), UNIQUE (id), CHECK (active != ''), CHECK
(authzPath != ''), CHECK (description != ''), CHECK (displayName !=
''), CHECK (path != ''), CHECK (serverType != ''), CHECK (serverType
IN ('Apache','Serve')))
Aug 15, 2007 7:00:11 AM
org.thoughtspark.sac.elements.ApplicationInitializer$Deployer install
INFO: Table created for RepositoryContainer
Aug 15, 2007 7:00:11 AM com.uwyn.rife.database.DbStatement outputTrace
INFO: 0ms : CREATE SEQUENCE SEQ_repository
Aug 15, 2007 7:00:11 AM com.uwyn.rife.database.DbStatement outputTrace
INFO: 29ms : CREATE TABLE repository (active CHAR(1) NOT NULL,
containerId INTEGER NOT NULL, created TIMESTAMP NOT NULL, dataStore
VARCHAR(4) NOT NULL, description VARCHAR(256) NOT NULL, displayName
VARCHAR(64) NOT NULL, id INTEGER NOT NULL, name VARCHAR(64) NOT NULL,
PRIMARY KEY (id), FOREIGN KEY (containerId) REFERENCES
repositorycontainer (id), UNIQUE (id), CHECK (active != ''), CHECK
(containerId != 0), CHECK (dataStore != ''), CHECK (dataStore IN
('BDB','FSFS')), CHECK (description != ''), CHECK (displayName != ''),
CHECK (name != ''))
Aug 15, 2007 7:00:11 AM
org.thoughtspark.sac.elements.ApplicationInitializer$Deployer install
INFO: Table created for Repository
Aug 15, 2007 7:01:24 AM com.uwyn.rife.database.DbStatement outputTrace
INFO: 36ms : SELECT * FROM Repository WHERE active = 'Y' ORDER BY
displayName ASC
Aug 15, 2007 7:01:24 AM com.uwyn.rife.database.DbStatement outputTrace
INFO: 2ms : SELECT * FROM RepositoryContainer WHERE active = 'Y' ORDER
BY displayName ASC
Aug 15, 2007 7:01:35 AM com.uwyn.rife.database.DbStatement outputTrace
INFO: 0ms : SELECT * FROM RepositoryContainer WHERE active = 'Y' ORDER
BY displayName ASC
Aug 15, 2007 7:02:18 AM com.uwyn.rife.database.DbStatement outputTrace
INFO: 12ms : SELECT count(*) FROM repositorycontainer WHERE id = -1
Aug 15, 2007 7:02:18 AM com.uwyn.rife.database.DbStatement outputTrace
INFO: 0ms : SELECT count(*) FROM repositorycontainer WHERE displayName
= 'Production Container' AND active = 'Y'
Aug 15, 2007 7:02:18 AM com.uwyn.rife.database.DbStatement outputTrace
INFO: 0ms : SELECT count(*) FROM repositorycontainer WHERE path =
'/Users/jwhitlock/dev/java/sac/web-app/target/repos' AND active = 'Y'
Aug 15, 2007 7:02:18 AM com.uwyn.rife.database.DbStatement outputTrace
INFO: 0ms : CALL NEXT VALUE FOR SEQ_repositorycontainer
Aug 15, 2007 7:02:18 AM com.uwyn.rife.database.DbStatement outputTrace
INFO: 103ms : INSERT INTO repositorycontainer (active, authzPath,
created, description, displayName, id, path, serverType) VALUES (?, ?,
?, ?, ?, ?, ?, ?)
Aug 15, 2007 7:02:19 AM com.uwyn.rife.database.DbStatement outputTrace
INFO: 0ms : SELECT * FROM RepositoryContainer WHERE active = 'Y' ORDER
BY displayName ASC
Aug 15, 2007 7:02:23 AM com.uwyn.rife.database.DbStatement outputTrace
INFO: 0ms : SELECT * FROM Repository WHERE active = 'Y' ORDER BY displayName ASC
Aug 15, 2007 7:02:23 AM com.uwyn.rife.database.DbStatement outputTrace
INFO: 4ms : SELECT * FROM RepositoryContainer WHERE active = 'Y' ORDER
BY displayName ASC
Aug 15, 2007 7:02:41 AM com.uwyn.rife.database.DbStatement outputTrace
INFO: 1ms : SELECT count(*) FROM repository WHERE id = -1
Aug 15, 2007 7:02:41 AM com.uwyn.rife.database.DbStatement outputTrace
INFO: 1ms : SELECT * FROM repositorycontainer WHERE id = 0
The above is me successfully creating a RepositoryContainer object
with the id of 0 and then trying to create a Repository that has a
containerId of 0.
Take care,
Jeremy
On 8/15/07, Geert Bevin <[EMAIL PROTECTED]> wrote:
>
> Hi Jeremy,
>
> can you please turn on SQL tracing to see which query is actually
> executed to perform the validation?
>
> You can do this by setting the config parameter SQL_DEBUG_TRACE to true.
>
> Thanks,
>
> Geert
>
> On 15 Aug 2007, at 04:18, Jeremy Whitlock wrote:
>
> >
> > Hi All,
> > I have a simple database configuration that looks like so:
> >
> > Repository
> > ----------------
> > ID (PK)
> > CONTAINERID (FK)
> > .....
> >
> > Container
> > --------------
> > ID (PK)
> > .....
> >
> > In my RepositoryMetaData.java, I have the following constraint:
> >
> > .....
> > addConstraint(new ConstrainedProperty("containerId")
> > .notEmpty(true)
> > .notNull(true)
> > .manyToOne(Container.class, "id")
> > );
> > .....
> >
> > RIFE creates my tables as expected from the MetaData classes but when
> > I try to validate a Repository bean, I get a ValidationError when I
> > shouldn't. The Repository.getContainerId() returns an id of an
> > existing container but when I do:
> >
> > ((Validated)repository).validate(Utils.getGenericQueryManager
> > (Repository.class))
> >
> > I get the following (error is a ValidationError):
> >
> > error.getSubject() = INVALID
> > error.getIdentifier() = containerId
> > error.getErroneousValue() = null
> >
> > Now...I know that there is a valid containerId set in my Repository
> > bean but RIFE continues to tell me that the containerId is invalid.
> > If my understanding is correct, if I have a Container row with an id
> > of 0 and my Repository bean has a containerId of 0, it should be
> > valid. Can someone see some error in my logic? All I want to do is
> > store the id of a Container object in my Repository object and
> > validate properly. Based on my POJOs and the MetaData for the POJOs,
> > I do not see where I'm going wrong.
> >
> > Thanks in advance,
> >
> > Jeremy
> >
> > >
>
> --
> Geert Bevin
> Terracotta - http://www.terracotta.org
> Uwyn "Use what you need" - http://uwyn.com
> RIFE Java application framework - http://rifers.org
> Music and words - http://gbevin.com
>
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"rife-users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/rife-users?hl=en
-~----------~----~----~----~------~----~------~--~---
