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