[appfuse-user] How to specify NULL value in sample-data.xml ?

[wnqq]

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]