[SNMP4J] Issue with dependent table Column

[Saraswat, Deepak]

Hi Frank,

 

I have two tables one is Base and the other is dependent table. I have
implemented a relationship between two tables by implementing a class
that extends MOTableRelation and overrides addDependentRows as explained
in JavaDoc. Finally, I called set relation to set relation between them.

 

 

            public void setCoamProductEntryRelation(MOTable baseTable) {

                        log.info(" Setting relationship between
CoamProductTableEntry and CoamProductExtTableEntry ");

                        coamProductNameEntryRelation =

                   new CoamProductTableRelation(baseTable,
getCoamProductExtTableEntry());

 
coamProductNameEntryRelation.createRelationShip();

              }

 

My dependent table got two columns in it. While adding rows in the base
table I can see that rows are also getting added to dependent table with
the value to both the columns:

 

/**            * Adds all dependent rows for the specified base table
row to the dependent

               * table. 

               *

               * @param baseTableRow

               *    a row of the base table.

               */

            protected void addDependentRows(MOTableRow baseTableRow) { 

                        log.info(" Adding rows in dependent
table.................");

                        OID[] indexes =
getDependentIndexes(baseTableRow);

                        ReadWriteProperties rwProp = new
ReadWriteProperties();                       

                        

                for (int i=0; i<indexes.length; i++) { 

                        byte [] baseRowIndex = indexes[i].toByteArray();

                                    OctetString baseRowIndexVal = new
OctetString(baseRowIndex);

                        

                        String depIndexVal =
rwProp.getProperty("DependentTable.Row1.Column1");

                        String depValCol2 =
rwProp.getProperty("DependentTable.Row1.Column2");

                        

                        OID index = (new OctetString(
baseRowIndexVal.toString() + "." + depIndexVal).toSubIndex(true));

                        

                        MOTableRow depRow =

                      dependentTable.createRow(index,

                                      new Variable[]{new
OctetString(depIndexVal), new OctetString(depValCol2)});// Adding Values
of the dependent table.

            

                  depRow.setBaseRow(baseTableRow); //Adding a row in a
dependent table

                  log.info(" Number of Columns in the dependent Row " +
depRow.size());

                  log.info("Size of dependent Row is " + depRow.size());

                  log.info(" dependent Row is " + depRow.toString());

                  dependentTable.addRow(depRow);

                }

 

However, when I query agent to get the values of the dependent table it
only returns values of the first column in table view. If I call getnext
on the table it displays value of first column only. I am not sure why
agent is not recognizing second column of the dependent table. While  it
created dependent table successfully and also added values in it
successfully.

 

Everything works fine for the Base table which also got two columns in
it. Could you help me to troubleshoot it.

 

Here is the code for Creating a Dependent table: 

 

                        

            public void createcoamProductExtTable()

            {

                        CoamProductExtEntryIndexes = 

                                    new MOTableSubIndex[] {

 
moFactory.createSubIndex(oidCoamProductExtFamily, 

 
SMIConstants.SYNTAX_OCTET_STRING, 0, 255)

                        };

 

                        CoamProductExtTableEntryIndex = 

 
moFactory.createIndex(CoamProductExtEntryIndexes,

                                                            false,

                                                            new
MOTableIndexValidator() {

                                                public boolean
isValidIndex(OID index) {

                                                            boolean
isValidIndex = true;

                                                            return
isValidIndex;

                                                }

                                    });

 

                        // Columns

                        MOColumn[] CoamProductExtTableEntryColumns = new
MOColumn[2];

 

 
CoamProductExtTableEntryColumns[idxCoamProductExtFamily] =

                                    new
MOMutableColumn(colCoamProductExtFamily,
SMIConstants.SYNTAX_OCTET_STRING,MOAccessImpl.ACCESS_READ_WRITE);

 

 
CoamProductExtTableEntryColumns[idxCoamProductExtDesc] =

                                    new
MOMutableColumn(idxCoamProductExtDesc,
SMIConstants.SYNTAX_OCTET_STRING,MOAccessImpl.ACCESS_READ_WRITE);

                        

 

                        CoamProductExtTableEntry =

                                    new
DefaultMOTable(oidCoamProductExtEntry,

 
CoamProductExtTableEntryIndex,

 
CoamProductExtTableEntryColumns);

                        //Table model

                        CoamProductExtTableEntryModel = new
DefaultMOMutableTableModel();

 

                        CoamProductExtTableEntryModel.setRowFactory(new
CoamProductExtTableEntryRowFactory());

 
CoamProductExtTableEntry.setModel(CoamProductExtTableEntryModel);

            }

            

            

            /**

             * A factory class to create rows in a
CoamProductExtTableEntry Table.

             * @author Deepak Saraswat

             *

             */

            class CoamProductExtTableEntryRowFactory implements
MOTableRowFactory 

            {

                        public synchronized MOTableRow createRow(OID
index, Variable[] values) throws UnsupportedOperationException 

                        {

                                    CoamProductExtTableEntryRow row =
new CoamProductExtTableEntryRow(index, values);

                                    return row;

                        }

 

                        public synchronized void freeRow(MOTableRow row)
{

 

                        }

            }

 

            /**

             * Creating customized rows by extending
DefaultMOMutableRow2PC and overwriting getValue and Prepare function of
it .

             */

            public class CoamProductExtTableEntryRow extends
DefaultMOMutableRow2PC {

                        public CoamProductExtTableEntryRow(OID index,
Variable[] values) {

                                    super(index, values);

                                    log.info(" Value size is " +
values.length);

                                    

                                    for(int i =0; i< values.length; i++)

                                                log.info(" Value " + i +
" is " + values[i]);

                                    

                                    log.info(" Coam Product Table Entry
Ext Row called in " + this.getClass().getName());

 

                        }

 

                        /**

                         * This function fetches value for the specified
index and return it back to North bound.

                         * Overwrite this method to provide custmoised
retrieval of the values. 

                         */

                        public Variable getValue(int column) 

                        {

                                    log.info(" Get value function of the
Dependent row for column " + column);

                                    String value = null;

                                    ReadWriteProperties rwProp = new
ReadWriteProperties();

                                    rwProp.loadPropertyFile();

                                    

                                    if(column ==idxCoamProductExtFamily)

                                                value =
rwProp.getProperty("DependentTable.Row1.Column1");

                                    else if(column ==
idxCoamProductExtDesc)

                                                 value =
rwProp.getProperty("DependentTable.Row1.Column2");

                                    else

                                                value = " could not find
a row";

                                    return new OctetString(value);

                        }

 

Thanks for the help in advance.

 

Regards,

Deepak