Document name.

[Former Member]

Hi, expertsI need your opinion on the following topic.

I need to know if there is any way that a sender Jdbc adapter has two document name.

I´ll be very grateful to hear your suggestions, Thank you.

[RaghuVamseedhar · Accepted solution]

Hi Josalca,

No, it is not possible to have 2 document names in one sender JDBC adapter.

Reason: - Sender JDBC adapter will execute JDBC query (Select * from table), and it will put the result into an XML structure. XML can have only one root node. Document name forms the root node of XML.

Well formed XML

<?xml version="1.0" encoding="utf-8"?>
<Document_Name>
<row>
<column-name1>column-value</ column-name1>
<column-name2>column-value</ column-name2>
<column-name3>column-value</ column-name3>
</row>
</Document_Name>
 

Not Well formed XML u2013 JDBC adapter will not allow

<?xml version="1.0" encoding="utf-8"?>
<Document_Name>
<row>
<column-name1>column-value</ column-name1>
<column-name2>column-value</ column-name2>
<column-name3>column-value</ column-name3>
</row>
</Document_Name>
<Document_Name>
<row>
<column-name1>column-value</ column-name1>
<column-name2>column-value</ column-name2>
<column-name3>column-value</ column-name3>
</row>
</Document_Name>

Regards,

Raghu_Vamsee