Some sql errors and resolutions

1. SQL Error: ORA-00932: inconsistent datatypes: expected DATE got NUMBER
Put the input date as DATE '2016-09-30'

2.  <JDBC> <BEA-001129> <Received exception while creating connection for pool "SOADataSource": ORA-28000: the account is locked

ALTER USER DEV_SOAINFRA  identified by password ACCOUNT UNLOCK

and change the password in the datasource added in console

Controlling ADF loopback Script

This code controls the ADF loopback script to run on each new window opened, whether its a ADF popup or browser popup.




<context-param>
    <param-name>
        oracle.adf.view.rich.newWindowDetect.OPTIONS
   </param-name>
    <param-value>off</param-value>
  </context-param>

HTML Formatting / Styling in ADF outputText

HTML Formatting in outputText (Escape Attribute)

For applying styling to some of the content, outputText's escape attribute could be used. Example:-

<af:outputText value="&lt;h2>ADF Tips and Tricks&lt;/h2>"/>
<af:outputText value="&lt;h2>ADF Tips and Tricks&lt;/h2>"
               escape="false"/>

Output

<h2>ADF Tips and Tricks</h2>

ADF Tips and Tricks

Note: You should avoid setting the escape attribute to false unless absolutely necessary. outputFormatted  component is more recommended in such cases.

Precautions During ADF Fusion WebApplication project

If you are making a ADF webapplication then you must aware about some of the basic problems you can came around.

The most common problem is Screen Resolution. What I mean by screen resolution is that user may be on different screen resolution than your during development screen. An example may clear more:: 

For development you have resolution of 1280*1024 and every thing looks fine but even 1024*768 can ruin your application easily.

This happens usually when you try to fix the size of a stretchable component like table etc.In the following example I didn't set the size of table's width then it can accommodate any screen size because its a stretchable component.See below...

Now what I do is - I fix the size of table and see what happens...

Now see what happens when I decrease the browser's size ...

 Although I have scrolled horizontally till end but I can't see the columns after Salary

So don't try to set the width of  adf table ...

Jdeveloper time Zone error

This is one of the most common error one can face Probably when your database is in different time zone or wrongly configured time. It usually happens with the database on the Linux/Solaris servers...
There is a simple workaround for this. Here it is...


1.Go to  the Project properties of (Model and ViewController) ...Right click on Model and ViewController to go to Project Properties or double click it..
2.Go to Run/Debug/Profile on the Left Pane.
 3.Select Launch Settings on the left pane and in Java option enter this value Note: you can change according to your Timezone.
-Duser.timezone="+05:30"
this above command works for India .Set your time accordingly...
 4.Click OK and OK again Save your project and then close JDeveloper and open again.
5. Run your application again and you can see the error gone