Problem:
Java error 0003 occurs when running SPLIFORM command to merge spool file with iForms
Solution:
To troubleshoot, we ran the SPLIFORM command with DSPSTDOUT *YES:
Environment variable added.
Command ended normally with exit status 3.
Link removed.
ERROR: Java errors 00003 occurred while generating report or form. Check
the joblog.
Spool file conversion to report or form failed. Check the job log.
Update the following files:
EDTF STMF('/rjsjava/rjsiforms/sql_server.properties')
sql_server.properties should look like:
#Tue Jan 29 10:27:41 CST 2008
driver_class=com.ibm.as400.access.AS400JDBCDriver
use_native_jdbc=true
ip_address=localhost
schema=RJSTEMP
host_type=iseries
replace_existing_tables=false
driver_manager=jdbc\:mysql
print_exceptions=true
print_info=true
password=
default_label=table created by XMLtoMetaDataFactory
user_id=
EDTF STMF('/rjsjava/rjsiforms/jdbc_connection.properties')
jdbc_connection.properties should look like:
#Mon Jan 21 12:35:14 CST 2008
driver_class=com.mysql.jdbc.Driver
default_input_file=
use_native_jdbc=true
ip_address=localhost
schema=RJSTEMP
host_type=iseries
driver_manager=jdbc\:mysql
parameter_file=
print_exceptions=true
print_info=true
password=
user_id=
default_report_type=-pdf
default_output_name=/outputFile
Creating Backup Copies of the jdbc_connection.properties and sql_server.properties.file
After getting the jdbc_connection.properties file and sql_server.properties files set the way you want them, you can create backup copies of the files in case the original's get corrupted. The following commands can be used to back up the two settings files.
CPY OBJ('/rjsjava/rjsiforms/jdbc_connection.properties') TOOBJ('/rjsjava/rjsiforms/jdbc_connection.properties.bak') REPLACE(*YES)
CPY OBJ('/rjsjava/rjsiforms/sql_server.properties') TOOBJ('/rjsjava/rjsiforms/sql_server.properties.bak') REPLACE(*YES)
Restoring Backup Copies of the jdbc_connection.properties and sql_server.properties.file
If you need to restore the jdbc_connection.properties file and sql_server.properties files from the backup copies, the following commands can be used to restore the two settings files.
CPY OBJ('/rjsjava/rjsiforms/jdbc_connection.properties.bak') TOOBJ('/rjsjava/rjsiforms/jdbc_connection.properties') REPLACE(*YES)
CPY OBJ('/rjsjava/rjsiforms/sql_server.properties.bak') TOOBJ('/rjsjava/rjsiforms/sql_server.properties') REPLACE(*YES)