× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.