Re: Creating an xml doc from another xml doc via xsl

["Steve Muench" <smuench at us dot oracle dot com>]

Matthew,

As these issues are no longer XSL-specific, I'll reply
off the list. Thanks.

______________________________________________________________
Steve Muench, Lead XML Evangelist & Consulting Product Manager
Business Components for Java & XSQL Servlet Development Teams
Oracle Rep to the W3C XSL Working Group
----- Original Message ----- 
From: "Matthew Cordes" <mcorde61@maine.edu>
To: <xsl-list@mulberrytech.com>
Sent: Monday, April 10, 2000 8:49 AM
Subject: Re: Creating an xml doc from another xml doc via xsl


| Thanks for replying...
| 
| > Instead of calling getString(1) like you would do get the 1st column as
| > as string value, you call:
| > 
| >   getCursor(1) 
| 
| This method doesn't appear to be part of jdbc 2.0, the only method that 
| explicitly mentioned cursor in its name was getCursorName(), which I'm 
| sure is not what you are refering to.  I looked in the documentation for
| both the jdk1.2 and 1.3 and this method did not appear to exist in either.
| 
| >    OracleXMLQuery oxq = new OracleXMLQuery(yourConnection, yourSQL);
| >    Document d = oxq.getXMLDOM(); // to return results as a DOM tree or
| >    String   s = oxq.getXMLString(); // to return results as XML "text"
| 
| When I do this, all I seem to get as output is an empty ResultSet, 
| perhaps you can see my mistake?
| 
| // Objects: Connection dbConn, Statement dbStat already exist
| 
| String dbQuery =  "select CATEGORY, cursor (select SUBJECT, 
| NAME, ALIAS from HOUSER.SPEAKER_TOPICS b where b.CATEGORY 
| = a.CATEGORY ) as CHILDDATA from HOUSER.SPEAKER_TOPICS a  
| group by CATEGORY";
| 
| Statement dbStat = dbConn.createStatement();
| ResultSet rs = dbStat.executeQuery( dbQuery );
| 
|     OracleXMLQuery oxq = new OracleXMLQuery(dbConn, rs);
| 
| String s = oxq.getXMLString();
| System.out.println( "DOM: " + s );
| 
| 
| This always results in this output:
| 
| DOM: <?xml version = '1.0'?>
| <ROWSET/>
| 
| 
| Again, I really appreciate your help thus far.
| 
| -matt
| 
| 
|  XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
| 


 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list