Hi,
I'm getting this error when trying to persist an object:
org.exolab.castor.jdo.engine.SQLEngine create
INFO: A fatal error occurred while creating/updating newClasses.Lom_Relation_Resource_Description_Langstring
using SQL: INSERT INTO LOM_RELATION_RESOURCE_DESCRIPTION_LANGSTRING (lomRelResDesLanID,lang,content,lomRelResDesID) VALUES (?,?,?,?)
java.sql.SQLException: Column 'lomRelResDesID' cannot be null
This is the code:
(...)
db.begin();
String lang = "es";
newClasses.Lom_Relation_Resource_Description description = new newClasses.Lom_Relation_Resource_Description();
newClasses.Lom_Relation_Resource_Description_Langstring
descriptionLangstring = new
newClasses.Lom_Relation_Resource_Description_Langstring();
descriptionLangstring.setLang(lang);
descriptionLangstring.setContent("langstring en español");
description.addLangstring(descriptionLangstring);
db.create(description);
(...)
I'm using Castor 0.9.9.1 and MySQL 5.0.
Any help would be appreciated,
Thanks,
Carmen
-----------
These are the create table statements for Lom_Relation_Resource_Description and
newClasses.Lom_Relation_Resource_Description_Langstring. The relation between Lom_Relation_Resource_Description and
newClasses.Lom_Relation_Resource_Description_Langstring is a 1:M relation.
create table LOM_RELATION_RESOURCE_DESCRIPTION(
lomRelResDesID integer not null
);
create table LOM_RELATION_RESOURCE_DESCRIPTION_LANGSTRING(
lomRelResDesLanID integer not null,
lomRelResDesID integer not null,
content varchar(50),
lang varchar(50)
);
-----------
These are the Lom_Relation_Resource_Description and Lom_Relation_Resource_Description_Langstring classes:
...
Lom_Relation_Resource_Description.java:
...
package newClasses;
public class Lom_Relation_Resource_Description extends generado.Description{
private Integer _id;
public Lom_Relation_Resource_Description() {
}
public void setId(Integer id){
this._id = id;
}
public Integer getId(){
return this._id;
}
public void addLangstring(newClasses.Lom_Relation_Resource_Description_Langstring
vLangstring)
throws java.lang.IndexOutOfBoundsException
{
_langstringList.addElement(vLangstring);
}
public void addLangstring(int index, newClasses.Lom_Relation_Resource_Description_Langstring
vLangstring)
throws java.lang.IndexOutOfBoundsException
{
_langstringList.insertElementAt(vLangstring, index);
}
public newClasses.Lom_Relation_Resource_Description_Langstring
getLangstring(int index)
throws java.lang.IndexOutOfBoundsException
{
//-- check bounds for index
if ((index < 0) || (index > _langstringList.size())) {
throw new IndexOutOfBoundsException("getLangstring: Index value '"+index+"' not in range [0.."+_langstringList.size()+ "]");
}
return (newClasses.Lom_Relation_Resource_Description_Langstring) _langstringList.elementAt(index);
}
public newClasses.Lom_Relation_Resource_Description_Langstring[] getLangstring()
{
int size = _langstringList.size();
newClasses.Lom_Relation_Resource_Description_Langstring[] mArray = new newClasses.Lom_Relation_Resource_Description_Langstring[size];
for (int index = 0; index < size; index++) {
mArray[index] = (newClasses.Lom_Relation_Resource_Description_Langstring) _langstringList.elementAt(index);
}
return mArray;
}
}
...
The only important thing about
generado.Description.java is that it has an attribute like this:
protected java.util.Vector _langstringList;
...
Lom_Relation_Resource_Description_Langstring
...
package newClasses;
public class Lom_Relation_Resource_Description_Langstring extends
generado.Langstring{
private Integer _id;
private newClasses.Lom_Relation_Resource_Description _lomRelationResourceDescription;
public Lom_Relation_Resource_Description_Langstring() {
}
public void setId(Integer id){
this._id = id;
}
public Integer getId(){
return this._id;
}
public void setLomRelationResourceDescription(newClasses.Lom_Relation_Resource_Description
description){
this._lomRelationResourceDescription = description;
}
public newClasses.Lom_Relation_Resource_Description getLomRelationResourceDescription(){
return this._lomRelationResourceDescription;
}
}
...
generado.Langstring has these two attributes:
private java.lang.String _content = "";
private java.lang.Object _lang;
...
-------------
mapping.xml
...
<class name="
newClasses.Lom_Relation_Resource_Description" identity="_id" key-generator="MAX">
<map-to xml="description" table="LOM_RELATION_RESOURCE_DESCRIPTION"/>
<field name="_id" type="integer" get-method="getId" set-method="setId">
<sql name="lomRelResDesID"/>
</field>
<field name=" _langstringList" type="newClasses.Lom_Relation_Resource_Description_Langstring" collection="array" get-method="getLangstring" set-method="setLangstring" required="true">
<sql many-key="lomRelResDesID"/>
<bind-xml name="langstring"/>
</field>
</class>
...
<class name="newClasses.Lom_Relation_Resource_Description_Langstring
" identity="_id" key-generator="MAX" depends="newClasses.Lom_Relation_Resource_Description">
<map-to xml="langstring" table="LOM_RELATION_RESOURCE_DESCRIPTION_LANGSTRING"/>
<field name="_id" type="integer" get-method="getId" set-method="setId">
<sql name="lomRelResDesLanID"/>
</field>
<field name="_lang" type="other" get-method="getLang" set-method="setLang">
<sql name="lang"/>
<bind-xml name="xml:lang" node="attribute"/>
</field> <field name="content" type="string">
<sql name="content"/>
<bind-xml node="text"/>
</field>
<field name="_lomRelationResourceDescription" type="newClasses.Lom_Relation_Resource_Description" get-method="getLomRelationResourceDescription" set-method="setLomRelationResourceDescription">
<sql name="lomRelResDesID"/>
</field>
</class>
...
- [castor-user] Column cannot be null Stromblad
- Re: [castor-user] Column cannot be null Werner Guttmann
