Can anyone help me with a little programming example? i want to view this in praxis:
what i would need is a
java program, that queries a database,
put the results in a xml file, transposes this into another
format (e.g. same tables as in the first database but different
names/datatypes) and sends it to the second database.
for example
Database A:
person(pers_id, name, address,..)
boat(boat_id, name, color,..)
has(pers_id, boat_id) //both foreign keys
Database B:
owner(social_security_number,Firstname,Secondname,adress,...)
ship(boatnumber, type, name, ...)
owns(ssnr, bnr) //both foreign keys
now the example should read the first database and then put
the data via XML/XSL into the Second DB
is there a necessarity to analyse database A and B?
(dont think so)can you send me the example's code (using
standard java, oraxml or xml4j parser)
thx
MArtin
