RE: java prmrs need jdbc access to system

The jt400.jar should provide the JDBC they need. It's included in IBMi.



-----Original Message-----
From: midrange [mailto:franz9000@xxxxxxxxx]
Sent: Wednesday, September 20, 2017 7:52 PM
To: 'Midrange Systems Technical Discussion' <midrange-l@xxxxxxxxxxxx>; 'Java Programming on and around the IBM i' <java400-l@xxxxxxxxxxxx>
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