Regarding source jdbc structure creation

[Former Member]

Hi,

I am doing jdbc sender scenario the source structure I am getting form xsd.

in jdbc sender data type root node should be created "row" and message type . is compulsory?

if i am getting xsd how can i deal that one.

Thanks & Regards

venkat.

[former_member200962 · Accepted solution]

If you are getting some XSD then make sure that the message structure included is compatible with that in the DB.....for some info: /people/yining.mao/blog/2006/09/13/tips-and-tutorial-for-sender-jdbc-adapter

row needs to be present.....create a DT with the same name as it is in the Root element of your XSD

Regards,

Abhishek.

[Former Member]

Dear ,

take the Table name and Field name from XSD and form your own data type.

[Former Member]

I am doing jdbc sender scenario the source structure I am getting form xsd.

in jdbc sender data type root node should be created "row" and message type . is compulsory?

--> Yes..

if i am getting xsd how can i deal that one.

---> We can make the changes at IR ..

Regards,

[prateek]

Yes, use of row is compulsary. You have to edit the xsd file by adding a row element above the structure.

Regards,

Prateek