IOException in SQLPlugin

Hi,

I am not sure where to report bugs in the KiwiSoft SQL plugin. Therefore
I'll post it here and hope that the author reads this newsgroup.

This exception happened while loading an example project, which did not
use any feature of the SQL plugin.

Regards,
Jean-Marie

javax.help.HelpSetException: Could not parse
Got an IOException (null)
Parsing failed for null
at javax.help.HelpSet.(HelpSet.java:146) at com.kiwisoft.sqlPlugin.actions.HelpAction.(HelpAction.java:51) at com.kiwisoft.sqlPlugin.SQLPluginPanel.createToolBar(SQLPluginPanel.java:151) at com.kiwisoft.sqlPlugin.SQLPluginPanel.]]>(SQLPluginPanel.java:114)
at
com.kiwisoft.sqlPlugin.SQLPluginPanel.getInstance(SQLPluginPanel.java:77)
at com.kiwisoft.sqlPlugin.SQLPlugin.projectOpened(SQLPlugin.java:49)
at com.intellij.openapi.project.impl.ProjectImpl.c(ProjectImpl.java:142)
at
com.intellij.openapi.project.impl.ProjectImpl.access$200(ProjectImpl.java:147)
at
com.intellij.openapi.project.impl.ProjectImpl$MyProjectManagerListener.projectOpened(ProjectImpl.java:0)
at
com.intellij.openapi.project.impl.ProjectManagerImpl$1.projectOpened(ProjectManagerImpl.java:5)
at
com.intellij.openapi.project.impl.ProjectManagerImpl.d(ProjectManagerImpl.java:148)
at
com.intellij.openapi.project.impl.ProjectManagerImpl.openProject(ProjectManagerImpl.java:73)
at
com.intellij.openapi.project.impl.ProjectManagerImpl.loadAndOpenProject(ProjectManagerImpl.java:4)
at com.intellij.ide.impl.ProjectUtil.openProject(ProjectUtil.java:69)
at com.intellij.idea.IdeaApplication.c(IdeaApplication.java:17)
at com.intellij.idea.IdeaApplication.access$400(IdeaApplication.java:18)
at
com.intellij.idea.IdeaApplication$IdeStarter$2.run(IdeaApplication.java:0)
at
com.intellij.openapi.application.impl.LaterInvocatorEx$FlushQueue.run(LaterInvocatorEx.java:13)
at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:461)
at
com.intellij.ide.IdeEventQueue.defaultDispatchEvent(IdeEventQueue.java:94)
at com.intellij.ide.IdeEventQueue.a(IdeEventQueue.java:119)
at com.intellij.ide.IdeEventQueue.dispatchEvent(IdeEventQueue.java:25)
at
java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)

8 comments

Hi,

Thanks for the info. I already encountered the same exception.
The exception can be ignored only the help button
will not be available in the plugins tool window but the plugins help is
included in the IDEA help.

Regards,
Stefan.

Jean-Marie Gaillourdet wrote:

Hi,

I am not sure where to report bugs in the KiwiSoft SQL plugin. Therefore
I'll post it here and hope that the author reads this newsgroup.

This exception happened while loading an example project, which did not
use any feature of the SQL plugin.

Regards,
Jean-Marie

javax.help.HelpSetException: Could not parse
Got an IOException (null)
Parsing failed for null
at javax.help.HelpSet.<init>(HelpSet.java:146)
at com.kiwisoft.sqlPlugin.actions.HelpAction.<init>(HelpAction.java:51)
at
com.kiwisoft.sqlPlugin.SQLPluginPanel.createToolBar(SQLPluginPanel.java:151)
at com.kiwisoft.sqlPlugin.SQLPluginPanel.<init>(SQLPluginPanel.java:114)
at
com.kiwisoft.sqlPlugin.SQLPluginPanel.getInstance(SQLPluginPanel.java:77)
at com.kiwisoft.sqlPlugin.SQLPlugin.projectOpened(SQLPlugin.java:49)
at com.intellij.openapi.project.impl.ProjectImpl.c(ProjectImpl.java:142)
at
com.intellij.openapi.project.impl.ProjectImpl.access$200(ProjectImpl.java:147)
at
com.intellij.openapi.project.impl.ProjectImpl$MyProjectManagerListener.projectOpened(ProjectImpl.java:0)
at
com.intellij.openapi.project.impl.ProjectManagerImpl$1.projectOpened(ProjectManagerImpl.java:5)
at
com.intellij.openapi.project.impl.ProjectManagerImpl.d(ProjectManagerImpl.java:148)
at
com.intellij.openapi.project.impl.ProjectManagerImpl.openProject(ProjectManagerImpl.java:73)
at
com.intellij.openapi.project.impl.ProjectManagerImpl.loadAndOpenProject(ProjectManagerImpl.java:4)
at com.intellij.ide.impl.ProjectUtil.openProject(ProjectUtil.java:69)
at com.intellij.idea.IdeaApplication.c(IdeaApplication.java:17)
at com.intellij.idea.IdeaApplication.access$400(IdeaApplication.java:18)
at
com.intellij.idea.IdeaApplication$IdeStarter$2.run(IdeaApplication.java:0)
at
com.intellij.openapi.application.impl.LaterInvocatorEx$FlushQueue.run(LaterInvocatorEx.java:13)
at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:461)
at
com.intellij.ide.IdeEventQueue.defaultDispatchEvent(IdeEventQueue.java:94)
at com.intellij.ide.IdeEventQueue.a(IdeEventQueue.java:119)
at com.intellij.ide.IdeEventQueue.dispatchEvent(IdeEventQueue.java:25)
at
java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)

0

Hi,

Thanks for the info. I already encountered the same exception.
The exception can be ignored only the help button
will not be available in the plugins tool window but the plugins help is
included in the IDEA help.

Regards,
Stefan.

Jean-Marie Gaillourdet wrote:

Hi,

I am not sure where to report bugs in the KiwiSoft SQL plugin. Therefore
I'll post it here and hope that the author reads this newsgroup.

This exception happened while loading an example project, which did not
use any feature of the SQL plugin.

Regards,
Jean-Marie

javax.help.HelpSetException: Could not parse
Got an IOException (null)
Parsing failed for null
at javax.help.HelpSet.<init>(HelpSet.java:146)
at com.kiwisoft.sqlPlugin.actions.HelpAction.<init>(HelpAction.java:51)
at
com.kiwisoft.sqlPlugin.SQLPluginPanel.createToolBar(SQLPluginPanel.java:151)
at com.kiwisoft.sqlPlugin.SQLPluginPanel.<init>(SQLPluginPanel.java:114)
at
com.kiwisoft.sqlPlugin.SQLPluginPanel.getInstance(SQLPluginPanel.java:77)
at com.kiwisoft.sqlPlugin.SQLPlugin.projectOpened(SQLPlugin.java:49)
at com.intellij.openapi.project.impl.ProjectImpl.c(ProjectImpl.java:142)
at
com.intellij.openapi.project.impl.ProjectImpl.access$200(ProjectImpl.java:147)
at
com.intellij.openapi.project.impl.ProjectImpl$MyProjectManagerListener.projectOpened(ProjectImpl.java:0)
at
com.intellij.openapi.project.impl.ProjectManagerImpl$1.projectOpened(ProjectManagerImpl.java:5)
at
com.intellij.openapi.project.impl.ProjectManagerImpl.d(ProjectManagerImpl.java:148)
at
com.intellij.openapi.project.impl.ProjectManagerImpl.openProject(ProjectManagerImpl.java:73)
at
com.intellij.openapi.project.impl.ProjectManagerImpl.loadAndOpenProject(ProjectManagerImpl.java:4)
at com.intellij.ide.impl.ProjectUtil.openProject(ProjectUtil.java:69)
at com.intellij.idea.IdeaApplication.c(IdeaApplication.java:17)
at com.intellij.idea.IdeaApplication.access$400(IdeaApplication.java:18)
at
com.intellij.idea.IdeaApplication$IdeStarter$2.run(IdeaApplication.java:0)
at
com.intellij.openapi.application.impl.LaterInvocatorEx$FlushQueue.run(LaterInvocatorEx.java:13)
at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:461)
at
com.intellij.ide.IdeEventQueue.defaultDispatchEvent(IdeEventQueue.java:94)
at com.intellij.ide.IdeEventQueue.a(IdeEventQueue.java:119)
at com.intellij.ide.IdeEventQueue.dispatchEvent(IdeEventQueue.java:25)
at
java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)

0

While we're talking about the SQLPlugin, a couple of things I noticed:

1. Can you make it so that it is possible to copy table names, columns names etc from the SQL Schema window. Currently if you copy you get something like:

com.kiwisoft.db.DatabaseTable@193b5ca

I know there's a context menu but it would be very useful to select several tables/column in the tree and copy all the table/column names to the clipboard using ctrl C/V.

2. If you select a rectangle of cells in the results window and select 'copy to clipboard' all values are separated with commas (ie you get a single row of values), I would have expected that each rows of cell values would have carriage returns between them?


3. I seem to have lost all my stored database config. Was that expected with the new release (running on Demetra).

0

Hi Stefan,

Stefan Stiller schrieb:

Thanks for the info. I already encountered the same exception.
The exception can be ignored only the help button
will not be available in the plugins tool window but the plugins help is
included in the IDEA help.


If it is safe to ignore that exception, why is not catched? Usually I
consider it a bug if an exception is not catched in a thread and the
user can see that.

Regards,
Jean-Marie

0

Also, the database config now seems to be stored at the IDE level, not project level.

Was this intentional? This is a backward step as far as I am concerned as I have several unrelated projects using different dbs, it's good that irrelevant dbs are not listed.

0

The exception is catched but just printed to the console.

Stefan.

Jean-Marie Gaillourdet wrote:

Hi Stefan,

Stefan Stiller schrieb:

>> Thanks for the info. I already encountered the same exception.
>> The exception can be ignored only the help button
>> will not be available in the plugins tool window but the plugins help is
>> included in the IDEA help.


If it is safe to ignore that exception, why is not catched? Usually I
consider it a bug if an exception is not catched in a thread and the
user can see that.

Regards,
Jean-Marie

0

Chris Sherratt wrote:

While we're talking about the SQLPlugin, a couple of things I noticed:

1. Can you make it so that it is possible to copy table names, columns names etc from the SQL Schema window. Currently if you copy you get something like:

com.kiwisoft.db.DatabaseTable@193b5ca

I know there's a context menu but it would be very useful to select several tables/column in the tree and copy all the table/column names to the clipboard using ctrl C/V.


I will look into it. But it will not be high priority.


2. If you select a rectangle of cells in the results window and select 'copy to clipboard' all values are separated with commas (ie you get a single row of values), I would have expected that each rows of cell values would have carriage returns between them?


My suggestion would be to change it such that if I select only a row or
a column the behavior would be as it is now. If I select more than one
row and column I will add line breaks after every row.


3. I seem to have lost all my stored database config. Was that expected with the new release (running on Demetra).


This was done intentionally. A lot of users requested this feature. I
have thought about allowing connections to be configured on project and
on application level but it is very difficult to manage and therefore
left out for this release.

You can use the grouping functionality to divide your project db's.

Regards,
Stefan.

0

>> My suggestion would be to change it such that if I select only a row or
>> a column the behavior would be as it is now. If I select more than one
>> row and column I will add line breaks after every row.

That would be perfect.


>> You can use the grouping functionality to divide your project db's.

Am already using grouping to divide between dev, qa, prod etc so it's getting a little busy. Multiple levels of grouping would cover it though.

0

Please sign in to leave a comment.