Practical experience on Oracle products

#ADF Talk Session 2 on Youtube

2012-01-17T23:44:00.002+01:00

In ADF Talk Session 2 Ulrich and me dive a bit deeper into the details of PL/SQL Code integration by custom jdev extension. The video shows the usage of custom jdeveloper extension: Application Module from Database Package. See it in action.

Get updated on new Sessions by following us on Twitter: @adftalk
Enjoy.

Play!ing with #WebSockets

2012-01-17T23:34:00.004+01:00

Development Stack

Server: Play 1.2.4, WebSocket
Client: jQuery, Boostrap
Tested with: Safari 5.0.5 (on Win XP)
On: Localhost

Inspired by a Blog-Post from Lucas Jellema I have done a similar demo with Play!.

The nice thing is that it was really easy to setup and deploy into the cloud. So everyone can test the websocket app - eeehm that was my initial plan (Actually it does not work currently, see why below). Further I took the chance to get in touch with git and published the source code on github. So feel free to test and fork.

https://github.com/multikoop/play-push-imgsel

Since there are some great cloud services arosed in the past I wanted to give it a try. So here are my experiences:

Deployment@Heroku

Prerequisite: install heroku CLI, git client (Please google for it how to set app. I only post the interesting stuff here)

C:\play\apps\play-push-imgsel>heroku login
C:\play\apps\play-push-imgsel>heroku create -s cedar play-push-imgsel
Creating play-push-imgsel... done, stack is cedar
http://play-push-imgsel.herokuapp.com/ | git@heroku.com:play-push-imgsel.git
Git remote heroku added

C:\play\apps\play-push-imgsel>git push heroku master
Counting objects: 46, done.
Delta compression using up to 2 threads.
Compressing objects: 100% (40/40), done.
Writing objects: 100% (46/46), 110.54 KiB, done.
Total 46 (delta 6), reused 0 (delta 0)

-----> Heroku receiving push
-----> Play! app detected
-----> WARNING: Play! version not specified in dependencies.yml. Default version
: 1.2.4 being used....
-----> Installing Play! 1.2.4.....
-----> done
-----> Installing ivysettings.xml..... done
-----> Building Play! application...
~        _            _
~  _ __ | | __ _ _  _| |
~ | '_ \| |/ _' | || |_|
~ |  __/|_|\____|\__ (_)
~ |_|            |__/
~
~ play! 1.2.4, http://www.playframework.org
~
1.2.4
Building Play! application at directory ./
Resolving dependencies: .play/play dependencies ./ --forceCopy --silent -
Duser.home=/tmp/build_jxh1de2j7wc9 2>&1
:: loading settings :: file = /tmp/build_jxh1de2j7wc9/.ivy2/ivysettings.x
ml
~ Resolving dependencies using /tmp/build_jxh1de2j7wc9/conf/dependencies.
yml,
~
~
~ No dependencies to install
~
~ Done!
~
Precompiling: .play/play precompile ./ --silent 2>&1
Listening for transport dt_socket at address: 8000
10:26:55,430 INFO  ~ Starting /tmp/build_jxh1de2j7wc9
10:26:56,387 INFO  ~ Precompiling ...
10:27:03,224 INFO  ~ Done.
-----> No Procfile found. Will use the following default process:
play run --http.port=$PORT $PLAY_OPTS
-----> Discovering process types
Procfile declares types -> (none)
Default types for Play! -> web
-----> Compiled slug size is 26.6MB
-----> Launching... done, v5
http://play-push-imgsel.herokuapp.com deployed to Heroku

To git@heroku.com:play-push-imgsel.git
* [new branch]      master -> master

C:\play\apps\play-push-imgsel>heroku open
Opening http://play-push-imgsel.herokuapp.com/

C:\play\apps\play-push-imgsel>

This is an awesome and easy to use stack!!!!! #PGH => Play, Git, Heroku!

Deployed at: http://play-push-imgsel.herokuapp.com/

Application is accessible but WS request are not working (oops).

C:\play\apps\play-push-imgsel>heroku logs
...
...
2012-01-14T10:36:29+00:00 heroku[router]: Error H12 (Request timeout) -> GET pla
y-push-imgsel.herokuapp.com/ap... dyno=web.1 queue= wai
t= service=30000ms status=503 bytes=0

=> Feature Request has been filed at Heroku. http://support.heroku.com/tickets/40910

Deployment@Cloudbees

Since WebSocket is currently not supported (according to: http://www.jamesward.com/2011/12/11/tutorial-play-framework-jpa-json-jquery-heroku) I decided to give cloudbees a try. Same here

Deployed at: http://play-push-imgsel.multikoop.cloudbees.net/

Same issues here:

... 20:27:42,952 WARN ~ 404 -> GET /application/pushimgsel/process (GET /application/pushimgsel/process) ...

=> Request #2383 "HTTP 404 on WebSocket Reque..." created. https://cloudbees.zendesk.com/tickets/2383

Conclusion

The cloud is not ready for WebSocket applications in early 2012! ;-)

If you want to see the demo live, all you need to do is

-Install Play 1.2.4

-Get push-imgsel Sourcecode: https://github.com/multikoop/play-push-imgsel

-Test with Safari (Other modern browsers currently not working, cause WebSocket Implementation in Play 1.2.4 cannot handle the newest Sec-WebSocket-Version Headers. Hopefully it will be fixed in 1.2.5 at least in 2.0.

Have fun!

ADF: MDS power user layer and "How to control MDS customizations at runtime"

2012-01-01T17:54:00.006+01:00

Tested with: JDeveloper/ADF 11.1.1.2
Happy new year 2012 to all of my readers! First post this year is a follow up on "ADF: Define default UI for MDS user customization".
http://multikoop.blogspot.com/2010/01/adf-11g-define-default-ui-for-mds-user.html
Introduction
In that previous post I introduced a feature to be able to define a default UI layout at runtime by a specific user. That particular UI customization acts as the initial default for any other logged in users. That is great and simplifies developers life as the default layouting (which columns to display, in which order arrange, splitter posisions and so on) can be done by a business user.
Although those great capabilities there is still a lack of control regarding applied MDS customizations of specific users. In User Support situations it is often helpful to reset the user customizations to factory defaults in order to have the "same view on the UI".
So here is our solution how to be able to reset MDS Customizations at runtime for ALL users, or for specific users with regards keeping the power user defaults.
First recap that we have defined a special layer "DefaultUserCC"

With this Customization class configured it is now possible to login as the user "layout" and define the default UI for all other users. It just means that the DefaultUserCC customizations are applied before the UserCC. (So the order of the CCs in the above screen is important!)
(You can test the behaviour with attached sample application based on ADF11.1.1.2. See download link at the end of this post)
Sample application

Two test users bob and alice and the power layout user "layout".
1. Login as layout
2. Remove all rows except Firstname and Lastname, Email.

3. Logout layout
4. Login as bob

[Notice that bob has inherited the ui settings from user layout]
5. Now Remove the email column

6. Logout bob
[Imagine: You get a support call from user bob. He says he is not able to lookup the email adress. To simplify further investigations you should be able to get his user layout back to default.]

7. Login as layout (or in general as an MDS Admin)
8. Enter username: bob

9.Click "Reset to layout user defaults"
As feedback you will get

[Imagine: In Support case you would now advise the user to login again. From that moment you can be sure user bob has same ui layout as defined by the user layout.]
Wow. This is a really powerful feature I think. Is there any other web app framework which can do this? ;)
How we do it: Delete MDS documents at runtime
To implement the mentioned features there is not really much to do (beyond the basic MDS configuration which I will not describe here. See references for details.)
1. Implement and configure custom Customization Class (Here: DefaultUserCC.java)
2. Use Oracle MDS API to delete MDS documents. To find how this actually can be done I followed to approaches. a) Reverse engineeer from deleteMetadata WLST command. b) Google.
Option a guided me through

oracle.mds.internal.lcm.mbean.AppRuntimeMBeanImpl
   public Map deleteMetadata(String[] docs, String[] custNames, boolean excludeAllCust, boolean excludeBaseDocs, boolean excludeExtendedMD, boolean cancelOnException)

oracle.mds.internal.lcm.MDSLCMManager
   Map deleteMetadata(String[] docs, String[] custNames, boolean excludeAllCust, boolean excludeBaseDocs, boolean excludeExtendedMD, boolean cancelOnException, Locale locale)
      ...
      doDelete(...)

  List doDelete(MetadataStore store, String[] docs, boolean excludeAllCust, boolean excludeBaseDocs, boolean excludeExtendedMD, boolean cancelOnException, TypeConfig typeConfig, CustConfig custConfig, List custLayerFilterList, DependencyConfig dConfig)
       ...
       TransferUnitList transferUnitList = TransferUnitList.create(mdsInstance, docsList, transferOptions, !excludeBaseDocs, true);
       List resultList = MDSTransfer.getInstance(mdsInstance).delete(transferUnitList, cancelOnException);
       ...
oracle.mds.internal.transfer.InternalMDSTransfer
    delete ...
    execute....

Option b guided me to a some really great resources. 1. http://oraclemw.blogspot.com/2011/04/working-with-oracle-mds-repository.html 2. http://idmclub.wikidot.com/metadata-store where I found some basic information on the usage of the MDS API.
Finally I came up with a MDSUtils.java and MDSAdminBean.java which does the needed work.
Here are the most important code snippets
MDSUtils.java

public static void deleteDocuments(final MDSInstance mdsInstance,
final List listOfFiles) throws MDSException {

MDSTransfer transferInstance = MDSTransfer.getInstance(mdsInstance);

TransferUnitList transferUnitList =
TransferUnitList.create(mdsInstance, listOfFiles, null, true,
true);
transferInstance.delete(transferUnitList, false /* cancelOnException */);
transferInstance.release(mdsInstance);
}

public static List queryAllFiles() {
final MDSSession mdsSession = MDSUtils.getCurrentMDSSession();

//String packagePath, String documentName, boolean recursive,
final NameQueryImpl nameQuery =
new NameQueryImpl(mdsSession, ConditionFactory.createNameCondition("/",
"%",
true));
final Iterator result = nameQuery.execute();
final ArrayList listOfFiles = new ArrayList();
while (result.hasNext()) {
final QueryResult qr = result.next();
final String absoluteName = qr.getAbsoluteName();
listOfFiles.add(absoluteName);
}

return listOfFiles;
}

MDSAdminBean.java

Nothing special here. Just use the "hard worked out";-) MDSUtils in action listern methods, e.g.

List listOfFiles =
MDSUtils.queryFilesMatch("/mdssys/cust/user/" + username);
try {
System.out.println("MDS Admin: Deleting " + listOfFiles);
MDSUtils.deleteDocuments(listOfFiles);
FacesContext.getCurrentInstance().addMessage(null,
new FacesMessage(FacesMessage.SEVERITY_INFO,
null,
"Deleted the following MDS-Documents for user " +
getUsername() +
": " +
listOfFiles));
} catch (MDSException e) {
e.printStackTrace();
}

Download the application and checkout the customization possibilities with bob, alice and layout!

http://www.box.com/s/kvjc43my8mbvoyi9lh3v (JDev 11112 Workspace)

References

User Customization with and without MDS

http://blogs.oracle.com/raghuyadav/entry/user_customization_with_and_wi

Programmatic access to Oracle Metadata Store (MDS)

http://idmclub.wikidot.com/metadata-store

Working with Oracle MDS Repository (MetaData Services)

http://oraclemw.blogspot.com/2011/04/working-with-oracle-mds-repository.html

ADF: Define default UI for MDS user customization

http://multikoop.blogspot.com/2010/01/adf-11g-define-default-ui-for-mds-user.html

Custom ADF Skin: Consume as Library

2011-12-20T22:44:00.002+01:00

Tested with JDeveloper: 11.1.2.1.0
Main purpose of this post is for me to have a reference project and proof of concept using an ADF Skin as Library.
Part 1: Skin Application
So first the ADF Skin project should be created. Since JDevR2 this process has been simplified by new ADF Skin wizard.

In the next screen just give your skin a name and extend from the fusionFx-simple-v2.desktop Oracle Skin. It is specially designed with extensibility in mind for cusom skins. Fortunataly the recommended skin is selected. (It is not with every ADF/Jdeveloper feature ;). So well done Oracle!

The following bunch of things is created on the fly

Now lets create a "green" skin with smallest amount of modifications. This is achieved by opening the CSS file and
go to the "Images" View. Just change some of the colors.

And afterwards click "Apply to Skin"
=> This will generate a lot of images according to your color schema.

In order to support versioning of skin I am adding the following to the trinidad-skins.xml
   <version>
     <name>v1</name>
     <default>true</default>
   </version>
=>

Now we are ready to bundle the custom skin as ADF library. There is nothing special here. Create the Deployment profile, keep defaults and deploy.
Next step is to test the provisioning of the ADF Skin through ADF Library through File System connection. To do that we create a filesystem connection in the resource pallete

The Skin shows up as expected

Part 2: Consume ADF Skin
a) Create an pure empty Fusion ADF Application by wizard.
b) Select the ViewController project
c) Select adflib-myskin.jarm Right Click and Click add to Project

The Message Pane should output something like
These ADF Library jar items are now in ViewController.jpr
{
file:/C:/ak/JDeveloper/mywork/TestADFSkin/MySkin/deploy/adflib-myskin.jar
These are in the project as a result of your ADF jar imports:
Resource Bundle Variable Resolver from .../TestADFSkin/MySkin/MySkin.jpr
}
d) Apply custom ADF Skin as default in Project Properties>ADF View

e) Create a simple JSF Page based on the threeColumnTemplate and take a look

At Design-Time there seem to be some problems.
At Runtime it looks as expected

Is it a Bug at Design Time?
Using just a QuickLayout everything is as expected also in design time

Download Sample Workspaces: http://www.box.com/s/h8mggth460ntujhg7o3r

RESTful Management Services in Oracle WebLogic Server 12c

2011-12-13T17:53:00.001+01:00

Version: 12.1.1 (developer edition, ZIP, no installer)

Installation

unzip wls1211_dev as follows

In order to be able to work with this edition we have to call configure.cmd. This basically unpacks all jars, create the registry.xml and wlserver\.product.properties

To have some reusable snippets I have created additional scripts in the new MW_HOME

env_wls12c_dev.cmd

@echo off
@rem ***************************************************************************
@rem This script is used to set the environment for
@rem Oracle WebLogic Server 12.1.1 dev ZIP edition
@rem ***************************************************************************

set MW_HOME=C:\oracle\product\12.1.1\middleware
set JAVA_HOME=C:\oracle\product\11.1.2.1\middleware\jdk160_24
set JAVA_VENDOR=Sun

install_wls12c_dev.cmd

@echo off
@rem ***************************************************************************
@rem This script is used to install Oracle WebLogic Server 12.1.1 dev ZIP edition
@rem ***************************************************************************

call env_wls1211_dev.cmd

title Installing WLS 12.1.1.0...

call %MW_HOME%\configure.cmd

pause

Now execute install_wls12c_dev.cmd

In order to create a domain by configuration wizard

a) call env_wls12c_dev.cmd

b) %MW_HOME%\wlserver\common\bin\config.cmd

RESTful Management Service API

Sounds cool...lets try

Activate by Domain > Configuration > Advanced Configuation > Enable RESTful Management Services

=> (restart required)

After restart you will notice the following in the output

INFO: Scanning for root resource and provider classes in the packages:
 weblogic.management.rest.resources
 weblogic.management.rest.provider
13.12.2011 00:03:13 com.sun.jersey.api.core.ScanningResourceConfig logClasses
INFO: Root resource classes found:
 class weblogic.management.rest.resources.ApplicationResource
 class weblogic.management.rest.resources.TestResource
 class weblogic.management.rest.resources.ClusterResource
 class weblogic.management.rest.resources.DataSourceResource
 class weblogic.management.rest.resources.ServerResource
13.12.2011 00:03:13 com.sun.jersey.api.core.ScanningResourceConfig logClasses
INFO: Provider classes found:
 class weblogic.management.rest.provider.CollectionResponseXmlProvider
 class weblogic.management.rest.provider.ItemResponseJsonProvider
 class weblogic.management.rest.provider.CollectionResponseJsonProvider
 class weblogic.management.rest.provider.CollectionResponseHtmlProvider
 class weblogic.management.rest.provider.ItemResponseHtmlProvider
 class weblogic.management.rest.provider.ItemResponseXmlProvider
13.12.2011 00:03:14 com.sun.jersey.server.impl.application.WebApplicationImpl _i
nitiate
INFO: Initiating Jersey application, version 'Jersey: 1.9 09/02/2011 11:17 AM'

(=> This is good news! It states that some RESTful service will be available.)

After Restart open http://localhost:7001/management/tenant-monitoring/servers

(the authorized users must be in the group Administrators or Monitors)

If you e.g. need better proccessable formats, JSON and XML are of course also supported. Let's see how it is done and what it looks.

Add Accept Header with application/json

Add Accept Header with application/xml

Currently there is REST support for Servers (all in a domain or specific one), Clusters ( all in a domain or specific incl server members), applications (all in a domain or specific app), data sources (all in a domain or specific).

With these capabilities it' possible to implement a custom monitoring solution. A slim mobile wls monitoring app (and more)! => Hands on;)

See doc for details of all available RESTful-Services in WLS12.1.1 http://docs.oracle.com/cd/E24329_01/web.1211/e26722/toc.htm

Collected Documentation links

Overview OTN: http://www.oracle.com/technetwork/middleware/weblogic/documentation/index.html

WLS 12c Data sheet: http://www.oracle.com/us/products/middleware/application-server/oracle-weblogic-server-ds-1391360.pdf

WLS 12c online Documentation Library: http://docs.oracle.com/cd/E24329_01/index.htm

Usind RESTful Services With WLS 12c: http://docs.oracle.com/cd/E24329_01/web.1211/e26722/toc.htm

Dislikes

- Still many BEA* stuff in diffrent scripts. It would be nice to have a clean and straight product without any historical garbage.

- configure.xml : ProgramGroupName=BEA WebLogic Platform 10.3 (Integrated Build)....

Why there is still the need to have a programm group called "BEA WebLogic Platform 10.3"?

My suggestions: Oracle WebLogic Platform 12.1.1 or Oracle Fusion Middleware Platform 12.1.1, everythin else, but not 10.3!

Like

- Java EE 6 Support. (It took a long time..)

- Better Maven Support

- RESTful Management Service

- ZIP distribution. Although the file is called wls1211_dev.zip it is possible to create a domain in production mode by the configuration wizard. At least in a simple testdrive it worked for me.

-Startup time feels better than wls11g

- more to test...(-Dservertype=wlx to avoid loading EJB, JMS, JCA )

ADF News Session (german) - Integration of BI Publisher into ADF Applications

2011-12-09T14:31:00.002+01:00

The folowing session was presented today on the german ADF News Session that is driven by the german ADF community.

Although the slides are in german I think the ADF concepts should be well decoupled from the language itself ;)

Integration of BI Publisher in ADF applications

View more presentations from multikoop.

Similiar Stuff / Links

ADF: Panel Tabbed Inter-Region Communication through shared bean datacontrol

2011-11-26T20:57:00.002+01:00

Tested with JDeveloper 11.1.1.2

Use Case

JSF Page with two tabs (Departments, Employees)
The DepartmentName is rendered as a command link. If the user clicks on a DepartmentName the view changes on to the Employees Tab and filters the data
In each tab there is an static adf region (bound to fragment based BTF)

In summary we need the following to do:

DepartmentName as command link
View switches to the Employees Tab
Tab text should change to “Employees (<DepartmentName>)
On the employees tab - of course – only the corresponding entries should be displayed
The employees tab contains a button to remove the “global” filter.

How to do it?

Create DataExchange Bean as follows
public class DeptEmpExchange {
    private Number deptId;
    private String deptName;
    public DeptEmpExchange() {
        super();
        System.out.println("DeptEmpExchange created " + this);
    }
    public void setDeptId(Number deptId) {
        this.deptId = deptId;
    }
    public Number getDeptId() {
        return deptId;
    }
    public void setDeptName(String deptName) {
        this.deptName = deptName;
    }
    public String getDeptName() {
        return deptName;
    }
    /**
     * Exposed as DC Operation.
     * Called from the dept btf
     * @param deptId
     * @param deptName
     */
    public void onDepartmentChange(final Number deptId,
                                   final String deptName) {
        System.out.println("onDepartmentExchange called: " + deptId + "/" + deptName);
        setDeptId(deptId);
        setDeptName(deptName);
        View1Bean view1 = (View1Bean)JSFUtils.resolveExpression("#{View1Bean}");
        view1.getEmpTab().setDisclosed(true);
        view1.getDeptTab().setDisclosed(false);
        view1.setEmpTabText("Employees ("+deptName+")");
        AdfFacesContext.getCurrentInstance().addPartialTarget(view1.getPanelTabbed());
    }
And expose as JavaBean DataControl.
Now, on depts page fragment: drop the exposed operation onto the command link and provide the parameters from the current row.

The refresh of the panel tabbed is done programmatically in the onDepartmentChange(..) method. In order to refresh the emp btf with the new dept id configure the following bindings / properties on the main page

- create an attribute binding on the deptId from the DeptEmpExchange Bean.
- bind the tf input parameter to the attribute binding
- do not forget to set refresh=ifNeeded => this causes the btf to refresh in case the input params will change.
Implementing the “remove global filter” functionality is pretty simple. Just drag the onDepartmentChange-Operation from the data control palette on to the toolbar and adjust the text.

I hope I have not forgotten any important steps.

Download JDev11112Workspace

Update on Dec 19th 2011: Added Sample Application

ADF Faces: Navigate on Checkbox selection

2011-11-24T11:26:00.001+01:00

Used in Version: 11.1.1.2

As you may have noticed there is no action attribute on af:selectBooleanCheckbox. So how could you trigger a navigation case if user changed selection state of the checkbox.

In a customers scenario I need to trigger a navigation in a BTF from a checkbox insige a jsff

<af:selectBooleanCheckbox label="Klick me" id="sbc1"
selected="#{MyBean.selected}"
autoSubmit="true"/>

MyBean.java looks like

 public void setSelected(String value) {
    final FacesContext context = FacesContext.getCurrentInstance();
    
    if ("true".equalsIgnoreCase(value)) {
        // checkbox is selected
        context.getApplication()
            .getNavigationHandler()
            .handleNavigation(context,null,"selected");
        return;
    }

    // checkbox is not selected
    context.getApplication()
        .getNavigationHandler()
        .handleNavigation(context,null,"notSelected");
 }

ADF Talk on Youtube started

2011-11-22T17:00:00.003+01:00

Today Ulrich and me started a series of sessions on ADF Topics.

In ADF Talk Session 1 we are introducing a way to integrate PL/SQL Code into ADF fusion applications. The video shows the usage of custom jdeveloper extension: TEAM Application Module from Database Package. See it in action.

My DOAG 2011 Slides – Upgrade Guide for Oracle ADF on WebLogic Server

2011-11-21T13:12:00.002+01:00

Just translated my german slides from DOAG 2011 and uploaded those to slideshare.
Hopefully someone will find it useful. At the conference there were just too few attendees…
http://www.slideshare.net/multikoop/doag-2011-upgrade-guide-for-oracle-adf-on-weblogic-server

DOAG 2011 - Upgrade Guide for Oracle ADF on WebLogic Server

View more presentations from multikoop

ADF 11.1.2.1 - clicktoedit table, createinsert, rollback bug?

2011-11-11T16:31:00.001+01:00

ADF version: 11.1.2.1
Firefox: 5.0

Prerequistes

-Using ADF BC
-Create the most simple jsf page declarativly (no custom java code)
--table features: single selection, sorting, filtering
--change table attributes: editingMode=clickToEdit

Steps to reproduce

1. start http://127.0.0.1:7101/TestInsertIntoClickToEditTable2-ViewController-context-root/faces/view1

[notice the yellow marked rows.]

2. Now Click on CreateInsert

OK, new row is inserted and can be edited now.

3. Click on Rollback-Button (or Execute-Button)

What happened to the last two rows?

Further issue: clicktoedit not working on some rows

You may click as often you want. The row won't change into edit mode. In the log window you will see

<FacesCtrlHierBinding$FacesModel> <makeCurrent> ADFv: Keine Zeile gefunden für rowKey: [oracle.jbo.Key[191 ]].

Known workaround so far

1. Click the Execute-Button after Rollback.

2. Bind Rollback action to a backing bean method and do the following (Rollback + setActiveRowKey)

/**
* Rollsback and Re-Executes the table iterator
* @param actionEvent
*/
public void onRollback(ActionEvent actionEvent) {
final DCBindingContainer bc = (DCBindingContainer)getBindings();
bc.getOperationBinding("Rollback").execute();

setActiveRowKey(bc);
}

/**
*
* @param bc
*/
private void setActiveRowKey(final DCBindingContainer bc) {
    final DCIteratorBinding empIter = bc.findIteratorBinding("EmployeesView1Iterator");
    final Row newRow = empIter.getCurrentRow();
    final ArrayList activeRowKeyList = new ArrayList();
    activeRowKeyList.add(newRow.getKey());
    getEmpTable().setActiveRowKey(activeRowKeyList);
}

public BindingContainer getBindings(){
return BindingContext.getCurrent().getCurrentBindingsEntry();
}

Download

Sample Application: http://www.box.net/s/od2t8en8ojo3hho704uz

Similiar issues

http://adfbugs.blogspot.com/2010/03/rollback-does-not-refresh-current-row.html

JDev 11.1.2.1 – Clear WLS Log tab Bug?

2011-11-11T13:06:00.001+01:00

Applies to JDeveloper: 11.1.2.1

Problem Description

After starting the integrated WLS from JDev the wls log is displayed in the log tab. Open mouse context menu and “clear” item is not activated

I have no chance to clear the log tab!! Arghh.

Is there any good reason for this behaviour? ( not beeing able to clear the log). The memory consumption is already enormous. Dear Oracle, please let me clear the log tab again…

Never seen this issue in 11gR1 versions.

Is there any workaround?

[solved] Download offline bc4j-junit_bundle 11.1.2.1 version/download link mismatch

2011-10-08T12:06:00.001+02:00

Applies to: JDeveloper 11.1.2.1

Download from: http://www.oracle.com/ocom/groups/public/@otn/documents/webcontent/131167.xml#oracle.BC4J.junit

Problem description

Trying to install the downloaded bc4j-junit_bundle offline version as extension I get the following error

Analysis

Open the corresponding bundle ZIP an lets see if it is really wrong version

But as you can see I have downloaded the correct version. So there is a mismatch.

Solution

After further investigating the download link I realized that it just references the old version

http://download-llnw.oracle.com/otn-pub/jdeveloper/11.1.2.0.0/extensions/bc4j-junit_bundle.zip

So let's try to adjust manually the URL und download

http://download-llnw.oracle.com/otn-pub/jdeveloper/11.1.2.1.0/extensions/bc4j-junit_bundle.zip

é voilà now the installation works fine as well

[solved] JDeveloper - Install Extensions offline / licences check issue

2011-10-08T11:51:00.001+02:00

Applies to: JDeveloper 11.1.2.1

Issue

Results in

The impact is that you are unable to install JUnit-Extension in a Workshop Lab e.g. where

you can't assume that the attendees have an internet connection

Workaround

Because we are quite smart let's workaround....

Open Bundle with your favourite archiver tool

and remove or comment out the following line

<u:requires-agreement url="http://junit.sourceforge.net/cpl-v10.html" />

Save change and Update Archive.

Import extension again.

=> No license check requirement shows up. Yeeeees we can!

Upgrade Oracle Team Productivity Center to 11.1.2.1 / Hudson Plugin

2011-10-03T18:53:00.001+02:00

From Version: 11.1.1.5
To Version: 11.1.2.1

Prepare

Check the content of the current otpc schema

SQL> select * from otpc_version t;

ID DB_UPGRADE_NUM DB_VERSION VERSION

-------------------- -------------------- ---------------------------------------------------------------- --------------------

1 2 11.1.1.5.37.60.13 1

Download tpcinstaller.jar from OTN

Installation

Start new installer

jar -jar tpcinstaller.jar

Click Next

Great: The installer recognized everything, so you really can expect the installation process will do the right thing

Choose: NExt

Point to the autodeploy directory of the privious installation. If you just point to the DOMAIN_HOME Location you will get an exception:

TPC-90026: The otpc.war of current installation for upgrade is missing in the server deployment directory

(Enhencement request: The installer should be smart enough to be able to check for otpc.war in the given domain!)

Choose: Next

...

Upgrade completed. Plus Hudson Plugin installed.

Verify installation/ Upgrade

Verify otpc_version in database schema:

SQL> select * from otpc_version t;

ID DB_UPGRADE_NUM DB_VERSION VERSION

-------------------- -------------------- ---------------------------------------------------------------- --------------------

1 2 11.1.2.1.38.60.81 2

SQL>

Everything worked as expected. Nice.

Lets start weblogic and check if otpc server is running

Seems to run, but (as stated in one of my privious posts) nobody can be sure which version actually is running. Especially from an ALM tool which now integrates with hudson I REALLY CAN EXPECT to see a BUILD-Number here! Dear Oracle, if you are reading this, please log an enhencement request to integrate a build number in the otpc server homepage! Further it would be nice if that homepage lists all installed otpc plugins (plus which version of course). Thanks.

BTW:

After starting the new otpc server a new folder has been created in DOMAIN_HOME

activemq-data

=> Oracle uses ActiveMQ now. I think in order to be able multi app server compatible. And ActiveMQ is obviously tinier than the WLS one.

OTPC Hudson Plugin

Now I am really interessted in how the hudson plugin looks like. So lets start my local hudson sanbox.

java -jar hudson-2.1.1.war -httpPort=8081 (8080 is used by the XE DB)

Observing the Hudson > Plugin Manager > Installed

=> No hints to a newly installed plugin

Looking into Hudson > Plugin Manager > Available

=> Bingo.

(Additional info. The plugin has been put to

$HUDSON_HOME/HudsonTpcPlugin.hpi

by the OTPC installer and not into the $HUDSON_HOME/plugins/ as I would expect.)

Ok, move on

Restart hudson.

The otpc plugin shows up in the installed section of the plugin manager.

So now we can use the plugin in our hudson jobs. Choose your job and configure..

Save changes and run your job.

Check the jobs console output

"The test result(s) Testergebnis will be sent to the Oracle Team Productivity Team Server at http://localhost:7001.

Successfully loggedin."

Thats all so far. Nothing else shows up in your hudson ui ;-(

What's next

Check OTPC in new JDev 11.1.2.1

Let's open an old task repository

Hhhm. let's create a new task repository

Same problem here.

Conclusion

OTPC is still not enterprise ready. OTPC should improve in the following

Task repository connection does not work in new version! Wow. Where is the mistake? the server logs

WARNUNG: RepositoryServerServiceImpl.getAll() 10/03/2011 17:43:29 MESZ - reposit

ory server 'New Repository Server11121' does not have any parameters by parentN

ame 'REPOSITORY_SERVER.New Repository Server11121.OTCP Task Repository11121'.

03.10.2011 17:43:29 oracle.alminternal.server.core.RepositoryServerServiceImpl g

etAll

Integration BUILD-Number into otpc server homepage

List installed connectors on otpc server homepage

Integrate LDAP vor OTPC Users/Groups. Provide a mapping from those users/groups to OTPC Roles

Integrate some nice charts in the hudson jobs webpages ;)

Like (in general about OTPC)

Saving the IDE context for a specific task.!! This really rocks!

JDeveloper 11.1.2/WLS 10.3.5 hot deployment issue [solved]

2011-09-07T23:16:00.001+02:00

Status: Solved

Applies to: JDeveloper 11.1.2 / WLS 10.3.5, Windows XP

Problem Description

Having activated the WebLogic Fast Swap Option

a strange Exception comes up in the Log-Window for the integrated WebLogic Server output.

java.net.URISyntaxException: Illegal character in opaque part at index 16: zip:C:/Dokumente und Einstellungen/ak/Anwendungsdaten/JDeveloper/system11.1.2.0.38.60.17/DefaultDomain/servers/DefaultServer/tmp/_WL_user/adf.oracle.domain.webapp/q433f9/WEB-INF/lib/adf-richclient-impl-11.jar!/oracle/adfinternal/view/faces/renderkit/rich/PageTemplateRenderer.class
at java.net.URI$Parser.fail(URI.java:2809)
at java.net.URI$Parser.checkChars(URI.java:2982)
at java.net.URI$Parser.parse(URI.java:3019)
at java.net.URI.<init>(URI.java:578)
at java.net.URL.toURI(URL.Java:918)
at com.bea.wls.redef.io.ClassChangeNotifier.toURI(ClassChangeNotifier.java:251)
at com.bea.wls.redef.io.ClassChangeNotifier.isRelative(ClassChangeNotifier.java:211)
at com.bea.wls.redef.io.ClassChangeNotifier.updateCache(ClassChangeNotifier.java:80)
at com.bea.wls.redef.RedefiningClassLoader.findClass(RedefiningClassLoader.java:115)
at java.lang.ClassLoader.loadClass(ClassLoader.java:305)
at java.lang.ClassLoader.loadClass(ClassLoader.java:246)

Issue Analysis

It turns out that the Exception occures because the (by default) created WebLogic domain is located at a directory which contains spaces, e.g. C:/Dokumente und Einstellungen/<user>/Anwendungsdaten/JDeveloper/system11.1.2.0.38.60.17/

Solution

Move your JDev User Dir to a location without space in directory names! This can be done as follows

1. systemwide (for all your JDev installations)

2. or finegrained (for specific JDev installation)

$MW_HOME\jdeveloper\jdeveloper.exe -J-Dide.user.dir=c:\ak\JDeveloper

(this will not effect other jdeveloper installations on your machine.)

If you now start Jdeveloper a new jdev user dir will be created.

Note: If you want to keep your prefs, etc. copy the system11.1.2.0.38.60.17 from old location to the new one and delete the wls default domain

system11.1.2.0.38.60.17\DefaultDomain directory. (This is needed, because many scripts in DefaultDomain are generated at time of domain creation and so may contain absolute paths! So in order not to get stuck with those issues just delete the DefaultDomain directory. it will be created next time you start wls from jdeveloper)

Conclusion

After moving the jdev user dir you will see in the wls log window

[05:26:06 PM] Updated /C:/ak/JDeveloper/system11.1.2.0.38.60.17/o.j2ee/drs/<app>/<app>WebApp.war/WEB-INF/classes

(after Rebuild of your ViewController project).

Happy fast swapping! It is a real timesaver now!

Further reading

Section 36.4, "Reloading Oracle ADF Metadata in Integrated WebLogic Server." of fusion developmen guide 11.1.2.0.

ALM with Oracle Team Productivity Center, OpenFire and Hudson

2011-05-19T00:41:00.001+02:00

Applies to: JDeveloper 11.1.1.2+, OTPC 11.1.1.2+

Introduction

Since JDeveloper 11g does not provide integration with Hudson CI Server I came up with the idea to use the chat component of Oracles Team Productivity Center Plugin in combination with OpenFire (XMPP Server) and hudson ci on your build server with IM plugin. The main aim is to be able to start builds from the jdeveloper IDE and also get informed if a build currently is running.

Prepare

Install OpenFire and create some test users + a user that acts as Hudson CI bot (See http://www.igniterealtime.org/projects/openfire/)
Install Oracle Team Productivity Center Plugin in JDeveloper
Install Hudson CI Server with the following plugins
1. Instant Messaging Plugin
2. Jabber Plugin
Configure Hudson as follows (Hudson > Manage Hudson > Confgure System)

Test Drive

Setup Build-Job with Hudson as follows
Open JDeveloper and connect with open fire by clicking (View->Team->Chat)

Now try to start a build by entering

!build <jobname>

Benefits

- Keeps Focus on Coding in JDeveloper. And so => Minimizes human context switches!

- Developers get instantly informed by the chat what's going on on the build server

- Developers are able to schedule jobs from JDeveloper

- The status of Hudson is transparent for everyone as it appears in your buddy list. If not you immediatly know that there is something wrong: server down, hudson not running, etc..

Cool stuff!

ADF 11g BC - Reactivate the "Add from Table..." button in Entity Object Overwiew Wizard

2011-01-14T17:35:00.001+01:00

Applies to : JDeveloper 11.1.1.2

Problem description

you are connected to database (network)
you are able to choose the desired button
so everything is fine, you are able to work productive

But

you're went standby with your machine because you moved from work to homeoffice
waking up you're machine, connecting to network you want to invoke "Add from Table...." button
=> No chance. the button is disabled! See my screenshot
-OK so first solution comes to mind. reopen the *EO.xml file
=> No change.the button is still disabled!

Fastest Solution found so far

Open the project settings and navigate to Business compontens section
Do nothing, apply the button "OK" (not visible in screenshot)
=> the db connections seems to be reestablished or verified or what ever
Close the EO.xml and reopen it
=> "Add from Table..." button is activated!
=> No need to restart JDeveloper. That would be another solution. But takes a lot more time if you only have an average hardware.

Failed solution approaches

close *EO.xml and reopen it. => "Add from Table...." button is still deactivated

Open questions / improve usability suggestion

Which circumstance leads actually to disable the "Add from Table..." button?
It would be nice if the "Add from Table..." button would be active for ever. On Demand/Click would be reported if there is no valid database connection.

Have you experienced similar annoying problem? Any useful hints for the observed behaviour would be greatly appreciated.

Andreas.

Reusing taskflows using ADF Libraries

2010-06-23T18:14:00.001+02:00

Used version: JDeveloper 11.1.1.3

Last week I did a short presentation on “ADF Taskflow Integration” on the german ADF Partner Community.

The presentation covers some basics on ADF task flows, ADF Library and the integration process with the focus on reuseabilty. I think it is worth to share with the english community as well;-)

Download

slides (german)
Workspaces (JDev11R1PS2, 11.1.1.3, HR)

Further Information

Type error in Installation Guide for Oracle Team Productivity Center Server 11.1.1.3?!

2010-05-09T17:40:00.002+02:00

Short post, but quite interesting to mention I think.

While going through the current installation guide of Oracle TPC Server 11.1.1.3 the following line catched my eyes:

“If you are using WebLogic Server as the installation server, make sure you are using version 10.3.4.”

That’s really up to date information;) IMHO WLS 10.3.3 is the “most current” WLS version.

Further information

Monitoring Dashboard in WLS Administration Console introduced

2010-04-30T00:31:00.001+02:00

Type: Info
Applies to: Oracle WebLogic Server: 10.3.3

Just after JDeveloper 11.1.1.3 was released of course I had to give it a try;-) Somehow I am always curious about changes the Admin Console of the WLS. Since WLS is integrated it is really easy and quick to do. Just start a simple ADF Fusion Web app and open http://localhost:7101/console

The following things catched my eyes:

a) The Admin Console is internationalized. On my laptop the login form appears in german by default now:

To change the language you just have to change the preferred language in the browser settings and reload the page.

b) On the Homepage I recognized a new entry:

This opens the so called “Monitoring Dashboard” which obviously is developed by ADF Faces RC. Cool! No activation of the diagnostic console needed! No slowly loading Applet;) Thanks!

c) the diagnostic-console can still be activated in the preferences but just in order to inform that it has been replaced by the new monitoring dashboard….and the Request Performance

d) Request performance
At the first look the view is a bit disappointing because you will not see anything here until you “…first configure WLDF instrumentation to use the ElapsedTimeAction diagnostic action attached to "Around" diagnostic monitors. Only data from the ElapsedTimeAction action is shown on this page.” See the context help for more information. (Maybe I will blog about it in more detail in a separate post)

It would be nice if this information (to first configure a WLDF inst) would be visible as INFO or WARNING directly on the Request Performance Tab.

ADF 11g: Be aware of the right run context

2010-04-18T17:50:00.002+02:00

Used version: JDeveloper 11.1.1.2.0

Problem description

Last week I did a two days training on fusion development with Oracle ADF BC / Faces RC. Everything worked fine except the following:

While doing the “Part 2 Create a Simple User Interface” from the cue cards some of the attendees (and me too) had the effect that at runtime the control flow rule defined in the bounded task flow did not worked.

So what actually went wrong here at runtime? Why a click on the Edit Order-Button did not trigger the control flow rule? Instead of that you just stay on the browseOrders page.

Solution

After some time of investigation I recognized that I had started the application under the wrong context. To test the application I selected browseOrders.jspx in the application navigator and have chosen “Run” because normally I am using taskflows with page fragments. So in real world projects you typically won’t start the application from a bounded task flow.

But because in this example the taskflow is based on whole pages rather than page fragments, the application must be started from within the bounded taskflow. Otherwise the control flow rules won’t be working at runtime!

You can check the correct run context by examining the URL in the browser. In the wrong case the URL will be …/faces/browseOrders.jspx of course whereas running the app from taskflow the URL is …/faces/adf.task-flow?adf.tfId=orders-flow&adf.tfDoc=/WEB-INF/orders-flow.xml

Lesson learned

Don’t panic if control flow rules seem not work as expected. Check the following

Which type of taskflow? (bounded /unbounded, with/without page fragment)
Does the action attribut of the command component match the control flow outcome?
How the application has been started?

First impression of Adobe Flash Builder 4

2010-03-28T23:49:00.001+02:00

Applies to: Flash Builder

The next version of Flex Builder has been released under “Flash Builder” some days ago and so I decided to give it a try.

The following points catched my eyes in the first couple of minutes

Integration of different data services through drag n drop data binding capabilities. The following list should give you an idea of the supported data services:

Trying out the Twitter XML API (http://twitter.com/statuses/public_timeline.xml?count=5) I could generate the data model very easy.
Data service tester is really cool and gives you quickly a “good feeling” for the used service
Theme browser/selector
Another great improvement seems to be done on the compiler performance. It just feels much faster although I did not try yet on a big project…
Generation of event handler code (at long last!;-))
Refactoring support. Although quite poor at the moment. Rename and Move. That’s it!
Generate setter/getter. Here is an example
surely there are more new features. But for me discovery time is over now;)

Still missing

Context-Menu and DnD operations in the outline view of the UI

It’s a READONLY view! No chance to move around components or bind your service data calls here. It is a pitty! Missing the flexibility I am used from the UI structure pane in JDeveloper!
Easy integration of database objects. It would be great If we could connect to a database and let Flash Builder generate corresponding server components. For now we have to generate/implement through LivecycleDS/BlazeDS/graniteDS.

Another idea could be to create ADF Business Components and expose them as Webservice by the service data object (SDO) facility! Yeeah, this could work quickly and great cause FB has good support for WebServices.

Anyone tried this already? Comments are welcome.

Conclusion

It looks like Adobe has learned some lessons from Oracles JDeveloper/ADF team. Especially the data binding/service integration facilities are comparable to ADFs data controls. But there is still a lot of work to do to get such productivity ADF makes possible;)

The UI Designer+CSS editor of course feels more “smooth” than the one of JDeveloper. But there are still missing some neat features like search boxes for ui components and properties. The non-interactive ui structure view should be fill with life! I am tired of searching manually for the desired component!

ADF: How to create method binding for action

2010-03-18T00:39:00.002+01:00

Applies to JDeveloper 11.1.1.2.0

Introduction

That is a really short post but shows all possibilities how to create a method binding action code in a backing bean. This is a very worthy feature if you need to invoke more than a single business service method. Currently ADF is limited to invoke just a single method declaretively/by DnD. Hopefully it will be possible in some of next JDev versions to bind a series of service methods to a command component by DnD.

a) In Design Mode: Just double-click on a command component and you will get the appropriate wizard

b) In Source Mode: Open the context menu and choose “Create Method Binding for Action”

The “Bind Action Property” Wizard will open as shown in a). Of course same Menu Action is available in Design mode too but double-clicking is more comfortable.

c) Property Inspector: No chance to generate ADF action binding code!

Just forgotten by JDeveloper developers or are there any good reasons why the above feature is not available here?

ADF App Internal Server Error 500

2010-03-17T23:54:00.001+01:00

Applies to ADF 11.1.1.2 and WLS 10.3.2

Problem description

1. stop datasource

2. stop app (all requests)

3. start datasource

4. start app (servicing all requests)

Call :/http://<host>:<port>/<context>

Expected

Functional ADF Application

Instead got

Analyzing

a)Take a look into <domain_home>/servers/<servername>/logs/<servername>.log

Caused By: java.lang.ClassCastException: oracle.adf.controller.internal.binding.DCTaskFlowBinding cannot be cast to oracle.adf.controller.internal.binding.DCTaskFlowBinding

at oracle.adf.controller.internal.binding.DCTaskFlowBindingDef.initializeExecutableBinding(DCTaskFlowBindingDef.java:301)

at oracle.adf.model.binding.DCBindingContainerDef.createExecutables(DCBindingContainerDef.java:590)

at oracle.adf.model.binding.DCBindingContainerDef.initializeBindingContainer(DCBindingContainerDef.java:728)

at oracle.adf.model.binding.DCBindingContainerDef.createBindingContainer(DCBindingContainerDef.java:944)

at oracle.adf.model.binding.DCBindingContainerReference.createBindingContainer(DCBindingContainerReference.java:152)

at oracle.adf.model.binding.DCBindingContainerReference.getBindingContainer(DCBindingContainerReference.java:92)

at oracle.adf.model.BindingContext.get(BindingContext.java:908)

Never seen that before! Where does all those .appmergegen hidden folders coming from?

Action

a) Googling. => not much information on this:(

b) rm -rf .appmergegen*

Test again

1. stop datasource

2. stop app

3. start datasource

4. start app

Call http://<host>:<port>/<context>

=> Application works as expected! But after a few more redeployments the internal error (500) occurs again.

Further research

a) Find out where all those .appmergegen hidden folders coming from? It seems that this leads in the end to a class loading problem.

b) How to make sure, the application will not fall into this situation again?

Any comments are greatly appreciated....

Generate ant build file from project issue

2010-03-02T12:12:00.001+01:00

Occured in JDeveloper Version: 10.1.3.4

Problem description

Trying to generate ant build file from project issues the following exception in Jdeveloper

java.lang.NullPointerException
    at oracle.ide.net.URLFactory.newURL(URLFactory.java:85)
    at oracle.ide.net.URLFactory.newUniqueURL(URLFactory.java:164)
    at oracle.jdeveloper.builder.SourceModel.generateDefaultFileName(SourceModel.java:135)
    at oracle.jdevimpl.ant.wizard.GenerateBuildfileModel.initializeFromContext(GenerateBuildfileModel.java:83)
    …

Reason

The appropriate project directory is not listed under the Project properties>Project content>Resources.

Solution

Just open the project properties and add the project folder under project content>Resources

After doing so the creation of the ant project build file works as expected!

FAQ: Why should I use Oracle ADF for application development?

2010-02-12T14:45:00.001+01:00

Examining JDeveloper Version: 11.1.1.2.0

As the fusion developer guide states Oracle ADF is

"An end-to-end application framework that builds on Java Platform, Enterprise Edition standards and open-source technologies to simplify and accelerate implementing service-oriented applications."

So what does this mean and what are the benefits from my personal point of view? I will try to give an satisfactorily answer.

At its core ADF couples loosly different technologies by its ADF binding layer and exposes business services uniformly through data controls for the frontend developer. The following business services in the backend and user interface frontends are supported:

From the architectural point of view further technologies can be integrated through custom data control implementations, e.g JSON Data Control, XML Data Control, etc.
No matter which type of backend technology you want to use (POJO, EJB3/JPA, ADF BC (based on DB tables or service data objects), WebService, Placeholder) the declarative ui development through data controls abstracts from the underlying technical details.
Write ONCE your business service and use it for API provisioning (Web service, REST) and UI (Web, Mobile, Desktop, Office)
With ADF it is easy to expose your Software as a Service (SaaS). Whether as ADF Taskflow with tight integration capabilities in Oracle WebCenter or through JSF portlet bridge as standard based JSR 168 Portlets. In analogy to service registries I think there will be someday an easy to use Taskflow registry (better than resource catalog;-) from which you can compose your application -> Improved WebCenter.
Abstract and easily "canonicalify" your data model through Service Data Objects (SDO). That way you can reuse business components across diffrent departments and abstract from the underlying persistence store.
Integrate your application into a SOA by firing events from your business components, invoke BPEL processes or create Human Workflows
Easily push data to the client by Oracles Active Data Service technology.
Based on JSF standards as the front end developer you don't have to care about which specific rendering technologies to use. As an example take a look at DVT (visualization) components. The usage of the components remains always the same, but the output can be configured: PNG or Flash. Someday HTML5 or JavaFX or whatever might be rendered. As Application Developer you just will get those features by updating to a new ADF Version without the need to know how the underlying rendering technology works.
Personalization: With ADF it is easy to let the application users customize the ui for their needs. Those runtime customizations are persisted across the session through Meta Data Services (MDS). Beyond this it is possible to create seeded customizations for different sites or industries.
Declaratively bind security constraints to application roles. Depending on infrastructure just map the enterprise roles (users, groups) to the application roles. Furthermore: if deployment is planned on the Oracle WebLogic Server it is really easy to integrate with almost any authentication provider: OID, OpenLDAP, ActiveDirectory, etc....

As the name suggests ADF simply was invented for exactly what you want to do: application development;-)

If you do not have any of the above requirements and prefer coding instead of dragging and dropping then you are well of with a more lightweight framework. In the Java world take a look at

Those frameworks are really cool and make a lot of fun to develop with - or should I say "to play with".

Of course there are some reasons for: "Why I should NOT use ADF for application development"

JDevelopers performance and stability is really poor in comparison to every other well Java IDE.
Integrated WebLogic server takes 3 minutes to startup. With every new release it seems that the startup time increases.

Further information

Oracle Application Development Framework

ADF 11g: Define default UI for MDS user customization

2010-01-18T17:45:00.001+01:00

JDeveloper Version: 11.1.1.2.0

Introduction

In this post I want to show how you can enhance the built-in feature “user customization accross sessions using MDS”. If you just activate this feature an define the default UserCC-class to be used, you typically will face the problem that for the first time the end users access your web application they will see the UI, layout, etc. as designed by the developer. Very often default values will be used so at the end someone might end up with fine tuning advises like “Please expand this column by 5px and put column x in front of the others….” and so on. And in the end you will still be not sure if your layout meet the exact idea of the manager.

What managers actually want is, to define e.g. the width of columns, etc on their own and let that setting be the default for all the other end users. With ADF11g that requirement can be achieved with only a few lines of code + configuration.

How to do

Create a custom Customization Class like the following

package de.team.faces.mds;

import javax.faces.context.FacesContext;

import oracle.adf.share.config.UserCC;

import oracle.mds.core.MetadataObject;
import oracle.mds.core.RestrictedSession;

public class DefaultUserCC extends UserCC {

private static final String DEFAULT_CC_VALUE_USERNAME =
"de.team.faces.mds.DEFAULT_CC_VALUE_USERNAME";

public DefaultUserCC() {
super();
}

/**
   * Overrides the UserCC
   * @param sess
   * @param mo
   * @return
   */
public String[] getValue(RestrictedSession sess, MetadataObject mo) {

    String[] value = super.getValue(sess, mo);
    if (value == null) {
      return null;
    }

    FacesContext context = FacesContext.getCurrentInstance();
    String valueUsername =
      context.getExternalContext().getInitParameter(DEFAULT_CC_VALUE_USERNAME);
    if (valueUsername == null) {
      return value;
    }

return new String[] { valueUsername };

}
}

and register it in your adf-config.xml file at the following position

It is important, to register the DefaultUserCC-class before UserCC class since that’s the precendence which will be evaluated by the MDS runtime.

Now edit the web.xml and add the following parameter to define the user whose mds runtime customization will be used as default customization for users that have not customized their UI yet.

With that configuration sking will be able to define the default UI for all the other users.

JDeveloper 11g: Know the IDEs coding features to get more productive

2010-01-11T00:03:00.001+01:00

JDeveloper Version: 11.1.1.2.0

Introduction

There are a couple of useful IDE features that may not be so obvious because those are not always accessible by the menu but only through shortcuts. So in this post I just want to show some of the cool features that makes one more productive while developing.

Tag-Documentation (Press Ctrl-D on a Tag)

Javadoc-Documentation (Press Ctrl-D on a class or method in java source code)

Javadoc-Documentation (Press Alt and Mouse Over on a class or method in java source code)

Quick Source View (Shift+ Mouse Over Sourcefiles in Application navigator)

Quick View in Sourcecode Mode (Ctrl+Mouse Over on right indicator bar)

This also works for Java Sourcecode of course:

Block Coloring (new in JDev 11.1.1.2)

Quick Preview in Taskflow (Shift+Mouse Over view-activity)

Quick file switch (Strg+TAB)

Go to Java Type (Ctrl+-)

Alternatively use the search box in the top right corner of the IDE

to quickly find the file you are looking for. In most cases you will be faster than searching manually in the application navigator.

Quick Outline/Method navigation (Ctrl+Shift+O)

Customize and explore

And of course you can customize your IDE shortcuts under Preferences>Shortcut keys

And of course it is good place to explorer new CodeEditor features.

Observation

There are still some features I am missing. used from e.g. Eclipse. This is

Ctrl+D: Delete current line
Alt+Arrow Up/Down: Move current line/block up down. This is really cool once you get used to it!

JDeveloper 11: Incomplete ViewObject information after IDE restart

2010-01-08T10:12:00.001+01:00

Status: open
JDeveloper Version: 11.1.1.2.0

Issue

Last time I often face the following issue:

Have a ViewObject-Definition file in Overview mode opened
Close JDeveloper.
Restart JDeveloper
Not every time but somtimes the ViewObject-Definition file seems to be incomplete!
Sometimes information shows up, but the two Overview tabs are confusing…
Any explanations for that behaviour?

Solution

First keep cool;-), your ViewObject-Definition content is still there! It just does not show up correctly in Overview Mode. Close the file and reopen it.

Update

Seeems like the two overview tabs show up everytime.

Oracle TPC: Possible upgrade issue from 11.1.1.1 to 11.1.1.2

2010-01-02T15:19:00.001+01:00

Status: resolved
Oracle Team Productivity Center: 11.1.1.2.0
Oracle WebLogic Server: 10.3.2
Environment: TELDE

First of all I wish all my readers out there a HAPPY AND SUCCESSFUL NEW YEAR 2010!

In a previous post I have blogged about setting up (a clean) Oracle Team Productivity Center Server. In this post I want to share my experience if you upgrade an existing OTPC database repository to 11.1.1.2 but want to install the otpc.war on a clean WLS 10.3.2 domain.

Issue

Tool/Area	Action
Client	Start Xming
Putty	Login as oracle {setup your environment} [oracle@telde ~]$ cd /u01/product/oracle/middleware/11.1.1/tpc/ [oracle@telde tpc]$ java -jar tpcinstaller.jar
Installer	1.Provide the database connection properties to the existing OTPC repository 2.Choose the autodeploy directory of a clean WLS 10.3.2 domain 3.Start installation
	You will encounter the following error

So how to solve the installation error if you want to install on a clean WLS 10.3.2 domain?

Solution

Tool/Area	Action

Putty	Login as oracle {setup your environment} OK so now we need to manually install the otpc.war into weblogic domain. 1) We first verify that it is included in the tpcinstaller: [oracle@telde tmp]$ jar -vft tpcinstaller.jar \| grep otpc 16485122 Fri Oct 30 01:33:40 CET 2009 lib/otpc.war 2) Now we extract it and copy otpc.war to the domain home/autodeploy [oracle@telde tmp]$ jar -xf tpcinstaller.jar lib/otpc.war [oracle@telde tmp]$ cp -p lib/otpc.war $DOMAIN_HOME/autodeploy 3)Run the tpcinstaller once again!!!! 4)Start the WebLogic server [oracle@telde tmp]$cd $DH [oracle@telde fusion_domain]./startWebLogic.sh

Background information

During installation of OTPC the otcp.war is modified so that it contains the correct database connection information.

[oracle@telde autodeploy]$ cd /u01/app/oracle/product/11.1.1.2/middleware/user_projects/domains/base_domain/autodeploy/    
[oracle@telde autodeploy]$ ls -l     
total 24252     
-rw-r--r-- 1 oracle oinstall  8309132 Nov  5 07:43 otpc.war     
-rw-r--r-- 1 oracle oinstall 16485122 Oct 30 01:33 otpc.war-1257402576730     
-rw-r----- 1 oracle oinstall     2131 Nov  4 02:07 readme.txt

Those connection properties are stored in persistence.xml which itself is contained in _wl_cls_gen.jar file.

So if you encounter connection problems persistence.xml in the exploded app directory is the file you should first look to verify the connection properties.

ADF 11: Create Application EAR for test and production deployment respectivly

2009-12-24T00:46:00.001+01:00

Status: resolved
Oracle JDeveloper Deploy: 11.1.1.2.0.5536

In this post I want to show how you can easily automate the issue mentioned in Andrejus Baranovskis post about How to do Manual Deployment for ADF 11g Application EAR with Auto Generated JDBC Descriptors.

Introduction

Ok, so what actually is the issue with the Auto Generated JDBC Descriptors in the generated EAR? To understand the problem better I have made up a quick overview

You see a typical scenario of a development environment (not optimal but no that bad) On each developers machine there is JDeveloper and the Integrated WebLogic Server installed. If a developer joins a project she checks out the sourcecode, opens it Jdeveloper and is able to run the application. It order to get this working JDeveloper generates the appropriate JDBC descriptors and packages the datasource definition into the EAR which is deployed on the integrated WLS. The application runs on developers machine with zero configuration changes because ‘Auto-generate and Synchronize weblogic-jdbc.xml Descriptors During Deployment' checkbox on the Deployment page of the workspace's Application Properties dialog is activated.

On the right side you see the components on the test/nightly build server with dedicated test database! So the connection information is different from the dev system, the data source in the WLS must be created manually or script based. For that reason the EAR must not include any datasource definitions because they are obtained from the container (WLS). The EAR is generated by the ojdeploy utility which operates mainly on the application workspace file (.jws)

The problem now is that the ‘Auto-generate and Synchronize weblogic-jdbc.xml Descriptors During Deployment' option is saved in the Application Workspaces file which resides in the SCM repository and both - the developer and Test-Server - obtain there config from a single source!

Solution

Is simple, works but maybe a bit dirty;-) Observing the application workspace file (jws) I recognized the following line

<value n="Weblogic-JDBC-Auto-Sync-Key" v="true"/>

So switching the value to false before running ojdeploy should do the trick. I have done this with Ant. Create the following files into your workspace

as follows

deploy_to_ear.ant.properties
oracle.jdeveloper.workspace.path=C\:\pathto\YourApp.jws autosync.true=<value n="Weblogic-JDBC-Auto-Sync-Key" v="true"/> autosync.false=<value n="Weblogic-JDBC-Auto-Sync-Key" v="false"/>

deploy_to_ear.ant.xml <?xml version="1.0" encoding="windows-1252" ?> <project name="Deploy Helper Tasks" default="usage" basedir="."> <property file="deploy_to_ear.ant.properties"/> <target name="usage"> <echo>Use one of the following targets:</echo> <echo>1) disable-wls-jdbc-autosync - desc todo</echo> <echo>2) enable-wls-jdbc-autosync - desc todo</echo> </target> <target name="disable-wls-jdbc-autosync"> <replaceregexp match="${autosync.true}" file="${oracle.jdeveloper.workspace.path}" replace="${autosync.false}"/> </target> <target name="enable-wls-jdbc-autosync"> <replaceregexp match="${autosync.false}" file="${oracle.jdeveloper.workspace.path}" replace="${autosync.true}"/> </target> </project>

deploy_to_ear.ojdeploy.xml<?xml version = '1.0' standalone = 'yes' ?> <ojdeploy-build> <deploy> <parameter name="workspace" value="${workspace.path}\YourApp.jws"/> <parameter name="profile" value="*"/> <parameter name="nocompile" value="true"/> <parameter name="nodatasources" value="true"/> <parameter name="forcerewrite" value="true"/> <parameter name="outputfile" value="${workspace.path}/deploy/${ear.filename}"/> </deploy> </ojdeploy-build>

deploy_to_ear.bat @echo off

echo [INFO] Create deployment EAR for ADF fusion web application

call ant -f deploy_to_ear.ant.xml disable-wls-jdbc-autosync
call ojdeploy -buildfile deploy_to_ear.ojdeploy.xml -define workspace.path=C:\yourpath\to\workspace,ear.filename=testapp1_without_datasources.ear
call ant -f deploy_to_ear.ant.xml enable-wls-jdbc-autosync

Alternatively to run the enable-wls-jdbc-autosync target after ojdeploy has finished you could also do a revert on the .jws file if your SCM system supports it.

In my sample application the generated EAR files look as follows

Keep on automating your build process;-)

Oracle Team Productivity Center (OTPC) – Team Server part

2009-12-12T13:31:00.001+01:00

Status: resolved
Oracle Team Productivity Center: 11.1.1.2.0
Oracle WebLogic Server: 10.3.2
Environment: TELDE

Overview

We want to use Oracles solution for Applpication Lifecycle Management (ALM) called Oracle Team Productivity Center. OTPC enables software development teams to collaborate and work productively together when developing applications using JDeveloper.

OTPC consist of several component from which we will cover the server side ones in this blog post. That are the Team Server which is connected to databased repository and some specific ALM connectors. Currently there are implementations for

JIRA (since 11.1.1.1.0)
MS Project Server (since 11.1.1.1.0)
Bugzilla (new in 11.1.1.2.0)

The following figures gives an overview of the involved components:

The Team Server component is a WAR exposing some WebServices which are cosumed by the JDeveloper TPC Extension counterpart. The deployement is currently supported either on a WebLogic Server or Apache Tomcat.

Quick Outline of this post

Download OTPC Server Component
Create Database Schema for OTPC
Install OTPC Server Component on WebLogic Server 10.3.2
Install JDeveloper OTPC extension
Test the OTPC connection.

Download Products

	Product	Download
	Oracle® Team Productivity Center Server Component + Connectors	Download from OTN

Create database schema

Area	Description
Putty	login as: oracle oracle@192.168.234.140's password: Last login: Mon Aug 3 21:47:45 2009 from 192.168.234.1 [oracle@telde ~]$ [oracle@telde ~]$ . ./setDb1Env.sh Aktuelle Oracle Umgebung: Oracle-Home: /u01/app/oracle/product/11.1.0/db_1 Oracle-SID: orcl [oracle@telde ~]$ sqlplus / as sysdba SQLPlus: Release 11.1.0.7.0 - Production on Thu Nov 5 07:40:04 2009 Copyright (c) 1982, 2008, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> create user ofm_tpc identified by ofm_tpc;* User created. SQL> grant connect, resource to ofm_tpc; Grant succeeded. SQL> connect ofm_tpc/ofm_tpc; Connected. SQL> disconnect; Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> exit; [oracle@telde ~]$

Area

Description

Putty

login as: oracle
oracle@192.168.234.140's password:
Last login: Mon Aug 3 21:47:45 2009 from 192.168.234.1

[oracle@telde ~]$

[oracle@telde ~]$ . ./setDb1Env.sh

Aktuelle Oracle Umgebung:

Oracle-Home: /u01/app/oracle/product/11.1.0/db_1

Oracle-SID: orcl

[oracle@telde ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.1.0.7.0 - Production on Thu Nov 5 07:40:04 2009

Copyright (c) 1982, 2008, Oracle. All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> create user ofm_tpc identified by ofm_tpc;

User created.

SQL> grant connect, resource to ofm_tpc;

Grant succeeded.

SQL> connect ofm_tpc/ofm_tpc;

Connected.

SQL> disconnect;

Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> exit;

[oracle@telde ~]$

Install OTPC Server Component

Area	Description
Client	Start Xming!
WinSCP	Copy downloaded tpcinstaller.jar to /u01/product/oracle/middleware/11.1.1/tpc
Putty / set java env	Login as oracle [oracle@telde ~]$ . ./setFusionDomainEnv.sh /home/oracle Aktuelle Oracle Umgebung: $WLS_DOMAIN: fusion_domain $WLS_DOMAIN_HOME(=$DH): /u01/app/oracle/product/11.1.1.2/middleware/user_projects/domains/fusion_domain $MW_HOME: /u01/app/oracle/product/11.1.1.2/middleware $JAVA_HOME: /u01/app/oracle/product/11.1.1.2/middleware/jrockit_160_14_R27.6.5-32 [oracle@telde ~]$ java -version java version "1.6.0_14" Java(TM) SE Runtime Environment (build 1.6.0_14-b08) BEA JRockit(R) (build R27.6.5-32_o-121899-1.6.0_14-20091001-2113-linux-ia32, compiled mode) [oracle@telde ~]$ cd /u01/product/oracle/middleware/11.1.1/tpc/ [oracle@telde tpc]$ java -jar tpcinstaller.jar
Installer	Choose: Next
	Input JDBC: jdbc:oracle:thin:@database.telde.local:1521:orcl Input Username: ofm_tpc Input Password: ofm_tpc Choose: Next
	Select: Server Select: Connectors Choose: Next
	Input: /u01/app/oracle/product/11.1.1.2/middleware/user_projects/domains/fusion_domain/autodeploy Choose: Next
	Choose File Name: <whatever connector you want to additionally be installed> Choose: Next
	Input Username: tpcadmin Input Password: welcome1 Input Confirm Password: welcome1 Choose: Next
	View Summary, Verify your made selections! Choose: Finish
Installation in progress	wait…..
	Choose: Close
Putty/Start WebLogic	Start the WebLogic server [oracle@telde tmp]$cd $DOMAIN_HOME [oracle@telde fusion_domain]./startWebLogic.sh ... [EL Info]: 2009-11-05 07:47:00.511--ServerSession(41694633)--zip:/u01/app/oracle/product/11.1.1.2/middleware/user_projects/domains/base_domain/servers/AdminServer/tmp/_WL_user/_appsdir_otpc_war/sfdu2u/war/WEB-INF/lib/_wl_cls_gen.jar!/-otpc login successful
Browser/Verify OTPC is running

Upgrade notes

Test the connection to OTPC from JDeveloper

Area	Description
JDeveloper	Start and Use Help>Check for updates to install the team productivity center extension, plus required client connectors.
	Select the Team Navigator tab or Open it by menu (View>Team>Team Navigator) Click: Connect To Team Server Input Team Server: telde.local Input Port: 7001 Input Username: tpcadmin Input Passwort: welcome1 Choose: Connect
JDeveloper/Team Administration	Now you can reach the Team Administration as follows Now you are able to create user, assign team repositories and so on...

Observations

Calling the Test Server Page (<host>:<port>/otpc) you just get a simple message “Oracle Team Productivity Center” Request to Oracle: Please display some more information: Version, active connectors, etc.....!!! At the moment this does not look enterprise production ready!! Sorry. It looks like a prototyp so far……
Do I really have to create all the users into the OTPC repository by hand? Can’t I connect to an LDAP-Server? This also looks not enterprise production ready. Sorry.

Further Information

DOAG09: Deployment of ADF fusion web applications on Oracle WebLogic Server 11g

2009-12-07T13:08:00.001+01:00

This year at DAOG 2009 (the german oracle user group) I had the chance to give a presentation on the interesting topic “deployment of adf applications on Oracle WebLogic Server 11g”.

From my point of view it is interesting because there are some issues you need to consinder when deploying your adf fusion web app to a standalone WebLogic Server in your Test oder Production environment. It is not always as easy as deploying just to the local integrated WebLogic Server.

The following points are covered

Installation WebLogic Server 11g
Configuration WebLogic Domain for ADF11g/10g
Introduction of various deployment options: Jdev Remote, Console/EM, Ant, WLST
Deployment guide for needed artefacts: datasource, meta data service repository, security configuration
Overview deployment & needed configuration changes in clustered environment
Some best practices, some WLST fragments

Download: Deployment von ADF-Applikationen auf den Oracle WebLogic Server 11g

Language: only in german

ADF: Query-By-Example table filter bug

2009-11-23T16:42:00.003+01:00

Status: open
Applies to JDeveloper: 11.1.1.2, 11.1.1.3

Today I tried if the Bug (discussed in http://forums.oracle.com/forums/message.jspa?messageID=3568706) is still reproducible.
And sadly to say: “Yes the bug still exists!”
The behaviour changed a bit but the table filtering feature still does not working as expected if used INSIDE PAGE FRAGMENT/TASKFLOW.
So take a look at the viewlet where I shortly explain the buggy behaviour.

Free online screen recorder

Download Testcase: http://www.box.net/shared/sviqlzzobp

Related resources

http://forums.oracle.com/forums/message.jspa?messageID=3568706
http://forums.oracle.com/forums/thread.jspa?threadID=2157454

TELDE - What's that?

2009-11-22T22:43:00.003+01:00

If you are wondering what telde is all about then I would like to give a hint on a presentation my collegue Ulrich gave at DOAG 2009 : ADF 11g rich client development best practices . We are using TELDE for development, testing and so on...while developing Apps on the oracle stack (currently ADF11g/JDeveleloper/WebLogic/Oracle Enterprise Linux). So TELDE stands for

TEam Linux Development Environment

It consists of the following components right now:

Oracle Enterprise Linux 5.3

Oracle Database 11.1.0.7

Oracle WebLogic Server 11g

Oracle JDeveloper 11.1.1.x

Oracle Team Productivity Center

Hudson Continuous Integration Server

OpenLDAP

SVN Server

running on VMWare.

So if you are interested in setting up such an environment, look at http://padora.blogspot.com

WLS: Monitoring Oracle JRockit JVM with JRockit Mission Control remotely

2009-11-16T17:01:00.003+01:00

Status: resolved
JRockit Mission Control: 3.1.2
WebLogic: 10.3.2

Use case

You have the need to remotely monitor and profile the JRockit JVM(s) of Oracle WebLogic Server.

Solution

Install JRockit Mission Control on the client
Configure WebLogic Server Domain with JRockit JVM
Configure JRockit Management Server

Components/Products

	Product	Download
	Oracle® WebLogic Server	Download from OTN
	Oracle® JRockit Mission Control	Download from OTN

How to

Bereich	Beschreibung

Putty	Login as oracle on telde.local [oracle@telde ~]$ cd middleware/user_projects/domains/base_domain/ [oracle@telde base_domain]$ vi startWebLogic.sh
Putty/vi	Add the following java Options before starting the WLS instance: JAVA_OPTIONS="-Xmanagement:ssl=false,authenticate=false,port=7091" export JAVA_OPTIONS ${DOMAIN_HOME}/bin/startWebLogic.sh $* Save file and Close vi.
Putty	Start WLS [oracle@telde base_domain]$ ./startWebLogic.sh …. Notice the starting of the management server … [JRockit] Management server started on port 7091, ssl=false, authenticate=false. …
Client	Start JRockit Mission Control
JRMC	Create a new connection Enter Host Enter Port Click: Test connection => Status keeps “Unable to connect” Click: Finish Starting the console on the newly created connection you might receive the following exception: Could not open Management Console for telde.local. com.jrockit.mc.rjmx.ConnectionException: Connection refused to host: 127.0.0.1; nested exception is: java.net.ConnectException: Connection refused: connect com.jrockit.mc.rjmx.ConnectionException: Connection refused to host: 127.0.0.1; nested exception is: java.net.ConnectException: Connection refused: connect at com.jrockit.mc.rjmx.ConnectionManager.connect(ConnectionManager.java:63) at com.jrockit.mc.console.ui.actions.StartConsole$1.preConnect… So how to fix?
Putty	Stop WLS
	Edit startWebLogic.sh Add -Djava.rmi.server.hostname=<remotehost> to the java options so that it looks like
Putty/vi	.. JAVA_OPTIONS="-Djava.rmi.server.hostname=telde.local -Xmanagement:ssl=false,authenticate=false,port=7091" export JAVA_OPTIONS ${DOMAIN_HOME}/bin/startWebLogic.sh $* Save file and exit vi.
Putty	Start WLS once again [oracle@telde base_domain]$ ./startWebLogic.sh
JRMC	Now try to test connection again. Result should be
JRMC	Start the console and monitor CPU, Mem, seak for memory leaks, etc.

Resources

java.rmi.server.hostname (1.1 and later)

The value of this property represents the host name string that should be associated with remote stubs for locally created remote objects, in order to allow clients to invoke methods on the remote object. In 1.1.7 and later, the default value of this property is the IP address of the local host, in "dotted-quad" format.

ADF: Export Collection ActionListener issue

2009-10-27T11:17:00.001+01:00

Status: work in progress
JDeveloper: 11.1.1.1.0
WebLogic: 10.3.1

Issue

Create simple Fusion Web Application as follows:

Create readonly VO in the Business Layer on a table with > 20,000 records and expose it through an AM
Create simple JSPX in the ViewController project
Generate readonly table on a PanelCollection by drag and drop from the data control palette
Create a command button with ExportCollectionActionListener (type="excelHTML" and exportId="<id of the table component>")
Example:
<af:panelCollection id="pc1">
<f:facet name="menus"/>
<f:facet name="toolbar">
<af:toolbar id="t2" flex="1">
<af:commandToolbarButton text="Test here: Excel Export"
id="ctb1">
<af:exportCollectionActionListener type="excelHTML"
exportedId="t1"/>
</af:commandToolbarButton>
</af:toolbar>
</f:facet>
<f:facet name="statusbar"/>
<af:table id="t1" ....
</af:table>
</af:panelCollection>

Now observe the memory consumption of the WLS

Run the web application
View the Memory consumtion of WLS process: ca 400MB
Click the export to Excel button.
View the Memory consumtion of WLS process: ca 740MB
Undeploy the application
View the Memory consumtion of WLS process: ca 740MB

Observations

A single export of 20,000 records consumes ca. 340MB
It seems there is a memory leak because the memory consumption remains after undeployment.
Same result on Windows XP and Oracle Enterprise Linux 5.3(32bit)

Question

So why the export functionality consumes so much RAM?
Is there a memory leak? How to workaround?

Solution

Still in progress..in cooperation with Oracle Support… will be updated here.

Proposal

In order to be more flexible and powerful it would be great to be able to implement own Exporter implementations, e.g.

<af:exportCollectionActionListener type="excelHTML" exportedId="t1"
exporterClass="com.company.fusionapp.export.MyExcelExporter"/>

or even better (like custom conveter concept)

<af:exportCollectionActionListener type="excelHTML" exportedId="t1" exporterId="myExporter" />

and in adfc-config.xml:

ADF: Text resource issue

2009-08-02T21:28:00.000+02:00

Status: Resolved
JDeveloper: 11.1.1.1.0
WebLogic: 10.3.1

Last week I came accross a cool blog about ADF BUGS FACTS. The author inspired me to write myself about similiar experiences with ADF11/JDeveloper. So today I will describe a bug concerning the i18n capabilities in ADF11.

First I have to mention tha the support for i18n text resources improved very well with JDev11 but there is a case when things do not work correctly. So in the case your ViewController project name contains a dash. things do not work anymore as expected. So in our company we have following convention to name our applications/projects.

customer-app
app-model
app-webui

With that convention your not able to work with the “select text resource” feature on ADF Faces Pages, because invalid code is generated. So here is the example

Because the ViewController project is called myapp-ui you get the following buggy code

Solution

Solution is to remove the dash in c:set and of course all EL references.

<c:set var="myappuiBundle"
value="#{adfBundle['de.team.training.i18n.myapp-uiBundle']}"/>

and

<af:outputText value="#{myappuiBundle.MY_APPLICATION_TITLE}" id="ot1"/>

After this fix the text resource is resolved correctly

Things learned

Don’t: use dashes (-) in project names! This may cause trouble in development of fusion web applications.

Page Fragment Design view is messed up when using resource bundle

Comment from Milkbird: Thanks for your reference Andreas. I think this is realy usefull, since someone could loose a lot of time to find out what is wrong and how to fix it.