Start a new topic

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?

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

Re: How to get Oracle XMLType to display properly
Thanks Roger for your feedback ;-) I confirm that DBVisualizer 7.1.5 and 7.2.0 b1641 work flawlessly with jdbc & xdk 11.1.
[This reply is migrated from our old forums.]

Re: How to get Oracle XMLType to display properly
Doug, After many hours of debugging we are unfortunately not able to fix so that XML is properly displayed in DbVisualizer when using the 11.2 JDBC driver from Oracle. It works fine with all versions up to and including 11.1. We will continue to verify whether there is a workaround to fix this but meanwhile the general recommendation is to NOT use the 11.2 drivers. Another workaround which actually works even with the 11.2 driver is if you put the *ojdbc16.jar* file and the Oracle XDK (required for the Oracle XML support) files, *xdk.jar* and *xmlparserv2.jar* in the *DBVIS-HOME/lib* directory. 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
Hi Roger, Just wondering if native XMLType support should be working in EA 720.1640? /Doug
[This reply is migrated from our old forums.]

Re: How to get Oracle XMLType to display properly
Sammy, Sorry I was too quick. It works fine in our dev environment while it doesn't seem to work when running the final installers available on our web site. We will look into this. Regards Roger
[This reply is migrated from our old forums.]

Re: How to get Oracle XMLType to display properly
Sammy, Are you using the most recent version of the XDK? I verified the 11.2.0.2 driver and the XDK this morning and it worked fine with the EA version. 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
Roger, I downloaded the early access version, and things work fine for me using the 11.1.0.7.0 driver only. If I use the 11.2.0.2.0 driver, I just get OPAQUE. So, I'm working now, but it would be nice to be able to use the most current driver. Thanks, Sammy
[This reply is migrated from our old forums.]

Re: How to get Oracle XMLType to display properly
Bertrand, Oracle seem to have adopted the new XML support that is included in Java 1.6 starting with version 11.2 of their JDBC driver. In order for DbVisualizer to handle this change we need to adjust our code base accordingly. This fix will be in the next maintenance version and in the early access version (for the next feature version) which will be released later today at http://www.dbvis.com/products/dbvis/eap/ A workaround is to use a driver version older than 11.2 and also make sure the xdb.jar and xmlparserv2.jar files are loaded in the DbVisualizer Driver Manager. 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
Hi Roger, I've just tested with the following configuration... Oracle RDBMS: 11.2.0.1.0 JDBC Driver: 11.2.0.2.0 XDK: 11.2.0.2.0 Unfortunately I have the same issue... XMLTYPE are rendered as OPAQUE within DBVisualizer and rendered as XML String within Oracle SQL Developer. Happy debugging ;-) Bertrand
[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 will try also to test with the following configuration next week... Oracle RDBMS: 11.2.0.2.0 JDBC Driver: 11.2.0.2.0 XDK: 11.2.0.2.0 instead of Oracle RDBMS: 9.2.0.7.0 JDBC Driver: 11.2.0.2.0 XDK: 11.2.0.2.0
[This reply is migrated from our old forums. The original author name has been removed]
[Attachment has been removed.]

Re: How to get Oracle XMLType to display properly
Hi Roger, What versions of the Oracle RDBMS, JDBC driver and the XDK kit are you using? Oracle RDBMS: 9.2.0.7.0 JDBC Driver: 11.2.0.2.0 XDK: 11.2.0.2.0 Are you using the XDK and JDBC drivers that are bundled with the Oracle RDBMS? Yes (from Oracle RDBMS 11.2.0.2.0)... and setup within DBVisualizer 7.1.5... but XMLType's are displayed as oracle.sql.OPAQUE instead of XML String (see attachment dbvizualizer.jpg). As far as I know, same versions are embedded within Oracle SQL Developer 3.0.04.b34... and XMLType's are displayed as XML String's as expected (see attachment oracle_sql_developer.jpg). Regards, Bertrand
[This reply is migrated from our old forums.]

Re: How to get Oracle XMLType to display properly
Bertrand, What versions of the Oracle RDBMS, JDBC driver and the XDK kit are you using? Are you using the XDK and JDBC drivers that are bundled with the Oracle RDBMS? Regards Roger
[This reply is migrated from our old forums.]

Re: How to get Oracle XMLType to display properly
Sammy, Really sorry for the delayed response... What XDK version are you using? If it is not the one bundled with the Oracle DB, then please give it a try. Regards Roger
[This reply is migrated from our old forums.]

Re: How to get Oracle XMLType to display properly
Hi Sammy, I have it on my desk and will dig into during the coming week. 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
Hi Roger, Any progress or thoughts on this issue?
[This reply is migrated from our old forums. The original author name has been removed]

Re: How to get Oracle XMLType to display properly
Hi Roger, I've tried also with the latest version of jdbc driver and xdk but I still can't visualize XMLType from DBVisualizer 7.1.5. I still don't understand why because I use the same jars as Oracle SQL Developer 3.0... and Oracle SQL Developer is able to visualize XMLType without any issue. Thanks in advance for your assistance. Best regards, Bertrand