出错提示:Exception occurred in target VM

Question

PreparedStatement statementInWeb = null;
    ResultSet resultSetAccess=null;
    Statement statementAccess=null;
    ResultSet resultSetInWeb=null;
    try {
      conIn.setAutoCommit(false);
      statementAccess = conAccess.createStatement();
      resultSetAccess=statementAccess.executeQuery(DataTransferSqlList.Select_A001PersonInfo);
      while (resultSetAccess.next()){
        System.out.println(resultSetAccess.getString("A0100"));
        statementInWeb=conIn.prepareStatement(PersonInfoSqlList.GET_A001PersonInfo);
        String a0100=resultSetAccess.getString("A0100");
        statementInWeb.setString(1,a0100);
        resultSetInWeb=statementInWeb.executeQuery();
        System.out.println("a0100="+resultSetAccess.getString("A0100"));程序运行此行:String a0100=resultSetAccess.getString("A0100");出错，错误原因是没发现数据。
难道结果集中的指向记录的指针会跑动?

Answer 1

Statement stmt = con.createStatement(
                                      ResultSet.TYPE_SCROLL_INSENSITIVE,
                                      ResultSet.CONCUR_UPDATABLE);设置参数就解决了，原来默认是只往下走