Welcome, Guest! Log In | Create Account

Tracker: Bugs

5 sql history does not work any more - ID: 2818367
Last Update: Comment added ( nobody )

An executed sql statement is not appended to the sql history, neither with
"Share SQL History" nor without it.

Last used and worked fine version was 2.6.9
Now, used version 3.0.2
Platform: Win XP
Plugin: Informix (IDS on AIX)--but I think that doesn't matter.
Java6: jre-1.6.0_13

Nobody/Anonymous ( nobody ) - 2009-07-08 06:21

5

Open

None

Rob Manning

Unknown

None

Public


Comments ( 5 )




Date: 2009-09-17 07:53
Sender: nobody

Now, I've switched back to 3.0.1 because sql history and multiply select
statements works.

Date: 2009-09-08 12:50
Sender: nobody

Further I recognized that with multiply select statements only the first
one is executed:
select * from a;
select * from b;
select * from c;

... with multiply update/insert/... (all other than select) statements, it
works!?

Date: 2009-08-27 08:04
Sender: nobody

it seems that only select statements aren't added to history,
insert/update/delete are added!?

Date: 2009-08-24 05:46
Sender: nobody

the problem still exists in all cases, every time

Add-on:
Platform: WinXP SP3
Java6: Build 1.6.0_15-b03

Error log (may this belongs to the "Method can be called only once" bug):
SQLState: IX000
ErrorCode: -79782
Colin Bell, Gerd Wagner, Rob Manning and others
2009-08-24 07:32:44,586 [Thread-7] ERROR
net.sourceforge.squirrel_sql.fw.util.DefaultExceptionFormatter - Exception
occurred while formatting: bad position: -1
java.lang.IllegalArgumentException: bad position: -1
at javax.swing.text.JTextComponent.setCaretPosition(Unknown Source)
at
net.sourceforge.squirrel_sql.plugins.syntax.netbeans.NetbeansSQLEntryPanel.setCaretPosition(NetbeansSQLEntryPanel.java:247)
at
net.sourceforge.squirrel_sql.plugins.informix.exception.InformixExceptionFormatter.format(InformixExceptionFormatter.java:108)
at
net.sourceforge.squirrel_sql.fw.util.DefaultExceptionFormatter.format(DefaultExceptionFormatter.java:68)
at
net.sourceforge.squirrel_sql.client.session.MessagePanel.privateShowMessage(MessagePanel.java:262)
at
net.sourceforge.squirrel_sql.client.session.MessagePanel.showMessage(MessagePanel.java:184)
at
net.sourceforge.squirrel_sql.client.session.Session.showMessage(Session.java:1142)
at
net.sourceforge.squirrel_sql.client.session.mainpanel.SQLResultExecuterPanel$SQLExecutionHandler.sqlExecutionWarning(SQLResultExecuterPanel.java:1353)
at
net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.handleWarnings(SQLExecuterTask.java:612)
at
net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.handleAllWarnings(SQLExecuterTask.java:569)
at
net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.processQuery(SQLExecuterTask.java:370)
at
net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.run(SQLExecuterTask.java:210)
at
net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
at java.lang.Thread.run(Unknown Source)
2009-08-24 07:32:44,586 [Thread-7] ERROR
net.sourceforge.squirrel_sql.client.session.MessagePanel -
privateShowMessage: Exception was Database has transactions
java.sql.SQLWarning: Database has transactions
at com.informix.util.IfxWarnMsg.getSQLWarning(IfxWarnMsg.java:125)
at com.informix.util.IfxWarnMsg.getSQLWarning(IfxWarnMsg.java:149)
at com.informix.jdbc.IfxSqliConnect.a(IfxSqliConnect.java:2249)
at com.informix.jdbc.IfxSqliConnect.t(IfxSqliConnect.java:4519)
at com.informix.jdbc.IfxSqliConnect.b(IfxSqliConnect.java:3077)
at com.informix.jdbc.IfxSqliConnect.a(IfxSqliConnect.java:2950)
at com.informix.jdbc.IfxSqli.c(IfxSqli.java:2835)
at com.informix.jdbc.IfxSqli.executeOpenDatabase(IfxSqli.java:2028)
at com.informix.jdbc.IfxSqliConnect.<init>(IfxSqliConnect.java:1608)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown
Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.informix.jdbc.IfxDriver.connect(IfxDriver.java:254)
at
net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:133)
at
net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.execute(OpenConnectionCommand.java:97)
at
net.sourceforge.squirrel_sql.client.mainframe.action.ConnectToAliasCommand$SheetHandler.run(ConnectToAliasCommand.java:280)
at
net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
at java.lang.Thread.run(Unknown Source)
2009-08-24 07:32:44,586 [Thread-7] ERROR
net.sourceforge.squirrel_sql.fw.util.DefaultExceptionFormatter - Exception
occurred while formatting: bad position: -1
java.lang.IllegalArgumentException: bad position: -1
at javax.swing.text.JTextComponent.setCaretPosition(Unknown Source)
at
net.sourceforge.squirrel_sql.plugins.syntax.netbeans.NetbeansSQLEntryPanel.setCaretPosition(NetbeansSQLEntryPanel.java:247)
at
net.sourceforge.squirrel_sql.plugins.informix.exception.InformixExceptionFormatter.format(InformixExceptionFormatter.java:108)
at
net.sourceforge.squirrel_sql.fw.util.DefaultExceptionFormatter.format(DefaultExceptionFormatter.java:68)
at
net.sourceforge.squirrel_sql.client.session.MessagePanel.privateShowMessage(MessagePanel.java:262)
at
net.sourceforge.squirrel_sql.client.session.MessagePanel.showMessage(MessagePanel.java:184)
at
net.sourceforge.squirrel_sql.client.session.Session.showMessage(Session.java:1142)
at
net.sourceforge.squirrel_sql.client.session.mainpanel.SQLResultExecuterPanel$SQLExecutionHandler.sqlExecutionWarning(SQLResultExecuterPanel.java:1353)
at
net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.handleWarnings(SQLExecuterTask.java:612)
at
net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.handleAllWarnings(SQLExecuterTask.java:569)
at
net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.processQuery(SQLExecuterTask.java:370)
at
net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.run(SQLExecuterTask.java:210)
at
net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
at java.lang.Thread.run(Unknown Source)
2009-08-24 07:32:44,586 [Thread-7] ERROR
net.sourceforge.squirrel_sql.client.session.MessagePanel -
privateShowMessage: Exception was Database selected
java.sql.SQLWarning: Database selected
at com.informix.util.IfxWarnMsg.getSQLWarning(IfxWarnMsg.java:125)
at com.informix.util.IfxWarnMsg.getSQLWarning(IfxWarnMsg.java:149)
at com.informix.jdbc.IfxSqliConnect.a(IfxSqliConnect.java:2249)
at com.informix.jdbc.IfxSqliConnect.t(IfxSqliConnect.java:4525)
at com.informix.jdbc.IfxSqliConnect.b(IfxSqliConnect.java:3077)
at com.informix.jdbc.IfxSqliConnect.a(IfxSqliConnect.java:2950)
at com.informix.jdbc.IfxSqli.c(IfxSqli.java:2835)
at com.informix.jdbc.IfxSqli.executeOpenDatabase(IfxSqli.java:2028)
at com.informix.jdbc.IfxSqliConnect.<init>(IfxSqliConnect.java:1608)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown
Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.informix.jdbc.IfxDriver.connect(IfxDriver.java:254)
at
net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:133)
at
net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.execute(OpenConnectionCommand.java:97)
at
net.sourceforge.squirrel_sql.client.mainframe.action.ConnectToAliasCommand$SheetHandler.run(ConnectToAliasCommand.java:280)
at
net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
at java.lang.Thread.run(Unknown Source)
2009-08-24 07:32:44,648 [Thread-7] ERROR
net.sourceforge.squirrel_sql.fw.util.DefaultExceptionFormatter - Exception
occurred while formatting: bad position: -1
java.lang.IllegalArgumentException: bad position: -1
at javax.swing.text.JTextComponent.setCaretPosition(Unknown Source)
at
net.sourceforge.squirrel_sql.plugins.syntax.netbeans.NetbeansSQLEntryPanel.setCaretPosition(NetbeansSQLEntryPanel.java:247)
at
net.sourceforge.squirrel_sql.plugins.informix.exception.InformixExceptionFormatter.format(InformixExceptionFormatter.java:108)
at
net.sourceforge.squirrel_sql.fw.util.DefaultExceptionFormatter.format(DefaultExceptionFormatter.java:68)
at
net.sourceforge.squirrel_sql.client.session.Session.formatException(Session.java:1114)
at
net.sourceforge.squirrel_sql.client.session.mainpanel.SQLResultExecuterPanel$SQLExecutionHandler.sqlExecutionException(SQLResultExecuterPanel.java:1372)
at
net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.handleError(SQLExecuterTask.java:626)
at
net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.run(SQLExecuterTask.java:267)
at
net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
at java.lang.Thread.run(Unknown Source)

Date: 2009-08-04 04:21
Sender: haxwell

I tried this and it worked for me.. The history drop down in 3.0.2 is
directly below the Objects, SQL, and Hibernate tabs that are visible once
you connect to a database. The queries I issued are correctly added to the
drop down, and to the SQL history dialog (second button to the right of the
drop down).

Does this issue occur in all cases? In other words, does it ever work?

I am using Ubuntu with JRE 1.6.0_10-b33. But that shouldn't matter
either..

Log in to comment.




Attached File

No Files Currently Attached

Change

No changes have been made to this artifact.



About SourceForge

Find Software

Develop Software

Community

Help

Copyright © 2009 Geeknet, Inc. All rights reserved. Terms of Use