Install Oracle Forms 11gr2 in OEL 6

The aim of this post isn´t write a complete guide about the installation process.
There are a good tutorials in internet and oficial doc is very clear
I will write about some important things that you should keep in mind before the installation.

  • Install a correct JDK

7.0.13 is a good option.OpenJDK can be good for Weblogic but not for Forms

rpm -ivh jdk-7u13-linux-x64.rpm

Register your JDKs for alternatives and change the current java version

/usr/sbin/alternatives --install /usr/bin/java java /usr/java/jdk1.7.0_71/bin/java 17071
# /usr/sbin/alternatives --config java
  • Configure your etc/hosts with your correct name
10.0.2.15   forms forms.formsdomain
127.0.0.1   forms forms.formsdomain

if you want to know the domain and host name you can try run this comannd

echo `uname -n`.`awk '/^domain/ {print $2}' /etc/resolv.conf`

It´s important have a IP and not init the installation without IP

  • Increase the tmp size in /etc/fstab until 6GB
tmpfs /tmp tmpfs nodev,nosuid,size=6000m

 

ADF with WebSockets Tips.

In these days everybody talk about the WebSokects  integration with ADF.
In this post I will give some advices about this integration.

  • You can use WebSockets in combination with Database Change Notification(DCN)
    • In this case remember you need a grant grant change notification to hr
  • In DCN You need to explicitly unregister a registration to delete it from the server and release the resources in the driver. You can unregister a registration using a connection different from one that was used for creating it
  • With DCN you could have problem with some column types.
    • ORA-29977: Unsupported column type for query registration in guaranteed mode
    • Check if in your query you have a blob,clob or xmlType column
  • Websockets have a default timeout in 30s
  • WebSocketAdapter now is deprecated, here you have oficial doc to build WebSockets in weblogic.

With WebSockets you can build something like that

websockets

 

LOV with create option

Sometime clients demands this feaute and I think is unknown funcionality

The LOV component  have a property called CreatePopupId where  you can indicate the popup that will use for create new rows.

Then above of the  table result appear a buton to open the new popup to create rows.

Extra Links:

http://www.oracle.com/webfolder/ux/middleware/richclient/guidelines5/lov.html#create

MongoDB and ADF

This week I have been learning MongoDb and I’m looking for some ways to connect MongoDB with ADF Faces.
We can use Bean or EJB DataControl.
Another way could be https://spring.io/guides/gs/accessing-data-mongodb/ in combination with ADF Faces

Here there are another way http://weblog.singhpora.com/2013/12/adf-ui-with-mongodb-for-persistence.html

And remember that in Oracle you have another No SQL database http://www.oracle.com/technetwork/database/nosqldb/downloads/default-495311.html

ADF 12c. It´s time to migrate to 12c

The last release of ADF 12.2.1 has a lot of improvments and news.I think now we have a stable release and is time to migrate o to begin a new project.

  • JDK8
  • JSF2.2
  • A lot of new Components
  • GIT Integration
  • Maven Integration with online maven repository
  • Support to REST Datacontrols
  • New Alta Skin
  • Explore Dependencies,af:target,…

Oracle Applications Cloud User Experience Rapid Development Kit

The Oracle Applications Cloud User Experience Rapid Development Kit (RDK) is Development Kit with a set of funcionalities to build application with a oracle cloud style and modern look and feel.

innovation-165  RDK is a set of free resources that will help you learn faster, design simpler and build better.

Is a good tool to learn how to build user friendly applications and get ideas

Isn’t necessary deploy this aplications in cloud, you can use this guidelines for your stand alone applications

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

Pack and unpack WebLogic Domains

This commands can be useful when you need pass a domain between node.

pack -domain=<path>\SourceDomain -template=<path>\domain.jar -template_name="Default Domain"
unpack -template=<path>\domain.jar -domain=<path>\TargetDomain

These shell scripts are available in

  • $MW_HOME/wlserver_[ver]/common/bin

More info

JDeveloper 12.2.1 is out

Some weeks ago Oracle released new version of JDeveloper, 12.2.1.

In this new version we have improvements in:

  • GIT integration
  • Maven Integration
  • Cloud Integration
  • Responsive layouts

and new features:

  • JDK 8
  • Theme Editor, user-friendly interface to work with Skins
  • New Graph Components
  • ADF REST Data Controls

Now the online demo has been redesigned with new template and Alta Skin

More info about this version:

Filter results in adf table

Another day someone in the OTN forum asked how to clean the resutls in a af:table.
We can do it with code, working withe the ViewCriterias of the ViewObject, but also we can add a hide funcionality in the af:table.

If we add a new column with the property rowHeader a true, our table will have a new column with a button to clean the filter in the tables
Like the below image

rowHeader