[ANN] SQLQueryPlugin 1.2.2 released

Stefan Stiller wrote:

I've just uploaded the newest release of my JDBC/SQL plugin.

http://www.intellij.org/twiki/bin/view/Main/SQLQueryPlugin

Changes:

• Bugfixes

• Enabled Character Encoding for MySQL driver (Thanks to Sergey

Bervinov)

• Display strings in different encodings

Bye,
Stefan.

Hi Stefan
thanks for the great plugin. Here is some feedback (I am using idea 887
on win xp, Db is Oracle 9i with oracle type4 jdbc) ...

ISSUE:
If I keep the sqlplugin window NOT pinned, execution of a query or even
switching tab from qery1 to query2 closes the window. As of now, the
only usable mode is with thw window pinned - while I am happy with
unpinned mode usually.

ISSUE:
I have serialized java objects in my tables, stored as blobs.
They are serialized/deserialized using a custom serialization mechanism
that require a framework and library to be programmatically initialized,
so I do NOT expect sqlplugin to succesfully deserialize them.
Actually I'd get an exception in IDEA's window and therefore no querty
result. I'd be happier if an option for no deserialization would be
provided so that I could justsee the blob as byte[] ?

here's the stack trace:
Connecting (jdbc:oracle:thin:@testlabpc1:1521:MMDB)...
java.lang.NullPointerException
at java.lang.Class.isAssignableFrom(Native Method)
at com.kiwisoft.idea.ResultSetTableModel.createData(Unknown Source)
at com.kiwisoft.idea.ResultSetTableModel.(Unknown Source) at com.kiwisoft.idea.QueryPanel.executeSelect(Unknown Source) at com.kiwisoft.idea.QueryPanel.access$1700(Unknown Source) at com.kiwisoft.idea.QueryPanel$ExecutionThread.run(Unknown Source) Closing connection...Done Connecting (jdbc:oracle:thin:@testlabpc1:1521:MMDB)... java.lang.NullPointerException at java.lang.Class.isAssignableFrom(Native Method) at com.kiwisoft.idea.ResultSetTableModel.createData(Unknown Source) at com.kiwisoft.idea.ResultSetTableModel.(Unknown Source) at com.kiwisoft.idea.QueryPanel.executeSelect(Unknown Source) at com.kiwisoft.idea.QueryPanel.access$1700(Unknown Source) at com.kiwisoft.idea.QueryPanel$ExecutionThread.run(Unknown Source) java.lang.NullPointerException at java.lang.Class.isAssignableFrom(Native Method) at com.kiwisoft.idea.ResultSetTableModel.createData(Unknown Source) at com.kiwisoft.idea.ResultSetTableModel.(Unknown Source) at com.kiwisoft.idea.QueryPanel.executeSelect(Unknown Source) at com.kiwisoft.idea.QueryPanel.access$1700(Unknown Source) at com.kiwisoft.idea.QueryPanel$ExecutionThread.run(Unknown Source) Closing connection...Done Error while getting column class name: null java.lang.NullPointerException at oracle.jdbc.driver.OracleStatement.describe(OracleStatement.java:6195 ) at oracle.jdbc.driver.OracleStatement.getDBDescription(OracleStatement.j ava:883) at oracle.jdbc.driver.OracleResultSetMetaData.getColumnCount(OracleResul tSetMetaData.java:150) at com.kiwisoft.idea.ResultSetTableModel.createData(Unknown Source) at com.kiwisoft.idea.ResultSetTableModel.]]>(Unknown Source)
at com.kiwisoft.idea.QueryPanel.executeSelect(Unknown Source)
at com.kiwisoft.idea.QueryPanel.access$1700(Unknown Source)
at com.kiwisoft.idea.QueryPanel$ExecutionThread.run(Unknown Source)
Connecting (jdbc:oracle:thin:@testlabpc1:1521:MMDB)...
Closing connection...Done


SUGGESTION:
current installation requires to extract the jar from zip and add it to
the plugins directory. Just unzipping to plugins could suffice if a
META-INF directory was present (see ideajad for example
http://www.tagtraum.com/ideajad.html).

when using the unzipped directory, you may allow to define a location to
place jdbc drivers - so that they do not need to be added to IDEA/lib
and therefore made avialbale globally to the IDE.

thanks'n'cheers

Edo

SUGGESTION:
current installation requires to extract the jar from zip and add it to
the plugins directory. Just unzipping to plugins could suffice if a
META-INF directory was present (see ideajad for example
http://www.tagtraum.com/ideajad.html).

when using the unzipped directory, you may allow to define a location to
place jdbc drivers - so that they do not need to be added to IDEA/lib
and therefore made avialbale globally to the IDE.

When I install, I create 'plugins/kl_sql/lib' and in it place the plugin
jar and my db driver jar. This way I can simply copy the directory when
installing a new eap. Of course it would be nice if the plugin came
packaged in a similar way (but for the value of this plugin, I would be
happy to compile from source while standing on my head).

Hi, Stefan.

The current and previous versions is unusable because it doesn't show the results page. :(

I'm using IDEA version #706 (Ariadna). Database Server - Firebird.

I had to rollback to the version 1.2.0 :(

-

Best regards,
Sergey Bervinov (James Advent)

I see the exact same behavior.

IDEA build 695, DB2 7.2.3, Win2k sp3