6 Replies Latest reply on May 13, 2011 3:55 PM by didier - oracle

    Rollback operation fails on 11.1.1.5

    attilas79
      Hi all,

      I have a strange bug(?) after upgrading to jDeveloper 11.1.1.5.0 and I reproduced in a clean jDev installation with HR schema.
      I have created the Entity Object and the View Object -based on Regions table- from the wizard with no customization at all, but a View Criteria in the VO.
      I made a plain jspx page with Regions table (editable) and ADF Query Panel. After updating a record and executing Rollback operation, the page crashes and all records appear to have the same data (the one of the last record) and after re-querying I get the error “Too many objects match the primary key oracle.jbo.Key[4]”.

      See the immage below
      [http://imageshack.us/f/861/87821658.jpg/]

      Thanks in advance for any help

      Edited by: apostolosk on May 13, 2011 1:23 AM
        • 1. Re: Rollback operation fails on 11.1.1.5
          attilas79
          Is it only me having this issue?
          any idea... please!

          Edited by: apostolosk on May 13, 2011 1:23 AM
          • 2. Re: Rollback operation fails on 11.1.1.5
            attilas79
            I can't believe that ROLLBACK operation triggers such an error!!!
            As you can see below the jspx page is as simple as possible. I have included just the Regions table from the HR schema and the Commit and Rollback operation. The page has been constructed with drag & drop - no customization at all !!!

            Is there any workaround or anybody facing the same????


            <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
            "http://www.w3.org/TR/html4/loose.dtd">
            <%@ page contentType="text/html;charset=UTF-8"%>
            <%@ taglib uri="http://java.sun.com/jsf/core" prefix="f"%>
            <%@ taglib uri="http://xmlns.oracle.com/adf/faces/rich" prefix="af"%>
            <f:view>
            <af:document id="d1" title="Regions">
            <af:messages id="m1"/>
            <af:form id="f1">
            <af:commandButton actionListener="#{bindings.Commit.execute}"
            text="Commit"
            id="cb1"/>
            <af:commandButton actionListener="#{bindings.Rollback.execute}"
            text="Rollback"
            immediate="true" id="cb2">
            <af:resetActionListener/>
            </af:commandButton>
            <af:table value="#{bindings.RegionsView1.collectionModel}" var="row"
            rows="#{bindings.RegionsView1.rangeSize}"
            emptyText="#{bindings.RegionsView1.viewable ? 'No data to display.' : 'Access Denied.'}"
            fetchSize="#{bindings.RegionsView1.rangeSize}"
            rowBandingInterval="0"
            selectedRowKeys="#{bindings.RegionsView1.collectionModel.selectedRow}"
            selectionListener="#{bindings.RegionsView1.collectionModel.makeCurrent}"
            rowSelection="single" id="t1">
            <af:column sortProperty="RegionId" sortable="true"
            headerText="#{bindings.RegionsView1.hints.RegionId.label}"
            id="c1">
            <af:inputText value="#{row.bindings.RegionId.inputValue}"
            label="#{bindings.RegionsView1.hints.RegionId.label}"
            required="#{bindings.RegionsView1.hints.RegionId.mandatory}"
            columns="#{bindings.RegionsView1.hints.RegionId.displayWidth}"
            maximumLength="#{bindings.RegionsView1.hints.RegionId.precision}"
            shortDesc="#{bindings.RegionsView1.hints.RegionId.tooltip}"
            id="it2">
            <f:validator binding="#{row.bindings.RegionId.validator}"/>
            <af:convertNumber groupingUsed="false"
            pattern="#{bindings.RegionsView1.hints.RegionId.format}"/>
            </af:inputText>
            </af:column>
            <af:column sortProperty="RegionName" sortable="true"
            headerText="#{bindings.RegionsView1.hints.RegionName.label}"
            id="c2">
            <af:inputText value="#{row.bindings.RegionName.inputValue}"
            label="#{bindings.RegionsView1.hints.RegionName.label}"
            required="#{bindings.RegionsView1.hints.RegionName.mandatory}"
            columns="#{bindings.RegionsView1.hints.RegionName.displayWidth}"
            maximumLength="#{bindings.RegionsView1.hints.RegionName.precision}"
            shortDesc="#{bindings.RegionsView1.hints.RegionName.tooltip}"
            id="it1">
            <f:validator binding="#{row.bindings.RegionName.validator}"/>
            </af:inputText>
            </af:column>
            </af:table>
            </af:form>
            </af:document>
            </f:view>

            Edited by: apostolosk on May 13, 2011 1:24 AM
            • 3. Re: Rollback operation fails on 11.1.1.5
              Jobinesh-Oracle
              I filed a bug#12551764 to track this issue. Please follow up with Oracle Support
              • 4. Re: Rollback operation fails on 11.1.1.5
                Michael Koniotakis
                I also filled an SR for this
                This is a realy serious (blocking) issue for someone to use the latest version of jdeveloper.
                Something similar was happening in 11.1.1.3 but was not so easy to reproduce

                I would expect better quality testing before releasing to public.
                At least a fast hot fix for this.

                Thanks
                • 5. Re: Rollback operation fails on 11.1.1.5
                  didier - oracle
                  I checked with our Development team -
                  This is probably a symptom of the following (internal) bug:
                  Bug 12393642 - NEW ROW ADDED TO TABLE PREPOPULATES DATA FROM PREVIOUS ROW

                  They are working on a patch.

                  Regards,

                  Didier.
                  • 6. Re: Rollback operation fails on 11.1.1.5
                    didier - oracle
                    We published the following Alert in "My Oracle Support":
                    Note 1321896.1 - 11.1.1.5.0 Regression: Rollback Button With Property immediate="true" Causes Replacing Existing Rows With Current One