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

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