JDBC ERROR

[Former Member]

I configured Receiver JDBC.In mapping i gave STATEMENT/TABLENAME ACTION= INSERT.

i got the below error:

"

error executing the statement for table....java.sql.SQL>Exception: ORA-00928: missing SELECT keyword."

why it is searching for SELECT as i gave INSERT and its receiver adapter.

Experts you are required.....

Thanks

Prabhakar

[dharamveer_gaur2 · Accepted solution]

First ensure your structure is correct format

<StatementName>

<dbTableName action=”INSERT”>

<table>realDbTableName</table>

<access>

<col1>val1</col1>

<col2>val2</col2>

</access>

</dbTableName>

</StatementName>

now Mapping

Map Constant[] to StatementName

Map ConstantI NSERT to action

access field Make sure its same level as of Table

Also go through this blog:

[Former Member]

thnx

[Former Member]

> I configured Receiver JDBC.In mapping i gave STATEMENT/TABLENAME ACTION= INSERT.

Hi,

Make sure your are using the right case (upper or lower case) for the above mentioned fields & nodes in you mapping...

Compare the fields & node name as given in this blog they should be exactly same.

action & access should be in lower case & TABLE should be used instead of TABLENAME.

Regards,

Sarvesh

[Former Member]

Thanks guys for your response..I finally solved .Mistake i did was ACCESS TAG is equ to STATEMENT.Once i changed it ..working fine..

Thanks

Prabhakar

[Former Member]

HI Venkat,

First check with Insert statement in the Oracle with payload values. If you are inserting success fully then check once once your generated Target structure.

Go throgh the following links.

Regards

Goli Sridhar

[Former Member]

what is your sender? is it JDBC?

[Former Member]

sender is file