QSQROUTE errors while processing XML on As400

[Madhavan <seawolf00@xxxxxxxxx>]

Hi , 

I am running a batch stress test process on AS400
v4r4m0 with about 100 xml document objects to be
processed. The process briefly described as below is

> XML request objects are passed from a Windows NT
caller
> Servlet on AS400 gets the request (XML document
object)
> Spins off the object to another thread object which
parses the XML and writes to database
> Uses Type II driver and implements IBM Con Pooling

JDBC Connection parameters are:

PoolName : JdbcDb2
Max Cons : 30
Min Cons : 10 
Con Time Out :2000
Max Age  : 300
Max Idle time :600
Reap time :180

The errors we get are : 

Suddenly in the middle of processing, I see this error
in the QTMHHTTP job (which is on CNDW on the AS400)

" 
Program does not include SQL statements.              
                    
Application error.  SQL7903 unmonitored by QSQCLI at
statement 0000004050, 
  instruction X'0000'.                           
                        
Pointer not set for location referenced.  "           
                      
When I see the detailed job log, the description is 

"                        Additional Message
Information                       
                                                      
                      
Message ID . . . . . . :   SQL7903                    
                      
Date sent  . . . . . . :   10/09/00      Time sent  .
. . . . . :   20:35:54 
                                                      
                      
Message . . . . :   Program does not include SQL
statements.                 
                                                      
                      
Cause . . . . . :   QSQROUTE program has been called,
but the calling program
  is not a valid precompiled SQL program.  The
QSQROUTE program can only be  
  called by a program that has been created through
the SQL precompiler.     
  Programs created using the non-Integrated Language
Environment (ILE)       
  commands must have been precompiled using the
non-ILE SQL commands.  Module
  created or bound using the Integrated Language
Environment (ILE) commands  
  must have been precompiled using the ILE SQL
commands.                     
Recovery  . . . :   Remove the call to QSQROUTE
program.  If SQL statements  
  need to be processed, use the CRTSQLRPG, CRTSQLCBL,
CRTSQLFTN, or CRTSQLPLI
  commands for non-ILE programs. To process SQL
statements in the Integrated 
  Language Environment, use the CRTSQLCI, CRTSQLCBLI
or CRTSQLRPGI commands. "

And 

"Message ID . . . . . . :   CEE9901                   
                         
Date sent  . . . . . . :   10/09/00      Time sent  .
. . . . . :   20:35:54   
                                                      
                        
Message . . . . :   Application error.  SQL7903
unmonitored by QSQCLI at       
  statement 0000004050, instruction X'0000'.          
                        
                                                      
                        
Cause . . . . . :   The application ended abnormally
because an exception      
  occurred and was not handled.  The name of the
program to which the          
  unhandled exception is sent is QSQCLI SQLPR
SQLPrepare. The program was      
  stopped at the high-level language statement
number(s) 0000004050 at the     
  time the message was sent.  If more than one
statement number is shown, the  
  program is an optimized ILE program.  Optimization
does not allow a single   
  statement number to be determined.  If *N is shown
as a value, it means the  
  real value was not available.                       
                        
Recovery  . . . :   See the low level messages
previously listed to locate the 
  cause of the exception.  Correct any errors, and
then try the request again. "

After this , there is a java.lang.unknown error. 

Can somebody please tell me what is happening ? 

Regards
madhavan














__________________________________________________
Do You Yahoo!?
Get Yahoo! Mail - Free email you can access from anywhere!
http://mail.yahoo.com/
+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---