I'm loosing my mind.... I just can't figure out what i'm doing wrong. Can some of you please take a look at my code / config and tell me what i'm doing wrong?
I know it's a long posting and I would really appreciate it very much if somebody could help me out.
I have 7 value objects: DocumentVO, DownloadVO, CategoryVO, UserVO, RoleVO, PalModelVO and KeywordVO. They all extend the abstract ValueObject class. DownloadVO and DocumentVO implement the SupportItemI Interface.
Here are the individual classes:
public abstract class ValueObject implements Serializable {
}public interface SupportItemI extends Serializable {
public Long getId();
public void setId(Long id);
public String getName();
public void setName(String name);
public String getDescription();
public void setDescription(String description);
public String getVersion();
public void setVersion(String version);
public Date getCreationDate();
public void setCreationDate(Date date);
public CategoryVO getCategory();
public void setCategory(String category);
public RoleVO getRole();
public void setRole(String role);
public File getFile();
public void setFile(String file);
public void setKeywords(String keywords);
}
public class CategoryVO extends ValueObject implements Serializable { private Long _id; private String _name; private String _description; private String _path; private Collection _allItemsOfCategory; }
public class DocumentVO extends ValueObject implements SupportItemI, Serializable {
private Long _id;
private String _name;
private String _description;
private String _version;
private byte[] _abstract;
private Date _creationDate;
private Long _categoryId;
private CategoryVO _category;
private Vector _palModels;
private Vector _keywords;
private UserVO _author;
private Long _authorId;
private String _filePath;
private Long _roleId;
private RoleVO _role;
}public class DownloadVO extends ValueObject implements SupportItemI, Serializable {
private Long _id;
private String _name;
private String _description;
private String _version;
private Date _creationDate;
private String _filePath;
private Long _categoryId;
private Long _roleId;
private Long _fileSize;
private Vector _palModels;
private Vector _keywords;
private CategoryVO _category;
private RoleVO _role;
}public class KeywordVO extends ValueObject implements Serializable {
private Long _id;
private String _name;
}public class PalModelVO extends ValueObject implements Serializable {
private Long _id;
private String _name;
private String _description;
}public class RoleVO extends ValueObject implements Serializable {
private Long _id;
private String _name;
private String _description;
}public class UserVO extends ValueObject implements Serializable {
private Long _id;
private String _firstName;
private String _lastName;
private String _userName;
private String _password;
private String _email;
private String _company;
private String _position;
private RoleVO _role;
private Long _roleId;
private boolean _authenticated;
}And here is the repository_user.xml
<?xml version="1.0" encoding="UTF-8"?>
<!-- Definitions for ch.ctc.support.common.SupportItemI -->
<class-descriptor class="ch.ctc.support.common.SupportItemI">
<extent-class class-ref="ch.ctc.support.document.DocumentVO" />
<extent-class class-ref="ch.ctc.support.download.DownloadVO" />
</class-descriptor><!-- Definitions for extent ch.ctc.support.common.ValueObject -->
<class-descriptor class="ch.ctc.support.common.ValueObject">
<extent-class class-ref="ch.ctc.support.category.CategoryVO" />
<extent-class class-ref="ch.ctc.support.document.DocumentVO" />
<extent-class class-ref="ch.ctc.support.user.UserVO" />
<extent-class class-ref="ch.ctc.support.user.RoleVO" />
<extent-class class-ref="ch.ctc.support.download.DownlaodVO" />
<extent-class class-ref="ch.ctc.support.keyword.KeywordVO" />
<extent-class class-ref="ch.ctc.support.palmodel.PalModelVO" />
</class-descriptor><!-- Definitions for ch.ctc.support.category.CategoryVO -->
<class-descriptor
class="ch.ctc.support.category.CategoryVO"
table="category"
> <field-descriptor
id="1"
name="_id"
column="id"
jdbc-type="BIGINT"
primarykey="true"
autoincrement="true"
/> <field-descriptor
id="2"
name="_name"
column="name"
jdbc-type="VARCHAR"
/> <field-descriptor
id="3"
name="_description"
column="description"
jdbc-type="VARCHAR"
/>
<field-descriptor
id="4"
name="_path"
column="path"
jdbc-type="VARCHAR"
/> <collection-descriptor
name="_allItemsOfCategory"
element-class-ref="ch.ctc.support.common.SupportItemI"
auto-retrieve="true"
auto-update="true"
auto-delete="false"
orderby="_id"
sort="DESC"
>
<inverse-foreignkey field-ref="_categoryId"/>
</collection-descriptor></class-descriptor>
<!-- Definitions for ch.ctc.support.user.UserVO -->
<class-descriptor
class="ch.ctc.support.user.UserVO"
table="user"
>
<field-descriptor
id="5"
name="_id"
column="id"
jdbc-type="BIGINT"
primarykey="true"
autoincrement="true"
/> <field-descriptor
id="6"
name="_firstName"
column="firstname"
jdbc-type="VARCHAR"
/> <field-descriptor
id="7"
name="_lastName"
column="lastname"
jdbc-type="VARCHAR"
/> <field-descriptor
id="8"
name="_email"
column="email"
jdbc-type="VARCHAR"
/> <field-descriptor
id="9"
name="_password"
column="password"
jdbc-type="VARCHAR"
/> <field-descriptor
id="10"
name="_position"
column="position"
jdbc-type="VARCHAR"
/> <field-descriptor
id="11"
name="_company"
column="company"
jdbc-type="VARCHAR"
/> <field-descriptor
id="12"
name="_roleId"
column="role_id"
jdbc-type="BIGINT"
/>
<field-descriptor
id="13"
name="_authenticated"
column="authenticated"
jdbc-type="BOOLEAN"
/> <reference-descriptor
name="_role"
class-ref="ch.ctc.support.user.RoleVO"
auto-retrieve="true"
>
<foreignkey field-ref="_roleId"/>
</reference-descriptor></class-descriptor>
<!-- Definitions for ch.ctc.support.document.DocumentVO -->
<class-descriptor
class="ch.ctc.support.document.DocumentVO"
table="document"
>
<field-descriptor
id="14"
name="_id"
column="id"
jdbc-type="BIGINT"
primarykey="true"
autoincrement="true"
/> <field-descriptor
id="15"
name="_name"
column="name"
jdbc-type="VARCHAR"
/> <field-descriptor
id="16"
name="_description"
column="description"
jdbc-type="VARCHAR"
/> <field-descriptor
id="17"
name="_version"
column="version"
jdbc-type="VARCHAR"
/> <field-descriptor
id="18"
name="_abstract"
column="abstract"
jdbc-type="LONGVARBINARY"
/> <field-descriptor
id="19"
name="_creationDate"
column="creation_date"
jdbc-type="DATE"
/> <field-descriptor
id="20"
name="_categoryId"
column="category_id"
jdbc-type="BIGINT"
/> <field-descriptor
id="21"
name="_authorId"
column="author_id"
jdbc-type="BIGINT"
/>
<field-descriptor
id="22"
name="_filePath"
column="file_link"
jdbc-type="VARCHAR"
/>
<field-descriptor
id="23"
name="_roleId"
column="role_id"
jdbc-type="BIGINT"
/> <collection-descriptor
name="_palModels"
element-class-ref="ch.ctc.support.palmodel.PalModelVO"
auto-retrieve="true"
auto-update="true"
indirection-table="document_pal_model"
>
<fk-pointing-to-this-class column="doc_id"/>
<fk-pointing-to-element-class column="model_id"/>
</collection-descriptor> <collection-descriptor
name="_keywords"
element-class-ref="ch.ctc.support.keyword.KeywordVO"
auto-retrieve="true"
auto-update="true"
indirection-table="document_keyword"
>
<fk-pointing-to-this-class column="doc_id"/>
<fk-pointing-to-element-class column="keyword_id"/>
</collection-descriptor> <reference-descriptor
name="_category"
class-ref="ch.ctc.support.category.CategoryVO"
auto-retrieve="true"
>
<foreignkey field-ref="_categoryId"/>
</reference-descriptor> <reference-descriptor
name="_author"
class-ref="ch.ctc.support.user.UserVO"
auto-retrieve="true"
>
<foreignkey field-ref="_authorId"/>
</reference-descriptor>
<reference-descriptor
name="_role"
class-ref="ch.ctc.support.user.RoleVO"
auto-retrieve="true"
>
<foreignkey field-ref="_roleId"/>
</reference-descriptor></class-descriptor>
<!-- Definitions for ch.ctc.support.palmodel.PalModelVO -->
<class-descriptor
class="ch.ctc.support.palmodel.PalModelVO"
table="pal_model"
> <field-descriptor
id="24"
name="_id"
column="id"
jdbc-type="BIGINT"
primarykey="true"
autoincrement="true"
/> <field-descriptor
id="25"
name="_name"
column="name"
jdbc-type="VARCHAR"
/> <field-descriptor
id="26"
name="_description"
column="description"
jdbc-type="VARCHAR"
/></class-descriptor>
<!-- Definitions for ch.ctc.support.keyword.KeywordVO --> <class-descriptor class="ch.ctc.support.keyword.KeywordVO" table="keyword" >
<field-descriptor
id="29"
name="_id"
column="id"
jdbc-type="BIGINT"
primarykey="true"
autoincrement="true"
/> <field-descriptor
id="30"
name="_name"
column="name"
jdbc-type="VARCHAR"
/></class-descriptor>
<!-- Definitions for ch.ctc.support.user.RoleVO -->
<class-descriptor
class="ch.ctc.support.user.RoleVO"
table="role"
> <field-descriptor
id="31"
name="_id"
column="id"
jdbc-type="BIGINT"
primarykey="true"
autoincrement="true"
/> <field-descriptor
id="32"
name="_name"
column="name"
jdbc-type="VARCHAR"
/>
<field-descriptor
id="33"
name="_description"
column="description"
jdbc-type="VARCHAR"
/></class-descriptor>
<!-- Definitions for ch.ctc.support.download.DownloadVO -->
<class-descriptor
class="ch.ctc.support.download.DownloadVO"
table="document"
>
<field-descriptor
id="34"
name="_id"
column="id"
jdbc-type="BIGINT"
primarykey="true"
autoincrement="true"
/> <field-descriptor
id="35"
name="_name"
column="name"
jdbc-type="VARCHAR"
/> <field-descriptor
id="36"
name="_description"
column="description"
jdbc-type="VARCHAR"
/> <field-descriptor
id="37"
name="_version"
column="version"
jdbc-type="VARCHAR"
/> <field-descriptor
id="38"
name="_creationDate"
column="creation_date"
jdbc-type="DATE"
/>
<field-descriptor
id="39"
name="_filePath"
column="file_link"
jdbc-type="VARCHAR"
/> <field-descriptor
id="41"
name="_categoryId"
column="category_id"
jdbc-type="BIGINT"
/> <field-descriptor
id="42"
name="_roleId"
column="role_id"
jdbc-type="BIGINT"
/>
<field-descriptor
id="43"
name="_fileSize"
column="size"
jdbc-type="BIGINT"
/> <collection-descriptor
name="_palModels"
element-class-ref="ch.ctc.support.palmodel.PalModelVO"
auto-retrieve="true"
auto-update="true"
indirection-table="download_pal_model"
>
<fk-pointing-to-this-class column="download_id"/>
<fk-pointing-to-element-class column="model_id"/>
</collection-descriptor> <collection-descriptor
name="_keywords"
element-class-ref="ch.ctc.support.keyword.KeywordVO"
auto-retrieve="true"
auto-update="true"
indirection-table="download_keyword"
>
<fk-pointing-to-this-class column="download_id"/>
<fk-pointing-to-element-class column="keyword_id"/>
</collection-descriptor> <reference-descriptor
name="_category"
class-ref="ch.ctc.support.category.CategoryVO"
auto-retrieve="true"
>
<foreignkey field-ref="_categoryId"/>
</reference-descriptor> <reference-descriptor
name="_role"
class-ref="ch.ctc.support.user.RoleVO"
auto-retrieve="true"
>
<foreignkey field-ref="_roleId"/>
</reference-descriptor></class-descriptor>
Additionaly i have uploaded a picture with my data model to the following URL: http://homepage.hispeed.ch/tabalooga/datamodel-web.jpg
Everytime I run a query on the PersistenceBroker I get the following exception:
org.apache.ojb.broker.PersistenceBrokerException: Column not found, message from server: "Unknown column 'A0.size' in 'field list'"
org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Unknown Source)
org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Unknown Source)
org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unknown Source)
org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(Unknown Source)
org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(Unknown Source)
I big thank you in advance, Patrick
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
