IntelliJ IDEA 11: New and Noteworthy in Database Realm

There are many little things in database and SQL area that got attention in yesterday’s IntelliJ IDEA 11 release but now I just want to highlight the major ones.

Data Sources view got a new look and now includes stored procedures both from DDL scripts and real databases. The existing SQL dialects support has been redesigned with two new dialects introduced: H2 and MS Transact-SQL. So the list of supported SQL languages now looks like this:

Data Sources Toolwindow
  • MySQL 5.6
  • PostgreSQL 9.0.5
  • Oracle 11.2
  • SQLite 3.7
  • SQL Server 10.50
  • Derby 10.8
  • HSQLDB 2.2
  • H2 1.3
  • SQL-92

   Featuring:

  • Exact syntax as in docs
  • Context-aware completion
  • PL-extensions support

Database view:

  • Includes stored procedures. Search for usages, navigate to, drag and drop to editor, etc.
  • Working with large databases is now less painful. Tables and procedures are available the moment their names are loaded. Columns, procedure parameters and other information are loaded in background afterwards.
  • If something is changed there’s no need to wait for the whole synchronization. Refresh only selected schemas, tables or procedures.

Database Console:

  • Console now remembers its state so you won’t lose statements you have never run.
  • If you do not want to switch editors back and forth you can run statements directly from an SQL file or any other place where SQL injection takes place: invoke “Run Query in Console” intention for the first time then use console “Execute” action shortcut as if you are in console.
  • Transact-SQL batch execution mode (the toggle is hidden in the console properties dialog)
  • Console editor now can be undocked and split as any other editor.

Enjoy.

This entry was posted in New Features and tagged , . Bookmark the permalink.

11 Responses to IntelliJ IDEA 11: New and Noteworthy in Database Realm

  1. B. K. Oxley (binkley) says:

    Do you know anyone who tried Sybase with this?

  2. B. K. Oxley (binkley) says:

    Do you know anyone who tried this with Sybase?

  3. Marc says:

    I just tried loading the table structures for some of my schemas and it’s really, really slow. This wouldn’t be that big of a deal but there’s no way to run this in the background, so effectively I can’t do work for a long period of time (not sure how long yet since I’m still waiting for it to finish). Please speed this up dramatically or make it so this information can be loaded in the background. Thanks!

    – Marc

  4. Gregory Shrago says:

    @Marc please see: http://youtrack.jetbrains.net/issue/IDEA-78240
    You don’t have to load schema in modal context.

  5. Fredrik says:

    Great update, thanks! Any plans to support DB2 dialect also? Forced to use it…

  6. Gregory Shrago says:

    DB2 and Sybase support is planned for 11.1 release.

  7. Olve Hansen says:

    I got some support for Sybase in 10.x, I at least got the tables up.. Now I only get a
    java.sql.SQLException: JZ0SA: Prepared Statement: Input parameter not set, index: 0.
    at com.sybase.jdbc3.jdbc.ErrorMessage.raiseError(Unknown Source)
    at com.sybase.jdbc3.tds.TdsParam.prepareForSend(Unknown Source)
    at com.sybase.jdbc3.jdbc.ParamManager.checkParams(Unknown Source)
    at com.sybase.jdbc3.tds.Tds.rpc(Unknown Source)
    at com.sybase.jdbc3.jdbc.SybCallableStatement.sendRpc(Unknown Source)
    at com.sybase.jdbc3.jdbc.SybCallableStatement.executeQuery(Unknown Source)
    at com.sybase.jdbc3.jdbc.SybDatabaseMetaData.if(Unknown Source)
    at com.sybase.jdbc3.jdbc.SybDatabaseMetaData.getSchemas(Unknown Source)

    using jconnect 6.0.5 (works with SquirrelSQL)

    Of course it might be our restrictive database access setup, but then again, it worket to some extent in 10.x

    Any timeline for 11.1?

  8. Fredrik says:

    @Gregory
    Thanks, much appreciated! The basic DB2 support that’s already there will do just fine until then =).

  9. Victor says:

    I can’t find the Data Sources view. Is it for Ultimate edition users only?

  10. WebComer says:

    i’ve tried to use the thingie and have a problem.
    data sources view doesn’t show existing table in my mysql database, while Netbeans see it. i’ve created a new schemes and tables in several databases with and without IDEA’s console. When i create connection in intellij idea data sources, it sees my schemes, i do select it in “schemas and tables” but then i don’t see it in the list. every schema appears, but those i’ve created. When i try to connect to it with netbeans or mysql workbench, it’s just ok. same story with several databases, everything with root access, too. any table, but mine’s. what could be wrong?

  11. WebComer says:

    i’ve successfully created schema, db and table with the tool from idea, but they don’t want to appear in the table list in data sources. Anybody, please – do you have an idea why?

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">