JAXB Query about unmarshalling from a clob inputstream

[Dilshad Marikar]

Hi

I have a query about unmarshalling XML data derived from a clob column in a database. If I use the getAsciiStream() method of java.sql.Clob and pass it to the Unmarshaller.unmarshall(InputStream) method, is there a risk that unicode characters in the XML won't get interpreted correctly? I cannot see how to use the Clob.getCharacterStream method with JAXB.

Any suggestions would be appreciated

Thanks
Dilshad

[Rashmi Razdan]

Hi dilshad,

Sorry i dont have reply to your query ; but have a query for you.
Would you please give me some info or point to some links which would provide the details of
1) how to retreive the data from Oracle as XML
2) and how to store/archive these xml data files
3) will the mechanissm for 1) be same in oracle8i /9i/10g

Im just starting with this analysis of XML as data resource or sub lyaer, would appreaciate if anybody else could also contribute to their experiences wrt this.

Thanks in advance,
Rashmi

[Dilshad Marikar]

The xml technology centre is a good place for information

I've pasted a code snippet below to illustrate my query:

 
ResultSet clobDetails = stmt.executeQuery("SELECT templatexml from clobstorewhere ref = 1");
    
try
    {
    clobDetails.next(); 
    java.sql.Clob clob = (java.sql.Clob)clobDetails.getObject(1);
    
    InputStream ist = clob.getAsciiStream(); 
    template = (Template) unmarshaller.unmarshal(ist);  
.
.
 

could using clob.getAsciiStream() cause problems if unicode chars are involved?

[Dilshad Marikar]

reading the jaxp api documentation a bit more closely shows that there is an unmarshall method that can be used to accept a character reader Reader via a decorator - the marshal(Source source) method