on 04-28-2008 11:28 AM
Hi Iam getting the following jdbc error in my jdbc interface "Error while parsing or executing XML-SQL document: Error processing request in sax parser: Error when executing statement for table/stored proc. 'UDAY' (structure 'STATEMENT'): com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC: DB2ADMIN.UDAY". please correct my error. points will be awarded .
Hi Uday,
Check the action attribute in the JDBC receiver. It should have value as "SELECT".
Check the JDBC payload structure in sxmb_moni
Most probable reason would be the receiver side datatype for JDBC. Recheck with this
http://help.sap.com/saphelp_nw2004s/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm
BestRegards,
Ramesh.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
sqlcode < 0 = execution was not successful
sqlstate 42704 = 'undefined object name'
so it looks like the SQL statement parsed from your XML document failed at DB2 level, cuz it refers an unexisting object name (DB2ADMIN.UDAY ?) or similar
Rgds
Chris
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Uday,
There might be error at your JDBC data type structure.
Please check it.
Regards
Bhanu Tiruveedula
Intelligroup.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.