On Thu, Sep 4, 2008 at 12:46 PM, oad <[EMAIL PROTECTED]> wrote:
>
> Hi,
> I installed AppFuse2 Spring MVC modular and I've been adding my own classes
> to the Hibernate model package. I am using MySQL5
> Everything was fine until and introduced a Date element on the DB model.
> The
> structure on the database is always created correctly(datetime type on
> MySQL) but when I am trying to autopopulate data from an XML file by
> running
> mvn command from the root project I get the error below:
>
> I have tried java.util.Date, java.sql.Date and java.util.Calendar but no
> luck so far
>
> On the default-data.xml file this is what i have:
>
> <table name="tbl_events">
> <column>event_id</column>
> <column>event_name</column>
> <column>description</column>
> <column>start_date</column>
> <column>end_date</column>
> <column>address</column>
> <column>province</column>
> <column>city</column>
> <column>country</column>
> <column>postal_code</column>
> <column>total_distance_km</column>
> <column>type_id</column>
> <row>
> <value description="event_id">1</value>
> <value description="event_name">Event name1 example</value>
> <value description="description">Event description1
> example</value>
> <value description="address">123 main st</value>
> <value description="city">New York</value>
> <value description="country">US</value>
> <value description="start_date">2008-09-11 10:45:40</value>
> <value description="end_date">2008-09-11 10:45:40</value>
> <value description="total_distance_km">10</value>
> <value description="postal_code">10014</value>
> <value description="province">NY</value>
> <value description="type_id">1</value>
> </row>
> .
>
<snip>
Ok, you need to put the dates in your XML file as follows:
<value
description="start_date"><![CDATA[2007-08-15]]></value>
