Previous Next JavaScript must be enabled to correctly display this content

## UpdateJSON

The example program is called `UpdateJSON`. We deliberately avoid using Java JSON APIs in this example so as to show how to perform these operations using Oracle NoSQL Database APIs only. Our imports are therefore limited to `oracle.kv`, `oracle.kv.table`, `java.io`, and `java.util`.

    package table;

    import oracle.kv.FaultException;
    import oracle.kv.KVStore;
    import oracle.kv.KVStoreConfig;
    import oracle.kv.KVStoreFactory;
    import oracle.kv.StatementResult;

    import oracle.kv.table.FieldValue;
    import oracle.kv.table.Index;
    import oracle.kv.table.IndexKey;
    import oracle.kv.table.MapValue;
    import oracle.kv.table.PrimaryKey;
    import oracle.kv.table.RecordValue;
    import oracle.kv.table.Row;
    import oracle.kv.table.Table;
    import oracle.kv.table.TableAPI;
    import oracle.kv.table.TableIterator;

    import java.io.BufferedReader;
    import java.io.FileNotFoundException;
    import java.io.FileReader;
    import java.io.IOException;

    import java.util.ArrayList;

    public class UpdateJSON {
        private String dataFile = "person_contacts.json";
        private String defaulthost = "localhost:5000";
        private String helperhosts[];
        private String storeName = "kvstore";

        private static void usage() {
            String msg = "Creates a table and loads data into it from\n";
            msg += "an external file containing one or more JSON\n";
            msg += "objects. The objects must conform to the table\n";
            msg += "schema. Table rows are then updated so that\n";
            msg += "zipcodes for all home addresses in Boston are\n";
            msg += "modified updated. Update is performed 3 different\n";
            msg += "ways so as to illustrate the ways to query JSON\n";
            msg += "data in Oracle NoSQL Database.\n";
            msg += "\nCommand line options: \n";
            msg += "-store <storename>\n";
            msg += "\tName of the store. Defaults to 'kvstore'\n";
            msg += "-hostport <hostname>:<port>\n";
            msg += "\tStore location. Defaults to 'localhost:5000'\n";
            msg += "-file <filename>\n";
            msg += "\tFile containing row data. Defaults to ";
            msg += "person_contacts.json";

            System.out.println(msg);
            System.exit(0);
        }

        public static void main(String args[]) {
            UpdateJSON uj = new UpdateJSON();

            uj.run(args);
        }