|
Your mail client is wrapping your email message as about 50 characters. The very short lines makes your messages hard to read. Suggest that you change it to 75 or larger or that you type in a mail window only 50 characters wide so that you can see what your mail will look like and format accordingly. Richard Jackson mailto:richardjackson@richardjackson.net http://www.richardjacksonltd.com Voice: 1 (303) 808-8058 Fax: 1 (303) 663-4325 -|-----Original Message----- -|From: owner-java400-l@midrange.com -|[mailto:owner-java400-l@midrange.com]On Behalf Of Madhavan -|Sent: Tuesday, October 10, 2000 11:26 AM -|To: java400-L@midrange.com -|Subject: QSQROUTE errors while processing XML on As400 -| -| -|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 -|+--- +--- | 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 +---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
