You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ojb-user@db.apache.org by Patrick Scheuerer <ta...@hispeed.ch> on 2004/01/03 03:17:51 UTC
Desperately need help with my repository
Hi everyone,
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: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org
Re: Desperately need help with my repository
Posted by Patrick Scheuerer <ta...@hispeed.ch>.
Luis Cruz wrote:
> Is it possible for you to post the snip of code that does the query? My
> guess is that you're doing something like this:
Here's one of my DAO methods in which the Exception is thrown:
public Collection findAllCategories() throws DataAccessException {
PersistenceBroker broker = null;
Collection results = null;
QueryByCriteria query = new QueryByCriteria(CategoryVO.class, null);
query.setStartAtIndex(1);
try {
broker = ServiceLocator.getInstance().findBroker();
results = broker.getCollectionByQuery(query);
} catch (ServiceLocatorException e) {
throw new DataAccessException("Bla Bla", e);
} finally {
if (broker != null) {
broker.close();
}
}
return results;
}
Another one that doesn't work is this ( I followed an example in the book
"Professional Struts Applications"):
public Collection findLatestAdditions() throws DataAccessException {
PersistenceBroker broker = null;
Collection results = new Vector();
Criteria criteria = new Criteria();
criteria.addOrderByDescending("id");
Query query = QueryFactory.newQuery(DocumentVO.class, criteria);
query.setStartAtIndex(1);
query.setEndAtIndex(MAXIMUM_LATESTADDITIONS - 1);
try {
broker = ServiceLocator.getInstance().findBroker();
results = (Collection) broker.getCollectionByQuery(query);
} catch (ServiceLocatorException e) {
} finally {
if (broker != null) {
broker.close();
}
}
return results;
}
> Criteria criteria = new Critetia();
> criteria.addEqualTo("size", someValue);
> Query query = new QueryByCriteria(classToQuery, criteria);
> Collection result = pb.getCollectionByQuery(query);
No i'm not. And that's the strange thing. I'm not running any query on the size
of a download.
Maybe the exception is thrown because DocumentVO doesn't have the _fileSize
attribute but it also implements the SupportItemI Interface as does DownloadVO
which has this attribute???? But if that was true queries on Interfaces wouldn't
be very useful, right?
> If so then the problem is that OJB queries are done against objects, not
> tables, there for you should change "size" to "_fileSize" or to the
> corresponding bean method name (depending on the value of
> PersistentFieldClass you defined in your OJB.properties file).
The PersistenceFieldClass is
org.apache.ojb.broker.metadata.fieldaccess.PersistentFieldDirectAccessImpl (default)
> Hope this helps,
> Luis Cruz
Thanks for your tips Luis! Any further ideas would be highly appreciated.
Patrick
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org
Re: Desperately need help with my repository
Posted by Luis Cruz <le...@netcabo.pt>.
Is it possible for you to post the snip of code that does the query? My
guess is that you're doing something like this:
Criteria criteria = new Critetia();
criteria.addEqualTo("size", someValue);
Query query = new QueryByCriteria(classToQuery, criteria);
Collection result = pb.getCollectionByQuery(query);
If so then the problem is that OJB queries are done against objects, not
tables, there for you should change "size" to "_fileSize" or to the
corresponding bean method name (depending on the value of
PersistentFieldClass you defined in your OJB.properties file).
Hope this helps,
Luis Cruz
On Sat, 2004-01-03 at 02:17, Patrick Scheuerer wrote:
> Hi everyone,
>
> 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: ojb-user-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-user-help@db.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org