Hi All,
To make this as easy to diagnose as possible, I have decided to
post non-obfuscated code:
SQL Trace Output
-------------------------
Aug 15, 2007 1:59:28 PM com.uwyn.rife.database.DbStatement outputTrace
INFO: 0ms : CREATE SEQUENCE SEQ_svnrepositorycontainer
Aug 15, 2007 1:59:28 PM com.uwyn.rife.database.DbStatement outputTrace
INFO: 103ms : CREATE TABLE svnrepositorycontainer (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','SvnServe')))
Aug 15, 2007 1:59:28 PM
org.thoughtspark.sac.elements.ApplicationInitializer$Deployer install
INFO: Table created for SVNRepositoryContainer
Aug 15, 2007 1:59:28 PM com.uwyn.rife.database.DbStatement outputTrace
INFO: 0ms : CREATE SEQUENCE SEQ_svnrepository
Aug 15, 2007 1:59:28 PM com.uwyn.rife.database.DbStatement outputTrace
INFO: 18ms : CREATE TABLE svnrepository (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
svnrepositorycontainer (id), UNIQUE (id), CHECK (active != ''), CHECK
(containerId != 0), CHECK (dataStore != ''), CHECK (dataStore IN
('BDB','FSFS')), CHECK (description != ''), CHECK (displayName != ''),
CHECK (name != ''))
Aug 15, 2007 1:59:28 PM
org.thoughtspark.sac.elements.ApplicationInitializer$Deployer install
INFO: Table created for SVNRepository
Aug 15, 2007 2:00:06 PM com.uwyn.rife.database.DbStatement outputTrace
INFO: 20ms : SELECT * FROM SVNRepositoryContainer WHERE active = 'Y'
ORDER BY displayName ASC
Aug 15, 2007 2:00:53 PM com.uwyn.rife.database.DbStatement outputTrace
INFO: 7ms : SELECT count(*) FROM svnrepositorycontainer WHERE id = -1
Aug 15, 2007 2:00:53 PM com.uwyn.rife.database.DbStatement outputTrace
INFO: 0ms : SELECT count(*) FROM svnrepositorycontainer WHERE
displayName = 'Some Container' AND active = 'Y'
Aug 15, 2007 2:00:53 PM com.uwyn.rife.database.DbStatement outputTrace
INFO: 0ms : SELECT count(*) FROM svnrepositorycontainer WHERE path =
'/Some/path' AND active = 'Y'
Aug 15, 2007 2:00:53 PM com.uwyn.rife.database.DbStatement outputTrace
INFO: 1ms : CALL NEXT VALUE FOR SEQ_svnrepositorycontainer
Aug 15, 2007 2:00:53 PM com.uwyn.rife.database.DbStatement outputTrace
INFO: 112ms : INSERT INTO svnrepositorycontainer (active, authzPath,
created, description, displayName, id, path, serverType) VALUES (?, ?,
?, ?, ?, ?, ?, ?)
Aug 15, 2007 2:00:54 PM com.uwyn.rife.database.DbStatement outputTrace
INFO: 1ms : SELECT * FROM SVNRepositoryContainer WHERE active = 'Y'
ORDER BY displayName ASC
Aug 15, 2007 2:01:00 PM com.uwyn.rife.database.DbStatement outputTrace
INFO: 0ms : SELECT * FROM SVNRepository WHERE active = 'Y' ORDER BY
displayName ASC
Aug 15, 2007 2:01:00 PM com.uwyn.rife.database.DbStatement outputTrace
INFO: 0ms : SELECT * FROM SVNRepositoryContainer WHERE active = 'Y'
ORDER BY displayName ASC
Container Id: 0
Aug 15, 2007 2:01:20 PM com.uwyn.rife.database.DbStatement outputTrace
INFO: 0ms : SELECT count(*) FROM svnrepository WHERE id = -1
Aug 15, 2007 2:01:20 PM com.uwyn.rife.database.DbStatement outputTrace
INFO: 0ms : SELECT * FROM svnrepositorycontainer WHERE id = 0
SVNRepository.java
----------------------------
.....
public class SVNRepository {
private int id = -1;
private int containerId;
.....
/**
* @return Returns the id.
*/
public int getId() {
return id;
}
/**
* @param id The id to set.
*/
public void setId(int id) {
this.id = id;
}
/**
* Returns the id of the repository container this repository is
* associated with.
*/
public int getContainerId() {
return containerId;
}
/**
* Sets the repository container id.
*
* @param The repository container id.
*/
public void setContainerId(int containerId) {
this.containerId = containerId;
}
.....
SVNRepositoryContainer.java
-----------------------------------------
.....
public class SVNRepositoryContainer {
private int id = -1;
.....
/**
* @return Returns the id.
*/
public int getId() {
return id;
}
/**
* @param id The id to set.
*/
public void setId(int id) {
this.id = id;
}
.....
SVNRepositoryMetaData.java
-----------------------------------------
....
public SVNRepositoryMetaData extends MetaData {
.....
addConstraint(new ConstrainedProperty("containerId")
.notEmpty(true)
.notNull(true)
.manyToOne(SVNRepositoryContainer.class, "id")
);
.....
SVNRepositoriesAdd.java
------------------------------------
.....
public SVNRepositoriesAdd extends Element {
.....
public void processElement() throws EngineException {
SVNRepository bean = getNamedInputBean("Repository");
if
(((Validated)repository).validate(SACUtils.getGenericQueryManager(SVNRepository.class)))
{
....
} else {
....
.....
.....
The SQL trace above shows the following:
Creation of the SVNREPOSITORYCONTAINER table
Creation of the SVNREPOSITORY table
Creation of necessary sequences
Creation of a row in the SVNREPOSITORYCONTAINER table with an id of 0
Attempt to create a row in the SVNREPOSITORY table with a CONTAINERID of 0
The problem is that the validate() call is always returning INVALID.
Unfortunately, it makes no sense because there is a row in the
SVNREPOSITORYCONTAINER table with an id of 0. I have verified this in
Java code and using a database browsing tool. Hopefully with exact
code, this can be easier to diagnose.
Take care,
Jeremy
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
