Re: Problem in importing Seed data

Posted by Hans Bakker on Jun 26, 2006; 8:25am
URL: http://ofbiz.116.s1.nabble.com/Problem-in-importing-Seed-data-tp140175p140198.html

You may want to look at the opentravelsystem, where we use the fixed asset for
the definition of the rooms. A fixed asset is then connected with a product
with the type 'fixed asset usage' in order to rent it to a customer. If a
room is available is also recorded there.

Regards,
Hans

On Monday 26 June 2006 13:53, Sangeeta Bhatia wrote:

> Hi All,
> I am using ofbiz build 5924.and database is localderby.While trying to
> import seed data, I am getting the following exception:
>
> An error occurred saving the data, rolling back transaction (true)
> Exception: java.lang.IllegalArgumentException
> Message: Type id not found
>
> An error occurred saving the data, rolling back transaction (true)
> Exception: java.lang.IllegalArgumentException
> Message: Type description not found
>
> Here is the relevant excrept from entitymodel.xml:
>     <entity entity-name="Room"
>             package-name="org.ofbiz.hotelCalifornia"
>             title="Hotel California's Rooms">
>       <field name="roomId" type="id"></field>
>       <field name="fId" type="id"></field>
>       <field name="numberFree" type="numeric"></field>
>       <prim-key field="roomId"/>
>       <relation type="one" fk-name="room_facility_map"
> rel-entity-name="RoomFacility">
>         <key-map field-name="fId"/>
>       </relation>
>     </entity>
>
> and here is what i am trying to import:
> <?xml version="1.0" encoding="UTF-8"?>
> <entity-engine-xml>
>       <RoomFacility fId="PLAIN" description="A plain room with minimal
> facilities"/> <Room roomId="PLAIN" fId="F100" numberFree=5/>
> </entity-engine-xml>
>
> Si has suggested that  this is an old problem with localderbyodbc not being
> set correctly, so it couldn't find the types on some fieldtype_...xml.Does
> anyone have any clue about this? Is there something I am missing? I have
> checked the fieldtypederby.xml and it corrcetly lists : <field-type-def
> type="id" sql-type="VARCHAR(20)" java-type="String"></field-type-def> I
> also trying (stupidly) to create this data through a service (as in
> delegator.create()) but still the same error. I have also been advised to
> upgrade the build but my point is that this should work with any build. Any
> help would be greatly appreciated:I have been struggling with this issue
> for the past two weeks!
>
> Thanks in advance!
> Sangeeta
>
> ===========================================================================
>=================================================
>
> Tech Mahindra, formerly Mahindra-British Telecom.
>
>
> Disclaimer:
>
>
> The contents of this E-mail (including the contents of the enclosure(s) or
> attachment(s) if any) are privileged and confidential material of Tech
> Mahindra and should not be disclosed to, used by or copied in any manner by
> anyone other than the intended addressee(s). In case you are not the
> desired addressee, you should delete this message and/or re-direct it to
> the sender. The views expressed in this E-mail message (including the
> enclosure(s) or attachment(s) if any) are those of the individual sender,
> except where the sender expressly, and with authority, states them to be
> the views of Tech Mahindra.
>
>
> This e-mail message including attachment/(s), if any, is believed to be
> free of any virus. However, it is the responsibility of the recipient to
> ensure that it is virus free and Tech Mahindra is not responsible for any
> loss or damage arising in any way from its use.
>
> ===========================================================================
>=================================================

--
Regards,
Hans Bakker
ANT Websystems Co.,Ltd (http://www.antwebsystems.com)

If you want to verify that this message really originates from
from the above person, download the public key from:
http://www.antwebsystems.com/hbakkerAntwebsystems.asc