Scratch all that... the output isn't showing up in Eclipse in the console window at the bottom... but I can select all and copy and paste it into my text editor and it is all there... I have spent hours now trying to figure out what I was doing wrong only to find out it is a bug in my IDE... sorry to waste your time and bandwidth.
-Dan Feather -----Original Message----- From: Dan Feather [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 21, 2005 2:35 PM To: [email protected] Subject: Custom XMLReader: I must be missing something? Hello, I have looked through the mailing list archives and I have seen threads where people have had similar problems, but I haven't read anything that jumped out at me as an answer to my problem. I have a simple XMLReader that opens a connection to a data base, and generates SAX events for the rows in a result set... I am piping the events through a TransformerHandler but I am not getting what I think I should get. I have a feeling it has something to do with my namespace (or lack of one) but I am not sure how to go about fixing it if that is the case. Here is the parse method from my XMLReader: ---------------------------------SNIP--------------------------------- public void parse(DbInputSource input) throws IOException, SAXException { //If we don't have a handler, we don't need to do anything. if(docHandler == null)return; Attributes EMPTY_ATTR = new AttributesImpl(); Connection con = input.getConnection(); String query = input.getQuery(); Statement stmt = null; try{ stmt = con.createStatement(); ResultSet rs = stmt.executeQuery(query); ResultSetMetaData rsmd = rs.getMetaData(); int columns = rsmd.getColumnCount(); docHandler.startDocument(); docHandler.startElement("","table","table",EMPTY_ATTR); while(rs.next()){ docHandler.startElement("","row","row",EMPTY_ATTR); for(int i = 1; i <= columns; i++){ String colName = rsmd.getColumnName(i); String value = rs.getString(i); docHandler.startElement("",colName,colName,EMPTY_ATTR); docHandler.characters(value.toCharArray(),0,value.length()); docHandler.endElement("",colName,colName); } docHandler.endElement("","row","row"); } docHandler.endElement("","table","table"); docHandler.endDocument(); } catch(Exception e){ e.printStackTrace(); } finally{ try{ stmt.close(); } catch(Exception e){} try{ con.close(); } catch(Exception e){} } } ---------------------------------SNIP--------------------------------- So I then use that parser in a simple test program like the following: ---------------------------------SNIP--------------------------------- try { TransformerFactory tFactory = TransformerFactory.newInstance(); if(tFactory.getFeature(SAXSource.FEATURE) && tFactory.getFeature(SAXResult.FEATURE)){ SAXTransformerFactory saxTFactory =(SAXTransformerFactory)tFactory; //TransformerHandler tHandler = saxTFactory.newTransformerHandler(); TransformerHandler tHandler = saxTFactory.newTransformerHandler(new StreamSource("test2.xsl")); XMLDBSaxParser parser = new XMLDBSaxParser(); parser.setContentHandler(tHandler); //parser.setProperty("http://xml.org/sax/properties/lexical-handler",tHa ndler); Serializer serializer = SerializerFactory.getSerializer(OutputPropertiesFactory.getDefaultMethod Properties("xml")); serializer.setOutputStream(System.out); tHandler.setResult(new SAXResult(serializer.asContentHandler())); // Parse the XML input document. DbInputSource input = new DbInputSource(); input.setQuery("select * from foo.bar"); parser.parse(input); } } catch (Exception e) { e.printStackTrace(); } ---------------------------------SNIP--------------------------------- I am using a simple stylesheet right now for testing (test2.xsl). When I do the following I get output: <xsl:stylesheet xmlns:xsl = "http://www.w3.org/1999/XSL/Transform"; version = "1.0" > <xsl:output method = "xml" /> <xsl:template match = "/" > <Test> <xsl:apply-templates select = "//row" /> </Test> </xsl:template> <xsl:template match = "row" > <xsl:value-of select="name()" /> </xsl:template> </xsl:stylesheet> I end up with <Test>rowrowrowrowrowrowrow...</Test>, which is what it should do. However, when I add start and end tags (<test1> and </test1>) in the template for "row" no output is produced at all: <xsl:stylesheet xmlns:xsl = "http://www.w3.org/1999/XSL/Transform"; version = "1.0" > <xsl:output method = "xml" /> <xsl:template match = "/" > <Test> <xsl:apply-templates select = "//row" /> </Test> </xsl:template> <xsl:template match = "row" > <test1> <xsl:value-of select="name()" /> </test1> </xsl:template> </xsl:stylesheet> I have a feeling I am not generating the events correctly. Can anyone give me an idea as to what I am doing wrong? I have found examples that do the same thing I am doing above, but they are 1 or 2 years old so I figure something may have changed and I am not finding it. I appreciate your help! -Dan Feather
