This discussion is archived
1 Reply Latest reply: Feb 16, 2012 3:40 PM by alwu RSS

Application Table Index not being created

900576 Newbie
Currently Being Moderated
Since this is slightly different than my last post, I created a new one.

I am using the example as a basis to complete the Bulk process from the Staging table to the Application table with the following code snippet:

public void completeBulk(String completeBulkFlags) throws Exception {
GraphOracleSem graph = null;
try {
graph = getModel().getGraph();
try {
graph.dropApplicationTableIndex();
} catch (SQLException e) {}
graph.getBulkUpdateHandler().completeBulk(completeBulkFlags, null);
graph.rebuildApplicationTableIndex();
finally {
if (graph != null)
graph.close();
}
}


It appears to be dropping the 'applicationTableIndex', however when the call 'rebuildApplicationTableIndex' the <MODEL_NAME>_IDX does not exist in the database.  And i'm not seeing errors anywhere alerting me that the index was not created.

Since this index is not created, deletes on the model do not have an index to scan over the <MODEL_NAME>_TPL table and takes forever.  For the time being, we are creating this index manually.  However is there something that we are doing wrong using the Jena Adapter API?

We are using the newest Jena Adapter and 11.2.0.3 Database instance.

Thanks
-Michael

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points