Install FMW Test environment

  1. install OEL.
  2. install JDK
    • rpm -ivh jdkname.rpm
  3. install JDeveloper
    • before install JDev
      • yum install glibc.i686
      • yum install libXtst-devel libXrender-devel kernel-devel libXtst-devel.i686
    • chmod +x jdevname.bin
  4. install oracle XE
  5. install WLS
    • $ unzip fmw_12.2.1.0.0_infrastructure_Disk1_1of1.zip
    • $ $JAVA_HOME/bin/java -jar fmw_12.2.1.0.0_infrastructure.jar
  6. Rcu for ADF development
    • $ORACLE_HOME/oracle_common/bin/rcu
  7. Create domain
    • $ORACLE_HOME/oracle_common/common/bin/config.sh
    • check Oracle JRF

Dynamic dataSource in af:query

If you need a search region that depends about something the user must point to differents database schemas, there are several options.Here I explain two

You can do a envInfoProvider implementation

And if you need a more simple solution, you can define, in design time, the two DataControl and redirect one of them in your bean code

 <iterator Binds=”YourView” RangeSize=”25″ DataControl=”#{yourBean.dataControl}” id=”YourViewIterator”/>

Ver multiples tablas en JDeveloper y SQL Developer

La verdad es que cuando necesitas editar un par de tablas a la vez, desde el Database de JDeveloper, es mucho más cómodo poder ver varias tablas a la vez:

En JDeveloper:

  • Para ello activiamos el checkAutomatically Freeze Object Viewer Windows en Tools > Preferences > Database > ObjectViewer

En SQL Developer:

  • Preferencias–>Base de datos–>Visor de Objetos–>Congelar automáticamente visor de Objetos