Examples of javax.sql.rowset.WebRowSet.writeXml()

javax.sql.rowset.WebRowSet.writeXml()

Populates this {@code WebRowSet} object withthe contents of the given {@code ResultSet} object and writes itsdata, properties, and metadata to the given {@code Writer} object in XML format.

NOTE: The {@code WebRowSet} cursor may be moved to write out thecontents to the XML data source. If implemented in this way, the cursor must be returned to its position just prior to the {@code writeXml()} call. @param rs the {@code ResultSet} object with which to populate this{@code WebRowSet} object @param writer the {@code java.io.Writer} object to write to. @throws SQLException if an error occurs writing out the rowsetcontents in XML format


        webRs.absolute(2);


        rs = st.executeQuery("SELECT * FROM USER_INFO");
        strWriter = new StringWriter();
        webRs.writeXml(rs, strWriter);


        /*
         * TODO spec says the cursor should move to previous position after
         * writing. However, RI doesn't. Harmony follows spec
         */

        WebRowSet webRs = newWebRowSet();
        Reader fileReader = new FileReader(XML_SRC_URL_INVALID_HEADER);
        webRs.readXml(fileReader);


        StringWriter strWriter = new StringWriter();
        webRs.writeXml(strWriter);
        assertFalse(-1 == strWriter.toString().indexOf(
                "http://java.sun.com/xml/ns/jdbc"));
        assertFalse(-1 == strWriter.toString().indexOf(
                "http://www.w3.org/2001/XMLSchema-instance"));
    }

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.