[ANN] Database Navigator 1.0.459 released

Hello Dan,

Do you still plan to make an IDEA 8 version of this pluging? I miss it since
I switched to IDEA 8, would be great to have it back. :)

Thx,
Andrei

DC> Have released a new version of Database Navigator (1.0.459).
DC>
DC>
DC> Highlights:
DC>
DC> - Method execution engine: support for executing standalone and
DC> package functions and stored procedures
DC>
DC> - Data editor: background loading of data (timeout is configurable
DC> in "Settings - Dataset Editor")
DC>
DC> - Several other backgroundable operations
DC>
DC> See also recently released "feature overview" page:
DC> http://www.jetbrains.net/confluence/display/CONTEST/Database+Navigat
DC> or
DC>
DC> ---
DC> Original message URL:
DC> http://www.jetbrains.net/devnet/message/5228420#5228420

Hey Andrei,

you have sql functionality in version 8.0. Did you give it a try? Of course it's not as extensive as from this plugin, but still, quite promising.
But I agree, I also like my plugin more... :-) No offence to the IJ team by that. Overall quality of the IntelliJ IDEA product was the main reason for starting this plugin in the first place.

Back to your question, I will provide at some point in time a 8.0 compatible version. I estimate it somewhere mid of February 2009. Let’s hope I can easily solve the conflict with the builtin SQL functionality. Because this is currently what's holding me from doing that.
Still, until a compatible version comes out, you can use in parallel a 7.0 instance with DBN on it. Have you considered that?

Regards,
Dan
.

Hello Dan,

Thanks for the update. I do use the bundled sql functionality a fair bit.
While I find it very convenient for sql files and language injection driven
sql validation and code completion (this is, indeed, a very nice feature),
I find its support for other DB related activities quite limited. I especially
miss the stored procedure view, indexes, and additional table information
your plugin provided. Right now I have to fall back to sql developer to get
that type of info.

Maybe you could provide an option to not change the file type binding from
IDEA's engine, but still offer all the other niceties your plugin provides
(including sql console and ability to run queries through your plugin).

Thx,
Andrei

Upgraded again to version 1.0.464.
Improved method execution engine: added support for declared types for both IN/OUT arguments (oracle only)

Hi Andrei,

providing a hybrid solution in 8.0 is not really what I want to do. Because eventually similar features will be implemented in IJ at some point in time. That would mean for my plugin to inhibit feature after feature until it becomes superfluous. And I don’t want this to happen. Cause I see lot of development potential in it. And in the end, this is what keeps my motivation alive...
On the other hand, injecting SQL into Java is not really big of a deal, so I will for sure "teach" my plugin to do that as soon as it goes 8.0. Currently (in 7.0) you can inject SQL it in Java by using IntelliLang.

Regards,
Dan

I'm using mysql and not able to display records where the column type is BIGINT(19).

I get the following error:

Error loading data for table xxxx.
Database error message: '1.22080016663E12' in column '5' is outside valid range for the datatype INTEGER.

Dino

Yet another small release (1.0.474)

Main achievement is the (overdue) "reload" feature in the objects browser.
Now objects can be reloaded on demand (from context menu >> Reload) or are reloaded automatically when changed within DBN (e.g. by database code editor for functions, views...).

Hi Dino,

please try again with latest release (1.0.474)
I have fixed the bigint issue, yet didn't really tested.

Regards,
Dan

I just updated to the latest version (1.0.483) and when I click on the Edit data menu entry for a table, none of the columns are being displayed.

I'm getting a lot of these exceptions in the log files:

009-01-05 14:00:41,265 [ 408406]   INFO - bn.object.impl.DBSchemaImpl$16 - Error loading data model
java.sql.SQLException: Too many failed attempts for loading all-constraints

    at com.dci.intellij.dbn.metadata.common.MetaDataStatementExecutionProcessor.execute(MetaDataStatementExecutionProcessor.java:93)

    at com.dci.intellij.dbn.metadata.common.MetaDataStatementExecutionProcessor.execute(MetaDataStatementExecutionProcessor.java:57)

    at com.dci.intellij.dbn.metadata.common.DataDictionaryImpl.execute(DataDictionaryImpl.java:50)

    at com.dci.intellij.dbn.metadata.common.DataDictionaryImpl.execute(DataDictionaryImpl.java:45)

    at com.dci.intellij.dbn.metadata.common.DataDictionaryImpl.loadAllConstraints(DataDictionaryImpl.java:154)

    at com.dci.intellij.dbn.object.impl.DBSchemaImpl$16.createResultSet(DBSchemaImpl.java:730)

    at com.dci.intellij.dbn.content.loader.DynamicContentResultSetLoader.loadContent(DynamicContentResultSetLoader.java:65)

    at com.dci.intellij.dbn.content.DynamicContentImpl.performLoad(DynamicContentImpl.java:146)

    at com.dci.intellij.dbn.content.DynamicContentImpl.load(DynamicContentImpl.java:114)

    at com.dci.intellij.dbn.content.DynamicContentImpl.getElements(DynamicContentImpl.java:239)

    at com.dci.intellij.dbn.content.loader.DynamicSubcontentLoader.loadContent(DynamicSubcontentLoader.java:31)

    at com.dci.intellij.dbn.content.loader.DynamicSubcontentCompoundLoader.loadContent(DynamicSubcontentCompoundLoader.java:33)

    at com.dci.intellij.dbn.content.DynamicContentImpl.performLoad(DynamicContentImpl.java:146)

    at com.dci.intellij.dbn.content.DynamicContentImpl.load(DynamicContentImpl.java:114)

    at com.dci.intellij.dbn.content.DynamicContentImpl.getElements(DynamicContentImpl.java:239)

    at com.dci.intellij.dbn.object.list.DBObjectListImpl.getObjects(DBObjectListImpl.java:42)

    at com.dci.intellij.dbn.object.list.DBObjectListImpl.getTreeChildren(DBObjectListImpl.java:141)

    at com.dci.intellij.dbn.object.list.DBObjectListImpl.isLeafTreeElement(DBObjectListImpl.java:149)

    at com.dci.intellij.dbn.browser.DatabaseBrowserManager.isLeaf(DatabaseBrowserManager.java:163)

    at com.intellij.ui.TreeToolTipHandler.getRendererComponent(TreeToolTipHandler.java:12)

    at com.intellij.ui.TreeToolTipHandler.getRendererComponent(TreeToolTipHandler.java:19)

    at com.intellij.ui.AbstractToolTipHandler.createToolTipImage(AbstractToolTipHandler.java:48)

    at com.intellij.ui.AbstractToolTipHandler.a(AbstractToolTipHandler.java:30)

    at com.intellij.ui.AbstractToolTipHandler.access$100(AbstractToolTipHandler.java:40)

    at com.intellij.ui.AbstractToolTipHandler$2.mouseMoved(AbstractToolTipHandler.java:4)

Hi Dino, to which version of MySQL are you connecting? I couldn't reproduce the problem with 6.0 and 5.0.
Do you see the lists of constraints in the object browser?

I'm connnecting to"Server version: 5.0.67-community-nt-log MySQL Community Edition (GPL)"

None of my tables contain constraints.

How can I revert back to an earlier version and test it?

Hello Dino,
indeed, constraints do not show up with 5.0.x. I actually meant 5.1 earlier. There are quite some differences in the INFORMATION_SCHEMA between 5.0 and 5.1, I was not aware of...
Now I’m in a kind of leave till end of the week, so it will take a bit until I solve this problem.
Getting an older version of the plugin is manually doable. I don’t think you can use the plugin manager of idea to do that. You need to download the version you want from the plugins site and unpack it in the plugins directory of intellij.
Regards,
Dan

Hi Dino,

I have released a new version (1.0.509) which among others contains also the fix on constraints for MySQL 4.0. Nevertheless the navigation from foreign key to primary is still not working for versions prior to 4.1. Additionally I don't advise using the procedure/function editors and method execution yet, since they are not working properly due to the missing PARAMETERS table in the INFORMATION_SCHEMA. This was only tested and is working properly with 6.0. I will try to find a solution for earlier versions as well.

Regards,
Dan

Thanks Dan.

It now works. Not only that columns with bigint types are now working.

Great!

i fixed also the method editor for 5.x versions, as well as method execution. (see 1.0.512)