RE: JDBCR4 on New IBM i v7r3 -- RPG400-L

Ok, I re-read the presentation and checked the recommended path in IFS and did see the jtds-1.2.5.jar /java/jdbc on my Development system but didn't see it on my Production system. Before the migration/upgrade I checked to see if I could figure out where the jtds-1.2.5.jar was located just in case there was a later version that I may have need to copy to IFS but I didn’t see it but the applications continued to work before the upgrade so I didn’t worry too much and hoped I wouldn’t need to find the location until later.

Thanks for the suggestion.

-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Pete Helgren
Sent: Monday, June 18, 2018 12:17 PM
To: RPG programming on the IBM i (AS/400 and iSeries)
Subject: Re: JDBCR4 on New IBM i v7r3

Until it shows up.... Perhaps you followed Scott's example in his presentation and put them in /java/jdbc ? Might be there....

https://www.scottklement.com/presentations/External%20Databases%20from%20RPG.pdf

Pete Helgren
www.petesworkshop.com
GIAC Secure Software Programmer-Java
Twitter - Sys_i_Geek IBM_i_Geek

On 6/18/2018 8:38 AM, Larenzo Alexander wrote:

Ok, sorry about that, I'm in panic mode. :-) I resent it to JAVA400-L

Thanks

-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of
Vernon Hamberg
Sent: Monday, June 18, 2018 9:36 AM
To: RPG programming on the IBM i (AS/400 and iSeries)
Subject: Re: JDBCR4 on New IBM i v7r3

Lorenzo

There is a Java group here at MIDRANGE.COM - subscribe to that and post your question there to get the best help on this.

Regards
Vern

On 6/18/2018 8:00 AM, Larenzo Alexander wrote:

I hope this is the right forum to find some java help. I'm not too familiar with Java but I'm using the Scott Kement's JDBCR4 to connect to SQL Server 2012 databases. It was working well on our old IBM I v7r1 but this weekend we got a new IBM I machine and upgraded to v7r3 and the applications that are using JDBCR4 seem to not be working. I may just need to set the class path since it's a new machine or I may need a later version of the jTDS driver that I'm using or there may be a later version of JDBCR4.

I'm clueless about what to check as far as Java and JVM so if anyone can point me in the right direction I would greatly appreciate. I've been looking through the IFS to see where I have the jTDS driver but I can't remember where I stored it. Or how to check if my class path is located but I'm about to do some googling and reading but thought I would post this in the meantime..

--
This is the RPG programming on the IBM i (AS/400 and iSeries)
(RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD

--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: http://amzn.to/2dEadiD