Sequence number for Primary key in oracle ADF, JDeveloper

If you have created an Entity object with a primary key field.  The question is, how you will generate maximum serial no for primary key filed and where the logic will be placed?  There are two methods to do this, using row level database trigger or using application level logic to obtain sequence  no for primary key. Continue reading Sequence number for Primary key in oracle ADF, JDeveloper

Using transient Attribute with “Derived from SQL Expression” in JDeveloper 11g

Transient attribute can be used to calculate a value based on SQL expression. This may be very helpful, for example, you can use a transient attribute in “SCOTT.EMP” Entity object definition to get name of the department for all employees. Continue reading Using transient Attribute with “Derived from SQL Expression” in JDeveloper 11g

Oracle Application Development Framework (ADF) and Oracle Forms Developers

I want to share my first impression of ADF and I am sure everyone with Oracle Forms background will feel same. I have been working in oracle Forms and Reports for more than five years.  I have development experience in Oracle Developer 6i/9i/10g and Forms, Reports 11g. After reading Oracle’s Statement of Direction for Forms and reports, I decided to learn ADF for web-based application development. Continue reading Oracle Application Development Framework (ADF) and Oracle Forms Developers

Enable Forms 6i short keys in Forms 10g and Forms 11g

Shortcuts in Forms 10g and 11g are different from Forms 6i keys. For example, Forms 6i uses F10 as short key to save records while in Forms 10g and 11g, CTRL+S  is default short key to save or commit changes.  If you have migrated an app from older version then probably you would be looking some way to retain key shortcuts. Continue reading Enable Forms 6i short keys in Forms 10g and Forms 11g

Create Oracle lite Database (odb) using olite Mobile Development Kit

Oracle Database Lite (olite) is small-scale database for small devices. Oracle Lite can be used in following two design patterns,

  1. You can configure olite database to Mobile client and use automatic synchronization feature of olite server to replicate data between mobile device and oracle database server.
  2. You can use an independent olite database with you mobile application.

Whatever way is used, the data in the mobile is stored in small mobile database files with ODB and OBS extension. ODB file contains data while indexes are stored in OBS file. In olite version 10.2.0.1.0, all objects are stored in ODB file. Continue reading Create Oracle lite Database (odb) using olite Mobile Development Kit

FireFox, IE crash with Forms 10g, Replace Jinitiator with JRE

Oracle Jinitiator is no longer compatible with oracle forms services. By default, Oracle Forms services 10g uses Jinitiator 1.3.1.22 to run Forms applications. Jinitiator was compatible with Internet Explorer 6 and Firefox version 2.0. Continue reading FireFox, IE crash with Forms 10g, Replace Jinitiator with JRE