Skip to Main Content

Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Subform submits data from other subforms

WP v.2Aug 25 2020 — edited Sep 4 2020

Hey all,

I'm playing around with subforms in a listView and I realized that clicking a button in one of the subforms was actually submitting the form data in all the subforms. I thought that perhaps this was because the subform was inside a iterator component like listView. However, I created a very basic page with two subforms and the same thing occurred.

Here is my page:

<f:view xmlns:f="http://java.sun.com/jsf/core" xmlns:af="http://xmlns.oracle.com/adf/faces/rich">

    <af:document title="Test" id="d1">

        <af:form id="f1">

            <af:subform id="subForm1" default="true">

                <af:panelFormLayout id="pfl5">

                    <f:facet name="footer"/>

                    <af:inputText label="Label 1" id="it5"/>

                    <af:button text="button 1" id="b6"/>

                </af:panelFormLayout>

            </af:subform>

            <af:subform id="subForm2" default="true">

                <af:panelFormLayout id="pfl6">

                    <f:facet name="footer"/>

                    <af:inputText label="Label 2" id="it4"/>

                    <af:button text="button 2" id="b4"/>

                </af:panelFormLayout>

            </af:subform>

         

        </af:form>

    </af:document>

</f:view>

And as you can see from the browser's network inspector, after clicking "button 2", it submits the values from both subforms:

https://drive.google.com/file/d/1IdHREfEAbCyF4Az_mLOgj1MFRR9ojhYJ/view?usp=sharing

What am I doing wrong here? Also do you guys see an issue with putting a subform in a listView? Because that is my ultimate goal.

I'm on JDeveloper 12.2.1.4

Thanks,

BIll

Comments

rober584812

Hello SmithJohn45.
Try the next commands:

systemctl start oracle-xe-21c
systemctl enable oracle-xe-21c

After running the commands, reboot and test the connection to SQLPLUS.
Regards.

SmithJohn45

thanks @rober584812 but it is already mentioned in guide and off course i executed those commands to start database audomatically.
image.png

rober584812
Answer
Marked as Answer by SmithJohn45 · Oct 1 2021
SmithJohn45

thanks again, will check it and give you feedback

SmithJohn45

@rober584812 here is my feedback...
this helped me and now I can connect to my PDB.
thanks very much for help :)

SmithJohn45

hi rober584812
it was connected to my PDB but when I restart my CentOS 7 VM now it is not connecting to XEPDB1
i issued 2 ' Alter Pluggable Database ' commands ( as below ) but still failed to connect using sys/ora1234@xepdb1
in my .bash_profile i added following environment variables which can only enable me to run sqlplus, also i have to issue command manually as below to connect to XE (CDB) but this also not allowed me to connect to PDB.
. oraenv
alter commands as per oracle documents:

alter PLUGGABLE DATABASE ALL OPEN;
alter PLUGGABLE DATABASE ALL SAVE STATE;

environment variables:
export ORACLE_BASE=/opt/oracle/
export LD_LIBRARY_PATH=$ORACLE_BASE/product/21c/dbhomeXE/lib
export ORACLE_HOME=$ORACLE_BASE/product/21c/dbhomeXE
export PATH=$ORACLE_BASE/product/21c/dbhomeXE/bin:$PATH
export PATH=/usr/bin:$PATH
export ORACLE_SID=XE
this is same problem i am facing in 18c XE. please help to connect and start Apex 21 + ORDS 21 installation and development.
regards
Is it necessary to issue , oraenv command ? what about if i add it in .bash_profile but will this accept XE as parameter in that file?

rober584812

Hello SmithJohn45 , check if the listener is running.

cd <oracle_home>/bin
lsnrctl status

After, if the listener status is OK, try the following command:
system/password@localhost.localdomain:1521/XEPDB1
The order . oraenv is necessary.
Regards.

SmithJohn45

yeah, i can connnect using ezconnect syntax. but as mentioned earlier, i am confused as i want to install Apex & ORDS, how I can configure to use it both " . oraenv " and ezconnect syntax without every time manually interact when logout and login, machine restart etc. and same for production environment?
regards

rober584812

Hello @smithjohn45 , the important thing is that the listener is working, if the listener is in the OK state, you will be able to access the Oracle XE instance without problems; Regarding the installation of APEX with ORDS, using "oraenv" will be required during the installation process, you can configure ORDS in autorun or standalone mode.
Regards.

1 - 9

Post Details

Added on Aug 25 2020
5 comments
226 views