Managing Tables Using the IntelliJ Plugin

Learn how to create tables and view table data in Oracle NoSQL Database KVStore from IntelliJ.

After connecting to the Oracle NoSQL Database, you can execute the examples downloaded with Oracle NoSQL Java SDK to create a sample table. With the help of the IntelliJ Plugin, you can view the tables and their data in the Schema Explorer window.

To execute an example program:

1. Open the NoSQL project connected to your Oracle NoSQL Database.
2. Locate and click BasicTableExample in the Project Explorer window. By looking at the code, you can notice that this program creates a table called audienceData, puts two rows into this table, queries the inserted rows, deletes the inserted rows, and finally drops the audienceData table.
3. To pass the required arguments, click Run > Edit Configurations. Enter the following program arguments, and click OK.

   Table 12-2 Program Arguments

   Program Arguments	More Information
   http://<proxy_host>:<proxy_http_port> -useKVProxy	For example, if your Proxy URL is http://<proxy_host>:8080, the program argument must be http://<proxy_host>:8080 -useKVProxy.

4. To execute this program, click Run > Run 'BasicExampleTable' or press Shift + 10.
5. Verify the logs in the terminal to confirm that the code executed successfully. You can see the display messages that indicate table creation, rows insertion, and so on.

   Tip:

   As the BasicExampleTable deletes the inserted rows and drops the audienceData table, you can't view this table in the Schema Explorer. If you want to see the table in the Schema Explorer, comment the code that deletes the inserted rows and drops the table, and rerun the program.
6. To view the tables and their data:
   1. Locate the Schema Explorer, and click the Refresh icon to reload the schema.
   2. Locate the audienceData table under your tenant identifier, and expand it to view its columns, primary key, and shard key details.
   3. Double-click the table name to view its data. Alternatively, you can right-click the table and select Browse Table.
   4. A record viewer window appears in the main editor. Click Execute to run the query and display table data.

      Note:

      As of the current release, only SELECT queries are supported on the NoSQL tables from the Schema Explorer.
   5. To view individual cell data separately, double-click the cell.