[myob-request] Added cleaner code with new getRoleDefaultWidgets() method

[myob-request] Added missing dot

[myob-request] Use one query to retrieve the widget instances per org level

Instead of executing one query per organization, use just one query to retrieve the default widget instances per organization level.

[myob-request] Added new WidgetClassInfo class

[myob-request] Keep widget class definition in cache

The widget class definition information depends just in the Application Dictionary information, for this reason we are keeping now in cache once it is retrieved the first time.

Another slight modification is that the available widget list in Workspace is not being sorted in the client side.

Fixed issue 35073: Fetching data when it is sorting by a null FK is not working

Fetching data when it was sorting by a null foreign key was not retrieving any record when should
had been retrieved data.

When AdvancedQueryBuilder class is created order by clause and it is working in resolve joins a
canUseInnerJoin method is invoked. This method is used to check if the left join can be safely
replaced with inner join when it is building order by clause. This method is not take into account
all the posibilities.

The problem has been resolved by take into account when any property of the list is not mandatory
and is not primitive. In this case left join can not be replaced with inner join. The rest of the
cases can be safely replaced it.

related to bug 35855: requests borrow more than one connection from DB

Reuse connection to use incorrect user/password message

fixes issue 35852: Add a mechanism to cache the static resources

[login-static] Use JDK7 nio2 alternative instead of java.io.File

[login-static] Keep gen folder location cached