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)

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

Last Modified On: December 10, 2016