语句无法执行，请重试：Oracle.kv.FaultException：表(12.1.4.3.11)(18.3.10)中没有这样的对象

Question

我试图存储的数据是来自存储在JSON文件中的tweet的元数据，但为了简单起见，我准备了一个带有更基本示例的演示。在这个演示中，我将尝试创建并填充一个只有4个字段的表和一个非常简单的JSON文件，其中包含要存储的数据。代码如下：

private static void demo(KVStore kvstore, String file2load) {
    //Creating the table
    String query = "CREATE TABLE Carros (plate STRING, brand STRING, owner STRING, km NUMBER, primary key (plate))";
    try {
        kvstore.executeSync(query);
    } catch (IllegalArgumentException e) {
        System.out.println("Invalid statement:\n" + e.getMessage());
    } catch (FaultException e) { //ATENTION HERE <-
        System.out.println("Statement couldn't be executed, please retry: " + e);
    }
    System.out.println("Table created");
    //Fill up the table
    populateTable(kvstore, file2load);
    System.exit(0);
}

上面看到的是在main中调用的方法。现在，我还将populateTable（）方法留在下面，尽管它工作得很好：

private static void populateTable(KVStore kvstore, String file2load) {
    TableAPI tableH = kvstore.getTableAPI();
    Table myTable = tableH.getTable("Carros");

    BufferedReader br = null;
    FileReader fr = null;

    try {
        String jObj = "";
        String currLine;
        int tCount = 0;
        boolean buildObj = false;
        boolean beganParsing = false;

        fr = new FileReader(file2load);
        br = new BufferedReader(fr);

        while ((currLine = br.readLine()) != null) {
            tCount += countParens(currLine, '{'); 

            if ((currLine = br.readLine()) == "\n") {
                continue;
            }

            if (tCount > 0) {
                buildObj = true;
                beganParsing = true;
            }
            //Anadimos la linea leida
            if (buildObj) {
                jObj += currLine;
            }

            tCount -= countParens(currLine, '}');
            if (tCount < 1)
                buildObj = false;


            if (beganParsing && !buildObj) {
                Row row = myTable.createRowFromJson(jObj, false);
                tableH.put(row, null, null);
                jObj = "";
            }
        }//While

    } catch (FileNotFoundException fnfe) {
        System.out.println("File not found: " + fnfe);
        System.exit(-1);
    } catch (IOException ioe) {
        System.out.println("IOException: " + ioe);
        System.exit(-1);
    } finally {
        try {
            if (br != null)
                br.close();
            if (fr != null)
                fr.close();
        } catch (IOException iox) {
            System.out.println("IOException on close: " + iox);
        }
    }
}//populateTable

所以我这里的问题是，每次我执行这个程序，它到达执行结束时都没有问题，因为我使用了try-catch块，但是，它不创建也不填充任何表。我得到的信息是：

execute "CREATE TABLE ....."

因为这也行不通。有什么想法吗？提前谢谢你。

Answer 1

当在try块中引入查询变量声明时，这个问题得到了解决；换句话说：

private static void demo(KVStore kvstore, String file2load) {
//Creating the table
String query;
try {
query = "CREATE TABLE Carros (plate STRING, brand STRING, owner STRING, km NUMBER, primary key (plate))";
    kvstore.executeSync(query);
} catch (IllegalArgumentException e) {
    System.out.println("Invalid statement:\n" + e.getMessage());
} catch (FaultException e) { //ATENTION HERE <-
    System.out.println("Statement couldn't be executed, please retry: " + e);
}
System.out.println("Table created");
//Fill up the table
populateTable(kvstore, file2load);
System.exit(0);
}

但是，如果执行以下命令：

执行“从Carros中选择*”