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.
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.