Problem:

When you run the DBEXPXLS and DBEXPXLS2 commands, you get the following in the Java error log:
Browse : /rjstemp/JAVASTDOUT-RSISLSWKLC-MFS6MF-959811.TXT(tm)
Record : 1 of 14 by 18 Column : 1 91 by 131
Control :

...+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8....+....9....+....0....+....1....+....2
************Beginning of data**************
Error connecting to JDBC data source.
ava.sql.SQLException: The application server rejected the connection. (Password is *NONE.)
at java.lang.Throwable.<init>(Throwable.java:195)
at java.lang.Exception.<init>(Exception.java:41)
at java.sql.SQLException.<init>(SQLException.java:40)
at com.ibm.as400.access.JDError.throwSQLException(JDError.java:528)
at com.ibm.as400.access.AS400JDBCConnection.setProperties(AS400JDBCConnection.java:2822)
at com.ibm.as400.access.AS400JDBCDriver.prepareConnection(AS400JDBCDriver.java:1240)
at com.ibm.as400.access.AS400JDBCDriver.initializeConnection(AS400JDBCDriver.java:1103)
at com.ibm.as400.access.AS400JDBCDriver.connect(AS400JDBCDriver.java:355)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at com.rjssoft.db.jdbc.JDBCConnection.connect(JDBCConnection.java:53)
at exportdbtoxls1.main(exportdbtoxls1.java:60)

Solution:

On the iSeries, you need to run interactive and batch Java jobs with a user ID that has a password. If you use a user without a password, such as a group user ID, this error occurs when trying to connect to the iSeries database. 
 
Note: When you run native iSeries Java jobs, such as calling a Java class from RPG or CL, you can pass *NONE for the user ID and *NONE for the password, and the job user info is automatically used. This is a unique iSeries feature.

Still have questions? We can help. Submit a case to Technical Support.

Last Modified On: December 10, 2016