XML Parser

[Vinod S]

Hi all i want to create a xml parser which reads the values from a xml file and inserts it into a database.

i will give you a description of my work. we are using oracle database for our application main server and mysql database for branches. i want to update the data from the branch to the main server. for that i am writing the data from the mysql database to a xml file. in the server i want to read the data from this xml file and insert this values in to the database. i cant use the default oracle tool for this cose i dont need the complete fileds in the xml to be entered in to the oracle database.

how can i do this. can anybody help me in this. its very urgent.

[khp]

Originally posted by Vinod S
i cant use the default oracle tool for this cose i dont need the complete fileds in the xml to be entered in to the oracle database.


Then send the xml through a xslt transform, that selects the parts you need, and then use the oracle tool on the result of that transformation.

[khp]

Crosspost.

Please don't do this. I see this is not the first time you have been told, not to do this.


[Andreas]: Removed link to other post...

[Vinod S]

I cant do that cose why i dont want all the fields in the xml file is .

i am using torque to insert data in to the oracle database as well as mysql. and using its auto incriment menthod - idbroker - for my primary key when i insert the branch data using oracle method i will get conflict on this primary key its why i dont want all the fields in xml file, but i cant avoid this when i use oracle method. so i have to insert the data using torque only. i think now you got the real problem.

so is there any parser which helps to read the values directly from the xml file.

[Vinod S]

I am Apologizing for the cross mail. its because of my eagerness i done so. first i have posted the question in XML form but there i dont find more interactions its why i posted the same in java form also.

[khp]

Originally posted by Vinod S
I cant do that cose why i dont want all the fields in the xml file is .

Originally posted by khp
Then send the xml through a xslt transform, that selects the parts you need...

[Andreas Masur]

[Merged threads]


VinodS, as being mentioned, please do not cross-post your questions. Thank you very much.