Mapping mulitple container levels to a DB columne

I want to map a DCR field to a DB column, and it is in a nested container level.

the code i have is -

there are two containers SheetContainer and SpecSheetContainer. the max occurance for the inner container can vary, for now i have mentioned it as 3.
at the time of deployment DD loops thru the inner containers and if it doesn't get value for the field (when the available container instances are less than the specified) it throws me an exception for Null value.
Please Note - Column NAME is part of a primary key
Can we map this type of multiple cascaded container to a DB column. Is there any other way of doing this?

Got to read follow in ddadmin guide -

If an attrmap element inside a group element has more than one column definition
whose value-from-field attribute is set to a replicant field, the value for the
specified value-from-field must have the same root element. For example, the
Treatment and Drug fields in the following example must have the same root
element (Treatment List):

value-from-field="Treatment List/[0-3]/Treatment"
is-replicant="yes"/>

value-from-field="Disease " />

value-from-field="Treatment List/[0-3]/Drug List/[0-4]/Drug"
is-replicant="yes"/>

...

Find more posts tagged with

Comments

Adam Stoller

I want to map a DCR field to a DB column, and it is in a nested container level.

the code i have is -

<column name="NAME" data-type="VARCHAR2(255)" value-from-field="BulkUpload/0/SheetContainer/[0-2]/SpecSheetContainer/[0-2]/SheetName/0" allows-null="no" is-url="no" is-replicant="yes"/>

there are two containers SheetContainer and SpecSheetContainer. the max occurance for the inner container can vary, for now i have mentioned it as 3.
[...]

Got to read follow in ddadmin guide -
[...]
<group name="drug_list">
<attrmap>
<column name="Treatment" data-type="varchar(100)"
value-from-field="Treatment List/[0-3]/Treatment"
is-replicant="yes"/>
<column name="Disease" data-type="varchar(100)"
value-from-field="Disease " />
<column name="Drug" data-type="varchar(100)"
value-from-field="Treatment List/[0-3]/Drug List/[0-4]/Drug"
is-replicant="yes"/>
</attrmap>
...
</group>

Please learn how to properly format and Preview your posts to ensure that it can be read correctly.

I seem to recall that the trailing

in your code is one of those sometimes-you-need-it-sometimes-you-don't kind of things - I don't recall what the rules and explanations surrounding its usage are - but the first thing I'd try is removing that and see if it resolves your problem.

Also - you say "the max occurance for the inner container can vary, for now i have mentioned it as 3" - you should use whatever the max value is, not some arbitrary number - also I'm not sure, and it is difficult to tell from the documentation, but I believe the leading number in the range [0..2] might actually mean that you can have 0, 1, or 2 instances, as in min="0", max="2" as opposed to something like [1..3] which might map to min="1", "max="3". Again, I'm not sure about it - I haven't had to muck around with DD for quite some time.

You may want to play with those numbers in addition to adding or leaving off the

at the end of the path specification.

And if by "vary" you mean that the max is defined as "unbounded", I'm pretty sure that DD doesn't handle such items.

Lastly (perhaps), I'm not sure if "name" is a reserved word - you may want to try altering the column name to something like "names" - just to be sure that you haven't got everything else correct already and are just getting hung up on a reserved-word issue.

Obviously it's possible that the problem is something else altogether, but I'd suggest playing with those three variables (the ending of the path specification, the ranges specified in the square-brackets, and the column name) in various combinations if, for nothing else, to rule them out as the source of the problem

Shilpax

Hi,

I tried changing the trailing /0, name of the column and the ranges too but somehow it did not reflect and still gives eror.

I changed my code as below -

column name="SPECSHEET_NAME" data-type="VARCHAR2(255)" value-from-field="BulkUpload/0/SpecSheetContainer/[0-2]/VSpecSheetContainer/[0-2]/SpecSheetName" allows-null="no" is-url="no" is-replicant="yes"

case 1 -
SpecSheetContainer available in DCR = 3
VSpecSheetContainer available in DCR = 2
In this case when DC loops VSpecSheetContainer for the third time it will not get any value as we have only 2 containers available, it will throw error saying can not isert NULL in PK (SPECSHEET_NAME is part of PK)

case 2 -
SpecSheetContainer available in DCR = 3
VSpecSheetContainer available in DCR = 3
In this case above code will run properly and will insert the resp records in the table.

Now the issue is - when we have less number of inner containers than the specified number (here it is 3) we will get the null exception. Ideally it shud not be the case. when the containers are not present DD shud not try to insert data for those. May be I am taking it in a wrong way. Please correct me.

Following is an example working for one level of container -
column name="DCR_PATH" data-type="VARCHAR2(500)" value-from-field="PageLayout/0/PageLayoutContainer/[0-5]/DCR_Path/0" is-replicant="yes" allows-null="no" is-url="no"

this inserts proper data in the DB table.

ShashankJain

I think you are messing with the database node, post your full config file.