How to use SqlLanguage in Plugin to reformat SQL

Created November 04, 2016 09:26

Hi there,

currently I am trying to add SQL reformating functionality to my plugin. To reformat e.g. JSON I do the following:

PsiFileFactory.getInstance(project).createFileFromText(JsonLanguage.INSTANCE, preProcessValue(text));

which works perfectly fine. Now when I try to reformat SQL I assumed it would work this way:

PsiFileFactory.getInstance(project).createFileFromText(SqlLanguage.INSTANCE, preProcessValue(text));

but I get a ClassNotFoundException. How can I add SQL support to my plugin?

4 comments

Gregory Shrago

Created November 04, 2016 17:03

Please include the exception stacktrace, it is not clear what exactly went wrong.

Also SqlLanguage.INSTANCE usually cannot be used as is, you need to specify the SQL dialect instead.

Woezelmann

Created November 09, 2016 09:43

SqlLanguage.INSTANCE

is giving me:

java.lang.Throwable
 at com.intellij.openapi.diagnostic.Logger.error(Logger.java:127)
 at com.intellij.openapi.actionSystem.DefaultActionGroup.unStub(DefaultActionGroup.java:356)
 at com.intellij.openapi.actionSystem.DefaultActionGroup.getChildren(DefaultActionGroup.java:312)
 at com.intellij.openapi.actionSystem.impl.Utils.a(Utils.java:225)
 at com.intellij.openapi.actionSystem.impl.Utils.a(Utils.java:205)
 at com.intellij.openapi.actionSystem.impl.Utils.expandActionGroup(Utils.java:153)
 at com.intellij.openapi.actionSystem.impl.Utils.expandActionGroup(Utils.java:96)
 at com.intellij.openapi.actionSystem.impl.ActionToolbarImpl.a(ActionToolbarImpl.java:942)
 at com.intellij.openapi.actionSystem.impl.ActionToolbarImpl.access$000(ActionToolbarImpl.java:65)
 at com.intellij.openapi.actionSystem.impl.ActionToolbarImpl$1.updateActionsImpl(ActionToolbarImpl.java:174)
 at com.intellij.openapi.actionSystem.impl.ToolbarUpdater$MyUpdateRunnable.run(ToolbarUpdater.java:186)
 at com.intellij.openapi.wm.impl.FocusManagerImpl.b(FocusManagerImpl.java:634)
 at com.intellij.openapi.wm.impl.FocusManagerImpl.a(FocusManagerImpl.java:615)
 at com.intellij.openapi.wm.impl.FocusManagerImpl.o(FocusManagerImpl.java:585)
 at com.intellij.openapi.wm.impl.FocusManagerImpl.a(FocusManagerImpl.java:481)
 at com.intellij.util.ui.UIUtil.invokeLaterIfNeeded(UIUtil.java:2397)
 at com.intellij.openapi.wm.impl.FocusManagerImpl.doWhenFocusSettlesDown(FocusManagerImpl.java:461)
 at com.intellij.openapi.actionSystem.impl.ToolbarUpdater.a(ToolbarUpdater.java:108)
 at com.intellij.openapi.actionSystem.impl.ToolbarUpdater.access$400(ToolbarUpdater.java:40)
 at com.intellij.openapi.actionSystem.impl.ToolbarUpdater$MyTimerListener.run(ToolbarUpdater.java:158)
 at com.intellij.openapi.actionSystem.impl.WeakTimerListener.run(WeakTimerListener.java:54)
 at com.intellij.openapi.actionSystem.impl.ActionManagerImpl$MyTimer.a(ActionManagerImpl.java:1417)
 at com.intellij.openapi.actionSystem.impl.ActionManagerImpl$MyTimer.a(ActionManagerImpl.java:1407)
 at com.intellij.openapi.actionSystem.impl.ActionManagerImpl$MyTimer.actionPerformed(ActionManagerImpl.java:1391)
 at javax.swing.Timer.fireActionPerformed(Timer.java:313)
 at javax.swing.Timer$DoPostEvent.run(Timer.java:245)
 at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:311)
 at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:756)
 at java.awt.EventQueue.access$500(EventQueue.java:97)
 at java.awt.EventQueue$3.run(EventQueue.java:709)
 at java.awt.EventQueue$3.run(EventQueue.java:703)
 at java.security.AccessController.doPrivileged(Native Method)
 at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:76)
 at java.awt.EventQueue.dispatchEvent(EventQueue.java:726)
 at com.intellij.ide.IdeEventQueue.e(IdeEventQueue.java:795)
 at com.intellij.ide.IdeEventQueue._dispatchEvent(IdeEventQueue.java:631)
 at com.intellij.ide.IdeEventQueue.dispatchEvent(IdeEventQueue.java:387)
 at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)
 at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
 at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)
 at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
 at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)
 at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)
[ 50715] ERROR - ctionSystem.DefaultActionGroup - IntelliJ IDEA 2016.2.5 Build #IU-162.2228.15 
[ 50715] ERROR - ctionSystem.DefaultActionGroup - JDK: 1.8.0_72 
[ 50715] ERROR - ctionSystem.DefaultActionGroup - VM: Java HotSpot(TM) 64-Bit Server VM 
[ 50715] ERROR - ctionSystem.DefaultActionGroup - Vendor: Oracle Corporation 
[ 50715] ERROR - ctionSystem.DefaultActionGroup - OS: Mac OS X 
[ 50715] ERROR - ctionSystem.DefaultActionGroup - Last Action: Debug 
[ 50715] ERROR - ctionSystem.DefaultActionGroup - Can't unstub XML (null)

I also tried:

SqlLanguageDialect.findLanguageByID("GenericSQL")

wich gives me:

[ 337449] ERROR - llij.ide.plugins.PluginManager - com/intellij/sql/dialects/SqlLanguageDialect 
java.lang.NoClassDefFoundError: com/intellij/sql/dialects/SqlLanguageDialect
 at com.woezelmann.showas.ShowAs.actionPerformed(ShowAs.java:38)
 at com.intellij.openapi.actionSystem.ex.ActionUtil$1.run(ActionUtil.java:197)
 at com.intellij.openapi.application.TransactionGuardImpl.a(TransactionGuardImpl.java:88)
 at com.intellij.openapi.application.TransactionGuardImpl.submitTransactionAndWait(TransactionGuardImpl.java:156)
 at com.intellij.openapi.actionSystem.ex.ActionUtil.performActionDumbAware(ActionUtil.java:211)
 at com.intellij.openapi.actionSystem.impl.ActionMenuItem$ActionTransmitter.a(ActionMenuItem.java:304)
 at com.intellij.openapi.wm.impl.FocusManagerImpl.runOnOwnContext(FocusManagerImpl.java:905)
 at com.intellij.openapi.wm.impl.IdeFocusManagerImpl.runOnOwnContext(IdeFocusManagerImpl.java:124)
 at com.intellij.openapi.actionSystem.impl.ActionMenuItem$ActionTransmitter.actionPerformed(ActionMenuItem.java:284)
 at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2022)
 at com.intellij.openapi.actionSystem.impl.ActionMenuItem.a(ActionMenuItem.java:112)
 at com.intellij.openapi.application.TransactionGuardImpl.a(TransactionGuardImpl.java:88)
 at com.intellij.openapi.application.TransactionGuardImpl.access$300(TransactionGuardImpl.java:40)
 at com.intellij.openapi.application.TransactionGuardImpl$2.run(TransactionGuardImpl.java:113)
 at com.intellij.openapi.application.TransactionGuardImpl.submitTransaction(TransactionGuardImpl.java:123)
 at com.intellij.openapi.application.TransactionGuard.submitTransaction(TransactionGuard.java:109)
 at com.intellij.openapi.actionSystem.impl.ActionMenuItem.fireActionPerformed(ActionMenuItem.java:112)
 at com.intellij.ui.plaf.beg.BegMenuItemUI.a(BegMenuItemUI.java:513)
 at com.intellij.ui.plaf.beg.BegMenuItemUI.access$300(BegMenuItemUI.java:45)
 at com.intellij.ui.plaf.beg.BegMenuItemUI$MyMouseInputHandler.mouseReleased(BegMenuItemUI.java:533)
 at java.awt.Component.processMouseEvent(Component.java:6535)
 at javax.swing.JComponent.processMouseEvent(JComponent.java:3324)
 at java.awt.Component.processEvent(Component.java:6300)
 at java.awt.Container.processEvent(Container.java:2236)
 at java.awt.Component.dispatchEventImpl(Component.java:4891)
 at java.awt.Container.dispatchEventImpl(Container.java:2294)
 at java.awt.Component.dispatchEvent(Component.java:4713)
 at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4888)
 at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4525)
 at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4466)
 at java.awt.Container.dispatchEventImpl(Container.java:2280)
 at java.awt.Window.dispatchEventImpl(Window.java:2750)
 at java.awt.Component.dispatchEvent(Component.java:4713)
 at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:758)
 at java.awt.EventQueue.access$500(EventQueue.java:97)
 at java.awt.EventQueue$3.run(EventQueue.java:709)
 at java.awt.EventQueue$3.run(EventQueue.java:703)
 at java.security.AccessController.doPrivileged(Native Method)
 at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:76)
 at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86)
 at java.awt.EventQueue$4.run(EventQueue.java:731)
 at java.awt.EventQueue$4.run(EventQueue.java:729)
 at java.security.AccessController.doPrivileged(Native Method)
 at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:76)
 at java.awt.EventQueue.dispatchEvent(EventQueue.java:728)
 at com.intellij.ide.IdeEventQueue.e(IdeEventQueue.java:795)
 at com.intellij.ide.IdeEventQueue._dispatchEvent(IdeEventQueue.java:627)
 at com.intellij.ide.IdeEventQueue.dispatchEvent(IdeEventQueue.java:387)
 at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)
 at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
 at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)
 at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
 at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)
 at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)
Caused by: java.lang.ClassNotFoundException: com.intellij.sql.dialects.SqlLanguageDialect PluginClassLoader[Show As ..., 0.5.1]
 at com.intellij.ide.plugins.cl.PluginClassLoader.loadClass(PluginClassLoader.java:64)
 at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
 ... 54 more
[ 337456] ERROR - llij.ide.plugins.PluginManager - IntelliJ IDEA 2016.2.5 Build #IU-162.2228.15 
[ 337456] ERROR - llij.ide.plugins.PluginManager - JDK: 1.8.0_72 
[ 337457] ERROR - llij.ide.plugins.PluginManager - VM: Java HotSpot(TM) 64-Bit Server VM 
[ 337457] ERROR - llij.ide.plugins.PluginManager - Vendor: Oracle Corporation 
[ 337457] ERROR - llij.ide.plugins.PluginManager - OS: Mac OS X 
[ 337457] ERROR - llij.ide.plugins.PluginManager - Last Action: Debugger.ShowAsSql

Permanently deleted user

Created February 12, 2017 13:43

Add following code to your plugin.xml file, and make sure the product running your plugin has the database module.

<depends>com.intellij.modules.database</depends>

see http://www.jetbrains.org/intellij/sdk/docs/basics/getting_started/plugin_compatibility.html

Woezelmann

Created February 24, 2017 15:53

Thanks Quhua, this is what I was looking for.

Please sign in to leave a comment.