RE: Running Java Application from Job Scheduler and User Has No Password -- JAVA400-L

Hi, Coy --

I'm sorry that I don't have more time to help you further.  However, after
glancing at the code, it seems that this request is going through the AS400
Network Print server which is one of the iSeries Access servers.   There
does not seem to be a native optimization for this request so, to connect to
the server, you always need a user id and password, I believe.

My recommendation is to use a gibberish password that no one will know to
prevent stray logins.

HTH,
Gary

> -----Original Message-----
> From: java400-l-bounces@xxxxxxxxxxxx 
> [mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of Coy Krill
> Sent: Wednesday, December 28, 2005 6:27 PM
> To: Java Programming on and around the iSeries / AS400
> Subject: RE: Running Java Application from Job Scheduler and 
> User Has No Password
> 
> 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.
> --
> 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.
> 
>