#1405 v3.9.0 v4.0.0 exception using DB2 Driver because it's called in worst mode by java code

[SkyBlackHawk]

Good morning,
when launch in windows10 x64 and jdk 7, 8, 9, 10, 11, 12 when Squirrel try to connect to DB2 using the Driver go out the below exception:
Exception occurred dispatching Event java.awt.event.InvocationEvent[INVOCATION_DEFAULT,runnable=net.sourceforge.squirrel_sql.fw.util.TaskThreadPool$MyCallback$1@3e478838,notifier=null,catchExceptions=false,when=1569576100813] on sun.awt.windows.WToolkit@27c82efd

Please to fix this bug, read this article about this error to fix the exception on Squirrel SQL 3.9.0 and 4.0.0.

Kind regards

[Gerd Wagner]

Could you please post the link to the article you mentioned.

Thanks
Gerd

[SkyBlackHawk]

Please fix it, catching the exception and refresh schema catching.
Users - 3.1.1 broken for me
|
|
|
| | |

|

|
|
| |
Users - 3.1.1 broken for me

3.1.1 broken for me. Just got the notice to upgrade to 3.1.1 on Windows XP. As soon as I type into the editor it starts throwing repeated errors, and I'm unable to execute any...
| |

|

|

Thanks a lot

Inviato da Yahoo Mail su Android

Il Mer, 9 Ott, 2019 alle 22:33, Gerd Wagnergerdwagner@users.sourceforge.net ha scritto:
Could you please post the link to the article you mentioned.

Thanks
Gerd

[bugs:#1405] v3.9.0 v4.0.0 exception using DB2 Driver because it's called in worst mode by java code

Status: open
Group: SQuirreL
Labels: DB2 driver exception sun.io.bytetocharconverter
Created: Fri Sep 27, 2019 09:31 AM UTC by SkyBlackHawk
Last Updated: Fri Sep 27, 2019 09:31 AM UTC
Owner: nobody

Good morning,
when launch in windows10 x64 and jdk 7, 8, 9, 10, 11, 12 when Squirrel try to connect to DB2 using the Driver go out the below exception:
Exception occurred dispatching Event java.awt.event.InvocationEvent[INVOCATION_DEFAULT,runnable=net.sourceforge.squirrel_sql.fw.util.TaskThreadPool$MyCallback$1@3e478838,notifier=null,catchExceptions=false,when=1569576100813] on sun.awt.windows.WToolkit@27c82efd

Please to fix this bug, read this article about this error to fix the exception on Squirrel SQL 3.9.0 and 4.0.0.

Kind regards

Sent from sourceforge.net because you indicated interest in https://sourceforge.net/p/squirrel-sql/bugs/1405/

To unsubscribe from further messages, please visit https://sourceforge.net/auth/subscriptions/

[SkyBlackHawk]

Pardon I forget to write the page to fix the problem:
https://www-01.ibm.com/support/docview.wss?uid=swg1IC74895

I found that the IBM DB2 latest Driver 11.5.0.0 is incompatible with Java8 so we can't see the Object tab because use these default classes but it was deleted from Java 8 (read the link).

I searched in jcc-1.5.0.0.jar IBM DB2 LATEST driver and the sun.io,ByteToCharConverter class is used in files list as in attached screenshot.

[SkyBlackHawk]

Using latest driver 11.5 jdbc type 4 DB2 called jcc-11.5.0 in mavenrepository it works fine with 3.8.0 because this version use java 7.

[Gerd Wagner]

This is a database / JDBC driver specific problem and won't be fixed by SQuirreL.
But according to https://www-01.ibm.com/support/docview.wss?uid=swg1IC74895 it can be easyly fixed by adding the parameter "-Ddb2.jcc.charsetDecoderEncoder=3" on the command line.
For example if you are using windows please edit squirrel-sql.bat change the line

start "SQuirreL SQL Client" /B "%LOCAL_JAVA%" -Dsun.awt.nopixfmt=true -Dsun.java2d.noddraw=true -cp %CP% -splash:"%SQUIRREL_SQL_HOME%/icons/splash.jpg" net.sourceforge.squirrel_sql.client.Main %TMP_PARMS%

to

start "SQuirreL SQL Client" /B "%LOCAL_JAVA%" -Ddb2.jcc.charsetDecoderEncoder=3 -Dsun.awt.nopixfmt=true -Dsun.java2d.noddraw=true -cp %CP% -splash:"%SQUIRREL_SQL_HOME%/icons/splash.jpg" net.sourceforge.squirrel_sql.client.Main %TMP_PARMS%