Exceção em WebRowSet (leitura de XML)

0 respostas
G

Galera,

Estou com um problema fantasmagórico! Daqueles que dá certo na máquina dos outros, mas na minha, não funciona!
Pretendo fazer algo muuuuuuuuuuuito simples! Preciso ler um arquivo xml, criado com o WebRowSet e depois ler o arquivo.
Crio o XML:

String caminhoXML = "C:/output.xml";
		try{
		WebRowSet wrs = new WebRowSetImpl();
		
		ResultSet rs = PoolProtocolo.getConnect().executeQuery("select codtiporelatorio, nmtiporelatorio from rempro.formulario");
        wrs.populate(rs);
        
        FileOutputStream fout = new FileOutputStream(caminhoXML);
        wrs.writeXml(fout);
        wrs.close();

Em outro momento, faço a leitura do aquivo:

try{
			WebRowSet wrs2 = new WebRowSetImpl();
			FileReader reader = new FileReader("C:/output.xml");
			wrs2.readXml(reader);
		}
		catch (SQLException selex){
			selex.printStackTrace();
		}
		catch (IOException ioex){
			ioex.printStackTrace();
		}

na linha

wrs2.readXml(reader);

recebo a exceção:

org.xml.sax.SAXNotRecognizedException: http://java.sun.com/xml/jaxp/properties/schemaLanguage
	at gnu.xml.aelfred2.XmlReader.getProperty(XmlReader.java:181)
	at gnu.xml.aelfred2.XmlReader.setProperty(XmlReader.java:166)
	at gnu.xml.aelfred2.JAXPFactory$JaxpParser.setProperty(JAXPFactory.java:147)
	at com.sun.rowset.internal.WebRowSetXmlReader.readXML(Unknown Source)
	at com.sun.rowset.WebRowSetImpl.readXml(Unknown Source)
	at br.gov.go.mp.rempro.util.testeXML.main(testeXML.java:18)
java.sql.SQLException: http://java.sun.com/xml/jaxp/properties/schemaLanguage
	at com.sun.rowset.WebRowSetImpl.readXml(Unknown Source)
	at br.gov.go.mp.rempro.util.testeXML.main(testeXML.java:18)

Abaixo o xml gerado:

<?xml version="1.0"?>
<webRowSet xmlns="http://java.sun.com/xml/ns/jdbc" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/jdbc http://java.sun.com/xml/ns/jdbc/webrowset.xsd">
  <properties>
    <command><null/></command>
    <concurrency>1008</concurrency>
    <datasource><null/></datasource>
    <escape-processing>true</escape-processing>
    <fetch-direction>1000</fetch-direction>
    <fetch-size>0</fetch-size>
    <isolation-level>2</isolation-level>
    <key-columns>
    </key-columns>
    <map>
    </map>
    <max-field-size>0</max-field-size>
    <max-rows>0</max-rows>
    <query-timeout>0</query-timeout>
    <read-only>true</read-only>
    <rowset-type>ResultSet.TYPE_SCROLL_INSENSITIVE</rowset-type>
    <show-deleted>false</show-deleted>
    <table-name><null/></table-name>
    <url><null/></url>
    <sync-provider>
      <sync-provider-name>com.sun.rowset.providers.RIOptimisticProvider</sync-provider-name>
      <sync-provider-vendor>Sun Microsystems Inc.</sync-provider-vendor>
      <sync-provider-version>1.0</sync-provider-version>
      <sync-provider-grade>2</sync-provider-grade>
      <data-source-lock>1</data-source-lock>
    </sync-provider>
  </properties>
  <metadata>
    <column-count>2</column-count>
    <column-definition>
      <column-index>1</column-index>
      <auto-increment>false</auto-increment>
      <case-sensitive>false</case-sensitive>
      <currency>false</currency>
      <nullable>2</nullable>
      <signed>true</signed>
      <searchable>true</searchable>
      <column-display-size>6</column-display-size>
      <column-label>codtiporelatorio</column-label>
      <column-name>codtiporelatorio</column-name>
      <schema-name></schema-name>
      <column-precision>5</column-precision>
      <column-scale>0</column-scale>
      <table-name></table-name>
      <catalog-name></catalog-name>
      <column-type>5</column-type>
      <column-type-name>int2</column-type-name>
    </column-definition>
    <column-definition>
      <column-index>2</column-index>
      <auto-increment>false</auto-increment>
      <case-sensitive>true</case-sensitive>
      <currency>false</currency>
      <nullable>2</nullable>
      <signed>false</signed>
      <searchable>true</searchable>
      <column-display-size>50</column-display-size>
      <column-label>nmtiporelatorio</column-label>
      <column-name>nmtiporelatorio</column-name>
      <schema-name></schema-name>
      <column-precision>0</column-precision>
      <column-scale>0</column-scale>
      <table-name></table-name>
      <catalog-name></catalog-name>
      <column-type>1</column-type>
      <column-type-name>bpchar</column-type-name>
    </column-definition>
  </metadata>
  <data>
    <currentRow>
      <columnValue>1</columnValue>
      <columnValue>Promotoria de Justiça                             </columnValue>
    </currentRow>
    <currentRow>
      <columnValue>2</columnValue>
      <columnValue>Promotoria de Justiça Comunitária                 </columnValue>
    </currentRow>
    <currentRow>
      <columnValue>3</columnValue>
      <columnValue>Promotoria de Justiça Militar                     </columnValue>
    </currentRow>
    <currentRow>
      <columnValue>4</columnValue>
      <columnValue>CAO                                               </columnValue>
    </currentRow>
    <currentRow>
      <columnValue>1</columnValue>
      <columnValue>Promotoria de Justiça                             </columnValue>
    </currentRow>
    <currentRow>
      <columnValue>4</columnValue>
      <columnValue>CAO                                               </columnValue>
    </currentRow>
    <currentRow>
      <columnValue>2</columnValue>
      <columnValue>Promotoria de Justiça Comunitária                 </columnValue>
    </currentRow>
    <currentRow>
      <columnValue>1</columnValue>
      <columnValue>Promotoria de Justiça                             </columnValue>
    </currentRow>
  </data>
</webRowSet>

Já executei o mesmo trecho em outra máquina e executou perfeitamente. Seria algo com meu eclipse? Algum item de configuração da IDE? algum jar??

Obrigado, guilherme maranhao

Criado 16 de julho de 2008
Respostas 0
Participantes 1