|
Thanks for your reply Mark
Like I said in a prior e-mail
This is ALL brand new to me, so apologies top one and for my incessant
questions
Sometimes the penny has to drop 100 miles with me before the light bulb
switches on
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
Mark Murphy
Sent: Thursday, September 14, 2017 9:05 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: RE: Accesssing External Databases
This error is not saying that the jar exists in the classpath variable, it
is saying that the environment variable exists. It is an all or nothing
replacement. You are going to have to read the environment variable,
concatenate what you want to add, and then replace it. Problem is, once the
jvm is started, you can't change the classpath. My CLP that initializes the
jvm sets the whole classpath right from the start all in one shot, and it
includes everything the job could possibly want. I know my machine, and the
Java programs running on it, so I know what needs to be in the classpath up
front.
On Sep 14, 2017 8:28 AM, "Alan Shore" <ashore@xxxxxxxx> wrote:
Hi everyone
I am looking at the ADDENVVAR command
Specifically
ADDENVVAR ENVVAR(CLASSPATH) VALUE('/java/jdbc/jtds-1.3.1.jar')
When I try this, I receive the message
Environment variable name exists.
Taking and F1 on that message, I see
Additional Message Information
Message ID . . . . . . : CPFA980 Severity . . . . . . . : 40
Message type . . . . . : Information
Date sent . . . . . . : 09/14/17 Time sent . . . . . . :
08:17:01
Message . . . . : Environment variable name exists.
Cause . . . . . : You tried to add an environment variable (ADDENVVAR),
'CLASSPATH', of level *JOB, that already exists.
Recovery . . . : Do one of the following:
- Specify the REPLACE(*YES) option to replace the existing value with
the
new value.
- Use the CHGENVVAR command to change the specified environment
variable.
- Retry the command with an environment variable that does not exist.
I then enter the command WRKENVVAR and choose CLASSPATH to display The
following is displayed
Name . . . . . . . . . : CLASSPATH
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:.'
Now if '/java/jdbc/jtds-1.3.1.jar' already exists in the CLASSPATH - how
come I don't see it in the display?
Is it contained within one of these
/QIBM/ProdData/OS400/jt400/lib/jt400Native.jar:
/QIBM/ProdData/OS400/jt400/lib/jt400Native11x.jar:
/QIBM/ProdData/OS400/jt400/MRI2924/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/db2jcc_license_cu.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
From: Alan Shore
Sent: Wednesday, September 13, 2017 7:17 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: RE: Accesssing External Databases
HI Charles
Appreciated
Sent via the Samsung GALAXY S(r) 5, an AT&T 4G LTE smartphone
-------- Original message --------
From: Charles Wilt <charles.wilt@xxxxxxxxx<mailto:charles.wilt@xxxxxxxxx>>
Date: 9/13/17 4:59 PM (GMT-05:00)
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx<mailto:
midrange-l@xxxxxxxxxxxx>>
Subject: Re: Accesssing External Databases Yep, do a 2=Change from
WRKENVVAR
Just tack it into the the end with a : before it...
Charles
On Wed, Sep 13, 2017 at 2:46 PM, Alan Shore <ashore@xxxxxxxx<mailto:ashore
@nbty.com>> wrote:
AGGGGGHHHHHHHHHHHHHHHHHHHHHmailto:
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<mailto: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<
midrange-l@xxxxxxxxxxxx>>
Subject: Re: Accesssing External Databases@nbty.com>> wrote:
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<mailto:ashore
mailto:midrange-l@xxxxxxxxxxxx>>
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<mailto: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<
mailto:charles.wilt@xxxxxxxxx>>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<
ashore@xxxxxxxx>> wrote:wrote:right.
Alan,
Use WRKJVMJOB to look at the JVM in your job...
In particular, the classpath still doesn't seem to be getting set
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<mailto:
mailto:midrange-l@xxxxxxxxxxxx>>
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<mailto: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<mailto:dlclark@xxxxxxxxxxxxxxxx>
Sent: Wednesday, September 13, 2017 3:57 PM
To: Midrange Systems Technical Discussion
<midrange-l@xxxxxxxxxxxx<
midrange-l-bounces@xxxxxxxxxxxx>> wrote on 09/13/2017Subject: RE: Accesssing External Databases
"MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx<mailto:
midrange.com>>03:51:10 PM:
From: Alan Shore <ashore@xxxxxxxx<mailto:ashore@xxxxxxxx>>
To: Midrange Systems Technical Discussion
<midrange-l@xxxxxxxxxxxx<mailto:midrange-l@xxxxxxxxxxxx>>
Date: 09/13/2017 03:51 PM
Subject: RE: Accesssing External Databases Sent by: "MIDRANGE-L"
<midrange-l-bounces@xxxxxxxxxxxx<mailto:midrange-l-bounces@
midrange-l-bounces@xxxxxxxxxxxx>> wrote onon
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
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<mailto:dlclark@xxxxxxxxxxxxxxxx>
Sent: Wednesday, September 13, 2017 11:14 AM
To: Midrange Systems Technical Discussion
<midrange-l@xxxxxxxxxxxx<mailto:midrange-l@xxxxxxxxxxxx>>
Subject: Re: Accesssing External Databases
"MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx<mailto:
called ApPServer4RPG:09/13/2017
10:57:31 AM:
Before I forget, we are on V7r1database
I have been asked to investigate how we can connect to an
external
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)
mailto:transmission.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
************************************************************
*********************************
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L)
mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx<
MIDRANGE-L@xxxxxxxxxxxx> To
midrange.com> Before posting, pleasesubscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email:
MIDRANGE-L-request@xxxxxxxxxxxx<mailto:MIDRANGE-L-request@
any subscription relatedtake a moment to review the archives at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxx<mailto:support@xxxxxxxxxxxx>
for
mailto: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<
MIDRANGE-L@xxxxxxxxxxxx> To
midrange.com> Before posting, pleasesubscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email:
MIDRANGE-L-request@xxxxxxxxxxxx<mailto:MIDRANGE-L-request@
any subscription relatedtake a moment to review the archives at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxx<mailto:support@xxxxxxxxxxxx>
for
MIDRANGE-L@xxxxxxxxxxxx> To subscribe,--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<mailto:
midrange.com> Before posting, please takeunsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx<mailto:MIDRANGE-L-request@
any subscription relateda moment to review the archives at https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxx<mailto:support@xxxxxxxxxxxx> for
MIDRANGE-L@xxxxxxxxxxxx> To subscribe,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<mailto:
midrange.com> Before posting, please takeunsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx<mailto:MIDRANGE-L-request@
any subscription relateda moment to review the archives at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxx<mailto:support@xxxxxxxxxxxx> for
MIDRANGE-L@xxxxxxxxxxxx> To subscribe,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<mailto:
unsubscribe, or change list options,midrange.com> Before posting, please take a
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx<mailto:MIDRANGE-L-request@
moment to review the archives at https://archive.midrange.com/midrange-l.
subscription related
Please contact support@xxxxxxxxxxxx<mailto:support@xxxxxxxxxxxx> for
any
questions.list
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
To post a message email: MIDRANGE-L@xxxxxxxxxxxx<mailto:MIDRANGE-L@xxxxxxxxxxxx>
To subscribe, unsubscribe, or change list options,midrange.com>
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx<mailto:MIDRANGE-L-request@
Before posting, please take a moment to review the archives atsubscription related
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxx<mailto:support@xxxxxxxxxxxx> for
any
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<mailto:
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<mailto:MIDRANGE-L-request@
midrange.com>
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxx<mailto: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
As an Amazon Associate we earn from qualifying purchases.
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.
midrange.com
