JSP + XML + Oracle

[Raja Ind]

Hi my requirement is as follows..
1. Query the Oracle EMP Table and get the records as XML.
2. Process this XML using JSP/Servlets
3. Display those records in <Table> format in the browser by applying XSL.
4. The idea is to sort the resultset as per the user wish in the browser level itself. User can sort it by EMpID, EMP Name or DeptNo etc...so that i can avoid the DB connection for each sort.

I tried to get the records using OracleXMLQuery class using java but it returned a XML string. I dont know how to process this XML string...and where to strore this string


It would be geatful if anyone can give me a code for this..

Regards,
Raja.

[Bear Bibeault]

"Manickavasagan M.",

There aren't many rules that you need to worry about here on the Ranch, but one that we take very seriously regards the use of proper names. Please take a look at the JavaRanch Naming Policy and adjust your display name to match it.

In particular, your display name must be a first and a last name separated by a space character, and must not be obviously fictitious.

Thanks!
bear
Forum Bartender

[Bear Bibeault]

Moved to the Oracle forum.

[Nimchi Yung]

Since you mentioned you will use XSL to do the presentation,
you could either perform the transformation
1) on server side or
2) appended the xml document to link with your xsl stylesheet

--Nimchi