Skip to Content
0
Former Member
Mar 03, 2009 at 09:43 AM

JDBC error

25 Views

Hi,

As per requirement,there is a source idoc structure imported as XSD..

The target table structure has many fields out of which 1 field 'YY' should contain the entire input IDOC details.

XSLT mapping is being used here.

In the adapter engire , i get the following error:

JDBC Message processing failed, due to Error processing request in sax parser: Error when executing statement for table/stored proc. 'ZZZ_table' (structure 'update_insert'): java.sql.SQLException: FATAL ERROR: Column '' does not exist in table 'ZZZ_table'

I have tried out few debugging:

1.The column name is correct

2. Made dummy change in JDBC adapter config as i added a new field 'XX' in table 'ZZZ_table' as CLOB type for holding entire incoming IDOC

What should be the type of 'YY'? i have declared it as string?