IDOC to JDBC Scenario error

[Former Member]

Hi All,

I am doing a IDOC to JDBC Scenario.I am done with IR and ID.

The Table in the DB is TABLE1 with Field1 and Field2.

Now when I run thescenario it throws an error ,

2009-03-19 12:41:06 Success INSERT INTO TABLE1 (Field1, Field2) VALUES (KM247850, FINJTIA)

2009-03-19 12:41:06 Error Unable to execute statement for table or stored procedure. 'TABLE1' (Structure 'Statement') due to java.sql.SQLException: [EUDNT038]The name "KM247850" is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted.

But it has successfully generated the SQL Query which I think is perfect.

But whats the error which follows that?

How do I resolve it?

Thanks,

Venu

[Shabarish_Nair · Accepted solution]

(KM247850, FINJTIA)

in your mapping where have you given these values.

Have a look again into your mapping. Maybe you need to rework.

[Former Member]

Hi,

It could be due to wrong structure of JDBC, compare your target structure with this blog..

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30

Regards,

Sarvesh