aspose file tools*
The moose likes XML and Related Technologies and the fly likes Databases and XML Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Engineering » XML and Related Technologies
Bookmark "Databases and XML" Watch "Databases and XML" New topic
Author

Databases and XML

Ramaswamy Srinivasan
Ranch Hand

Joined: Aug 31, 2004
Posts: 295
Hi all,

Greetings.

Now I come up with a proposal of pulling some data from the databases say oracle and constructing an XML out of that.

Then match an XSL with that XML, on the fly, and format the view.

Any idea regarding the connectivities and other issues involved in this task will be highly appreciated.

Thanks in advance.

Cheers,
Swamy
Ramaswamy Srinivasan
Ranch Hand

Joined: Aug 31, 2004
Posts: 295
Hi ppl

Got the answer for the generation of XML from DB Here

Is this the only solution available, is there no way using Java API or any thing like SAX, DOM, etc.

Well.....now i need the answer for matching an XSL, on the fly with the XML

Cheers,
Swamy
Lasse Koskela
author
Sheriff

Joined: Jan 23, 2002
Posts: 11962
    
    5
Oracle has some proprietary XML features you might want to look into.

Other than that, I'm afraid you have to do the conversion between a ResultSet and a DOM Document yourself.


Author of Test Driven (2007) and Effective Unit Testing (2013) [Blog] [HowToAskQuestionsOnJavaRanch]
steve souza
Ranch Hand

Joined: Jun 26, 2002
Posts: 852
http://www.coderanch.com/t/127005/XML/Generating-XML-SQL


http://www.jamonapi.com/ - a fast, free open source performance tuning api.
JavaRanch Performance FAQ
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Databases and XML
 
Similar Threads
XML and science
XML based databases
xml:replacement
Saving XML in Oracle Blob Data type
Prototype and Scriptaculous