Hi Experts, I want a complete end to end code for the below requirement. I would like to explain you the below requirement into 3 steps. cases. I request you to please provide me the code to FULFIL my requirement....

1) Fetch all the records from a SQL VIEW (not from original table) based on the query "SELECT * from AMAR_VIEW WHERE CLASS = 'TENTH" & SIGN = 'AAA' " List of fields below fields as example: - Fields are; - TIMESTAMP,ROLLNO,FROMID,SIGN,CLASS

2) Once you Select lets say 10 records from table / view then you need to Update the selected records only based on the UNIQUR KEY FIELD --> ROLL_NO and what ever the you selected rows those only needs to be update the Signature field SIGN from 'AAA' to 'BBB'

3) Once you Update there immediately then you need to push and output XML file with all records into a single XML with containing as Row's.

Please see the output XML: - I need output XML File as: -

**

<?xml version="1.0" encoding="utf-8"?>
<ns:MT_TestingSQL xmlns:ns="http://abcd.com//SQL_to_File">
    <row>
        <TIMESTAMP>20101107094853</TIMESTAMP>
        <ROLL_NO>112</ROLL_NO>  // UNIQUE KEY FIELD 
        <FROM_ID>SQL01</FROM_ID>    
        <SIGN>AAA</SIGN>        // FLAG = Intially it will comes as W21 once you select 10 records lets say ex: -  then you need to UPDATE Only those Selected fields only with status field SIGN = 'AAA'
        <CLASS>TENTH</CLASS>
    </row>

**

Kindly provide me the JAVA CODE for generating the output XML file.

Regards Amar Srinivas Eli