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