cancel
Showing results for 
Search instead for 
Did you mean: 

JDBC Error

former_member189440
Participant
0 Kudos

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 .

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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.

Answers (3)

Answers (3)

Former Member
0 Kudos

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

former_member556603
Active Contributor
0 Kudos

Vuday,

Go through this links,

Thanks,

Satya Kumar

Former Member
0 Kudos

Hi Uday,

There might be error at your JDBC data type structure.

Please check it.

Regards

Bhanu Tiruveedula

Intelligroup.