| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| [Solved] Data Insert Node Issue |
« View previous topic :: View next topic » |
| Author |
Message
|
| elvis_gn |
 Posted: Wed Sep 21, 2005 2:20 am Post subject: [Solved] Data Insert Node Issue |
 |
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi,
I am trying to enter a row of data into an Oracle database. I am using the Data Insert node...all seems to be ok, i got the table from th list and imported it into the workspace...
I have finished mapping the input-->output fields.....
On running the flow the input fields are all populated and reach the node....an exception is thrown which says that NULL value cannot be passed to the field "Datasource.Table.Field"
Has anyone faced this issue ??
WBIMB v5.0.4
Oracle9i
Windows 2000 Prof.
Regards.
Last edited by elvis_gn on Wed Sep 21, 2005 3:51 am; edited 1 time in total |
|
| Back to top |
|
 |
| Ian |
| Posted: Wed Sep 21, 2005 2:48 am Post subject: |
|
|
Disciple
Joined: 22 Nov 2002
Posts: 152
Location: London, UK
|
Your description here suggests that you have not combined the mappings in the DataInsert node to apply to the same row.
If mappings are not combined to apply to one row then an individual INSERT statement will be generated for every column mapping.
If any of the columns is defined to have NOT NULL, then this will lead to a database error indicating that a NULL value cannot be inserted.
For example, if a table has 2 columns but you only insert a value into one of them then the other will be assigned the value NULL.
Refer to the v5 topic "ar00870_" for a further information on combining mappings into one row.
_________________
Regards, Ian |
|
| Back to top |
|
|
| elvis_gn |
| Posted: Wed Sep 21, 2005 3:51 am Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
| Thanks a lot.Got it working. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
