Exceptions with SQL Query Plugin

Tried to connect to a SQLServer database with microsoft driver, with an
invalid db URL.


Error during dispatching of
java.awt.event.MouseEvent[MOUSE_RELEASED,(394,542),button=1,modifiers=Button
1,clickCount=1] on dialog1: Can't dispose InputContext while it's active
java.lang.IllegalStateException: Can't dispose InputContext while it's
active
at sun.awt.im.InputContext.dispose(InputContext.java:601)
at java.awt.Window$1DisposeAction.run(Window.java:560)
at java.awt.Window.dispose(Window.java:570)
at java.awt.Dialog.disposeImpl(Dialog.java:638)
at java.awt.Dialog.dispose(Dialog.java:634)
at
com.intellij.openapi.ui.impl.DialogWrapperPeerImpl$1.run(DialogWrapperPeerIm
pl.java:1)
at
com.intellij.openapi.ui.impl.DialogWrapperPeerImpl.dispose(DialogWrapperPeer
Impl.java:4)
at com.intellij.openapi.ui.DialogWrapper.dispose(DialogWrapper.java:343)
at
com.kiwisoft.utils.idea.IdeaDialogWrapper.dispose(IdeaDialogWrapper.java:63)
at
com.kiwisoft.sqlPlugin.settings.GlobalSettingsDialogStub$ApplyAction.actionP
erformed(GlobalSettingsDialogStub.java:133)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1786)
at
javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButto
n.java:1839)
at
javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:4
20)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
at
javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener
.java:245)
at java.awt.Component.processMouseEvent(Component.java:5100)
at java.awt.Component.processEvent(Component.java:4897)
at java.awt.Container.processEvent(Container.java:1569)
at java.awt.Component.dispatchEventImpl(Component.java:3615)
at java.awt.Container.dispatchEventImpl(Container.java:1627)
at java.awt.Component.dispatchEvent(Component.java:3477)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3483)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3198)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3128)
at java.awt.Container.dispatchEventImpl(Container.java:1613)
at java.awt.Window.dispatchEventImpl(Window.java:1606)
at java.awt.Component.dispatchEvent(Component.java:3477)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:456)
at
com.intellij.ide.IdeEventQueue.defaultDispatchEvent(IdeEventQueue.java:18)
at com.intellij.ide.IdeEventQueue.a(IdeEventQueue.java:125)
at com.intellij.ide.IdeEventQueue.dispatchEvent(IdeEventQueue.java:141)
at
java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.ja
va:201)
at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java
:151)
at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java
:141)
at java.awt.Dialog$1.run(Dialog.java:540)
at java.awt.Dialog.show(Dialog.java:561)
at
com.intellij.openapi.ui.impl.DialogWrapperPeerImpl$MyDialog.show(DialogWrapp
erPeerImpl.java:0)
at
com.intellij.openapi.ui.impl.DialogWrapperPeerImpl.show(DialogWrapperPeerImp
l.java:21)
at com.intellij.openapi.ui.DialogWrapper.show(DialogWrapper.java:734)
at com.kiwisoft.utils.Utils$1.run(Utils.java:67)
at com.kiwisoft.utils.Utils.wrapDialog(Utils.java:70)
at
com.kiwisoft.sqlPlugin.actions.PropertiesAction.actionPerformed(PropertiesAc
tion.java:49)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1786)
at
javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButto
n.java:1839)
at
javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:4
20)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
at
javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener
.java:245)
at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:231)
at java.awt.Component.processMouseEvent(Component.java:5100)
at java.awt.Component.processEvent(Component.java:4897)
at java.awt.Container.processEvent(Container.java:1569)
at java.awt.Component.dispatchEventImpl(Component.java:3615)
at java.awt.Container.dispatchEventImpl(Container.java:1627)
at java.awt.Component.dispatchEvent(Component.java:3477)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3483)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3198)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3128)
at java.awt.Container.dispatchEventImpl(Container.java:1613)
at java.awt.Window.dispatchEventImpl(Window.java:1606)
at java.awt.Component.dispatchEvent(Component.java:3477)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:456)
at
com.intellij.ide.IdeEventQueue.defaultDispatchEvent(IdeEventQueue.java:18)
at com.intellij.ide.IdeEventQueue.a(IdeEventQueue.java:125)
at com.intellij.ide.IdeEventQueue.dispatchEvent(IdeEventQueue.java:141)
at
java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.ja
va:201)
at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.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)



java.lang.NullPointerException
at java.awt.Component.requestFocusHelper(Component.java:6099)
at java.awt.Component.requestFocusInWindow(Component.java:6040)
at javax.swing.JComponent.requestFocusInWindow(JComponent.java:1145)
at
java.awt.DefaultKeyboardFocusManager.dispatchEvent(DefaultKeyboardFocusManag
er.java:317)
at java.awt.Component.dispatchEventImpl(Component.java:3506)
at java.awt.Container.dispatchEventImpl(Container.java:1627)
at java.awt.Window.dispatchEventImpl(Window.java:1606)
at java.awt.Component.dispatchEvent(Component.java:3477)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:456)
at
com.intellij.ide.IdeEventQueue.defaultDispatchEvent(IdeEventQueue.java:18)
at com.intellij.ide.IdeEventQueue.a(IdeEventQueue.java:19)
at com.intellij.ide.IdeEventQueue.dispatchEvent(IdeEventQueue.java:141)
at java.awt.SequencedEvent.dispatch(SequencedEvent.java:93)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:454)
at
com.intellij.ide.IdeEventQueue.defaultDispatchEvent(IdeEventQueue.java:18)
at com.intellij.ide.IdeEventQueue.a(IdeEventQueue.java:19)
at com.intellij.ide.IdeEventQueue.dispatchEvent(IdeEventQueue.java:141)
at
java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.ja
va:201)
at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.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)




3 comments
Comment actions Permalink

Another exception. This one happens every time I run a query it seems like.
The queries return data.

java.sql.SQLException: [SQLServer 2000 Driver for JDBC]Can't
start a cloned connection while in manual transaction mode.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown
Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown
Source)
at com.microsoft.jdbc.base.BaseConnection.getImplConnection(Unknown
Source)
at com.microsoft.jdbc.base.BaseStatement.setupImplConnection(Unknown
Source)
at com.microsoft.jdbc.base.BaseStatement.(Unknown Source) at com.microsoft.jdbc.base.BaseConnection.createStatement(Unknown Source) at com.microsoft.jdbc.base.BaseConnection.createStatement(Unknown Source) at com.microsoft.jdbc.base.BaseDatabaseMetaData.getPrimaryKeys(Unknown Source) at com.kiwisoft.db.Database.getPrimaryKeys(Database.java:401) at com.kiwisoft.sqlPlugin.ResultSetTableModel.createData(ResultSetTableModel.ja va:113) at com.kiwisoft.sqlPlugin.ResultSetTableModel.]]>(ResultSetTableModel.java:7
1)
at
com.kiwisoft.sqlPlugin.QueryPanel.executeSelect(QueryPanel.java:605)
at com.kiwisoft.sqlPlugin.QueryPanel.access$1600(QueryPanel.java:63)
at
com.kiwisoft.sqlPlugin.QueryPanel$ExecutionThread.run(QueryPanel.java:707)
Error while getting primary keys: [SQLServer 2000 Driver for
JDBC]Can't start a cloned connection while in manual transaction mode.



0
Comment actions Permalink

If you disable the option 'Highlight Primary Keys' in the plugins
settings dialog this exception should not occure again. It happens
because I currently use the same connection for executing the query and
getting the database meta data. Some databases don't like this.

--
Stefan.

Vincent Mallet wrote:

Another exception. This one happens every time I run a query it seems like.
The queries return data.

java.sql.SQLException: [SQLServer 2000 Driver for JDBC]Can't
start a cloned connection while in manual transaction mode.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown
Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown
Source)
at com.microsoft.jdbc.base.BaseConnection.getImplConnection(Unknown
Source)
at com.microsoft.jdbc.base.BaseStatement.setupImplConnection(Unknown
Source)
at com.microsoft.jdbc.base.BaseStatement.<init>(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.createStatement(Unknown
Source)
at com.microsoft.jdbc.base.BaseConnection.createStatement(Unknown
Source)
at
com.microsoft.jdbc.base.BaseDatabaseMetaData.getPrimaryKeys(Unknown Source)
at com.kiwisoft.db.Database.getPrimaryKeys(Database.java:401)
at
com.kiwisoft.sqlPlugin.ResultSetTableModel.createData(ResultSetTableModel.ja
va:113)
at
com.kiwisoft.sqlPlugin.ResultSetTableModel.<init>(ResultSetTableModel.java:7
1)
at
com.kiwisoft.sqlPlugin.QueryPanel.executeSelect(QueryPanel.java:605)
at com.kiwisoft.sqlPlugin.QueryPanel.access$1600(QueryPanel.java:63)
at
com.kiwisoft.sqlPlugin.QueryPanel$ExecutionThread.run(QueryPanel.java:707)
Error while getting primary keys: [SQLServer 2000 Driver for
JDBC]Can't start a cloned connection while in manual transaction mode.


0
Comment actions Permalink

Stefan Stiller wrote:

If you disable the option 'Highlight Primary Keys' in the plugins
settings dialog this exception should not occure again. It happens
because I currently use the same connection for executing the query and
getting the database meta data. Some databases don't like this.

--
Stefan.

Vincent Mallet wrote:

>> Another exception. This one happens every time I run a query it seems
>> like.
>> The queries return data.
>>
>> java.sql.SQLException: [SQLServer 2000 Driver for JDBC]Can't
>> start a cloned connection while in manual transaction mode.

That's a problem in Microsofts JDBC driver. Setting the driver property
"SelectMethod" to "cursor" in the URL fixes this, but makes it go slower.

Stefan: Could you please perhaps add explicit support for jTDS
(http://jtds.sourceforge.net/) to the SQL Plugin?

/Kreiger



Attachment(s):
signature.asc
0

Please sign in to leave a comment.