Error 1 when calling DBEXPXLS or DBEXPXLS2 or SMTPDB2 to convert a file to XLS
From Support
| If you have a question or seek clarification, please call Technical Support. |
[edit]
Problem:
The following Java error log is created when running the DBEXPXLS and DBEXPXLS2 commands:
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)
[edit]
Solution:
On the iSeries, interactive and batch Java jobs must be run using a user ID that has a password. If a user without a password such as a group user ID is used when running Java jobs then the above error may occur when trying to connect to the iSeries database.
Note: When running native iSeries jobs such as calling a java class from RPG or CL, we normally pass *NONE for the user ID and *NONE for the passsword on native Java jobs and the job user info is automatically used. This is a unique iSeries feature.
