Oracle Enterprise Repository 11g – How to create own custom reports
TweetOracle Enterprise Repository 11g (OER) is very powerful tool for SOA governance. OER for report generation uses Oracle BI Publisher In the BI Publisher you can create your own custom reports (from OER data), and these own custom reports can be added to OER (execute from OER). How to do it: create your own [...]
OSB-WLST-Customizer or Customize OSB SBconfig with WLST
TweetOSB-WLST-Customizer is a simple WLST script that contains several features for a more detailed customization SBConfig, before deploying to the Oracle Service Bus 11g. The WLST script to read existing SBConfig jar file and modify (customize) it according to the settings in the properties and generate a new SBConfig jar file. The WLST script allow [...]
Review of book: Oracle SOA Suite 11g Developer’s Cookbook
TweetI really quite enjoyed reading a book: Oracle SOA Suite 11g Developer’s Cookbook, . I think that, this book is fantastic and I would certainly recommend it to all those, who have at least minimal experience and knows about Oracle SOA Suite and Oracle Service Bus. The book can be divided into two main parts: [...]
How to get Server or Host name from OSB proxy service
TweetBecause the OSB 11g does not provide simple features for getting: server or host name from the proxy service. I created two simple functions that makes it possible. How does it work? it’s easy;),sample code: weblogic.jndi.Environment env = new Environment(); Context ctx = env.getInitialContext(); // Get the Local MBeanHome form server where is proxy service [...]
How to Install and Configure Oracle BI Publisher for Oracle Enterprise Repository
TweetWhat need to have before installing Oracle BI Publisher? Successfully installed Oracle Enterprise Repository 11g(11.1.1.6.0) and created OER domain. Database – Oracle 11g Download Repository Creation Utility 11.1.1.6.0 – RCU and extracted to $RCU_HOME/ Download Oracle BI Publisher 11g Enterprise – BI and extracted to $BI_INSTALL_HOME Installation consists of several steps: 1. Open [...]
List of XQuery functions that are supported in OSB 11g
TweetA List of XQuery functions that are supported in OSB 11g, you can download here: list and full details about all XQuery functions, you can find in these files: OSB_HOME\eclipse130\plugins\com.bea.alsb.common.xquery.ui_1.3.0\xquery-ui.jar/strings\com\bea\wli\ide\xquery\ui\views\functions\BaseContext.decl OSB_HOME\eclipse130\plugins\com.bea.alsb.common.xquery.ui_1.3.0\xquery-ui.jar/strings\com\bea\wli\ide\xquery\ui\views\functions\xquery-functions.xml
How to fix mapping errors in Hibernate(no dialect mapping for JDBC type: -9, Found: nclob, expected: nvarchar2)
TweetHow to resolve these exceptions in Hibernate (with Oracle 11g Database – varchar2, nvarchar2, clob,…)? MappingException: No Dialect mapping for JDBC type: -9 or Wrong column type in MIG.LOG for column msg. Found: nclob, expected: nvarchar2(255 char) These errors or problems you can fix, by using custom dialect, here is a sample code: public class [...]
Active Session in Weblogic, how to check in WLST?
TweetHere is a simple WLST script, that checks whether, session (pending changes) is activated in the WebLogic: connect(‘<user>’,’<host>’,’<adminServer>’) #config manager cmgr = getConfigManager() user = cmgr.getCurrentEditor() #active session in weblogic for user if user != None: edit() print ‘———–Active Session in WebLogic————-’ print ‘User: ‘ + str(user) showChanges()#print all changes in [...]
How to create a service with EJB 3.0 (transport) in OSB 11g
TweetA simple manual to create a “Business Service” with using EJB 3.0 transport in OSB 11g. Open the Eclipse IDE (J2EE version), and click the menu “File-> New-> EJB Project“. Enter the name of the EJB 3.0 project “HelloOsbEjb” and select the checkbox “Add EAR project“, click “Next“. In the next wizard page, select all [...]
Highcharts integration with JBoss RichFaces (JSF/Facelets)
TweetIf you want to integrate the Highcharts with JBoss RichFaces JSF/Facelets project, so some RichFaces components will not work. The problem is Prototype and jQuery and other JavaScript frameworks, which are included in JBoss RichFaces. To solve this problem, you need to make some minor changes in the Java Script for Highcharts, here they are. Load Highcharts script [...]