How to use SqlLanguage in Plugin to reformat SQL

创建于 2016年11月04日 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 条评论

Gregory Shrago

创建于 2016年11月04日 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

创建于 2016年11月09日 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

创建于 2017年02月12日 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

创建于 2017年02月24日 15:53

Thanks Quhua, this is what I was looking for.

请先登录再写评论。