Re: RDi Data Perspective with JTDS Driver Connection Failed

Don't know if it makes a difference, but I am using this driver:
jdbc42.jar

I use that to call MicroShaft Stored-Procedures using Java...


-Ken Killian-


-----Original Message-----
From: Ken Killian
Sent: Wednesday, April 25, 2018 3:01 PM
To: Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries <wdsci-l@xxxxxxxxxxxx>
Subject: RE: [WDSCI-L] RDi Data Perspective with JTDS Driver Connection Failed

What version of Java are you using?

I had tons of problems with Java-9. So, I went back to Java-8 and my problems went away.

But, I also verify my connections through another client. In my case, I used SquirrelSQL.org. But, any Java software client "should be" able to confirm that the JTDS driver is good.

This of course assumes that you are using the SAME DRIVER in the different clients.

Did you restart RDI? To start a new connection? Just in-case it has an old Java VM running? Just a thought.

RDi typically uses his own version of java. My is located here:
C:\Program Files\IBM\SDP_96\jdk\jre\bin

C:\Program Files\IBM\SDP_96\jdk\jre\bin

java -version

java version "1.8.0"
Java(TM) SE Runtime Environment (build pwa6480sr4fp10-20170727_01(SR4 FP10)) IBM J9 VM (build 2.8, JRE 1.8.0 Windows 10 amd64-64 Compressed References 20170722_357405 (JIT enabled, AOT enabled) J9VM - R28_20170722_0201_B357405 JIT - tr.r14.java_20170722_357405
GC - R28_20170722_0201_B357405_CMPRSS
J9CL - 20170722_357405)
JCL - 20170726_01 based on Oracle jdk8u144-b01

While my windows java is located here:
C:\Program Files\Java\jdk1.8.0_172\bin

java -version

java version "1.8.0_172"
Java(TM) SE Runtime Environment (build 1.8.0_172-b11) Java HotSpot(TM) 64-Bit Server VM (build 25.172-b11, mixed mode)


So, please note that I am RUNNING Java-8, not java-9. I had problems with Java-9, so I do NOT use that...

Hope that helps...


-Ken Killian-

-----Original Message-----
From: WDSCI-L <wdsci-l-bounces@xxxxxxxxxxxx> On Behalf Of Larenzo Alexander
Sent: Wednesday, April 25, 2018 2:49 PM
To: Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries <wdsci-l@xxxxxxxxxxxx>
Subject: Re: [WDSCI-L] RDi Data Perspective with JTDS Driver Connection Failed

I checked and I did had a Java update waiting to be installed so I installed it and restarted my PC hoping that will work but no luck. I'm worried because I believe I'm using the jtds driver in many applications to connect to sql server and if all of sudden they stop working then my "goose is cooked"

Thanks