RE: Running java on Iseries

["Smith, Mike" <Mike_Smith@xxxxxxxxxxxxxxxx>]

Thanks Pete, I'll take a look.

Michael Smith
iSeries.mySeries.


-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx
[mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of Pete Helgren
Sent: Friday, September 15, 2006 10:14 AM
To: Java Programming on and around the iSeries / AS400
Subject: Re: Running java on Iseries


"I had to create a system dsn in order to make my connection to the
Access Database.   Will my program running on the ISERIES be able to
access this?  If not how do I overcome this? "

Mike,

A long while back, Joe Pluta posted some open source code in a project 
called OS400Bridge.  You'll still find it here: 
http://sourceforge.net/projects/os400bridge/.  It has pretty good 
examples of how to get data from an Access DB on a PC and display it in 
an RPG program.  The connection is through using the JDBC/ODBC bridge.  
You could modify it to retrieve the data into any kind of program.

It's old but still worth a look.

Pete Helgren


Smith, Mike wrote:
> Hi all.
> I have the task of trying to read several tables from an access
database
> and load the data on the ISERIES.  I asked for suggestions on another
> list and after digesting them, decided that since I had taken a couple
> of Java classes a few years ago(haven't touched it since)  I would
give
> it a go and see if I could accomplish my task.  
>
> I'm happy to say that I have been able to create a java program that 
> does what I need it to do.  I created this in WDSC 6.0
>
> Now that I have it created I have a few things I need to get figured 
> out.
>
> I have created this in WDSC.  How do I get the source and program to 
> the ISERIES.
> I would like to run this program via a CL Call .  Can I do this?  How?

> I had to create a system dsn in order to make my connection to the
> Access Database.   Will my program running on the ISERIES be able to
> access this?  If not how do I overcome this?
>
>
> Thanks for any help you can provide.  
>
> Michael Smith
> iSeries.mySeries.
>
>