[ANN] Database Navigator 2.0.1285 released

A new version of Database Navigator plugin for IDEA 8.1 was released. (2.0.1285)
http://plugins.intellij.net/plugin/?id=1800


One of the main features is the regional sensitive display format and input validation of dates and numbers. The default setting is taken from the system default locale. You can select the desired locale and formatting in the "General" settings tab. The custom formats are now used allover the application, on query results, data browsing, data editing, method execution and so on.

Additionally, the data editing has been improved substantially.
Objects factory is now supporting the creation of functions and stored procedures.


Note:
The plugin update may not be visible in your plugin manager due to some issues with the versioning patern.
You may need to locate and download it from the "Available" tab of your plugin manager instead of the tab "Installed".

10 comments
Comment actions Permalink

I'm having trouble using this plug-in on a Mac.  I've got a MacBook Pro with OS X 10.5.6.

I go to settings and configure a database connection (tried Oracle and Sybase so far).   I'm able to successfully "Test" the connection and get "Info" on it.  So far so good...

When I then open the Database Browser pane and click onto a connection, it diplays the word "Loading" and I see the rotating swirly thingy.  Shortly thereafter I get an IDE error (stacktrace shown below).  The connection never actually "opens" to allow me to navgate in the database.

I've tried various version of oracle drivers .

The plugin  looks awesome! I can't wait to use it.


java.sql.SQLException: method <init>(Ljava/lang/String;Ljava/lang/Throwable;)V not found: java.sql.SQLException: method <init>(Ljava/lang/String;Ljava/lang/Throwable;)V not found
java.lang.NoSuchMethodError: java.sql.SQLException: method <init>(Ljava/lang/String;Ljava/lang/Throwable;)V not found
    at com.dci.intellij.dbn.metadata.common.MetaDataStatementExecutionProcessor.execute(MetaDataStatementExecutionProcessor.java:89)
    at com.dci.intellij.dbn.metadata.common.MetaDataStatementExecutionProcessor.execute(MetaDataStatementExecutionProcessor.java:58)
    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.loadUsers(DataDictionaryImpl.java:89)
    at com.dci.intellij.dbn.object.common.DBObjectBundleImpl$5.createResultSet(DBObjectBundleImpl.java:384)
    at com.dci.intellij.dbn.content.loader.DynamicContentResultSetLoader.loadContent(DynamicContentResultSetLoader.java:65)
    at com.dci.intellij.dbn.content.DynamicContentImpl.performLoad(DynamicContentImpl.java:145)
    at com.dci.intellij.dbn.content.DynamicContentImpl.load(DynamicContentImpl.java:113)
    at com.dci.intellij.dbn.content.dependency.MultipleContentDependencyAdapter.beforeLoad(MultipleContentDependencyAdapter.java:54)
    at com.dci.intellij.dbn.content.DynamicContentImpl.performLoad(DynamicContentImpl.java:136)
    at com.dci.intellij.dbn.content.DynamicContentImpl.load(DynamicContentImpl.java:113)
    at com.dci.intellij.dbn.content.DynamicContentImpl.getElements(DynamicContentImpl.java:240)
    at com.dci.intellij.dbn.object.list.DBObjectListImpl.getObjects(DBObjectListImpl.java:42)
    at com.dci.intellij.dbn.object.list.DBObjectListImpl.initTreeElement(DBObjectListImpl.java:76)
    at com.dci.intellij.dbn.object.common.DBObjectBundleImpl.addChildToList(DBObjectBundleImpl.java:184)
    at com.dci.intellij.dbn.object.common.DBObjectBundleImpl.access$100(DBObjectBundleImpl.java:42)
    at com.dci.intellij.dbn.object.common.DBObjectBundleImpl$1.run(DBObjectBundleImpl.java:163)
    at com.intellij.openapi.progress.impl.ProgressManagerImpl$TaskRunnable.run(ProgressManagerImpl.java:3)
    at com.intellij.openapi.progress.impl.ProgressManagerImpl$2.run(ProgressManagerImpl.java:5)
    at com.intellij.openapi.progress.impl.ProgressManagerImpl.executeProcessUnderProgress(ProgressManagerImpl.java:13)
    at com.intellij.openapi.progress.impl.ProgressManagerImpl.runProcess(ProgressManagerImpl.java:101)
    at com.intellij.openapi.progress.impl.ProgressManagerImpl$6.run(ProgressManagerImpl.java:16)
    at com.intellij.openapi.application.impl.ApplicationImpl$5.run(ApplicationImpl.java:8)
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417)
    at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269)
    at java.util.concurrent.FutureTask.run(FutureTask.java:123)
    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
    at java.lang.Thread.run(Thread.java:613)
    at com.intellij.openapi.application.impl.ApplicationImpl$1$1.run(ApplicationImpl.java:5)

Thanks!

0
Comment actions Permalink

Hello John,

this looks to me more like a JRE problem, rather than a driver one.
The plugin was compiled with java 1.6. Can you please make sure your IntelliJ environment runs with 1.6?

Regards,
Dan

PS. Please note that the plugin only supports Oracle and MySQL for now. Even if you are able to setup a connection for a different database and test it successfully, the support is still limited to mentioned databases. Object browsing does not rely on the jdbc meta data, on the one hand because this does not support all the features I wanted to provide, but mainly because of performance reasons. So I opted for a specific approach, rather than generically supporting all the databases thru jdbc common feature set.

0
Comment actions Permalink

Ah!

No my IntelliJ runs under Java 5.  It comes configured that way from Jetbrains and due to the sketchy support for java on the mac I've never experimented with running IntelliJ under Java 6.  I'll look for some online docs on changing my setup to use Java 6.

Thanks! I'm really looking forward to using it.

John

0
Comment actions Permalink

It is easy. You have to install Java Update 2 for Leopard via software update, then open terminal:

cd /System/Library/Frameworks/JavaVM.framework/Versions/

sudo rm CurrentJDK sudo ln -s 1.6 CurrentJDK


 


That is it! Good luck.

0
Comment actions Permalink

Hello John,

well I hope it meets your expectations.. :-) I never tested it on mac. Especially the GUI may be a bit weird, although I tried to avoid hardcoded colors and dimensions for the GUI components. Please send me snapshots if you find any noncompliant screens.

Note: I released a new version (2.0.1292), which is mainly PL/SQL related but contains also some performance enhancements and bug fixes.

Regards,
Dan

0
Comment actions Permalink

Thanks for the reply.

I found however that I needed to edit the plist for IntelliJ and change the JVMVersion from "1.5*" to "1.6*".

Just changing the symbolic link you mentioned seemed to have no effect.

John

0
Comment actions Permalink

After some initial issues it seems to be working fine.  I initially experienced the filter dialog hang IntelliJ several times. I've disabled it for now.

I had to bump up MaxPermSize, but that's OK.

It looks really good!  THANKS!

John

0
Comment actions Permalink

Update on my status... after my previous message you'd probably assume I was happily using Database Navigator under OS X and Java 6, but I'm sad to say that's not the case.

IntelliJ exhibits a lot of quirks when running under Java 6 on the Mac. It seems VERY memory hungry (perhaps due to the 64 bitness, unresponsive, and generally uunreliable.  In all fairness, Java on the Mac is a dicey proposition for numerous historical reasons, so I don't really blame JetBrains for this.  It is simply unusable IMO under Java 6.  My co-worker coroborated my results.

I don't suppose you can compile Database Navigator under Java 5 by any chance?  IntelliJ under Java 5 on the Mac is very nice and we'd looooove to use your plug-in.

John

0
Comment actions Permalink

While I agree it is not JetBrains fault that good Java 6 support on the Mac is not as simple as changing "1.5*" to "1.6*" in a plist file, that doesn't mean it is impossible, or even difficult.


SquirrelSQL 3 runs fine, looks fine, and is not a memory hog on Java 6 on the Mac.


Is there another thread somewhere that provides any (technical) details on why IntelliJ has difficulty on Java 6 on the Mac?

0
Comment actions Permalink

Hi John,

I gave it a try some days ago with compiling and running the plugin with java 5, and I experienced some backward compatibility issues and some small GUI problems which will require a separate development branch. The differences are minimal so I do not expect big maintenance efforts for the two development threads. Nevertheless I never tested this on mac, so I will appreciate any feedback from you as soon as a j5 version is available.

Regards,
Dan

0

Please sign in to leave a comment.