JDBC mapping

[Former Member]

Hi all,

I have a scenario whr i have five fields number1 ,number2 , number3,number4,number5 in my source which i have to map to only one field telephone in the target structure such that it will create five diiff insert statements ....i.e. insert five diff numbers for a dealer.( Databse is designed in such a manner).

How can i do it?

Regards,

Vinithra

[Former Member · Accepted solution]

Hi,

Create a access with o-unbounded occurance.

<StatementName>

<dbTableName action=u201DINSERTu201D>

<table>realDbTableName</table>

<access>

<col1>val1</col1>

<col2>val2</col2>

</access>

<access>

<col1>val11</col1>

</access>

</dbTableName>

</StatementName>

Map Like below.

number1--exits--createif--access.
number1--telephone

Same like duplicate the access structure and map.

Regards,

Prakasu.M

[Former Member · Accepted solution]

Hi all,

It doesnt take more than one access nodes... Moreover how can i map it at runtime... Can you plzz explain more on it.

Thanks.

[Former Member · Accepted solution]

as u say u have 5 fields exactly u can duplicate the access node then map 1 to 1

field1 to accesss(1)-->telephone

field1 > accesss(2)>telephone ...

[Former Member · Accepted solution]

Hi ...

I am not able to define more than one access in the datatype. it shows me the message Name already being used. Is there a problem with my datatype structure.

Regards,

[Former Member · Accepted solution]

u need to duplicate this in the mapping

right click on the node and click duplicate

[Former Member · Accepted solution]

Hi,

you should have to create a access 0-unbounded occurance and then dublicate your access strcture,map with number field.

Regards,

Prakasu.M

Edited by: prakasu on Jun 1, 2009 3:20 PM

[Former Member · Accepted solution]

Hi,

I tried as told.... ItS succesful in sxmb_moni. and message monitoring.. But in component monitoring its not showing any entry. neither it has hit the database.

Please help.

[Former Member · Accepted solution]

did u check the payload in the receiver JDBC channel or what is the error it shows

[Former Member · Accepted solution]

Hi,

It might be the cache issue. Refersh the cache using sxi_cache and repost the message once again.

Regards,

Prakasu.M

[Former Member · Accepted solution]

Thanks Mr. Prakasu and Mr. Arvind... and all.. Its becos of u i cld solve it.. Thanks

[Shabarish_Nair]

<StatementName2>

<dbTableName action=u201DINSERTu201D>

<table>realDbTableName</table>

<access>

<col1>val1</col1>

<col2>val2</col2>

</access>

<access>

<col1>val11</col1>

</access>

</dbTableName> 

  </StatementName2>

create multiple Statement nodes which will incorporate multiple inserts

http://help.sap.com/saphelp_nw04/helpdata/en/14/80243b4a66ae0ce10000000a11402f/frameset.htm

[Former Member]

if it is the same DB table multiple access nodes will also help