| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Insert into Database Table using Mapping Node |
« View previous topic :: View next topic » |
| Author |
Message
|
| shashivarungupta |
 Posted: Thu Feb 19, 2015 1:37 pm Post subject: Insert into Database Table using Mapping Node |
 |
|
Grand Master
Joined: 24 Feb 2009
Posts: 1343
Location: Floating in space on a round rock.
|
Hi,
A simple transformation action of Insert into db table (Oracle, JDBC Connection), using Mapping node [of Broker v8].
I see an exception (coded below) while insert operation using mapping. I wonder how the Select Keyword is expected at all during Insert Opertaion in a table.
| Code: |
ExceptionList
RecoverableException
File:CHARACTER:F:\build\slot1\S800_P\src\DataFlowEngine\ImbDataFlowNode.cpp
Line:INTEGER:1154
Function:CHARACTER:ImbDataFlowNode::createExceptionList
Type:CHARACTER:ComIbmSOAPInputNode
Name:CHARACTER:V1/MF_DatabaseTest#FCMComposite_1_7
Label:CHARACTER:V1.MF_DatabaseTest.SOAP Input
Catalog:CHARACTER:BIPmsgs
Severity:INTEGER:3
Number:INTEGER:2230
Text:CHARACTER:Node throwing exception
Insert
Type:INTEGER:14
Text:CHARACTER:V1.MF_DatabaseTest.SOAP Input
RecoverableException
File:CHARACTER:F:\build\slot1\S800_P\src\DataFlowEngine\PluginInterface\ImbJniNode.cpp
Line:INTEGER:1253
Function:CHARACTER:ImbJniNode::evaluate
Type:CHARACTER:ComIbmMSLMappingNode
Name:CHARACTER:V1/MF_DatabaseTest#FCMComposite_1_8
Label:CHARACTER:V1.MF_DatabaseTest.Mapping
Catalog:CHARACTER:BIPmsgs
Severity:INTEGER:3
Number:INTEGER:2230
Text:CHARACTER:Caught exception and rethrowing
Insert
Type:INTEGER:14
Text:CHARACTER:V1.MF_DatabaseTest.Mapping
RecoverableException
File:CHARACTER:MbErrorHandler.java
Line:INTEGER:154
Function:CHARACTER:evaluate
Type:CHARACTER:
Name:CHARACTER:
Label:CHARACTER:
Catalog:CHARACTER:BIPmsgs
Severity:INTEGER:3
Number:INTEGER:3947
Text:CHARACTER:Caught BrokerXCIDynamicException
Insert
Type:INTEGER:5
Text:CHARACTER:{V1}:MF_DatabaseTest_Mapping_Insert
Insert
Type:INTEGER:5
Text:CHARACTER:RDBReturn: let $dbinsert1 := jdbc:insert('D7wam', 'insert into SCHEMANAME.TABLENAME1 ', $dbinsert1_var_params, xs:int('0'),false(),'', xs:int('8') )
RecoverableException
File:CHARACTER:MbErrorHandler.java
Line:INTEGER:318
Function:CHARACTER:throwableToMbException
Type:CHARACTER:
Name:CHARACTER:
Label:CHARACTER:
Catalog:CHARACTER:BIPmsgs
Severity:INTEGER:3
Number:INTEGER:3949
Text:CHARACTER:Caught BrokerXCIDynamicException
Insert
Type:INTEGER:5
Text:CHARACTER:java.sql.SQLSyntaxErrorException: ORA-00928: missing SELECT keyword
ORA-00928: missing SELECT keyword
|
Any Suggestion?
_________________
*Life will beat you down, you need to decide to fight back or leave it. |
|
| Back to top |
|
 |
| fjb_saper |
| Posted: Fri Feb 20, 2015 8:51 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
Insert into table1 select [fieldlist | *] from table2 ?? maybe ??
or Insert into table1 (field1, ... , fieldn) Values (value1,...,valuen)
Did you maybe forget the field list? (field1, ... , fieldn) ?
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| shashivarungupta |
| Posted: Fri Feb 20, 2015 11:55 pm Post subject: |
|
|
Grand Master
Joined: 24 Feb 2009
Posts: 1343
Location: Floating in space on a round rock.
|
| fjb_saper wrote: |
Insert into table1 select [fieldlist | *] from table2 ?? maybe ??
or Insert into table1 (field1, ... , fieldn) Values (value1,...,valuen)
Did you maybe forget the field list? (field1, ... , fieldn) ?
|
Nope, I didn't forget the list of mapping fields (..to fields of the table) while Inserting a Row to selected Table... Eventually I tried to insert with "Assign" transformation (with dummy constant values to respective columns) to that Table and it INSERTs a row without that error.
I still couldn't get what was wrong with the mapping when I am simply use "Move" transformation of input message fields to columns of table. 
(Using Mapping, 'Insert' is an easy and simple way where you don't need to write the 'select' statement or there is no option to write 'where' clause while selecting from table)
_________________
*Life will beat you down, you need to decide to fight back or leave it. |
|
| Back to top |
|
|
| shashivarungupta |
| Posted: Sat Feb 21, 2015 12:01 am Post subject: |
|
|
Grand Master
Joined: 24 Feb 2009
Posts: 1343
Location: Floating in space on a round rock.
|
Also, I ran the User Trace after that Exception (during 'Insert' operation) and I could see that there was something (not clear yet) not correct while mapping of input message fields to table's columns, and map was not able to find output message assembly fields (here database table's columns) with the respective input message assembly fields.
(Then after I tried with "Assign" operation which worked). I could only suspect that there would be something wrong with WSDL / Schema Definition which was getting used while mapping as Input Message Assembly .
_________________
*Life will beat you down, you need to decide to fight back or leave it. |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Sat Feb 21, 2015 6:02 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
That would do it... Garbage In Garbage Out...
_________________
MQ & Broker admin |
|
| 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
|
|
|
|
