SQL Zone is brought to you in partnership with:

Daniel have developed support for proprietary technology which is processing huge volumes of XML data. Now is working on Register of traffic accidents(J2EE application build on Websphere) for Ministry of Interior of the Slovak Republic. Daniel has posted 9 posts at DZone. You can read more from them at their website. View Full User Profile

SQLXML Support for NetBeans IDE 7.4

  • submit to reddit

Anyone who is using SQLXML on modern db engine knows that there is really small tool set available for developing such queries in the IDEs. So if you are using really powerful sql editor in the NetBeans IDE, there is plugin  extending it's abilities for comfortable developing SQLXML. Plugin is adding new options to the code completion:

and an action to the context menu of the sql editor, which can execute SQLXML query and show the SQLXML datatype as XML document:

 Result of the query must have SQLXML,CLOB or VARCHAR type in first column of the first row. If your jdbc driver doesn't support SQLXML datatype, you can use XMLSERIALIZE as VARCHAR or CLOB and the plugin will recognize the data type and show XML result.

Download link: http://plugins.netbeans.org/plugin/51894/sqlxml-plugin 

Average: 4.5 (2 votes)
Published at DZone with permission of its author, Daniel Kec.

(Note: Opinions expressed in this article and its replies are the opinions of their respective authors and not those of DZone, Inc.)