Hi Jim,
I would also recommend using stored procedures (RPG and SQL) on the IBMi to give access to the data.
First. It's very fast. You can receive/update parameters and return result sets. We have seen a VAST improvement in data retrieval times.
Second. If they start hard coding libraries and you want to move data around that creates an issue. You can decide where to look. Think of live vs test.
Third. When the data changes via vendor package update or you want to change the layouts, including moving data to another file, you are in control of getting the job done.
This is how I am moving the old MS SQL systems to access the new power 8. Wins all the way around.
There will be complaining about having to go through you when a new process is wanted (your slowing them down) but protecting the data is your responsibility.
Stored Procedures are very easy to do.
-----Original Message-----
From: JAVA400-L [mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of midrange
Sent: Wednesday, September 20, 2017 7:52 PM
To: 'Midrange Systems Technical Discussion'; 'Java Programming on and around the IBM i'
Subject: java prmrs need jdbc access to system
We now have java programmers, with their tooling for unix systems. They want to use jdbc to access our systems, (read, write, update).
They already have various tools (freeware) but so far they don't connect and see a license error messages.
What is the normal (and not expensive way of doing this?
We do have licensing for i Access and I know iNavigator has jdbc option.
All (so far) of this java processes on non-i systems making a request to i for small amounts of data (the web service route is not being considered (lost that argument.).
We already have very extensive Win apps doing same with OLE-DB, but this needs to come from java based unix systems, and their team is coding this.
OS V7R1 (for now..)
Jim Franz
--
This is the Java Programming on and around the IBM i (JAVA400-L) mailing list To post a message email: JAVA400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at
https://archive.midrange.com/java400-l.
Subject to Change Notice:
WalzCraft reserves the right to improve designs, and to change specifications without notice.
Confidentiality Notice:
This message and any attachments may contain confidential and privileged information that is protected by law. The information contained herein is transmitted for the sole use of the intended recipient(s) and should "only" pertain to "WalzCraft" company matters. If you are not the intended recipient or designated agent of the recipient of such information, you are hereby notified that any use, dissemination, copying or retention of this email or the information contained herein is strictly prohibited and may subject you to penalties under federal and/or state law. If you received this email in error, please notify the sender immediately and permanently delete this email. Thank You;
WalzCraft PO Box 1748 La Crosse, WI. 54602-1748
www.walzcraft.com Phone... 608-781-6355
midrange.com
