Java webrowset.readXml() throws SQLException

Question

I have a testWebRowset() with a webRowset object that creates an xml, populates it and manipulates some of the data and then it tries to read the xml file. Definitely not adding or removing columns though... After that it creates another instance of WebRowSet that tries to read this xml. At this point the mothod readXml() throws an SQLException saying "Invalid column index" and I just can't see what is the reason for this.

Can you help me to figure it out? Thanks.

The code:

public void testWebRowSet() throws SQLException, IOException {
    FileReader fReader;
    FileWriter fWriter;
    String priceListFileName = "pricelist.xml";
    int[] keyCols = {1};
    WebRowSet priceList = new WebRowSetImpl();

    priceList.setUsername("tom");
    priceList.setPassword("mypassword");
    priceList.setUrl("jdbc:derby://localhost:1527/TestDatabase/");
    priceList.setCommand("select * from item");
    priceList.setKeyColumns(keyCols);

    // Populate the WebRowSet
    priceList.execute();
    System.out.println("Size of the WebRowSet is: " + priceList.size());

    // Insert a new row
    priceList.moveToInsertRow();
    priceList.updateString("ITEMID", "S1002");
    priceList.updateString("NAME", "Scanner");
    priceList.updateFloat("PRICE", 8.99f);
    priceList.insertRow();
    priceList.moveToCurrentRow();
    System.out.println("New row inserted");
    System.out.println("Size of the WebRowSet is: " + priceList.size());

    //Delete the row with "Scanner"
    priceList.beforeFirst();
    while(priceList.next()) {
        if(priceList.getString(2).equals("Scanner")) {
            System.out.println("Deleting row with Scanner...");
            priceList.deleteRow();
            break;
        }
    }

    // Update price of Printer
    priceList.beforeFirst();
    while(priceList.next()) {
        if(priceList.getString(2).equals("Printer")) {
            System.out.println("Updating row with Printer...");
            priceList.updateFloat(3, 6.99f);
            priceList.updateRow();
            break;
        }
    }

    int size1 = priceList.size();
    fWriter = new FileWriter(priceListFileName);
    priceList.writeXml(fWriter);
    fWriter.flush();
    fWriter.close();

    // Create the receiving WebRowSet object
    WebRowSet receiver = new WebRowSetImpl();
    receiver.setUrl("jdbc:derby://localhost:1527/TestDatabase/");
    receiver.setUsername("tom");
    receiver.setPassword("mypassword");

    //Now read the XML file.
    fReader = new FileReader(priceListFileName);
    receiver.readXml(fReader);
    int size2 = receiver.size();
    if(size1 == size2) {
        System.out.println("WebRowSet serialized and "
                + "deserialiazed properly");
    } else {
        System.out.println("Error....serializing/deserializng the WebRowSet");
    }
    priceList.acceptChanges();
}

The stacktrace:

org.xml.sax.SAXException: Error inserting values : Invalid column index
    at com.sun.rowset.internal.XmlReaderContentHandler.endElement(XmlReaderContentHandler.java:741)
    at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.endElement(AbstractSAXParser.java:606)
    at com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaValidator.endElement(XMLSchemaValidator.java:858)
    at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanEndElement(XMLDocumentFragmentScannerImpl.java:1742)
    at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(XMLDocumentFragmentScannerImpl.java:2900)
    at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(XMLDocumentScannerImpl.java:607)
    at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.next(XMLNSDocumentScannerImpl.java:116)
    at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:489)
    at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:835)
    at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:764)
    at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:123)
    at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1210)
    at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(SAXParserImpl.java:568)
    at com.sun.rowset.internal.WebRowSetXmlReader.readXML(WebRowSetXmlReader.java:109)
    at com.sun.rowset.WebRowSetImpl.readXml(WebRowSetImpl.java:182)
    at DB.DB.testWebRowSet(DB.java:175)
    at DB.DBtest.main(DBtest.java:28)
Exception in thread "main" java.sql.SQLException: Error inserting values : Invalid column index
    at com.sun.rowset.WebRowSetImpl.readXml(WebRowSetImpl.java:200)
    at DB.DB.testWebRowSet(DB.java:175)
    at DB.DBtest.main(DBtest.java:28)
Java Result: 1

The XML file:



  
    select * from item
    1008
    
    true
    1000
    0
    2
    
      1
    
    
    
    0
    0
    0
    true
    ResultSet.TYPE_SCROLL_INSENSITIVE
    false
    item
    jdbc:derby://localhost:1527/TestDatabase/
    
      com.sun.rowset.providers.RIOptimisticProvider
      Oracle Corporation
      1.0
      2
      1
    
  
  
    4
    
      1
      false
      true
      false
      1
      false
      true
      6
      ITEMID
      ITEMID
      TOM
      6
      0
      ITEM
      
      12
      VARCHAR
    
    
      2
      false
      true
      false
      1
      false
      true
      15
      NAME
      NAME
      TOM
      15
      0
      ITEM
      
      12
      VARCHAR
    
    
      3
      false
      false
      false
      1
      true
      true
      22
      PRICE
      PRICE
      TOM
      15
      0
      ITEM
      
      8
      DOUBLE
    
    
      4
      false
      false
      false
      1
      true
      true
      22
      QUANTITY
      QUANTITY
      TOM
      15
      0
      ITEM
      
      8
      DOUBLE
    
  
  
    
      S1002
      Scanner
      8.99
      
    
    
      001
      Item 01
      2000.0
      20.0
    
    
      002
      Item 02
      1000.0
      5.0
    
    
      003
      Item 03
      20.2
      25.0
    
    
      004
      Item 04
      1500.0
      40.0
    
    
      005
      Item 05
      1600.0
      40.0
    
    
      006
      Item 06
      1700.0
      45.0
    
    
      007
      Item 07
      1800.0
      1200.0
    
    
      P1002
      Canon Printer
      60.2
      9.0

Java webrowset.readXml() throws SQLException

Answers (0)

Related Questions