|
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 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.