on 11-11-2008 4:49 AM
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
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:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
thnx
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
> 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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
what is your sender? is it JDBC?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.