Agile (MOSC)

MOSC Banner

Performance issues when downloading a BOM using the java API

edited Aug 15, 2016 5:00AM in Agile (MOSC) 2 commentsAnswered

I'm currently using this Java code to get a BOM from Agile. It works, but it's slow, especially over an internet connection. Is there a better way to do this?

//This is a recursive method of a class

public static void GetBom(String PartNumber, String PartRevision, int level) {

  try {

     String itemNumber, itemRevision, Quantity, Description;

     Iterator it;

     IItem item;

     ITable table;

     item = (IItem)session.getObject(ItemConstants.CLASS_PART, PartNumber);

     table = item.getTable(ItemConstants.TABLE_BOM);

     it = table.iterator();

     while (it.hasNext()) {

         IRow row = (IRow)it.next();

         itemNumber = (String)row.getValue(ItemConstants.ATT_BOM_ITEM_NUMBER);

         itemRevision = (String)row.getValue(ItemConstants.ATT_BOM_ITEM_REV);

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center