To specify a null value, simply leave out the value field. So in your
sample.xml:
<row>
<value>1</value>
<value>Tree 01</value>
</row>
Mike.
On 3/30/07, wnqq <[EMAIL PROTECTED]> wrote:
Environment: Appfuse v2.0M4 + Hibernate + MySQL5.0
Question: How to specify NULL value in sample-data.xml so that the data
could be inserted into database via "mvn dbunit:operation" ?
The following is an extract from my POJO Tree.java:
=======================================
private Long parentTreeId;
private Tree parentTree;
@Column(name = "PARENT_TREE_ID")
public Long getParentTreeId() {
return parentTreeId;
}
@ManyToOne(optional=true)
@JoinColumn(name="PARENT_TREE_ID", nullable=true, updatable = false,
insertable = false)
public Tree getParentTree() {
return parentTree;
}
=======================================
The following is an extract of my sample-data.xml:
=======================================
<table name='tree'>
<column>id</column>
<column>name</column>
<column>parent_tree_id</column>
<row>
<value>1</value>
<value>Tree 01</value>
<value></value>
</row>
<row>
<value>2</value>
<value>Tree 02</value>
<value>1</value>
</row>
</table>
</dataset>
=======================================
I am trying to simulate a tree structure where the tree without a
parent-tree is the ROOT.
Thus, it is necessary to be able to insert parent_tree_id=NULL for the
ROOT
record (id=1).
Unfortunately, when mvn is executed, I got the following error:
Caused by: org.dbunit.dataset.datatype.TypeCastException: Error casting
value for table 'tree' and column 'PARENT_TREE_ID'
So, how to revolve it?
Thanks in advance.
--
View this message in context:
http://www.nabble.com/How-to-specify-NULL-value-in-sample-data.xml---tf3490838s2369.html#a9748925
Sent from the AppFuse - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
