jt400 4.9. I've tried both Native and non-Native. OS is V5R3. JVM is 1.5.


Coy Krill
Systems Analyst
Whidbey Island Bank 
-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx [mailto:java400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Gary L Peskin
Sent: Wednesday, December 28, 2005 17:26
To: 'Java Programming on and around the iSeries / AS400'
Subject: RE: Running Java Application from Job Scheduler and User Has No P
assword

What version of the toolkit or JT400 are you using?

Gary 

> -----Original Message-----
> From: java400-l-bounces@xxxxxxxxxxxx
> [mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of Coy Krill
> Sent: Wednesday, December 28, 2005 10:41 AM
> To: Java Programming on and around the iSeries / AS400
> Subject: RE: Running Java Application from Job Scheduler and User Has 
> No P assword
> 
> I'm using new AS400().
> 
> Here is the stack trace:
> 
> com.ibm.as400.access.ExtendedIllegalStateException: system: 
> Property is not
> set.                        
>  at java.lang.Throwable.<init>(Throwable.java:196)
> 
>  at java.lang.RuntimeException.<init>(RuntimeException.java:43)
> 
>  at
> java.lang.IllegalStateException.<init>(IllegalStateException.java:38)
> 
>  at
> com.ibm.as400.access.ExtendedIllegalStateException.<init>(Exte
> ndedIllegalSta
> teException.java:170)   
>  at
> com.ibm.as400.access.PrintObjectListImplRemote.checkRunTimeSta
> te(PrintObject
> ListImplRemote.java:253)
>  at
> com.ibm.as400.access.PrintObjectListImplRemote.openSynchronous
> ly(PrintObject
> ListImplRemote.java:484)
>  at
> com.ibm.as400.access.PrintObjectList.openSynchronously(PrintOb
> jectList.java:
> 540)                    
>  at com.wibank.is.cold.UserTest.processQueues(UserTest.java:27)
> 
>  at com.wibank.is.cold.UserTest.run(UserTest.java:19)
> 
>  at com.wibank.is.cold.UserTest.main(UserTest.java:59)
> 
> 
> This error only occurs when the user profile has password *NONE. Here 
> is the code that generated the error. It's a much cutdown version just 
> for demonstrating the error:
> 
> package com.wibank.is.cold;
> 
> import com.ibm.as400.access.AS400;
> import com.ibm.as400.access.SpooledFile; import 
> com.ibm.as400.access.SpooledFileList;
> import static com.ibm.as400.access.PrintObject.*;
> import java.sql.Connection;
> import java.sql.DriverManager;
> import java.util.Enumeration;
> 
> public class UserTest {
>     
>     public UserTest() {
>         this.system = new AS400();
>     }
>     
>     public void run() {
>         this.initializeJDBC();
>         this.processQueues();
>     }
>     
>     protected void processQueues() {
>         try {
>             SpooledFileList splfList = new 
> SpooledFileList(this.system);
>             splfList.setUserFilter("*ALL");
>             splfList.setQueueFilter("/QSYS.LIB/QUSRSYS.LIB/P1.OUTQ");
>             splfList.openSynchronously();
>             Enumeration splfEnum = splfList.getObjects();
>             while (splfEnum.hasMoreElements()) {
>                 SpooledFile splf = (SpooledFile) 
> splfEnum.nextElement();
>                 
> System.err.println(splf.getStringAttribute(ATTR_JOBSYSTEM) + "-" +
>                         splf.getName() + "-" +
>                         splf.getNumber() + "-" +
>                         splf.getJobName() + "-" +
>                         splf.getJobUser() + "-" +
>                         splf.getJobNumber());
>             }
>             splfList.close();
>         } catch (Exception e) {
>             e.printStackTrace();
>             System.exit(0);
>         }
>     }
>     
>     protected void initializeJDBC() {
>         try {
>             DriverManager.registerDriver(
>                     new com.ibm.db2.jdbc.app.DB2Driver());
>             this.dbConnection = DriverManager.getConnection(
>                     "jdbc:db2://localhost");
>         } catch (java.sql.SQLException e) {
>             e.printStackTrace();
>             System.exit(0);
>         }
>     }
>     
>     public static void main(String[] args) {
>         UserTest mainApp = new UserTest();
>         mainApp.run();
>         
>         System.exit(0);
>     }
>     
>     protected AS400 system = null;
>     protected Connection dbConnection = null; }
> 
> Coy Krill
> Systems Analyst
> Whidbey Island Bank
> -----Original Message-----
> From: java400-l-bounces@xxxxxxxxxxxx
> [mailto:java400-l-bounces@xxxxxxxxxxxx]
> On Behalf Of Gary L Peskin
> Sent: Tuesday, December 27, 2005 21:05
> To: 'Java Programming on and around the iSeries / AS400'
> Subject: RE: Running Java Application from Job Scheduler and User Has 
> No Password
> 
> 1. It would help if you sent a full stack trace of the exact exception 
> that you're getting.
> 2. When creating the AS400 object, are you specifying a systemName of 
> "localhost" or using the
> 
>   new AS400()
> 
> constructor?
> 
> If not, what does your AS400 constructor invocation look like?
> 
> Gary
> 
> > -----Original Message-----
> > From: java400-l-bounces@xxxxxxxxxxxx 
> > [mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of Coy Krill
> > Sent: Tuesday, December 27, 2005 6:30 PM
> > To: Java Programming on and around the iSeries / AS400
> > Subject: Running Java Application from Job Scheduler and
> User Has No
> > Password
> > 
> > I've looked through the list and have seen some references
> to problems
> > running jobs with a user profile with *NONE for the
> password, but none
> > of the referenced fixes seems to work for me.
> >  
> > I have a program that manages our spooled files and it
> works just fine
> > when submitted by an interactive job, but when I put the job on the 
> > scheduler and run it using our automation user profile that has 
> > password *NONE, it complains about the fact that the user has a 
> > password of *NONE. At first it was a complaint when using the 
> > cross-platform JDBC driver, so I switched to the native DB2 driver.
> > The next problem was that it didn't have a property set way down in 
> > the SpooledFileList. I traced through the code to where it
> was sending
> > the exception because the system name wasn't set in the
> implementation
> > object. So I tried to force it by making an AS400.FILE connection 
> > early on. That's now where I'm getting the error on the
> password being
> > *NONE. Is there no way to run a java app from the scheduler using a 
> > user profile with no password? I have set the expiration limit to 
> > *NOMAX and that doesn't seem to have helped.
> > 
> > Coy Krill
> > Systems Analyst
> > Whidbey Island Bank
> 
> --
> 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.
> 
> **************************************************************
> **********
> The information in this e-mail is confidential and may be legally 
> privileged. It is intended solely for the addressee.
> Access to this e-mail by anyone else is unauthorized. If you are not 
> the intended recipient, any disclosure, copying, distribution or any 
> action taken or omitted to be taken in reliance on it, is prohibited 
> and may be unlawful.
> **************************************************************
> *********
> --
> 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.

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

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

This mailing list archive is Copyright 1997-2021 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.