JDBC receiver error: field not exist in the table

[Former Member]

But the field does exist.

Columns Name Data Type Size Scale Not NULL Default Value

EMPID VARCHAR2 10

EMPNAME VARCHAR2 30

EMPAGE VARCHAR2 3

FLAG VARCHAR2 1

The Database is Oracle.

Message processing failed. Cause: com.sap.aii.af.ra.ms.api.RecoverableException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'emp' (structure 'Statement1'): java.sql.SQLException: FATAL ERROR: Column 'flag' does not exist in table 'emp'.

[Former Member]

It works fine after I capitalized the field names.

For SQl Server the field names is not case sensitive.

But we use Oracle now.

[dharamveer_gaur2]

Does it have the field flag?? XI is case sensitive!!Check you have the correct spelling and case.

Even if not workig use this same thread

Edited by: Dharamveer Gaur on Oct 10, 2008 7:56 AM

[dharamveer_gaur2]

Once again check your table field, and manualy insert few row and again check.