Need to display full SQLException chain
Brought to you by:
mkobold
When displaying a SQLException iSQL-Viewer should
follow the chain of exceptions via
SQLException.getNextException to display all the
related exceptions.
Trying to connect to an Apache Derby database can
result in an SQLException where the usful information
is in one of the chained exceptions. ALl that is seen
by iSQL is something like
[09:28:34] Service connection failed to initialize
(SQLException occured whille attempt to make a
connection to
URL[jdbc:derby:/work/is.test;create=true]... nested
exception (Failed to start database '/work/is.test',
see the next exception for details.))
Logged In: YES
user_id=67341
I do belive i have support for SQLException chains, there
might be a bug in teh defaults, If you could check the JDBC
preferences in the Preferences Editor. (* it is underneath
servicemanger dbl-click to see the section *)
Try setting it a value just do something like clear the text
area, and re-enter the default value, which if i recall is
10. I will still look into why you are not seeing the
chains, but i know i support them, and the code where i
handle it is in the
org.isqlviewer.util.BasicUtilities#handleException method.
Thanks for the input.
Logged In: YES
user_id=1171244
I did see that iSQL-Viewer did follow the exception chain
elsewhere, I think for an error when running a query. But in
this case it was trying to open a connection (Service).