Integration of BIRT Report with Oracle ADF

Requirement -Using BIRT Report with Oracle ADF

Solution –
Environment:
Jdev 11.1.0.2
JDK 1.6
Weblogic 10
Birt runtime 2.6.2

-> Download birt_runtime_2_6_2 from eclipse.org
-> Extract the content to a folder
-> From the WebViewerExample sub folder, copy lib, platform, tlds folders and server-config.wsdd to WEB-INF of the ViewController project of your ADF application
-> From the WebViewerExample sub folder, copy webcontent, scriptlib, report and logs folders to public_html folder of the ViewController project of the ADF application
-> Create a folder named reports in public_html folder of the project. This will contain all the rptdesign files.
-> Edit web.xml of your project to reflect all the contents of the web.xml of WebViewerExample of birt runtime
-> Because weblogic has an older version of js.jar of rhino, download rhino.jar from www.mozilla.org to WEB-INF\lib folder of ViewController project and add it in your project library classpath.
-> In order to have this rhino take precedence over the older version, edit weblogic-application.xml to include the following in the Application Preferred Packages under Class Loading tab;
org.mozilla.javascript.* and
org.mozilla.classfile.*
-> At this point, you can run your reports from a backing bean as follows;

 
 public void call_report() 
{

FacesContext ctx = FacesContext.getCurrentInstance();
HttpServletRequest request = (HttpServletRequest)ctx.getExternalContext().getRequest();
 
// Redirect browser
url = request.getContextPath()+"/frameset?__report=reports/test.rptdesign";
try {
//url = ctx.getExternalContext().encodeResourceURL(url);
ctx.getExternalContext().redirect(url);
} catch (IOException e) {
e.printStackTrace();
message = new FacesMessage(
FacesMessage.SEVERITY_FATAL, e.getMessage(), "");
FacesContext.getCurrentInstance().addMessage(null, message);
}
}
 

If you get “Error: Java code in jsp source files is not allowed in ojsp.next mode” when running jspx applications, you need to enable user customizations.
In Jdeveloper workspace,
1. Go to Project Property
2. Go to ADF View
3. Enable User Customizations
4. check on Across Sessions using MDS
Also you need to either adapt your code to remove the scriptlets in your JSP page,
or you can use the following Java option to disable OJSP:
-Dadfvdt.disableOjspDeployment=true
You can add this option -Dadfvdt.disableOjspDeployment=true in your file “ide.conf” in the directory “\jdeveloper\ide\bin”
For your Production environment, you can have your Managed WLS ignoring the OJSP mode by adding the Java Option -Dadfvdt.disableOjspDeployment=true
* in the “startManagedWebLogic” (if you want to limit it to a specific Managed Server)
* or “setDomainEnv” (for all managed servers in a domain).

NOTE:
-> Ensure that you have the same version of birt_runtime corresponding to the version of rpt design files
-> birt 2.6.2 is not compatible with google chrome. (works well with ie and firefox)

I found this information in OTN. Special thanks to -Michael Ekeagbara

Happy coding with Vinay Kumar in techartifact.

WebCenter Portal 11g Certification

Hi All,

Another exam , i gave now Oracle Webcenter 11g essential exam that mean IZ0-541.I somehow , managed to pass.So ,now i am now Oracle Webcenter portal 11g certified implementation specialist. 🙂

Tips for new candidates – Its bit tricky and confusing too.I found one question have all options are wrong. weird isn’t it? All options are wrong,
focus on Webcenter spaces,content , how to add different portal using which protocol and so on.few question on ADF too.Passing percentage 65%.Time to complete exam is 120 mintues The questions were confusing.

Read more: http://www.techartifact.com/blogs/2013/11/oracle-adf-certification.html#ixzz2mh3dbuz0

Prepration material –
Webcenter 11g administration cookbook – http://www.packtpub.com/oracle-webcenter-11g-ps3-administration-cookbook/book
Oracle webcenter 11g handbook . – http://www.amazon.com/Oracle-WebCenter-11g-Handbook-Customizable/dp/0071629327

RCU – Repository creation Utility for 11g

RCU is used to create repository for various middleware products ie. SOA Suite , Webcenter Suite , Identity Management Suite, Content Management & Weblogic Communication Services , Portal & BI.

If you are working on ADF application with MDS featurs then you will be needing a MDS schema .RCU will create a default schema for MDS.Download
RCU 11g from oracle.com .Downloded file will be File : ofm_rcu_linux_11.1.1.3.0_disk1_1of1.zip
unzip this ofm_rcu_linux_11.1.1.3.0_disk1_1of1.zip file.

UNIX– Launch ./rcu from cd /oracle/rcuHome/bin
Windows – go to Oracle/rcuHome/bin folder and click installer.

Below are the screen shots for rcu Install –

Keep clicking Next and Create until the MDS Database Repository is created.

Now, if you open your database you will notice that new tablespace entries, corresponding to your MDS Repository, have been created

Happy coding with Vinay Kumar in techartifact….