[ANN] SQLQueryPlugin 1.2.0 released
I've just uploaded the newest release of my JDBC/SQL plugin.
http://www.intellij.org/twiki/bin/view/Main/SQLQueryPlugin
New features:
Use of variables in queries
(Example: select * from table where id=&id;)
Use configurable string to display NULL values
Option to save passwords as free text
Load BLOB objects if they are located in the projects
classpath
Bye,
Stefan.
Please sign in to leave a comment.
A few questions/remarks:
1. I've just got the following exception trying to click on plugin info button.
2. How and where do I define variables?
3. How do I define/change/choose column format? I can only see "Default" in
format menu, so I'm forced to do all formats (like "java.lang.Long.toHexString"(column))
in the query itself. It's very fortinate that HSQLDB does allow this, otherwise I'd be
in trouble :(
Thanks,
--Oleg
2003-07-03 11:41:27,866 ERROR - com.intellij.ide.IdeEventQueue - Error during dispatching of
java.awt.event.MouseEvent[MOUSE_RELEASED,(556,36),button=1,modifiers=Button1,clickCount=1] on dialog0
2003-07-03 11:41:27,866 ERROR - com.intellij.ide.IdeEventQueue - IntelliJ IDEA 3.0.5 Build #705
2003-07-03 11:41:27,866 ERROR - com.intellij.ide.IdeEventQueue - JDK: 1.4.1_02
2003-07-03 11:41:27,866 ERROR - com.intellij.ide.IdeEventQueue - VM: Java HotSpot(TM) Client VM
2003-07-03 11:41:27,866 ERROR - com.intellij.ide.IdeEventQueue - Vendor: Sun Microsystems Inc.
2003-07-03 11:41:27,866 ERROR - com.intellij.ide.IdeEventQueue - OS: Windows 2000
2003-07-03 11:41:27,866 ERROR - com.intellij.ide.IdeEventQueue -
java.lang.ClassCastException
at com.kiwisoft.idea.MainPanel$AboutAction.actionPerformed(Unknown Source)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at com.intellij.ide.q.a(q.java:71)
at com.intellij.ide.q.dispatchEvent(q.java:50)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
"Stefan Stiller" <stefan@sstiller.de> wrote in message news:12098501.1057243284643.JavaMail.itn@is.intellij.net...
>
>
>
Oleg Danilov wrote:
I tested your exception and it only occurs if the plugin window is
floating. I will fix this with the next release.
You must enable the use of variables with the '123' button in the query
panel. If your query contains something like &var1; a dialog will be
opened after you clicked on execute. In the dialog you can specifiy the
values of the variables.
If the value returned by the JDBC driver is a number then there should
be more items in the format menu (see attached image). So the error
could be that the HSQLDB driver doesn't return java.lang.Number objects.
Regards,
Stefan.
Attachment(s):
format.png
"Stefan Stiller" <stefan.stiller@net-linx.de> wrote in message news:3F05269A.9010909@net-linx.de...
>
>
>
>
>
In my particular case it does return java.lang.Byte and java.lang.Long which
are also java.lang.Number, but I've never managed to see this menu, default only.
How do you check the type, with instanceof or just ==?
--Oleg
>
>
>
-
The formats are registered only for java.lang.Number, java.util.Date,
java.lang.String and java.lang.Object.
I search for a renderer with the objects class. If none can be found I
search for a renderer of the super class and so on.
So if it works for one subclass it should work for all subclasses.
Bye, Stefan.
"Stefan Stiller" <stefan.stiller@net-linx.de> wrote in message news:3F055801.5060103@net-linx.de...
>
Well, it doesn't work....
>
>
I've found the error. It happens because the HSQL JDBC driver doesn't
support the function ResultSetMetaData.getColumnClassName() which I use
to determine the type of a column. I will implement a workaround in the
next release (probably next week).
Oleg Danilov wrote:
>>>In my particular case it does return java.lang.Byte and java.lang.Long which
>>>are also java.lang.Number, but I've never managed to see this menu, default only.
>>>How do you check the type, with instanceof or just ==?
>>
>>The formats are registered only for java.lang.Number, java.util.Date,
>>java.lang.String and java.lang.Object.
>>I search for a renderer with the objects class. If none can be found I
>>search for a renderer of the super class and so on.
>>So if it works for one subclass it should work for all subclasses.
>>Bye, Stefan.
>>
Can't use it on internal build here at IntelliJ due to the following:
ERROR - intellij.plugins.PluginManager -
ERROR - intellij.plugins.PluginManager - IntelliJ IDEA (Aurora)
Bui
ld #__BUILD_NUMBER__
ERROR - intellij.plugins.PluginManager - Internal version.
Compiled 0
3 July 2003 22:56
ERROR - intellij.plugins.PluginManager - JDK: 1.4.2-beta
ERROR - intellij.plugins.PluginManager - VM: Java HotSpot(TM)
Client
VM
ERROR - intellij.plugins.PluginManager - Vendor: Sun Microsystems
Inc
.
ERROR - intellij.plugins.PluginManager - OS: Windows XP
ERROR - intellij.plugins.PluginManager - Original exception:
java.lang.NumberFormatException: For input string: "__BUILD_NUMBER__"
at
java.lang.NumberFormatException.forInputString(NumberFormatException.
java:48)
at java.lang.Integer.parseInt(Integer.java:468)
at java.lang.Integer.parseInt(Integer.java:518)
at org.intellij.sequencer.util.b.]]>(Unknown Source)
at org.intellij.sequencer.SequencePlugin.h(Unknown Source)
at org.intellij.sequencer.SequencePlugin.f(Unknown Source)
at org.intellij.sequencer.ShowSequenceAction.update(Unknown Source)
at
com.intellij.openapi.keymap.impl.IdeKeyEventDispatcher.processAction(
IdeKeyEventDispatcher.java:252)
at
com.intellij.openapi.keymap.impl.IdeKeyEventDispatcher.inInitState(Id
eKeyEventDispatcher.java:235)
at
com.intellij.openapi.keymap.impl.IdeKeyEventDispatcher.dispatchKeyEve
nt(IdeKeyEventDispatcher.java:96)
at
com.intellij.ide.IdeEventQueue.dispatchEvent(IdeEventQueue.java:231)
at
java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchTh
read.java:201)
at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThre
ad.java:151)
at
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:145)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:
137)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:100)
ERROR - intellij.plugins.PluginManager -
--
Best regards,
Maxim Shafirov
JetBrains, Inc / IntelliJ Software
http://www.intellij.com
"Develop with pleasure!"
"Stefan Stiller" <stefan@sstiller.de> wrote in message
news:12098501.1057243284643.JavaMail.itn@is.intellij.net...
>
>
>
Sorry, posted to wrong plugin topic.
--
Best regards,
Maxim Shafirov
JetBrains, Inc / IntelliJ Software
http://www.intellij.com
"Develop with pleasure!"
"Maxim Shafirov" <max@intellij.net> wrote in message
news:be3tqh$u7u$1@is.intellij.net...
>
Microsystems
Source)
>
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:
>
>
>
>
>
>
>
"Stefan Stiller" <stefan.stiller@net-linx.de> wrote in message news:3F05760A.9090607@net-linx.de...
Why would you use such an awkward and unreliable way? There are always
all kinds of troubles with metadata stuff so this is always a last resort. Why don't
you just call getObject() and check the result type? In your case you don't need
to know type if the result is null.
>
>
Just noticed two new (but unmentioned) features:
- send to sql plugin now takes care of the multi-line sql queries, removing
the concatenations (requested some time ago)
- the question marks are replaced with variables in queries when the sql
statement is sent to the plugin.
A BIG thank you for both of them.
Andrei
"Stefan Stiller" <stefan@sstiller.de> wrote in message
news:12098501.1057243284643.JavaMail.itn@is.intellij.net...
>
>
>
test
Hm, it doesn't work for me though:
2003-07-09 14:20:04,957 ERROR -
mand.impl.CommandProcessorImpl -
2003-07-09 14:20:04,957 ERROR -
mand.impl.CommandProcessorImpl - IntelliJ IDEA (Aurora) Build #856
2003-07-09 14:20:04,957 ERROR -
mand.impl.CommandProcessorImpl - JDK: 1.4.2
2003-07-09 14:20:04,957 ERROR -
mand.impl.CommandProcessorImpl - VM: Java HotSpot(TM) Client VM
2003-07-09 14:20:04,957 ERROR -
mand.impl.CommandProcessorImpl - Vendor: Sun Microsystems Inc.
2003-07-09 14:20:04,957 ERROR -
mand.impl.CommandProcessorImpl - OS: Windows XP
2003-07-09 14:20:04,957 ERROR -
mand.impl.CommandProcessorImpl - Last Action: SQLQueryPlugin.EditorAction
2003-07-09 14:20:04,957 ERROR -
mand.impl.CommandProcessorImpl - Current Command: Send to SQLPlugin
2003-07-09 14:20:04,957 ERROR -
mand.impl.CommandProcessorImpl -
java.lang.NullPointerException
at com.kiwisoft.utils.StringUtils.convertJavaString(Unknown Source)
at com.kiwisoft.idea.EditorContextAction$ActionHandler.execute(Unknown
Source)
at
com.intellij.openapi.editor.actionSystem.EditorAction$1.run(EditorAction.java:2)
at com.intellij.openapi.command.b.b.executeCommand(b.java:48)
at
com.intellij.openapi.editor.actionSystem.EditorAction.actionPerformed(EditorAction.java:3)
at
com.intellij.openapi.editor.actionSystem.EditorAction.actionPerformed(EditorAction.java:20)
at com.intellij.openapi.actionSystem.a.k.actionPerformed(k.java:4)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at com.intellij.openapi.actionSystem.a.bb.fireActionPerformed(bb.java:45)
at com.intellij.ui.a.a.t.doClick(t.java:17)
at com.intellij.ui.a.a.t.access$300(t.java:47)
at com.intellij.ui.a.a.u.mouseReleased(u.java:4)
at java.awt.Component.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at com.intellij.ide.s.a(s.java:111)
at com.intellij.ide.s.dispatchEvent(s.java:17)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
Andrei Oprea wrote:
>>I've just uploaded the newest release of my JDBC/SQL plugin.
>>
>>http://www.intellij.org/twiki/bin/view/Main/SQLQueryPlugin
>>
>>New features:
>> * Use of variables in queries
>> (Example: select * from table where id=&id;)
>> * Use configurable string to display NULL values
>> * Option to save passwords as free text
>> * Load BLOB objects if they are located in the projects
>> classpath
>>
>>Bye,
>>Stefan.
You'd have to select something before invoking the send to sql plugin
command. I get the same error if I invoke the command without a selection in
the editor.
HTH,
Andrei
"kesh" <dummy@dummy.com> wrote in message
news:behmgn$s93$1@is.intellij.net...
>
>
com.intellij.openapi.editor.actionSystem.EditorAction$1.run(EditorAction.jav
a:2)
>
com.intellij.openapi.editor.actionSystem.EditorAction.actionPerformed(Editor
Action.java:3)
>
com.intellij.openapi.editor.actionSystem.EditorAction.actionPerformed(Editor
Action.java:20)
>
>
removing
>
Stefan Stiller wrote:
The deserialization of BLOBs containing java serialized classes is
causing me a few problems
if the object fails to deserialize, the whole output of the query can't
be seen
I'd prefer if blob attempt to deserialize but the tabular display of the
query result still came out on blob errors.
thanks for an outstanding plugin
Edo