ORA-29975: Cannot register a query in the middle of an active transaction exceptiona ADF

Laus

Hello,

I am using JDeveloper 12.1.3. 64-bit.

I have a single entity object validator on EO FirstEO that is method based:

public boolean validateSomeThingCheckRule() {

        boolean flag=false;

        RowSet rowSet = this.getMyVO1();/*an accessor to ViewObject MyVO*/

        rowSet.setRangeSize(-1);

        rowSet.executeQuery();/

        Row myRow = rowSet.first();

        if(myRow!= null){

            ...do something

            if(something>0){

                flag=true;

            }

            else{

                flag=false;

            }

        }   

        return flag;

    }

The validator works ok.

I also have Application Module with AMImpl java class, where I override before commit operation:

@Override

    public void beforeCommit(TransactionEvent transactionEvent) {

        MyViewObjectImpl firstViewObjectImpl=getFirstVO1();/*Raturns FirstVO that is based on FirstEO */

        MyViewRowImpl firstViewRowImpl=(MyViewRowImpl) firstViewObjectImpl.getCurrentRow();

        RowSet myRowSet=(RowSet)firstViewRowImpl.getAttribute("MyVO1");/*an accessor to ViewObject MyVO, like in EO validator, they both access same view object MyVO*/

        Row myRow = myRowSet.getRowSet().first(); /*Here I have:ORA-29975: Cannot register a query in the middle of an active transaction exceptiona*/

        /*do something...*/

        super.beforeCommit(transactionEvent);

    }

Can anyone explain me why, and help me with solution. Many thx.

kdario

This is probably related to database change notifications.

Maybe you have enabled auto-refresh on that VO ?

Also, coding validations in beforeCommit() method is not very good practice: this is "global" method so it is invoked for each commit on each page and in some cases this method can be invoked by framework: http://andrejusb.blogspot.ba/2013/03/coding-validation-in-adf-bc-view-object.html

Dario

kdario

This is probably related to database change notifications.

Maybe you have enabled auto-refresh on that VO ?

Also, coding validations in beforeCommit() method is not very good practice: this is "global" method so it is invoked for each commit on each page and in some cases this method can be invoked by framework: http://andrejusb.blogspot.ba/2013/03/coding-validation-in-adf-bc-view-object.html

Dario

Laus

Yes Dario,

There was AutoRefresh on MyVO view object.

Thank you so much.

Best regards