Hello,
We have some data which is stored in an XML repository/DB, xindice. When we
query the db we get a valid result set which we would like to push into the
WebRowSet via the readXML(Reader) method, and then cast this over to a
CachedRowSet and store it in our DAO which is based on the baseJDAO project.
We are using the latest release of JAXP1.2.
I have looked at the example provided with the rowset early access (RC4) and
am trying to get it to work. However every time I issue the readXML()
method I encounter the following exception:
java.sql.SQLException: readXML: com/sun/xml/parser/Resolver
at sun.jdbc.rowset.XmlReaderImpl.readXML(XmlReaderImpl.java:94)
at sun.jdbc.rowset.WebRowSet.readXml(WebRowSet.java:161)
at WebRowSetTest.TestWebRowSet.go(TestWebRowSet.java:41)
at WebRowSetTest.TestWebRowSet.main(TestWebRowSet.java:15)
readXML: com/sun/xml/parser/Resolver
The below code is based of off the Example6. I have searched the JDC Fourm
and have found several post of individuals encountering the same problem,
but unfortunately I have seen no replies with a solution. Any Suggestions?
package WebRowSetTest;
import java.sql.*;
import javax.sql.*;
import sun.jdbc.rowset.WebRowSet;
import java.io.*;
public class TestWebRowSet {
public static void main(String args[])
{
TestWebRowSet rs = new TestWebRowSet();
try {
rs.go();
} catch (SQLException ex) {
System.err.println("SQLException: " + ex.getMessage());
}
}
private void go() throws SQLException {
// create a new row set
WebRowSet wrs = new WebRowSet();
System.out.println("rs created...");
try {
// this seems to make no difference
System.setProperty("org.xml.sax.parser",
"org.apache.xerces.parsers.SAXParser");
java.io.FileReader FR = new java.io.FileReader("Example6.xml");
// populate wrs with xml contents
wrs.readXml(FR);
System.out.println("RowSet populated (I think).");
scrollCursor(wrs);
} catch (Throwable ex) {
ex.printStackTrace();
System.out.println(ex.getMessage());
}
}
private void scrollCursor(WebRowSet wrs) throws SQLException {
System.out.println("Fetching from RowSet...");
String v1;
int v2;
wrs.beforeFirst();
while (wrs.next()) {
System.out.println("This is row: " + wrs.getRow());
}
}
}
Todd G. Nist
Chief Technology Officer
FBO Systems Inc.
3555 Koger Blvd.
Suite 300
Duluth, GA 30096
Phone: 770-723-1011
Email: [EMAIL PROTECTED]
begin 666 ATT00030.htm
M/"%$3T-465!%($A434P@4%5"3$E#("(M+R]7,T,O+T141"!(5$U,(#0N,"!4
M<F%N<VET:6]N86PO+T5.(CX-"CQ(5$U,/CQ(14%$/@T*/$U%5$$@2%144"U%
M455)5CTB0V]N=&5N="U4>7!E(B!#3TY414Y4/2)T97AT+VAT;6P[(&-H87)S
M970]=VEN9&]W<RTQ,C4R(CX-"CQ4251,13X\+U1)5$Q%/@T*#0H\345402!C
M;VYT96YT/2)-4TA434P@-2XU,"XT.3$R+C,P,"(@;F%M93U'14Y%4D%43U(^
M/"](14%$/@T*/$)/1%D^#0H\1$E6/CQ&3TY4(&9A8V4]07)I86P@<VEZ93TR
M/DAE;&QO+#PO1D].5#X\+T1)5CX-"CQ$258^/$9/3E0@9F%C93U!<FEA;"!S
M:7IE/3(^/"]&3TY4/B9N8G-P.SPO1$E6/@T*/$1)5CX\1D].5"!F86-E/4%R
M:6%L('-I>F4],CY792!H879E('-O;64@9&%T82!W:&EC:"!I<R!S=&]R960@
M:6X@86X@6$U,( T*<F5P;W-I=&]R>2]$0BP@>&EN9&EC92XF;F)S<#L@5VAE
M;B!W92!Q=65R>2!T:&4@9&(@=V4@9V5T(&$@=F%L:60@<F5S=6QT('-E=" -
M"G=H:6-H('=E('=O=6QD(&QI:V4@=&\@<'5S:"!I;G1O('1H92!796)2;W=3
M970@=FEA('1H92!R96%D6$U,*%)E861E<BD@;65T:&]D+" -"F%N9"!T:&5N
M(&-A<W0@=&AI<R!O=F5R('1O(&$@0V%C:&5D4F]W4V5T(&%N9"!S=&]R92!I
M="!I;B!O=7(@1$%/('=H:6-H(&ES(&)A<V5D( T*;VX@=&AE(&)A<V5*1$%/
M)FYB<W [<')O:F5C="XF;F)S<#LF;F)S<#M792!A<F4@=7-I;F<@=&AE(&QA
M=&5S="!R96QE87-E(&]F( T*2D%84#$N,BX\+T9/3E0^/"]$258^#0H\1$E6
M/CQ&3TY4(&9A8V4]07)I86P@<VEZ93TR/CPO1D].5#XF;F)S<#L\+T1)5CX-
M"CQ$258^/$9/3E0@9F%C93U!<FEA;"!S:7IE/3(^22!H879E(&QO;VME9"!A
M="!T:&4@97AA;7!L92!P<F]V:61E9"!W:71H('1H92 -"G)O=W-E="!E87)L
M>2!A8V-E<W,@*%)#-"D@86YD(&%M('1R>6EN9R!T;R!G970@:70@=&\@=V]R
M:RXF;F)S<#L@2&]W979E<B!E=F5R>2 -"G1I;64@22!I<W-U92!T:&4@<F5A
M9%A-3"@I(&UE=&AO9"!)(&5N8V]U;G1E<B!T:&4@9F]L;&]W:6YG( T*97AC
M97!T:6]N.CPO1D].5#X\+T1)5CX-"CQ$258^/$9/3E0@9F%C93U!<FEA;"!S
M:7IE/3(^/"]&3TY4/B9N8G-P.SPO1$E6/@T*/$1)5CX\1D].5"!F86-E/4%R
M:6%L('-I>F4],CYJ879A+G-Q;"Y344Q%>&-E<'1I;VXZ(')E861834PZ( T*
M8V]M+W-U;B]X;6PO<&%R<V5R+U)E<V]L=F5R/$)2/B9N8G-P.V%T( T*<W5N
M+FID8F,N<F]W<V5T+EAM;%)E861E<DEM<&PN<F5A9%A-3"A8;6Q296%D97))
M;7!L+FIA=F$Z.30I/$)2/B9N8G-P.V%T( T*<W5N+FID8F,N<F]W<V5T+E=E
M8E)O=U-E="YR96%D6&UL*%=E8E)O=U-E="YJ879A.C$V,2D\0E(^)FYB<W [
M870@#0I796)2;W=3971497-T+E1E<W1796)2;W=3970N9V\H5&5S=%=E8E)O
M=U-E="YJ879A.C0Q*3Q"4CXF;F)S<#MA=" -"E=E8E)O=U-E=%1E<W0N5&5S
M=%=E8E)O=U-E="YM86EN*%1E<W1796)2;W=3970N:F%V83HQ-2D\0E(^<F5A
M9%A-3#H@#0IC;VTO<W5N+WAM;"]P87)S97(O4F5S;VQV97(\0E(^/"]&3TY4
M/CPO1$E6/@T*/$1)5CX\1D].5"!F86-E/4%R:6%L('-I>F4],CY4:&4@8F5L
M;W<F;F)S<#MC;V1E(&ES)FYB<W [8F%S960@;V8@;V9F('1H92 -"D5X86UP
M;&4V+B9N8G-P.R!)(&AA=F4@<V5A<F-H960@=&AE($I$0R!&;W5R;2!A;F0@
M:&%V92!F;W5N9"!S979E<F%L('!O<W0@;V8@#0II;F1I=FED=6%L<R!E;F-O
M=6YT97)I;F<@=&AE('-A;64@<')O8FQE;2P@8G5T('5N9F]R='5N871E;'D@
M22!H879E('-E96X@;F\@#0IR97!L:65S('=I=&@@82!S;VQU=&EO;BXF;F)S
M<#LF;F)S<#LF;F)S<#M!;GD@4W5G9V5S=&EO;G,_/"]&3TY4/CPO1$E6/@T*
M/$1)5CX\1D].5"!F86-E/4%R:6%L('-I>F4],CX\+T9/3E0^)FYB<W [/"]$
M258^#0H\1$E6/CQ&3TY4(&9A8V4]07)I86P@<VEZ93TR/G!A8VMA9V4@5V5B
M4F]W4V5T5&5S=#L\+T9/3E0^/"]$258^#0H\1$E6/CQ&3TY4(&9A8V4]07)I
M86P@<VEZ93TR/CPO1D].5#XF;F)S<#L\+T1)5CX-"CQ$258^/$9/3E0@9F%C
M93U!<FEA;"!S:7IE/3(^:6UP;W)T(&IA=F$N<W%L+BH[/$)2/FEM<&]R="!J
M879A>"YS<6PN*CL\0E(^:6UP;W)T( T*<W5N+FID8F,N<F]W<V5T+E=E8E)O
M=U-E=#L\0E(^:6UP;W)T(&IA=F$N:6\N*CL\+T9/3E0^/"]$258^#0H\1$E6
M/CQ&3TY4(&9A8V4]07)I86P@<VEZ93TR/CPO1D].5#XF;F)S<#L\+T1)5CX-
M"CQ$258^/$9/3E0@9F%C93U!<FEA;"!S:7IE/3(^/$)2/G!U8FQI8R!C;&%S
M<R!497-T5V5B4F]W4V5T('L\+T9/3E0^/"]$258^#0H\1$E6/CQ&3TY4(&9A
M8V4]07)I86P@<VEZ93TR/CPO1D].5#XF;F)S<#L\+T1)5CX-"CQ$258^/$9/
M3E0@9F%C93U!<FEA;"!S:7IE/3(^)FYB<W [)FYB<W [)FYB<W [('!U8FQI
M8R!S=&%T:6,@=F]I9"!M86EN*%-T<FEN9R -"F%R9W-;72D\0E(^)FYB<W [
M)FYB<W [)FYB<W [( T*>R9N8G-P.R9N8G-P.R9N8G-P.R9N8G-P.R9N8G-P
M.R9N8G-P.R9N8G-P.R9N8G-P.R9N8G-P.R9N8G-P.R9N8G-P.R9N8G-P.R9N
M8G-P.R9N8G-P.R9N8G-P.R -"CQ"4CXF;F)S<#LF;F)S<#LF;F)S<#LF;F)S
M<#LF;F)S<#LF;F)S<#LF;F)S<#L@5&5S=%=E8E)O=U-E="!R<R ](&YE=R -
M"E1E<W1796)2;W=3970H*3L\0E(^)FYB<W [)FYB<W [)FYB<W [)FYB<W [
M)FYB<W [)FYB<W [)FYB<W [('1R>2 -"GL\0E(^)FYB<W [)FYB<W [)FYB
M<W [)FYB<W [)FYB<W [)FYB<W [)FYB<W [)FYB<W [)FYB<W [)FYB<W [
M)FYB<W [( T*<G,N9V\H*3LF;F)S<#LF;F)S<#LF;F)S<#LF;F)S<#LF;F)S
M<#LF;F)S<#LF;F)S<#L@#0H\0E(^)FYB<W [)FYB<W [)FYB<W [)FYB<W [
M)FYB<W [)FYB<W [)FYB<W [('T@8V%T8V@@*%-13$5X8V5P=&EO;B!E>"D@
M#0I[/$)2/B9N8G-P.R9N8G-P.R9N8G-P.R9N8G-P.R9N8G-P.R9N8G-P.R9N
M8G-P.R9N8G-P.R9N8G-P.R9N8G-P.R9N8G-P.R -"E-Y<W1E;2YE<G(N<')I
M;G1L;B@B4U%,17AC97!T:6]N.B B("L@#0IE>"YG971-97-S86=E*"DI.SQ"
M4CXF;F)S<#LF;F)S<#LF;F)S<#LF;F)S<#LF;F)S<#LF;F)S<#LF;F)S<#L@
M#0I]/$)2/B9N8G-P.R9N8G-P.R9N8G-P.R!]/"]&3TY4/CPO1$E6/@T*/$1)
M5CX\1D].5"!F86-E/4%R:6%L('-I>F4],CX\+T9/3E0^)FYB<W [/"]$258^
M#0H\1$E6/CQ&3TY4(&9A8V4]07)I86P@<VEZ93TR/B9N8G-P.R9N8G-P.R9N
M8G-P.R!P<FEV871E('9O:60@9V\H*2!T:')O=W,@#0I344Q%>&-E<'1I;VX@
M>SPO1D].5#X\+T1)5CX-"CQ$258^/$9/3E0@9F%C93U!<FEA;"!S:7IE/3(^
M/"]&3TY4/B9N8G-P.SPO1$E6/@T*/$1)5CX\1D].5"!F86-E/4%R:6%L( T*
M<VEZ93TR/B9N8G-P.R9N8G-P.R9N8G-P.R9N8G-P.R9N8G-P.R9N8G-P.R9N
M8G-P.R9N8G-P.R9N8G-P.R9N8G-P.R9N8G-P.R -"CQ"4CXF;F)S<#LF;F)S
M<#LF;F)S<#LF;F)S<#LF;F)S<#LF;F)S<#LF;F)S<#L@+R\@8W)E871E(&$@
M;F5W(')O=R -"G-E=#Q"4CXF;F)S<#LF;F)S<#LF;F)S<#LF;F)S<#LF;F)S
M<#LF;F)S<#LF;F)S<#L@5V5B4F]W4V5T('=R<R ](&YE=R -"E=E8E)O=U-E
M="@I.SQ"4CXF;F)S<#LF;F)S<#LF;F)S<#LF;F)S<#LF;F)S<#LF;F)S<#LF
M;F)S<#L@#0I3>7-T96TN;W5T+G!R:6YT;&XH(G)S( T*8W)E871E9"XN+B(I
M.SQ"4CXF;F)S<#LF;F)S<#LF;F)S<#LF;F)S<#LF;F)S<#LF;F)S<#LF;F)S
M<#L@=')Y( T*>SQ"4CXF;F)S<#LF;F)S<#LF;F)S<#LF;F)S<#LF;F)S<#LF
M;F)S<#LF;F)S<#LF;F)S<#LF;F)S<#LF;F)S<#LF;F)S<#LF;F)S<#L\+T9/
M3E0^/"]$258^#0H\1$E6/CQ&3TY4(&9A8V4]07)I86P@<VEZ93TR/CQ&3TY4
M( T*8V]L;W(](S P,#!F9CXF;F)S<#LF;F)S<#LF;F)S<#LF;F)S<#LF;F)S
M<#LF;F)S<#LF;F)S<#LF;F)S<#LF;F)S<#LF;F)S<#LF;F)S<#LF;F)S<#LO
M+R -"G1H:7,@<V5E;7,@=&\@;6%K92!N;R -"F1I9F9E<F5N8V4\0E(^/"]&
M3TY4/B9N8G-P.R9N8G-P.R9N8G-P.R9N8G-P.R9N8G-P.R9N8G-P.R9N8G-P
M.R9N8G-P.R9N8G-P.R9N8G-P.R9N8G-P.R -"E-Y<W1E;2YS9710<F]P97)T
M>2@B;W)G+GAM;"YS87@N<&%R<V5R(BP@#0HB;W)G+F%P86-H92YX97)C97,N
M<&%R<V5R<RY305A087)S97(B*3L\+T9/3E0^/"]$258^#0H\1$E6/CQ&3TY4
M(&9A8V4]07)I86P@<VEZ93TR/CPO1D].5#XF;F)S<#L\+T1)5CX-"CQ$258^
M/$9/3E0@9F%C93U!<FEA;" -"G-I>F4],CXF;F)S<#LF;F)S<#LF;F)S<#LF
M;F)S<#LF;F)S<#LF;F)S<#LF;F)S<#LF;F)S<#LF;F)S<#LF;F)S<#LF;F)S
M<#L@#0IJ879A+FEO+D9I;&5296%D97(@1E(@/2!N97<@#0IJ879A+FEO+D9I
M;&5296%D97(H(D5X86UP;&4V+GAM;"(I.SQ"4CXF;F)S<#LF;F)S<#LF;F)S
M<#LF;F)S<#LF;F)S<#LF;F)S<#LF;F)S<#LF;F)S<#LF;F)S<#LF;F)S<#LF
M;F)S<#L@#0HO+R!P;W!U;&%T92!W<G,@=VET:"!X;6P@8V]N=&5N=',\+T9/
M3E0^/"]$258^#0H\1$E6/CQ&3TY4(&9A8V4]07)I86P@<VEZ93TR/CPO1D].
M5#XF;F)S<#L\+T1)5CX-"CQ$258^/$9/3E0@9F%C93U!<FEA;" -"G-I>F4]
M,CXF;F)S<#LF;F)S<#LF;F)S<#LF;F)S<#LF;F)S<#LF;F)S<#LF;F)S<#LF
M;F)S<#LF;F)S<#LF;F)S<#LF;F)S<#L@#0IW<G,N<F5A9%AM;"A&4BD[/$)2
M/B9N8G-P.R9N8G-P.R9N8G-P.R9N8G-P.R9N8G-P.R9N8G-P.R9N8G-P.R9N
M8G-P.R9N8G-P.R9N8G-P.R9N8G-P.R -"E-Y<W1E;2YO=70N<')I;G1L;B@B
M4F]W4V5T('!O<'5L871E9" H22!T:&EN:RDN(BD[/"]&3TY4/CPO1$E6/@T*
M/$1)5CX\1D].5"!F86-E/4%R:6%L('-I>F4],CX\+T9/3E0^)FYB<W [/"]$
M258^#0H\1$E6/CQ&3TY4(&9A8V4]07)I86P@#0IS:7IE/3(^)FYB<W [)FYB
M<W [)FYB<W [)FYB<W [)FYB<W [)FYB<W [)FYB<W [)FYB<W [)FYB<W [
M)FYB<W [)FYB<W [( T*<V-R;VQL0W5R<V]R*'=R<RD[/"]&3TY4/CPO1$E6
M/@T*/$1)5CX\1D].5"!F86-E/4%R:6%L('-I>F4],CX\+T9/3E0^)FYB<W [
M/"]$258^#0H\1$E6/CQ&3TY4(&9A8V4]07)I86P@<VEZ93TR/B9N8G-P.R9N
M8G-P.R9N8G-P.R9N8G-P.R9N8G-P.R9N8G-P.R9N8G-P.R!](&-A=&-H( T*
M*%1H<F]W86)L92!E>"D@>SQ"4CXF;F)S<#LF;F)S<#LF;F)S<#LF;F)S<#LF
M;F)S<#LF;F)S<#LF;F)S<#L@#0HF;F)S<#ME>"YP<FEN=%-T86-K5')A8V4H
M*3L\0E(^)FYB<W [)FYB<W [)FYB<W [)FYB<W [)FYB<W [)FYB<W [)FYB
M<W [)FYB<W [)FYB<W [)FYB<W [)FYB<W [( T*4WES=&5M+F]U="YP<FEN
M=&QN*&5X+F=E=$UE<W-A9V4H*2D[/$)2/B9N8G-P.R9N8G-P.R9N8G-P.R9N
M8G-P.R9N8G-P.R9N8G-P.R9N8G-P.R -"GT\0E(^)FYB<W [)FYB<W [)FYB
M<W [('T\+T9/3E0^/"]$258^#0H\1$E6/CQ&3TY4(&9A8V4]07)I86P@<VEZ
M93TR/CPO1D].5#XF;F)S<#L\+T1)5CX-"CQ$258^/$9/3E0@9F%C93U!<FEA
M;"!S:7IE/3(^)FYB<W [)FYB<W [)FYB<W [('!R:79A=&4@=F]I9" -"G-C
M<F]L;$-U<G-O<BA796)2;W=3970@=W)S*2!T:')O=W,@4U%,17AC97!T:6]N
M( T*>SQ"4CXF;F)S<#LF;F)S<#LF;F)S<#LF;F)S<#LF;F)S<#LF;F)S<#LF
M;F)S<#L@4WES=&5M+F]U="YP<FEN=&QN*")&971C:&EN9R -"F9R;VT@4F]W
M4V5T+BXN(BD[/$)2/B9N8G-P.R9N8G-P.R9N8G-P.R9N8G-P.R9N8G-P.R9N
M8G-P.R9N8G-P.R -"CQ"4CXF;F)S<#LF;F)S<#LF;F)S<#LF;F)S<#LF;F)S
M<#LF;F)S<#LF;F)S<#L@4W1R:6YG( T*=C$[/$)2/B9N8G-P.R9N8G-P.R9N
M8G-P.R9N8G-P.R9N8G-P.R9N8G-P.R9N8G-P.R!I;G0@=C([/"]&3TY4/CPO
M1$E6/@T*/$1)5CX\1D].5"!F86-E/4%R:6%L('-I>F4],CX\+T9/3E0^)FYB
M<W [/"]$258^#0H\1$E6/CQ&3TY4(&9A8V4]07)I86P@<VEZ93TR/B9N8G-P
M.R9N8G-P.R9N8G-P.R9N8G-P.R9N8G-P.R9N8G-P.R9N8G-P.R -"G=R<RYB
M969O<F5&:7)S="@I.SQ"4CXF;F)S<#LF;F)S<#LF;F)S<#LF;F)S<#LF;F)S
M<#LF;F)S<#LF;F)S<#L@#0H\0E(^)FYB<W [)FYB<W [)FYB<W [)FYB<W [
M)FYB<W [)FYB<W [)FYB<W [('=H:6QE("AW<G,N;F5X="@I*2![/"]&3TY4
M/CPO1$E6/@T*/$1)5CX\1D].5"!F86-E/4%R:6%L( T*<VEZ93TR/B9N8G-P
M.R9N8G-P.R9N8G-P.R9N8G-P.R9N8G-P.R9N8G-P.R9N8G-P.R9N8G-P.R9N
M8G-P.R9N8G-P.R9N8G-P.R -"E-Y<W1E;2YO=70N<')I;G1L;B@B5&AI<R!I
M<R!R;W<Z("(@*R -"G=R<RYG9712;W<H*2D[/$)2/B9N8G-P.R9N8G-P.R9N
M8G-P.R9N8G-P.R9N8G-P.R9N8G-P.R9N8G-P.R -"GT\0E(^)FYB<W [)FYB
M<W [)FYB<W [)FYB<W [)FYB<W [)FYB<W [)FYB<W [)FYB<W [/$)2/CPO
M1D].5#X\1D].5"!F86-E/4%R:6%L( T*<VEZ93TR/B9N8G-P.R9N8G-P.R9N
M8G-P.R!]/$)2/GT\0E(^/"]$258^/"]&3TY4/@T*/$1)5CX\1D].5"!F86-E
M/4%R:6%L('-I>F4],CX\+T9/3E0^/$9/3E0@9F%C93U!<FEA;" -"G-I>F4]
M,CX\+T9/3E0^/$)2/CQ"4CX\+T1)5CX-"CQ0/CQ&3TY4('-I>F4],CY4;V1D
M($<N($YI<W0\0E(^0VAI968@5&5C:&YO;&]G>2!/9F9I8V5R/$)2/D9"3R!3
M>7-T96US( T*26YC+CQ"4CXS-34U($MO9V5R($)L=F0N/$)2/E-U:71E(#,P
M,#Q"4CY$=6QU=&@L($=!)FYB<W [(#,P,#DV/$)2/E!H;VYE.B9N8G-P.R -
M"C<W,"TW,C,M,3 Q,3Q"4CY%;6%I;#HF;F)S<#LF;F)S<#L@=&YI<W1 9F)O
D<RYC;VT\0E(^/"]&3TY4/CPO4#X\+T)/1%D^/"](5$U,/@T*
`
end
_______________________________________________
MVC-Programmers mailing list
[EMAIL PROTECTED]
http://www.basebeans.com:8081/mailman/listinfo/mvc-programmers
