Author Archives: Manish Pandey

ADF: How to upload file in FTP server using apache common net API?

This post is about How to upload file in FTP Server using apache common net API(Download here). ADF faces inputFile component allows user to upload file from browser. So we only need to connect to FTP server and upload file. Following are steps- Add inputFile component from component palette to page. Make sure usesUpload property of form is true. On ... Read More »

Creating new row on pressing “TAB” key in the last cell of Table.

Someone asked in oracle community forum, How to create new row on pressing tab key in table’s last cell? So here is complete example with sample code (jdev 11.1.1.9.0). I’m using HR Schema for sample application. There are three main steps First add clientListener and serverListener to last column of ADF table. Following java script method is called when user ... Read More »

ADF: Customizing the Appearance of Button using Skin

ADF framework provide component specific skin selector to customize look & feel of component. For Button  af|commandButton skin selector is used. This post is about how to customize ADF button.  af:commandButton have five state 1.normal af|commandButtonhover 2.hover : when mouse over button. af|commandButton:hover 3.focus: when the button on focus af|commandButton:hover 4.disabled : when button  disabled af|commandButton:disabled 5.active : when button ... Read More »

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 »