System Folder Delete And Recover Artifacts ( DataSource , Repository URLS)

This post talks about how to take backup of configured datasources and repository (SVN) connection.

Follow these steps :

STEP 1 :

Take a back up of below files before you delete the old system folder

• SYSTEM_FOLDER\DefaultDomain\config\config.xml
• SYSTEM_FOLDER\DefaultDomain\config\jdbc

Folder

• SYSTEM_FOLDER\o.jdeveloper.subversion\repositories.xml

STEP 2 :

Now delete the systemFolder

STEP 3:

Restore configurations

Copy the jdbc-system-resource elements into config.xml from the backup config.xml
Copy the contents of jdbc from the back up into the new jdbc folder
Create a dummy repository connection and Copy the svn-repository elements from the back up repositories.xml

Note that these steps only restore the SVN repositories and data sources.

Unfortunately all the encrypted passwords got corrupted.

So had to clear the password save and reset the passwords.

Enjoy!!!

Hierarchical Dropdown in ADF

This post talks about how to display hierarchical dropdown in selectOneChoice.

There is one method explained by Frank here. Well this method show two levels in hierarchical dropdown using two af:ForEach iteration.

What if we have multiple level, and don't know how many af:forEach would be required. Other approach is to achieve required spaces through query to show dropdown structure. Thanks to my friend Prahlad for sharing this.

In below query, emp_disp will have appropriate spaces based on the level of the employee in the employee hierarchy.

select LEVEL,FIRST_NAME,LAST_NAME,
LPAD(FIRST_NAME ||' '|| LAST_NAME,length(FIRST_NAME ||' '|| LAST_NAME)+(LEVEL-1)*4,unistr('\00A0\00A0\00A0\00A0')) emp_disp
from EMPLOYEES
start with MANAGER_ID is null
connect by prior EMPLOYEE_ID = MANAGER_ID;

All you need to do is create a VO with above sample query and use this for dropdown.

Sample is uploaded here..

Enjoy.

Recover Missing Firefox icon..

Multiple times ...firefox seems to loose it's icon... and it looks real bad. I did some google and found this link : http://www.heerengandhi.com/2009/07/29/firefox-icon-went-missing-in-windows-7-heres-a-fix/comment-page-1/

Just copy paste of the instructions for my reference..and anyone else reading.

Follow these directions:

1. Close all folder windows that are currently open.
2. Launch Task Manager using the CTRL+SHIFT+ESC key sequence, or by running taskmgr.exe
3. In the Process tab, right-click on the Explorer.exe process and select End Process
4. Click the End process button when asked for confirmation.
5. From the File menu of Task Manager, select New Task (Run…)
6. Type CMD.EXE, and click OK
7. In the Command Prompt window, type the commands one by one and press ENTER after each command:
   CD /d %userprofile%\AppData\Local
   DEL IconCache.db /a
   EXIT
8. In Task Manager, click File, select New Task (Run…)
9. Type EXPLORER.EXE, and click OK.

Your icons should be as good as new!