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.

Plugin owner:

danielkec

Website:

https://github.com/danielkec/SqlXmlPlugin

Added:

2013-11-25

License:

The MIT License (MIT)

Category:

Databases

Downloaded:

1,090 times

Rating:

4.48, by 2 users

Plugin Log

Show log

2013-11-30 15:23:55	carlosqt	Vote cast by carlosqt for SqlXml Plugin, UC 7.4, vote value: 1; verification overall status recalculated: 1 (0 NoGos, 3 Gos of 7 requests, therefore overal GO)
2013-11-30 08:41:26	ent38	Vote cast by ent38 for SqlXml Plugin, UC 7.4, vote value: 1; verification overall status recalculated: 1 (0 NoGos, 2 Gos of 7 requests, therefore overal GO)
2013-11-30 04:30:24	geertjan	Vote cast by geertjan for SqlXml Plugin, UC 7.4, vote value: 1; verification overall status recalculated: 0 (0 NoGos, 1 Gos of 7 requests, therefore overal Undecided)
2013-11-29 08:29:24	danielkec	Plugin edited, id:51894, pubid:51894
2013-11-29 08:29:24	danielkec	Plugin edit initiated
2013-11-29 08:28:16	danielkec	Plugin edited, id:51894, pubid:51894
2013-11-29 08:28:16	danielkec	Plugin edit initiated
2013-11-29 08:04:53	danielkec	Plugin edited, id:51894, pubid:51894
2013-11-29 08:04:53	danielkec	Plugin edit initiated
2013-11-29 08:03:46	danielkec	Plugin edited, id:51894, pubid:51894
2013-11-29 08:03:46	danielkec	Plugin edit initiated
2013-11-29 07:32:13	danielkec	Verification request registered for verifier mmirilovic, with id: 51990
2013-11-29 07:32:13	danielkec	Verification request registered for verifier mcreps, with id: 51989
2013-11-29 07:32:13	danielkec	Verification request registered for verifier jpirek, with id: 51988
2013-11-29 07:32:13	danielkec	Verification request registered for verifier jkovalsky, with id: 51987
2013-11-29 07:32:13	danielkec	Verification request registered for verifier geertjan, with id: 51986
2013-11-29 07:32:13	danielkec	Verification request registered for verifier ent38, with id: 51985
2013-11-29 07:32:12	danielkec	Verification request registered for verifier carlosqt, with id: 51984
2013-11-29 07:32:12	danielkec	Verification registered for version 7.4, with id: 51983
2013-11-29 07:32:04	danielkec	Old version of binary has verification and version is still verifable - removing it now. User will have to apply again.
2013-11-29 07:32:04	danielkec	Binary successfully saved 1385728323_SqlXmlPlugin-1.2-SNAPSHOT.nbm, binary_id: 2790, version: 7.4
2013-11-29 07:32:03	danielkec	Binary uploaded successfully - /space/pluginportal-v2/public/data/nbms/SqlXmlPlugin-1.2-SNAPSHOT.nbm
2013-11-29 07:32:03	danielkec	Uploading new binary for version 7.4
2013-11-27 11:42:06	danielkec	Plugin edited, id:51894, pubid:51894
2013-11-27 11:42:06	danielkec	New thumbnail image added
2013-11-27 11:42:06	danielkec	Plugin edit initiated
2013-11-27 11:36:59	danielkec	Plugin edited, id:51894, pubid:51894
2013-11-27 11:36:59	danielkec	New thumbnail image added
2013-11-27 11:36:59	danielkec	Plugin edit initiated
2013-11-27 10:49:04	danielkec	Verification request registered for verifier mmirilovic, with id: 51956
2013-11-27 10:49:04	danielkec	Verification request registered for verifier mcreps, with id: 51955
2013-11-27 10:49:04	danielkec	Verification request registered for verifier jpirek, with id: 51954
2013-11-27 10:49:04	danielkec	Verification request registered for verifier jkovalsky, with id: 51953
2013-11-27 10:49:04	danielkec	Verification request registered for verifier geertjan, with id: 51952
2013-11-27 10:49:04	danielkec	Verification request registered for verifier ent38, with id: 51951
2013-11-27 10:49:03	danielkec	Verification request registered for verifier carlosqt, with id: 51950
2013-11-27 10:49:03	danielkec	Verification registered for version 7.4, with id: 51949
2013-11-27 10:48:47	danielkec	Old version of binary has verification and version is still verifable - removing it now. User will have to apply again.
2013-11-27 10:48:47	danielkec	Binary successfully saved 1385567327_SqlXmlPlugin-1.1-SNAPSHOT.nbm, binary_id: 2790, version: 7.4
2013-11-27 10:48:47	danielkec	Binary uploaded successfully - /space/pluginportal-v2/public/data/nbms/SqlXmlPlugin-1.1-SNAPSHOT.nbm
2013-11-27 10:48:47	danielkec	Uploading new binary for version 7.4
2013-11-27 10:47:31	danielkec	Plugin edited, id:51894, pubid:51894
2013-11-27 10:47:31	danielkec	Plugin edit initiated
2013-11-27 10:46:06	danielkec	Plugin edited, id:51894, pubid:51894
2013-11-27 10:46:06	danielkec	New full image added
2013-11-27 10:46:06	danielkec	New thumbnail image added
2013-11-27 10:46:06	danielkec	Plugin edit initiated
2013-11-27 10:38:19	danielkec	Plugin edited, id:51894, pubid:51894
2013-11-27 10:38:19	danielkec	New thumbnail image added
2013-11-27 10:38:19	danielkec	Plugin edit initiated
2013-11-27 10:35:49	danielkec	Verification request registered for verifier mmirilovic, with id: 51948
2013-11-27 10:35:49	danielkec	Verification request registered for verifier mcreps, with id: 51947
2013-11-27 10:35:49	danielkec	Verification request registered for verifier jpirek, with id: 51946
2013-11-27 10:35:49	danielkec	Verification request registered for verifier jkovalsky, with id: 51945
2013-11-27 10:35:49	danielkec	Verification request registered for verifier geertjan, with id: 51944
2013-11-27 10:35:49	danielkec	Verification request registered for verifier ent38, with id: 51943
2013-11-27 10:35:48	danielkec	Verification request registered for verifier carlosqt, with id: 51942
2013-11-27 10:35:48	danielkec	Verification registered for version 7.4, with id: 51941
2013-11-27 10:21:15	danielkec	Old version of binary has verification and version is still verifable - removing it now. User will have to apply again.
2013-11-27 10:21:15	danielkec	Binary successfully saved 1385565675_SqlXmlPlugin-1.1-SNAPSHOT.nbm, binary_id: 2790, version: 7.4
2013-11-27 10:21:15	danielkec	Binary uploaded successfully - /space/pluginportal-v2/public/data/nbms/SqlXmlPlugin-1.1-SNAPSHOT.nbm
2013-11-27 10:21:15	danielkec	Uploading new binary for version 7.4
2013-11-26 05:33:39	danielkec	Verification request registered for verifier mmirilovic, with id: 51922
2013-11-26 05:33:39	danielkec	Verification request registered for verifier mcreps, with id: 51921
2013-11-26 05:33:39	danielkec	Verification request registered for verifier jpirek, with id: 51920
2013-11-26 05:33:39	danielkec	Verification request registered for verifier jkovalsky, with id: 51919
2013-11-26 05:33:39	danielkec	Verification request registered for verifier geertjan, with id: 51918
2013-11-26 05:33:39	danielkec	Verification request registered for verifier ent38, with id: 51917
2013-11-26 05:33:39	danielkec	Verification request registered for verifier carlosqt, with id: 51916
2013-11-26 05:33:39	danielkec	Verification registered for version 7.4, with id: 51915
2013-11-26 05:33:24	danielkec	Binary successfully saved 1385462004_SqlXmlPlugin-1.0-SNAPSHOT.nbm, binary_id: 2790, version: 7.4
2013-11-26 05:33:24	danielkec	Binary uploaded successfully - /space/pluginportal-v2/public/data/nbms/SqlXmlPlugin-1.0-SNAPSHOT.nbm
2013-11-26 05:33:24	danielkec	Uploading new binary for version 7.4
2013-11-26 03:20:57	jkovalsky	Plugin published
2013-11-25 14:46:15	danielkec	Plugin edited, id:51894, pubid:51894
2013-11-25 14:46:15	danielkec	Plugin edit initiated
2013-11-25 14:45:29	danielkec	Plugin edited, id:51894, pubid:51894
2013-11-25 14:45:29	danielkec	Plugin edit initiated
2013-11-25 14:42:42	danielkec	Plugin saved with .nbm/zip file; id: 51894

Versions available

NetBeans 7.4

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

[ 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