SqlXml Plugin - plugin detail

SqlXml plugin is adding context menu action to the sql editor, which can execute SQLXML query and show the SQLXML datatype as XML document. Also you can use the code completion extension, which is adding SQLXML functions with the documentation.

NetBeans Plugin - SqlXml Plugin
Plugin owner: danielkec
Website: https://github.com/danielkec/SqlXmlPlugin
Added: 2013-11-25
License: The MIT License (MIT)
Category: Databases
Downloaded: 1,072 times
Rating:
 4.48, by 2 users

Plugin Log Show log

Versions available

Download plugin   Download size: 0.07 MB   Last Update: 2013-11-29

This plugin is also available on the NetBeans Plugin Portal Update Center. Use 'Tools > Plugins' action from the NetBeans IDE main menu for convenient installation of this plugin


What's new in this version

Support for datatype from XMLSERIALIZE(if your jdbc driver doesn't support SQLXML datatype) - CLOB or VARCHAR. Fix of missing bundle bug.

Verifications for NetBeans versions

7.4 verification PASSED See verification details


Introduction

SqlXml plugin is adding context menu action to 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.
For more information about using the plugin go for wikipage on GitHub: WIKI
For more information about SQLXML you can read my article on javalobby: SQLX - From DB Straight to XML and Back



SQLXML support

[ You have to be logged in to be able to comment. ]

User Comments

  

RE

Thx for the update!
Posted by ent38 on Nov 30, 2013
  

RE: ent38

Fixed in 1.2
Posted by danielkec on Nov 29, 2013
  

RE: ent38

Thank you i'm going to fix it in the next release, you can track the state of the fix here: https://github.com/danielkec/SqlXmlPlugin/issues/1
Posted by danielkec on Nov 29, 2013
  

Bis

Verified with NB 7.4 patch1.
Posted by ent38 on Nov 27, 2013
  

Error with localization

Hi,
I've just tested the plugin: there is a little exception thrown every startup:

Annotation: Offending classloader: ModuleCL@1516a74[cz.syntea.nb.sqlxml.SqlXmlPlugin]
Annotation: #149833: failed to find cz.syntea.nb.sqlxml.plugin.Bundle in locale en_US in ModuleCL@1516a74[cz.syntea.nb.sqlxml.SqlXmlPlugin] for C:\Java\__prefs__\7.4.0_jdk7_userdir\modules\cz-syntea-nb-sqlxml-SqlXmlPlugin.jar; resource lookup of cz/syntea/nb/sqlxml/plugin/Bundle.properties -> null
Annotation: Offending classloader: ModuleCL@1516a74[cz.syntea.nb.sqlxml.SqlXmlPlugin]
Annotation: #149833: failed to find cz.syntea.nb.sqlxml.plugin.Bundle in locale en_US in ModuleCL@1516a74[cz.syntea.nb.sqlxml.SqlXmlPlugin] for C:\Java\__prefs__\7.4.0_jdk7_userdir\modules\cz-syntea-nb-sqlxml-SqlXmlPlugin.jar; resource lookup of cz/syntea/nb/sqlxml/plugin/Bundle.properties -> null
Offending classloader: ModuleCL@1516a74[cz.syntea.nb.sqlxml.SqlXmlPlugin]
#149833: failed to find cz.syntea.nb.sqlxml.plugin.Bundle in locale en_US in ModuleCL@1516a74[cz.syntea.nb.sqlxml.SqlXmlPlugin] for C:\Java\__prefs__\7.4.0_jdk7_userdir\modules\cz-syntea-nb-sqlxml-SqlXmlPlugin.jar; resource lookup of cz/syntea/nb/sqlxml/plugin/Bundle.properties -> null
Offending classloader: ModuleCL@1516a74[cz.syntea.nb.sqlxml.SqlXmlPlugin]
#149833: failed to find cz.syntea.nb.sqlxml.plugin.Bundle in locale en_US in ModuleCL@1516a74[cz.syntea.nb.sqlxml.SqlXmlPlugin] for C:\Java\__prefs__\7.4.0_jdk7_userdir\modules\cz-syntea-nb-sqlxml-SqlXmlPlugin.jar; resource lookup of cz/syntea/nb/sqlxml/plugin/Bundle.properties -> null
Caused: java.util.MissingResourceException: No such bundle cz.syntea.nb.sqlxml.plugin.Bundle
at org.openide.util.NbBundle.getBundle(NbBundle.java:451)
[catch] at org.netbeans.StandardModule.getLocalizedAttribute(StandardModule.java:169)
at org.netbeans.modules.autoupdate.services.ModuleUpdateElementImpl.getDescription(ModuleUpdateElementImpl.java:133)
at org.netbeans.api.autoupdate.UpdateElement.getDescription(UpdateElement.java:115)
at org.netbeans.modules.autoupdate.ui.Unit.getDescription(Unit.java:180)
at org.netbeans.modules.autoupdate.ui.UnitDetails.buildUnitText(UnitDetails.java:166)
at org.netbeans.modules.autoupdate.ui.UnitDetails.getUnitText(UnitDetails.java:190)
at org.netbeans.modules.autoupdate.ui.UnitDetails.setUnit(UnitDetails.java:96)
at org.netbeans.modules.autoupdate.ui.UnitTab.showDetailsAtRow(UnitTab.java:579)
at org.netbeans.modules.autoupdate.ui.UnitTab.access$1700(UnitTab.java:119)
at org.netbeans.modules.autoupdate.ui.UnitTab$11.valueChanged(UnitTab.java:620)
at javax.swing.DefaultListSelectionModel.fireValueChanged(DefaultListSelectionModel.java:184)
at javax.swing.DefaultListSelectionModel.fireValueChanged(DefaultListSelectionModel.java:154)
at javax.swing.DefaultListSelectionModel.setValueIsAdjusting(DefaultListSelectionModel.java:685)
at javax.swing.plaf.basic.BasicTableUI$Handler.setValueIsAdjusting(BasicTableUI.java:953)
at javax.swing.plaf.basic.BasicTableUI$Handler.mouseReleased(BasicTableUI.java:1166)
at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:290)
at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:289)
at java.awt.Component.processMouseEvent(Component.java:6505)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3320)
at java.awt.Component.processEvent(Component.java:6270)
at java.awt.Container.processEvent(Container.java:2229)
at java.awt.Component.dispatchEventImpl(Component.java:4861)
at java.awt.Container.dispatchEventImpl(Container.java:2287)
at java.awt.Component.dispatchEvent(Component.java:4687)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4832)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4492)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4422)
at java.awt.Container.dispatchEventImpl(Container.java:2273)
at java.awt.Window.dispatchEventImpl(Window.java:2719)
at java.awt.Component.dispatchEvent(Component.java:4687)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:735)
at java.awt.EventQueue.access$200(EventQueue.java:103)
at java.awt.EventQueue$3.run(EventQueue.java:694)
at java.awt.EventQueue$3.run(EventQueue.java:692)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:87)
at java.awt.EventQueue$4.run(EventQueue.java:708)
at java.awt.EventQueue$4.run(EventQueue.java:706)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:705)
at org.netbeans.core.TimableEventQueue.dispatchEvent(TimableEventQueue.java:159)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:242)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:161)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:150)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:146)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:138)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:91)

Tested on:
Product Version: NetBeans IDE 7.4 (Build 201310111528)
Java: 1.7.0_45; Java HotSpot(TM) Client VM 24.45-b08
Runtime: Java(TM) SE Runtime Environment 1.7.0_45-b18
System: Windows 7 version 6.1 running on x86; Cp1252; en_US (nb)


Best regards.
Posted by ent38 on Nov 27, 2013
By use of this website, you agree to the NetBeans Policies and Terms of Use. © 2012, Oracle Corporation and/or its affiliates. Sponsored by Oracle logo