How can we help you today?

Start a new topic
Discussions DbVisualizer Forums Support

How to get Oracle XMLType to display properly

[This topic is migrated from our old forums. The original author name has been removed]
[Attachment has been removed.]

I'm having a situation similar to the user in this post (http://www.dbvis.com/forum/thread.jspa?threadID=3339&tstart=0). If I use getClobVal on the XMLType column, I get the correct data from my XMLType column. Otherwise, using a straight SELECT or viewing table data from within DbVis, I get part of the XML string, but it has high ASCII characters embedded throughout. See attached picture. Any suggestions?
19 CommentsSorted by Newest First
[This reply is migrated from our old forums. The original author name has been removed]

Re: How to get Oracle XMLType to display properly
I am currently running with the XDK jar files. I am not having the "opaque" problem, just one that may be related to it. I mentioned the later drivers causing or re-introducing the "opaque" problem, but I'm running on the 11.1.0.7.0 drivers. Please see the attached image for my exact problem. It looks like it's just not handling the tags properly. The basic query looks fine, but it's scrambling the xml version information and removing my opening and closing tags. Again, getClobVal works fine, but viewing table data or a straight select causes it to not show correctly. Thanks, Sammy
[This reply is migrated from our old forums.]

Re: How to get Oracle XMLType to display properly
Sammy, Our recommendation for proper processing of XML data in DbVisualizer has been to load the XDK classes in the DbVisualizer Driver Manager. Read more here: http://www.dbvis.com/products/dbvis/doc/supports.jsp?db=Oracle#Oracle Just recently we got information that XML support should be part of the latest JDBC driver versions from Oracle. We haven't yet verified this ourselves but your last response indicate that it may still not be the case. I suggest you try loading the XDK jars as explained in the web page above and see if it fixes the opaque problem. Best Regards Roger
[This reply is migrated from our old forums. The original author name has been removed]

Re: How to get Oracle XMLType to display properly
*Database:* Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production *Driver:* 11.1.0.7.0-Production Using the 11.2.0.2.0 driver produced worse results, only showing the vague "opaque" return for the column. See reference in this post http://www.dbvis.com/forum/thread.jspa?messageID=9752☘. Edited by: Sammy on Mar 18, 2011 9:55 AM
[This reply is migrated from our old forums.]

Re: How to get Oracle XMLType to display properly
Sammy, What version of Oracle and the JDBC driver are you using? Seems as if there is an charset problem resulting in the text appearing scrambled. Regards Roger
Comments to this discussion are now closed!
More topics in Support
See all 1317 topics