× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



We looked into this about 12 months ago, and we couldn't find an iSeries
JDBC driver for MS Access.  

One alternative (which I'm just guessing here as I've never done it) is
to keep the Java code where it is, and do a SBMRMTCMD from within CL to
run the java remotely.

Let us know how you get on.

-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx [mailto:java400-l-
bounces@xxxxxxxxxxxx] On Behalf Of Colin Williams
Sent: 15 September 2006 13:47
To: Java Programming on and around the iSeries / AS400
Subject: Re: Running java on Iseries

Shane,

"I would like to run this program via a CL Call .  Can I do this?
How?"

You dont need to put the source code on the iseries to run then, just
put
your java classes or jar file containing your classes (either way will
work)
on the IFS. To run your java from CL, use the RUNJVA command. The
first 3
parms on that, CLASS, PARM and CLASSPATH are the ones you need to
worry
about and get right.

One thing to make sure you understand is the distinction between the
PATH
and the PACKAGE when it comes to running your java classes on the IFS.
Your
PATH goes in the CLASSPATH parm and your PACKAGE goes in the CLASS
parm

good luck

cheers
Colin.W



On 15/09/06, Shane_Cessna@xxxxxxx <Shane_Cessna@xxxxxxx> wrote:

Mike,

Why not just use a linked table in Access to do this via ODBC?

Shane




"Smith, Mike" <Mike_Smith@xxxxxxxxxxxxxxxx>
Sent by: java400-l-bounces@xxxxxxxxxxxx
09/15/2006 07:28 AM
Please respond to
Java Programming on and around the iSeries / AS400
<java400-l@xxxxxxxxxxxx>


To
<java400-l@xxxxxxxxxxxx>
cc

Subject
Running java on Iseries






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.

--
This is the Java Programming on and around the iSeries / AS400
(JAVA400-
L)
mailing list
To post a message email: JAVA400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.


--
This is the Java Programming on and around the iSeries / AS400
(JAVA400-
L)
mailing list
To post a message email: JAVA400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.


--
This is the Java Programming on and around the iSeries / AS400
(JAVA400-L)
mailing list
To post a message email: JAVA400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.


This message may contain confidential information and is intended only for the 
individual named. If you are not the named addressee you should not 
disseminate, distribute or copy this e-mail. Please notify the sender 
immediately by e-mail if you have received this e-mail by mistake and delete 
this e-mail from your system. E-mail transmission cannot be guaranteed to be 
secure or error-free as information could be intercepted, corrupted, lost, 
destroyed, arrive late or incomplete, or contain viruses. Although the company 
has taken reasonable precautions to ensure no viruses are present in this 
e-mail, the company cannot accept responsibility for any loss or damage arising 
from the use of this e-mail or attachments. Any views or opinions presented in 
this e-mail are solely those of the author and do not necessarily represent 
those of the company.



As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.