Hi all,

I have following tables, Can anyone tell me how do I
create xml schema (xsd file) for these tables so that
Castor XML (Source Generator) should be able to
generate the source and then the objects of these
classes should be persisted using Castor JDO.
Here is the sample table structure with Many-many
relationship.

HR Database
--------------
EMPLOYEE
    - EMP_ID (PK) int
    - NAME varchar
    - SALARY float
    - MGR_ID (FK to EMP_ID) [one-to-one relationship
between employee and mgr]
    - IS_MGR varchar

CLUBS
    - CLUB_ID (PK) int
    - NAME varchar

EMP_CLUB [many-to-many relationship between employee
and club]
    EMP_ID int
    CLUB_ID int

RESOURCES
    - RESOURCE_ID int
    - EMP_ID [one-to-many relationship between
employee and resources] int
    - TYPE varchar


My requirement is that the data will come in the
specific xml format, and that will tell whether to
delete/insert or update a record.
My code will generate the appropriate classes using
the  Castor XML and then create the instance of this
object, which will insert/delete/update the mapped
table(s). On Update it will give record in xml format.
If anyone has this kinda example then it's going to be
 a great help.

Please send me the schema atleast.

Thanks
Dennis

Thanks
Deepesh

__________________________________________________
Do You Yahoo!?
Yahoo! Health - Feel better, live better
http://health.yahoo.com

----------------------------------------------------------- 
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
        unsubscribe castor-dev

Reply via email to