Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Receiver JDBC Data Structure

Hi All,

I am trying to insert some data into database using JDBC receiver adapter.

Details:

table Name: testdata.

Fields: DataKey,Data1,Data2.

what should be my xi data structure?

I am created

<JDBC_Insert>

<statementname>

<dbTableName action=”INSERT”>

<table>realDbTableName</table>

<access>

<col1>val1</col1>

<col2>val2new</col2>

</access>

</dbTableName>

</StatementName1>

But I am getting this error:

=======================

Error while parsing or executing XML-SQL document: Error processing request in sax parser: Error when executing statement for table/stored proc. 'testdata' (structure 'statementName'): java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Line 1: Incorrect syntax near ')'.

Ranjeet Singh.

Former Member
Not what you were looking for? View more on this topic or Ask a question