Author Archives: Manish Pandey

How to solve disabled MaxDate problem in ADF Calendar component?

In my previous post I had explained how to disabled future date using MaxValue property of date component. But there was an issue, which disables Max date too. It’s because, the date object returns date as dd/mm/yyyy 00:00 (notice the time value which is 00:00). At the time of selection, the date including current time (could be dd/mm/yyyy 00:01 +) ... Read More »

How to customize look and feel of ADF table?

Sometimes we need to customize ADF table, so here I will explain how to change look and feel of table using CSS. Showing table without header cell and row selection background color set to transparent like following image. af|table.stylestable { border:none; } af|table.stylestable af|column::column-header-cell { display:none; } .AFTableCellDataVHGrid:alias { border:none } af|table.stylestable::data-row:selected af|column::data-cell { background-color:transparent; border: none; } af|table.stylestable::data-row:selected:focused af|column::data-cell ... Read More »

How to Create Web Service using Application Module custom method?

This article is about creating Web Service using Application Module Custom method. To make it simple I’m using hr database’s Employee table and created a method that has two parameters, Employee Id (Which employee information you want to access) and Column name (what information you want to get e.g.  first name, email id). Create method on Application module Impl class ... Read More »

How to insert Unicode Character on your database table when your Oracle database does not have Unicode Character Set?

This post is about How to insert Unicode character (like Hindi) when your database not support Unicode Charset. To check your database support Unicode character or not you can use following query   SELECT value$ FROM sys.props$ WHERE name = 'NLS_CHARACTERSET' ;   If it will return WE8ISO8859P1 that means it is not support Unicode characters. For binding or defining ... Read More »

How to invoke Application Module Method from Page?

Sometimes we need to perform some database operation like insert data to table or others, for that purpose we can use application module method   which easily get connection from database to perform database curd operation. 1. First create method to Application Module Impl class as follows- public String createDepartment(String id, String name, String mid, String lid) { String msg = ... Read More »

Custom Error Message for Business Component

In my previous post, I had explained how to Display Custom error message to user to extend DCErrorHandlerImpl and register to Databinding.cpx file. Well, there’s another way to do the same. Follow these steps… Rigth Click on Model Project and select project properties Then select “Option” under Business Component To add custom message bundle class for your project, click New and ... Read More »

Defining validation in the ADF View Layer

ADF framework provides ADF Faces validation to add validation rules to an ADF Faces component. A “validator” attribute is used to create business specific validation rule. Validator uses el expression to bind method in a managed bean. In this Example, I will explain how to build your own custom validation logic. This example is based on HR schema Employees table ... Read More »

ORA-02292: Integrity Constraint

    Sometimes user need to change foreign key attribute value in ADF table’s master detail relationship. If you try to change master table’s foreign key value, you’ll  get the following integrity constraint error message. ORA-02292: integrity constraint (JAGRANDB.SYS_C00162401) violated – child record found   Download Sample Code   To resolve this issue, if user want to change a foreign ... Read More »

Automatically delete all child rows when User Delete Parent Record in Master-Detail relationship : ADF

In Master Detail relationship sometimes user needs to delete master row, if you try to delete master row before deleting child rows, runtime will not allow deletion of parent row if any child row exist. You will need to delete all child rows before deleting parent record. For this ADF business components provides very useful option. When you describe Association ... Read More »