File 2Jdbc error

[former_member189440]

Hi Friends,

I got a error when doing file 2 jdbc scenario. the error is "Error: TransformException error in xml processor class, rollback:

Error processing request in sax parser: Error when executing statement for table/stored proc. 'miracle' (structure 'statement'): java.sql.SQLException: FATAL ERROR: Column 'empid' does not exist in table 'miracle' "please solve this error for me.

points will be rewarded if useful.

[Former Member]

Hi,

the error is due to the lacking of the column 'empid' in the table "Miracle".

You can try to activate the trace log in the jdbc channel in order to see the sql statements.

Then you can try to execute the statement directly on the DB.

To activate the jdbc log, insert the following setting on the "Additional Parameter":

JDBC Receiver Adapter Parameters

1. Parameter name: "logSQLStatement"

Parameter type: boolean

Parameter value: true for any string value, false only for empty string

Parameter value default: false (empty String)

Available with: SP9

.

Once I had the same problem even if I had the column. I sort it out by recreating the table...

Regards

Emiliano

[Former Member]

Hi,

In ur miracle table there is no field like empid. Check ur jdbc structure once..

Regards,

Soumya

[former_member240483]

U checked u JDBC structure.

Check what ever fields u try to update is exist with the same name in table.

Regards

Rao

[Former Member]

Hi,

Its clearly shows that empid is does not exist in the database table.

check that fist.

Thanks,

Phani

[prateek]

According to the error, ur table miracle does not have field "empid". There is some mismatch in database structure and XI datatype

Regards,

Prateek