1 Reply Latest reply on Sep 19, 2019 9:10 AM by Kaustubh Khare

    SODA-FOR-JAVA :- Not all return parameters registered

    Kaustubh Khare

      I am using Oracle 12c. I am trying to insert a document into oracle using SODA lib using https://blogs.oracle.com/jsondb/oracle-rdbms-as-a-nosql-json-document-store.

      I have created a collection using SODA. Now I am trying to insert document, But I am getting the exception while inserting doc.

      Caused by: java.sql.SQLException: Not all return parameters registered
      at oracle
      .jdbc.driver.OracleStatement.processDmlReturningBind(OracleStatement.java:4876)
      at oracle
      .jdbc.driver.OraclePreparedStatement.setupBindBuffers(OraclePreparedStatement.java:3101)
      at oracle
      .jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:2355)
      at oracle
      .jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3579)
      at oracle
      .jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3665)
      at oracle
      .jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1352)
      at oracle
      .soda.rdbms.impl.TableCollectionImpl.insertAndGet(TableCollectionImpl.java:784)

       

      Code

       

      // connection code

      final OracleCollection countersCollection = database.openCollection(SC_LMS_SEQUENCE_COLLECTION);
      countersCollection
      .insertAndGet(database.createDocumentFromString("{\"id\" : \"COURSE_SEQ\",\"seq\" : 0}"));