Thank you Mike. It works great!
Michael Horwitz wrote: > > Sorry! Got it wrong - too much too fast ;-). To insert a null insert a > <null/> element: > > <row> > <value>1</value> > <value>Tree 01</value> > <null/> > </row> > > Do for the second case: > > <row> > <value>2</value> > <null/> > <value>1</value> > </row> > > More details can be found here: > http://dbunit.sourceforge.net/components.html (look under IDataSet, > XmlDataSet). > > Mike. > > > On 3/30/07, wnqq <[EMAIL PROTECTED]> wrote: >> >> >> Dear Mike, >> >> thank you very much! >> >> One more question: how does appfuse know which column(s) is(are) being >> inserted NULL value(s)? >> It looks like we can only insert nulls to the last column(s) as defined >> in >> the sample-data.xml. >> In other words, how to insert the following data (with NULL for the 2nd >> column)? >> >> <value>2</value> >> <value>NULL</value> >> <value>1</value> >> >> >> >> Michael Horwitz wrote: >> > >> > 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] >> >> >> >> >> > >> > >> >> -- >> View this message in context: >> http://www.nabble.com/How-to-specify-NULL-value-in-sample-data.xml---tf3490838s2369.html#a9749392 >> Sent from the AppFuse - User mailing list archive at Nabble.com. >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> For additional commands, e-mail: [EMAIL PROTECTED] >> >> > > -- View this message in context: http://www.nabble.com/How-to-specify-NULL-value-in-sample-data.xml---tf3490838s2369.html#a9749839 Sent from the AppFuse - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
