[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.

0
14 comments
Avatar
Permanently deleted user

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...

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.



0
Avatar
Permanently deleted user

Oleg Danilov wrote:

A few questions/remarks:

1. I've just got the following exception trying to click on plugin info button.


I tested your exception and it only occurs if the plugin window is
floating. I will fix this with the next release.

2. How and where do I define variables?


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.

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 :(


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.


Thanks,

--Oleg


Regards,
Stefan.



Attachment(s):
format.png
0
Avatar
Permanently deleted user


"Stefan Stiller" <stefan.stiller@net-linx.de> wrote in message news:3F05269A.9010909@net-linx.de...

Oleg Danilov wrote:

A few questions/remarks:

>

1. I've just got the following exception trying to click on plugin info button.

>

I tested your exception and it only occurs if the plugin window is
floating. I will fix this with the next release.

>

2. How and where do I define variables?

>

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.

>

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 :(

>

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.


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

>

>

Thanks,

>

--Oleg

>

Regards,
Stefan.

>


-







0
Avatar
Permanently deleted user

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.

0
Avatar
Permanently deleted user


"Stefan Stiller" <stefan.stiller@net-linx.de> wrote in message news:3F055801.5060103@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 ==?

>

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.


Well, it doesn't work....

>

Bye, Stefan.

>


0
Avatar
Permanently deleted user

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:

"Stefan Stiller" <stefan.stiller@net-linx.de> wrote in message news:3F055801.5060103@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 ==?
>>
>>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.


Well, it doesn't work....

>>Bye, Stefan.
>>



0
Avatar
Permanently deleted user

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...

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.




0
Avatar
Permanently deleted user

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...

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.<clinit>(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...

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.

>
>


0
Avatar
Permanently deleted user


"Stefan Stiller" <stefan.stiller@net-linx.de> wrote in message news:3F05760A.9090607@net-linx.de...

I've found the error. It happens because the HSQL JDBC driver doesn't
support the function ResultSetMetaData.getColumnClassName() which I use


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.

to determine the type of a column. I will implement a workaround in the
next release (probably next week).

>

Oleg Danilov wrote:

"Stefan Stiller" <stefan.stiller@net-linx.de> wrote in message news:3F055801.5060103@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 ==?
>>
>>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.
>
>

Well, it doesn't work....

>
>
>>Bye, Stefan.
>>
>
>
>

>


0
Avatar
Permanently deleted user

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...

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.



0
Avatar
Permanently deleted user

test

0
Avatar
Permanently deleted user

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:

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...

>>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.



0
Avatar
Permanently deleted user

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...

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.jav
a:2)

at com.intellij.openapi.command.b.b.executeCommand(b.java:48)
at

>
com.intellij.openapi.editor.actionSystem.EditorAction.actionPerformed(Editor
Action.java:3)

at

>
com.intellij.openapi.editor.actionSystem.EditorAction.actionPerformed(Editor
Action.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:

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...

>
>>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.
>
>
>

>


0
Avatar
Permanently deleted user

Stefan Stiller 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.


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

0

Please sign in to leave a comment.