Friday, October 18, 2013

issue accessing 10g database from 11g using DBLink ADF

Issue when you try to use a query with DBLink with 10g database in an ADF VO
e.g select * from table@10GDBLink
https://forums.oracle.com/thread/1080919


ORA-28267 Invalid Namespace Value/ JBO-27122 SQL Exception ADF

Wednesday, October 16, 2013

Wednesday, October 9, 2013

issue filtering date column in table ADF

 
SELECT  trunc(UPDATE_TS) UPDATE_TS,  // TIMESTAMP
          INSP_ID,
       trunc(LAST_INSP_DATE) LAST_INSP_DATE // DATE
FROM INSP_TABLE

Use Trunc to truncate the timestamp and date to be able to filter data in an af:table

Also use  <af:convertDateTime pattern="MM/dd/yyyy"/> in both table filter as well as input date component

http://dkleppinger.blogspot.com/2011/09/how-to-ignore-time-component-of-date.html

Tuesday, October 1, 2013

custom validator ADF

http://jjzheng.blogspot.com/2010/10/create-custom-validators-in-adf.html

http://lucbors.blogspot.com/2011/10/adf-11g-quicky-3-adding-error-info-and.html

bind the component to bean; on Submit click, if there is any message/error to be shown; trigger the warning/error to the component

Regular Expressions to validate input string adf