Can you please confirm with an external SQL client that you have a
RepositoryContainer with the id 0. Also, it might be possible that
you have inserted the RepositoryContainer in a transaction which
hasn't been committed and then validating it outside of the
transaction, which causes it to not be present yet.
On 15 Aug 2007, at 15:07, Jeremy Whitlock wrote:
>
> 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
>>
>>
>>>
>>
>
> >
--
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
-~----------~----~----~----~------~----~------~--~---
