How to Hardcode sender JDBC action node as EXECUTE

[Former Member]

Hi ,

I have JDBC to File scenario ,please suggest me how to hardcode sender JDBC structure nodes <b>action</b> as "EXECUTE" and <b>table</b> as "ST_PROS.Get_Table" while designing the message mapping.

[MichalKrawczyk]

hi,

use funciton type : constant

double click on it and write inside: ST_PROS.Get_Table"

then connect to action

Regards,

michal

[Former Member]

Hi michal,

Thanks for reply, but i guess i need to define in the comunication channel under processing parameters in the "query SQL statement" if the structure is JDBC sender instead of defining in the message mapping .I guess i am not wrong.

Raju

[bhavesh_kantilal]

Raju,

In the ase of sendrer JDBC adapters you need to provide the SQL Query in the adapter.

Also, the document name and document namespace will be the values for the Message Type Name and MessageTypeNamespace.

The Messagetype youcreate will have to be of this format,

<MESSAGETYPENAME>

<row> <b> 0 to unbounded</b>

<ColumnName1> </ColumnName1>

<ColumnName2> </ColumnName2>

</row

</MESSAGETYPENAME>

if your select query is

Select name,empno from emptable;

the datatype will be,

<MESSAGETYPENAME>

<row> <b> 0 to unbounded</b>

<name> </name>

<empno> </empno>

</row

</MESSAGETYPENAME>

Regards

Bhavesh

[Former Member]

Thanx Bhavesh, u r right i followed ur method .

Raju

[bhavesh_kantilal]

Hi Raju,

Please close the thread if the problem is solved. It would help anyone reading this thread identify the correct answer in this case.

Regards

Bhavesh