JDBC Adapter

[Former Member]

Hi all,

I have configured the JDBC Adapter with the Data Type as follows:

MAT_TEST

STATEMENT NAME

TEST

action-------INSERT

TABLE----

---

(Constant)MATTEST

access

MATTEST.......

I am getting the following error:

Error: TransformException error in xml processor class: Error processing request in sax parser: Error when executing statement for table/stored proc. 'MATTEST' (structure 'STATEMENTNAME'): java.sql.SQLException: [SQL0204] MATTEST in SAPUSER type *FILE not found.

The DB I am using is the DB2 iseries.

The File name is MATTEST,Memeber is MATTEST and Field is MATTEST.

I am sending as a Flat file to the DB by concatenation in the Message mapping.

Can anyone tell me the reason for the error?

Thank you,

Joslyn.

[Former Member · Accepted solution]

Hi ,

Check wether your table MATTEST is accessible.and also use this structure..

<root>

<Statement>

<dbTableName action=”INSERT”>

<table>realDbTableName</table>

<access>

<col1>val1</col1>

<col2>val2</col2>

</access>

</dbTableName>

</Statement>

</root>

sekhar

[Former Member · Accepted solution]

Hi Sekhar,

The dbTablename action was declared wrong.The problem is solved.

Thank you and I appreciate your help.

Joslyn.