Read XML serialization of an ADO.NET Recordset in Java

[roboB]

Whth .NET WS I have serialized an ADO.NET Recordset in an XML Stream like this:

<xml xmlns:s='uuid:B DC6E3F0-6DA3-11d1-A2A3-00AA00C14882'
xmlns:dt='uuid: C2F41010-65B3-11d1-A29F-00AA00C14882'
xmlns:rs='urn:s chemas-microsoft-com:rowset'
xmlns:z='#Rowse tSchema'>
<s:Schema id='RowsetSchem a'>
<s:ElementTyp e name='row' content='eltOnl y'>
<s:AttributeTyp e name='FIELD' rs:number='1' rs:nullable='tr ue'>
<s:datatype dt:type='string ' rs:dbtype='str'
dt:maxLength='5 12'/>
</s:AttributeType >
...
<s:AttributeTyp e name='FIELDn' rs:number='n'
rs:nullable='tr ue' rs:writeunknown ='true'>
<s:datatype dt:type='string ' rs:dbtype='str'
dt:maxLength='1 80'/>
</s:AttributeType >
<s:extends type='rs:rowbas e'/>
</s:ElementType>
</s:Schema>
<rs:data>
<z:row FIELD1='C' ... FIELDn='(A)'/>
<z:row FIELD1='C' ... FIELDn='(B)'/>
...
</rs:data>
</xml>
Now in my Java application I use Axis to obtain the WS Stream. How can
I deserialize this XML in Java classes?

I have seen JAXB, but it wants two file: an XSD Schema and a XML file....
Thanks

Roberto

[John Saunders]

"roboB" <ro***@discussi ons.microsoft.c omwrote in message
news:65******** *************** ***********@mic rosoft.com...

Whth .NET WS I have serialized an ADO.NET Recordset in an XML Stream like
this:

<xml xmlns:s='uuid:B DC6E3F0-6DA3-11d1-A2A3-00AA00C14882'
xmlns:dt='uuid: C2F41010-65B3-11d1-A29F-00AA00C14882'
xmlns:rs='urn:s chemas-microsoft-com:rowset'
xmlns:z='#Rowse tSchema'>
<s:Schema id='RowsetSchem a'>
<s:ElementTyp e name='row' content='eltOnl y'>
<s:AttributeTyp e name='FIELD' rs:number='1'
rs:nullable='tr ue'>
<s:datatype dt:type='string ' rs:dbtype='str'
dt:maxLength='5 12'/>
</s:AttributeType >
...
<s:AttributeTyp e name='FIELDn' rs:number='n'
rs:nullable='tr ue' rs:writeunknown ='true'>
<s:datatype dt:type='string ' rs:dbtype='str'
dt:maxLength='1 80'/>
</s:AttributeType >
<s:extends type='rs:rowbas e'/>
</s:ElementType>
</s:Schema>
<rs:data>
<z:row FIELD1='C' ... FIELDn='(A)'/>
<z:row FIELD1='C' ... FIELDn='(B)'/>
...
</rs:data>
</xml>
Now in my Java application I use Axis to obtain the WS Stream. How can
I deserialize this XML in Java classes?

I have seen JAXB, but it wants two file: an XSD Schema and a XML file....

If that's what JAXB wants, then why not give it to JAXB?

Why would you expect Java or anything else to understand this XML format?
Does JAXB know about the 'urn:schemas-microsoft-com:rowset' namespace? If
not, then how will it be able to interpret an rs:data element?

You should think this through, starting with the WSDL file and its
associated schemas, and then, maybe finally deciding how to serialize your
ADO.NET Recordset. That's the final thing you should be doing, not the
first.
John

[roboB]

Ok, Jhon, pehaps I was not so very clear.

Some question more spicifically:

1) Why Does Microsoft persist an ADO.NET recordset in this mode if this is
not so very useful to deserialize in Java environment? WS are made to do
interoperabilit y more accessible...

2) How Do you think it is more convenient to serialize and deserialize
ADO.NET recordset in Java?

Thanks to you

"John Saunders" wrote:

"roboB" <ro***@discussi ons.microsoft.c omwrote in message
news:65******** *************** ***********@mic rosoft.com...

Whth .NET WS I have serialized an ADO.NET Recordset in an XML Stream like
this:

<xml xmlns:s='uuid:B DC6E3F0-6DA3-11d1-A2A3-00AA00C14882'
xmlns:dt='uuid: C2F41010-65B3-11d1-A29F-00AA00C14882'
xmlns:rs='urn:s chemas-microsoft-com:rowset'
xmlns:z='#Rowse tSchema'>
<s:Schema id='RowsetSchem a'>
<s:ElementTyp e name='row' content='eltOnl y'>
<s:AttributeTyp e name='FIELD' rs:number='1'
rs:nullable='tr ue'>
<s:datatype dt:type='string ' rs:dbtype='str'
dt:maxLength='5 12'/>
</s:AttributeType >
...
<s:AttributeTyp e name='FIELDn' rs:number='n'
rs:nullable='tr ue' rs:writeunknown ='true'>
<s:datatype dt:type='string ' rs:dbtype='str'
dt:maxLength='1 80'/>
</s:AttributeType >
<s:extends type='rs:rowbas e'/>
</s:ElementType>
</s:Schema>
<rs:data>
<z:row FIELD1='C' ... FIELDn='(A)'/>
<z:row FIELD1='C' ... FIELDn='(B)'/>
...
</rs:data>
</xml>
Now in my Java application I use Axis to obtain the WS Stream. How can
I deserialize this XML in Java classes?

I have seen JAXB, but it wants two file: an XSD Schema and a XML file....

If that's what JAXB wants, then why not give it to JAXB?

Why would you expect Java or anything else to understand this XML format?
Does JAXB know about the 'urn:schemas-microsoft-com:rowset' namespace? If
not, then how will it be able to interpret an rs:data element?

You should think this through, starting with the WSDL file and its
associated schemas, and then, maybe finally deciding how to serialize your
ADO.NET Recordset. That's the final thing you should be doing, not the
first.
John

[John Saunders]

"roboB" <ro***@discussi ons.microsoft.c omwrote in message
news:AE******** *************** ***********@mic rosoft.com...

Ok, Jhon, pehaps I was not so very clear.

Some question more spicifically:

1) Why Does Microsoft persist an ADO.NET recordset in this mode if this is
not so very useful to deserialize in Java environment? WS are made to do
interoperabilit y more accessible...

Why would Java be an overwhelming consideration for Microsoft?

2) How Do you think it is more convenient to serialize and deserialize
ADO.NET recordset in Java?

Why do you want Java or any other platform to have to understand what a
DataSet is? Pretend that DataSets don't exist and that you still have to
send the same data. Then separate the data to be sent from the platform
sending it.

John