This document is a bit long, and I haven't really got the time to see if
there is a solution for you in here, but it could quite well have.
I know that the oracle team generally give code examples for just java, but
there may be a code sippit for you in here
http://spdoc.cineca.it/oracle8i/appdev.817/a86030/toc.htm
Cheers
Simon
----- Original Message -----
From: "michel geadah" <m_ace_g(_at_)hotmail(_dot_)com>
To: <xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com>
Sent: Tuesday, August 12, 2003 1:59 PM
Subject: Re: [xsl] OFF Subject...
hey,
My work is in XML...
i am using the XSU in order to transform the database tables to XML
documents (and vice versa) and then i work with these XML documents
(transform them to other XML by writing the XSL etc...), format them in
order to insert them in another database tables.
The thing is i need to know how to create the output file in the desired
place...
From: "Simon Kelly" <kelly(_at_)ipe(_dot_)fzk(_dot_)de>
How are you using the XSU package?
I use it with my business logic to perform differing tasks. Here is the
main xsu section that gets a document following a structure I define in
an
xsl file and returns me a JDom document. It is then an easy case of just
writing this document to a file. instaed of returning it to the calling
class.
I would like to know how you use the xsu to do your db actions.
Cheers
Simon
[code]
OracleXMLQuery qry = new OracleXMLQuery(this.dbConn.getConnection(),
this.sqlString);
qry.keepObjectOpen(true);
qry.setXSLT(new StringReader(this.xslString), null);
Enumeration enum = this.xslParams.keys();
while(enum.hasMoreElements()) {
String name = (String)enum.nextElement();
qry.setXSLTParam(name, "'" +
this.xslParams.getProperty(name) + "'");
if(log.isDebugEnabled()) {
log.debug(thisClass + "::" + thisMethod + "Param
name
:
" + name + "Param value : " + this.xslParams.getProperty(name));
}
}
XMLDocument temp = (XMLDocument)qry.getXMLDOM();
DOMBuilder builder = new DOMBuilder();
Element oracleElement =
builder.build(temp.getDocumentElement());
// -- Create a return document
Document retDoc = new
Document((Element)oracleElement.clone());
[/code]
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
_________________________________________________________________
Tired of spam? Get advanced junk mail protection with MSN 8.
http://join.msn.com/?page=features/junkmail
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list