RE: Accesssing External Databases -- MIDRANGE-L

AGGGGGHHHHHHHHHHHHHHHHHHHHH
Ye gods

Didn't even see THAT

So I entered this command
ADDENVVAR ENVVAR(CLASSPATH) VALUE('/java/jdbc/jtds-1.3.1.jar')
And it came back with this message
Environment variable name exists.
When I use the command WRKENVVAR and take the option to display CLASSPATH, it shows

Value . . . . . . . . . : '/QIBM/ProdData/OS400/jt400/lib/jt400Native.jar:/QI
BM/ProdData/OS400/jt400/lib/jt400Native11x.jar:/QIBM/ProdData/OS400/jt400/MRI292
4/jt400Mri.jar:/QIBM/ProdData/Java400/ext/IBMmisc.jar:/QIBM/ProdData/Java400/ext
/db2_classes.jar:/QIBM/ProdData/Java400/ext/jssl.jar:/QIBM/ProdData/Java400/ext/
ibmjssl.jar:/QIBM/ProdData/Java400/ext/db2jcc.jar:/QIBM/ProdData/Java400/ext/db2
jcc_license_cu.jar:.'

Is there a limit as to what is in the CLASSPATH?

Should I use the option 2 to change the value?
Is it just a case of inserting at the end?

What value needs to be inserted there for VALUE('/java/jdbc/jtds-1.3.1.jar')

Alan Shore
E-mail : ASHORE@xxxxxxxx
Phone [O] : (631) 200-5019
Phone [C] : (631) 880-8640
'If you're going through hell, keep going.'
Winston Churchill

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Charles Wilt
Sent: Wednesday, September 13, 2017 4:36 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: Re: Accesssing External Databases

Alan,

I copied & pasted the command you had in your message.

The file is jtds

The command you had in your post is jdts..

Either you copied & pasted wrong, or you have a type on the command.

And in answer to your other question, yes WBOHQECDB01 needs to resolve.
Preferably via DNS as opposed to a host table entry.

Charles.

On Wed, Sep 13, 2017 at 2:27 PM, Alan Shore <ashore@xxxxxxxx> wrote:

Hi Charles
When I look in the ifs directory
/java/jdbc
The jar file is out there as
jtds-1.3.1.jar

So I believe my command is correct

Alan Shore
E-mail : ASHORE@xxxxxxxx
Phone [O] : (631) 200-5019
Phone [C] : (631) 880-8640
'If you're going through hell, keep going.'
Winston Churchill

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
Charles Wilt
Sent: Wednesday, September 13, 2017 4:18 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: Re: Accesssing External Databases

typo s/b
jtds-1-3-1.jar

but you show
3. I executed the command
ADDENVVAR ENVVAR(CLASSPATH) VALUE('/java/jdbc/jdts-1.3.1.jar')

Charles

On Wed, Sep 13, 2017 at 2:16 PM, Charles Wilt <charles.wilt@xxxxxxxxx>
wrote:

Alan,

Use WRKJVMJOB to look at the JVM in your job...

In particular, the classpath still doesn't seem to be getting set right.

Note, it's
jtds-1.1.1.jar

not
jdts-1.3.1.jar

that you have shown in your post ADDENVVAR post :)

Charles

On Wed, Sep 13, 2017 at 2:08 PM, Alan Shore <ashore@xxxxxxxx> wrote:

Hi Dave
I noticed that as well
I thought that I was just being ignored Im used to being ignored -
Im married

Alan Shore
E-mail : ASHORE@xxxxxxxx
Phone [O] : (631) 200-5019
Phone [C] : (631) 880-8640
'If you're going through hell, keep going.'
Winston Churchill

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf
Of dlclark@xxxxxxxxxxxxxxxx
Sent: Wednesday, September 13, 2017 3:57 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: RE: Accesssing External Databases

"MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx> wrote on 09/13/2017
03:51:10 PM:

From: Alan Shore <ashore@xxxxxxxx>
To: Midrange Systems Technical Discussion
<midrange-l@xxxxxxxxxxxx>
Date: 09/13/2017 03:51 PM
Subject: RE: Accesssing External Databases Sent by: "MIDRANGE-L"
<midrange-l-bounces@xxxxxxxxxxxx>

Thanks for your reply Dave
Just found out about that, less than 20 minutes ago'I will need
to investigate it

Alan Shore

What is strange is that, as you can see, I sent my message
at
11:15 AM this morning but it apparently took until 3:51 PM to appear on
the list. Sorry you had to wait so long for this information. ;-)

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On
Behalf Of dlclark@xxxxxxxxxxxxxxxx
Sent: Wednesday, September 13, 2017 11:14 AM
To: Midrange Systems Technical Discussion
<midrange-l@xxxxxxxxxxxx>
Subject: Re: Accesssing External Databases

"MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx> wrote on
09/13/2017
10:57:31 AM:

Before I forget, we are on V7r1

I have been asked to investigate how we can connect to an
external

database

Google search presented the following web page
http://www.scottklement.com/jdbc/

That is one method. We went a different route -- because
it allowed us to use standard embedded SQL in our RPG programs
and is better for performance because it prestarts a shared JVM
for all jobs to use. We downloaded a free, Source Forge project
from one of the members of this list (Dieter) called ApPServer4RPG:
https://sourceforge.net/projects/appserver4rpg/

Sincerely,

Dave Clark
--
int.ext: 91078
direct: (937) 531-6378
home: (937) 751-3300

Winsupply Group Services
3110 Kettering Boulevard
Dayton, Ohio 45439 USA
(937) 294-5331

************************************************************
*********************************
This email message and any attachments is for use only by the named
addressee(s) and may contain confidential, privileged and/or
proprietary information. If you have received this message in
error, please immediately notify the sender and delete and destroy
the message and all copies. All unauthorized direct or indirect use
or disclosure of this message is strictly prohibited. No right to
confidentiality or privilege is waived or lost by any error in

transmission.

************************************************************
*********************************
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L)
mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To
subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please
take a moment to review the archives at
https://archive.midrange.com/midrange-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 Midrange Systems Technical Discussion (MIDRANGE-L)
mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To
subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please
take a moment to review the archives at
https://archive.midrange.com/midrange-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 Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at https://archive.midrange.com/midrange-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 Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at
https://archive.midrange.com/midrange-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 Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at https://archive.midrange.com/midrange-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