JDBC Mapping:

[Former Member]

Hello all:

I have been working on a JDBC(MSSQL)->File scenario. I am coming across some errors on the mapping.

If I use message mapping and use the interface mapping in the interface determination, I am getting a mapping exception error.

Whereas if I don't use the interface mapping, I am getting the output file sucessfully.

can you please clear this question for me?

Regards,

N.S

[moorthy]

Hi Swamy,

The problem may be during runtime. Test the mapping from Source XML ie data from SXMB_MONI and test it in the Interface Mapping in XI in the Integration Repository.

I think, the problem is in mapping with structure mismatch. btw what is the mapping error you get ?

Regards,

Moorthy

[bhavesh_kantilal]

Hi,

If you are using a Sender JDBC adapter, the datatype should be of this format,

<MESSSAGTETYPENAME>

<row> --- 0 to unbounded

<col1>

<col2>

<col3>

</row>

</MESSAGETYPENAME>

Also, your Document Name and Docume Namespace in the Sender JDBC adapter should contain the MessageType name and the namespace respectively.

Check this blog also,

/people/yining.mao/blog/2006/09/13/tips-and-tutorial-for-sender-jdbc-adapter

Regards,

Bhavesh

[agasthuri_doss]

Hi N.S

Try out this

Go to Objects tab in ID - you find the Message mapping -

---

Right Click and ADD to Scenario.

Regards

Agasthuri Doss

[former_member206604]

Hi,

There might be some problem with the namespace of some field duing the runtime. Try downloading the payload from the SXMB_MONI and save as a .xml file.

Goto Interface mapping and load the xml file and test it, you should get the same error. This will help you track the error and rectify the same.

Thanks,

Prakash

[Former Member]

Hey swamy,

you just do following steps and try:

1. Do the mapping properly and check by pressing f7 and activate ( DO all mandatory mappings)

2. Once, mapping successful, go and create Interface mapping properly and press F7 there also( at test tab)and activate.

If still you are facing problems... send me the IN and Out structures, we ( sdn guru's) will help you out!!!!

[Former Member]

There are no errors when invoking "F7".

Here is the file structure.

File_In: File_Out:

Name 0..1----

---

Name 0..1

Address 0..1----

---

Address 0..1

Country 0..1----

---

Country 0..1

Regards,

N.S

[agasthuri_doss]

Hi,

1) Check whether the mapping is activated

2) Check whether changes have been made in Work item

3) Refresh the cache.

Regards

Agasthuri Doss