for IntelliJ IDEA

Compatible with  IntelliJ IDEA
41 119
A productivity tool to help you work with databases inside IDEA. This tool is targeted on the Java developers, who are also stored procedure developers. Key features include: 1) Adding two new file types IDEA can recognize: a. SQL – The SQL script file b. DIA – The database schema diagram file 2) Basic syntax highlighting – Supporting keywords, single line comments, /** **/ style multi-line comments, strings and number. The keyword is updated dynamically based on the database you are working with. 3) Code completion: a. Supporting basic completion: Hit Ctrl + Space lists all the objects in the current database and narrows down as the user typing b. Correlation name completion: When the user hits ‘.’, it will resolve the correlation name and pops up the suggestions, such as catalogs, schemas, table columns and stored procedures. It can also resolve SQL correlation name, temp tables, declared variables and parameters (works for SQL iAnywhere or ASE T-SQL format) 4) Run SQL script inside IDEA editor – At any time, the user can highlight a block SQL script or run the whole SQL script in IDEA editor and the result will show in the DBHelper output panel. 5) View Database schema as diagram – At any time, the user can select multiple tables or a type of tables and view the schema in a graphical diagram. The diagram can be saved as DIA format or copied as image. 6) Update table data – The user can view the data of any table and insert/delete/update the table data. 7) Support multiple databases via standard JDBC interface, tested databases are: a. Sybase SQL Anywhere (tested on version 9.x) b. Sybase ASE (tested on version 12.x) c. MySQL (tested on version 5.x) d. SQL Server (tested on version 2000) e. Oracle (tested on 9i) Extra database meta data can be supported by adding plugin jars to DBHelper (Implementing IMetaProvider interface, see ASA user meta extension sample) 8) It is designed to be extended using Velocity templates. (Velocity is an open source apache project for generating text content based on a simple template). Uses can add templates to generate customized content based on the database meta data, such as generating XML data based on resultset, or JDBC call to retrieve the resultset from the database. There are some templates come with this release as examples. 9) SQLConsole is newly added to support users that primarily don’t write lots of stored procedures and only want to run some simple queries inside IDEA. Users can open SQLConsole in DBOutput tool window and run any SQL queries. Of course syntax highlighting and SQL code completion are also available in the SQLConsole. 10) Query Manager: Users can create new or update queries in DBOutput tool window Saved Queries tab.

Download plugin

Recent change notes

1) Add Ctrl+Shift+Space for smart SQL completion 2) Add feature to copy database connection profile 3) Add feature to run any Velocity template 4) DBHelper can support editting sql files with different file extension, not just .sql. 5) Add feature to hide a database profile 6) Support the new IDEA 7.x

General usage instructions

The plugin zip file includes the documentation.
OpenSUSE 13.1 64-bit + Java 1.8 + IDEA 13.2 = Tilt 15:50:29 NoSuchMethodError: dbhelp.plugin.idea.ProjectMain@36f93c60: com.intellij.openapi.fileEditor.FileDocumentManager.addFileDocumentManagerListener(Lcom/intellij/openapi/fileEditor/FileDocumentManagerListener;)V Rating: Would love it if it did work
Encountering an issue when IntelliJ restarts after plugin is installed. NoSuchMethodError: com.intellij.openapi.fileEditor.FileDocumentManager.addFileDocumentManagerListener Please address!
com.intellij.openapi.fileEditor.FileDocumentManager.addFileDocumentManagerListener(Lcom/intellij/openapi/fileEditor/FileDocumentManagerListener;)V: com.intellij.openapi.fileEditor.FileDocumentManager.addFileDocumentManagerListener(Lcom/intellij/openapi/fileEditor/FileDocumentManagerListener;)V java.lang.NoSuchMethodError: com.intellij.openapi.fileEditor.FileDocumentManager.addFileDocumentManagerListener(Lcom/intellij/openapi/fileEditor/FileDocumentManagerListener;)V at dbhelp.plugin.idea.ProjectMain.projectOpened(ProjectMain.java:79) at com.intellij.openapi.project.impl.ProjectImpl.c(ProjectImpl.java:400) at com.intellij.openapi.project.impl.ProjectImpl.access$200(ProjectImpl.java:74) at com.intellij.openapi.project.impl.ProjectImpl$MyProjectManagerListener.projectOpened(ProjectImpl.java:435) at com.intellij.openapi.project.impl.ProjectManagerImpl$2.projectOpened(ProjectManagerImpl.java:153) at com.intellij.openapi.project.impl.ProjectManagerImpl.d(ProjectManagerImpl.java:1077) at com.intellij.openapi.project.impl.ProjectManagerImpl.openProject(ProjectManagerImpl.java:418) at com.intellij.openapi.project.impl.ProjectManagerImpl.loadAndOpenProject(ProjectManagerImpl.java:484) at com.intellij.ide.impl.ProjectUtil.openProject(ProjectUtil.java:175) at com.intellij.ide.RecentProjectsManager.doOpenProject(RecentProjectsManager.java:44) at com.intellij.ide.RecentProjectsManagerBase$MyAppLifecycleListener.appStarting(RecentProjectsManagerBase.java:322) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.intellij.util.messages.impl.MessageBusConnectionImpl.deliverMessage(MessageBusConnectionImpl.java:110) at com.intellij.util.messages.impl.MessageBusImpl.doPumpMessages(MessageBusImpl.java:220) at com.intellij.util.messages.impl.MessageBusImpl.pumpMessages(MessageBusImpl.java:212) at com.intellij.util.messages.impl.MessageBusImpl.sendMessage(MessageBusImpl.java:202) at com.intellij.util.messages.impl.MessageBusImpl.access$000(MessageBusImpl.java:42) at com.intellij.util.messages.impl.MessageBusImpl$2.invoke(MessageBusImpl.java:128) at $Proxy44.appStarting(Unknown Source) at com.intellij.idea.IdeaApplication.d(IdeaApplication.java:330) at com.intellij.idea.IdeaApplication.access$400(IdeaApplication.java:56) at com.intellij.idea.IdeaApplication$IdeStarter$2.run(IdeaApplication.java:298) at com.intellij.openapi.application.impl.LaterInvocator$FlushQueue.run(LaterInvocator.java:333) at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209) at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:646) at java.awt.EventQueue.access$000(EventQueue.java:84) at java.awt.EventQueue$1.run(EventQueue.java:607) at java.awt.EventQueue$1.run(EventQueue.java:605) at java.security.AccessController.doPrivileged(Native Method) at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87) at java.awt.EventQueue.dispatchEvent(EventQueue.java:616) at com.intellij.ide.IdeEventQueue.e(IdeEventQueue.java:699) at com.intellij.ide.IdeEventQueue._dispatchEvent(IdeEventQueue.java:538) at com.intellij.ide.IdeEventQueue.b(IdeEventQueue.java:420) at com.intellij.ide.IdeEventQueue.dispatchEvent(IdeEventQueue.java:378) at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161) at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
The plugin is very useful.

But there is a problem with Mac OSX.

Problem with cursor position in db console on macosx. cursor position is not correct when i type sql request. I thing the proble is related with font - if select monospace fond I thing everything will ok, but I cannot change font for the plugin.
Under what license this source code is available ?
Not working for me - Mac OS X 10.5.8, JDK 1.6. Plugin fails on startup.

Bad version number in .class file [Plugin: DBHelper]: Bad version number in .class file [Plugin: DBHelper]
com.intellij.diagnostic.PluginException: Bad version number in .class file [Plugin: DBHelper]
at com.intellij.openapi.components.impl.ComponentManagerImpl$ComponentsRegistry.a(ComponentManagerImpl.java:46)
Why on earth so few provide support for PostgreSql and yet so many are so quick to implement tools for this cursed ms sql server. Even you guys, java guys? Freaks!
I have updated the plugin to run under IDEA 8. If you use older version, please don't download the latest.
When will this work with v8.1? The default Database view in IDEA is simply inadequate.
Plugin DBHelper failed to initialize and will be disabled: com/intellij/highlighter/custom/impl/CustomFileType
I hope this gets fixed soon.
I was using this plugin with intellij v7 and loved it. I just upgraded to intellij v8 and it doesn't work. I get the following error:
Plugin DBHelper failed to initialize and will be disabled: com/intellij/highlighter/custom/impl/CustomFileType
I hope this gets fixed soon.
Doesn't work for me either with IntelliJ 8, I'm getting the following error:
Plugin DBHelper failed to initialize and will be disabled: com/intellij/ide/highlighter/custom/impl/CustomFileType
Doesn't work for me either. Using IntelliJ 8.0
From all the hype reguarding this plugin you would at least think that it actually works, but not in my case.

I keep getting the following error:

Plugin DBHelper failed to initialize and will be disabled: com/intellij/highlighter/custom/impl/CustomFileType

The highlighting feature dosn't work in IDEA 7.x?
Please  sign in  to leave a comment.