My windows Java version 8 Update 171. I restarted Java and my PC.
C:\Program Files\IBM\SDP\jdk\jre\bin - Java file is Version 8.0.0.0
Maybe I need to try to reinstall my jtds driver in RDi if I can remember where it is.
Thanks for the suggestions
-----Original Message-----
From: WDSCI-L [mailto:wdsci-l-bounces@xxxxxxxxxxxx] On Behalf Of Ken Killian
Sent: Wednesday, April 25, 2018 2:58 PM
To: Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries
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
--
This is the Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries (WDSCI-L) mailing list To post a message email: WDSCI-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/wdsci-l.
midrange.com
