Recent changes to bugs

Can't save partial JDBC connections

2012-06-06T18:23:13Z

Consider this scenario...

1) select File->New->Database Service
2) start setting things up
3) realize that an import bit of information needed is not currently available, say the JDBC class path
4) try to save all the lengthy stuff you've already typed, but you can't and the service is abandoned, requiring you to type it all in again

Suggestion:

Allow services to be saved into the list in a partially setup format. Use an icon or other visual display to indicate to the user that they need to complete the process, if they want.

iSQL allows Disconnect without connection

2012-06-06T18:20:18Z

New to iSQL here. While exploring the UI, I selected Services->Disconnect. I assume this menu item should only be active if there is an active connection, which there isn't. So I got a...

java.lang.NullPointerException
at org.isqlviewer.ui.JdbcWorkbench.handleServiceDisconnect(JdbcWorkbench.java:608)
at org.isqlviewer.ui.JdbcWorkbench.actionPerformed(JdbcWorkbench.java:294)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.isqlviewer.swing.action.SwingEventManager$EventLoop.delegateEvent(SwingEventManager.java:340)
at org.isqlviewer.swing.action.SwingEventManager$EventLoop.run(SwingEventManager.java:319)
at java.lang.Thread.run(Thread.java:680)

iSQL-Viewer hangs in 1st opening

2010-03-17T18:48:13Z

Every 1st time I open iSQL-Viewer, it hangs when I execute the 1st SQL. After restarting iSQL-Viewer, everything works fine.

NullPointerException in JdbcWorkbench

2009-11-11T21:14:36Z

I'm trying to connect to a Service I created for the HXTT MS Access driver. I know the MDB file is OK, because I can browse it elsewhere. I was able to create the Service and when I connect, it brings up the login dialog. After I fill that out, I get the following:

[13:06:58] Initializing iSQL-Viewer (3.0.0).
[13:06:58] Using Java Runtime Environment 1.5.0_20 (1.5) provided by 'Apple Inc.'.
[13:06:59] iSQL-Viewer has been successfully initialized.
[13:07:12] Warning the preferred schema:'' is not valid for this connection.
[13:07:12] error dispatching event
java.lang.NullPointerException
at org.isqlviewer.ui.JdbcWorkbench.buildCatalogMenu(JdbcWorkbench.java:1470)
at org.isqlviewer.ui.JdbcWorkbench.changeConnection(JdbcWorkbench.java:697)
at org.isqlviewer.ui.JdbcWorkbench.actionPerformed(JdbcWorkbench.java:290)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:592)
at org.isqlviewer.swing.action.SwingEventManager$EventLoop.delegateEvent(SwingEventManager.java:340)
at org.isqlviewer.swing.action.SwingEventManager$EventLoop.run(SwingEventManager.java:319)
at java.lang.Thread.run(Thread.java:613)

I'm assuming the message about the preferred schema is not relevant. Access doesn't have any such concept. Why is iSQL-Viewer asking for one?

Let me know if I can provide any other information. dlamet@yahoo.com

Thanks, Dan

setHoldability not supported by Sybase jConnect

2008-10-09T14:22:41Z

Hi,

On disconnecting, the following exception occurs with my Sybase jConnect driver:

com.sybase.jdbc3.utils.UnimplementedOperationException: La méthode com.sybase.jdbc3.jdbc.SybConnection.setHoldability(int) ne s'est pas achevée et n'aurait pas dû être appelée.

Apparently, even in the last jConnect version 6.05, this method is not implemented (see http://www.sybase.com/detail?id=1037380\).

The problem is I cannot change from one connection to another, due to this exception.

I use iSQL-Viewer 3.0.0.

Thanks,

SQL Server

2008-02-12T15:58:37Z

hi,

Seem to be having an issue when i try to configure the connection to my database on SQL Server the error is...
Unable to properly load the class:'com.microsoft.jdbc.sqlserver.SQLServerDriver' using the current classpath, please your classpath settings and try again

I figured that this may be a issue with my system but another application that lso uses jdbc for connection orks just fine...

Help...

3.0.1 Browsing Schema Not Working

2007-08-06T21:39:33Z

Using sybase jConnect 5_5.
When Browsing Schema, only the System Table displays. Nothing esel. It doesn't matter which Schema I attempt to view.

Prefer the 3.0.1 interface over the 2.1.8, so hope this can be resolved, soon. Can you let me know?

Cannot quit program when sql query is too long

2007-06-06T21:35:12Z

When closing the program via the 'File'->'Exit iSQL-viewer' menu item it gives me the following error stacktrace:

Note that the query that I was working on was 53395 characters long. (793 lines)

So it doesn't actually exit because it can't save the history?

Java 1.6 on Windows 2000

[14:25:45] error dispatching event
java.lang.IllegalArgumentException: Value too long: [53395 character sql query here]
at java.util.prefs.AbstractPreferences.put(Unknown Source)
at org.isqlviewer.ui.JdbcWorkbench.disposeView(JdbcWorkbench.java:468)
at org.isqlviewer.ui.ApplicationFrame.processWindowEvent(ApplicationFrame.java:92)
at java.awt.Window.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at org.isqlviewer.ui.JdbcWorkbench.actionPerformed(JdbcWorkbench.java:225)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.isqlviewer.swing.action.SwingEventManager$EventLoop.delegateEvent(SwingEventManager.java:340)
at org.isqlviewer.swing.action.SwingEventManager$EventLoop.run(SwingEventManager.java:319)
at java.lang.Thread.run(Unknown Source)

Machine Reboot on Exit

2006-08-08T09:43:27Z

When closing the application via the File menu the
system closes down no problem. However, when using
the X button at the top right on the Title bar it
actually reboots the machine. I am using version
2.1.8 and it is running under Windows 2000

http://www.isqlviewer.com/install.html

2006-02-17T21:00:47Z

http://www.isqlviewer.com/install.html

the new Link for "IBM BSF is the Bean Scripting
Framework" is:

http://jakarta.apache.org/bsf/