Testing, One, Two….
![Testing, One, Two….]({"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"http:\/\/seattletimes.nwsource.com\/ABPub\/2012\/08\/02\/2018836700.jpg","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"} "Testing, One, Two….")
Just in time for the Oracle PL/SQL Programming Conference, OPP2007, the Code Tester for Oracle is released. I am very excited about this tool and more posts will follow. …
Category: Oracle
Removing double records (and keeping one of them)
Assume you have a table with contaminated data (in this example: non-unique values on col1 and col2), for instance because no unique key was implemented. col1 col2 value 2 …
Writing a pure SQL based String Tokenizer
A quite common concept in many programming langiages, though perhaps strongest in Java, is the String Tokenizer. This is a utility class or function that takes a String as …
Creating XML Data Services for Reporting and ESB integration using DBMS_EPG (the internal HTTP/PLSQL Gateway) and XMLType
Today I all of a sudden found myself investigating the creation op PL/SQL based Data Services, returning XML documents with data from SQL queries to HTTP Clients. The direct …
Never Assume, always test…
Yesterday evening I started preparing for the upcoming Oracle PL/SQL Programming Test-A-Thon. I strongly believe that building your own programs to perform a functionality, which is already provided as …
My first steps with Oracle BI Publisher Enterprise Edition 10.1.3.2: create a report based on the OraBlogs rss-feed
After receiving a new, pretty powerful laptop, on Thursday and installing the Oracle BI Enterprise Edition on Friday, this weekend sees my first steps with the BI Publisher (previously …
How to programmatically add a CDATA section to an XML document (with the internal Xerces)
This problem probably sounds very easy and it is actually very easy, but it took me so long to figure this out I think it’s worth a blog. I’ll …
Invoking BPEL Worklist API from Remote Server with Java
Recently, I was working on an Forms application that required a Form to retrieve and complete a Human Workflow task from the worklist of a BPEL 10.1.3 server (also …
Transaction Dependent Webservice Invocation…or how to call a webservice from a database trigger and make the call part of the transaction
One of our clients asked us to help with calling a webservice from a database trigger. This webservice would duplicate the actions done by the database in a different …
Oracle WebCenter Suite 10g (10.1.3.2.0) available for download too
February 1, 2007
IT, Java, Oracle, Oracle Application Development Framework, Oracle WebLogic Server, Tools
No Comments
Yesterday we received the 10.1.3.2 release of JDeveloper, with the WebCenter design time; today we are presented with the WebServer Suite (Server) as well. Download from http://www.oracle.com/technology/software/products/ias/htdocs/101310.html :
How to refer to an Attribute in the Currently Selected Table row in an ADF Faces page – implementing a Generic Row Reader
January 31, 2007
IT, Java, Oracle, Oracle Application Development Framework, Oracle WebLogic Server, Tools
5 Comments
A very small article on a very trivial issue. I have a page with a Master-Detail construction with a (master) Table of Departments and a (detail) Table of Employees. …
XML-Publisher how to display your input parameter
This week I have played a bit with XML-Publisher. The goal was take some reports and try to migrate them to XML-Publisher version. Yesterday I posted a blog about …
Creating an ADF URL Service DataControl for binding a File or Servlet/JSP service and using it in an ADF Faces Web Application
January 31, 2007
IT, Java, Oracle, Oracle Application Development Framework, Oracle WebLogic Server, Tools, Web HTML5 CSS3
No Comments
Looking through the list of new features for JDeveloper 10.1.3.2 yesterday I suddenly noticed a feature that was not new at all, but that had so far escaped my …
Using the new JSF Components ShowDetailFrame and PanelCustomizable for structuring the User Interface in JDeveloper 10.1.3.2
January 31, 2007
IT, Java, Oracle, Oracle Application Development Framework, Oracle WebLogic Server, Tools, Web HTML5 CSS3
2 Comments
One of the interesting new features that come along with WebCenter in JDeveloper 10.1.3.2, but hopefully are not necessarily part of WebCenter (licence) is the set of Customizable Components: …
JDeveloper 10.1.3.2 & WebCenter – first impressions and first tip
January 31, 2007
IT, Java, Oracle, Oracle Application Development Framework, Oracle WebLogic Server, Tools
No Comments
It was hard to miss yesterday as weblogs around the world – just like telex machines in the old days – started ticking and buzzing: JDeveloper 10.1.3.2 is released! …
ADF Flex Fields or ADF User Extensibility or "The End User driving the Application" or "ADF goes APEX" or… (sneak preview)
January 30, 2007
IT, Java, Oracle, Oracle Application Development Framework, Oracle WebLogic Server, Tools
1 Comment
One picture speaks more than a thousand words (a pity for someone as verbally skilled and graphically challenged as myself). However, for once, I will try to let the …
(dirty little) Trick for calling methods with multiple input parameters from JSF EL Expressions
January 27, 2007
IT, Java, Oracle, Oracle Application Development Framework, Oracle WebLogic Server, Web HTML5 CSS3
4 Comments
I am not sure yet whether I have been really clever or am suffering from a twisted mind. In this article I present a grantedly farfetched approach for invoking …
How to build an Oracle Forms application on BPEL/WF
Why Oracle Forms and BPEL? Old style Forms applications normally don’t hold much workflow functionality. Sure there is an order in which the forms should be used. The workflow …
Getting started with the ICEfaces (1.5.2) library of rich AJAX JSF components in JDeveloper 10.1.3.x
January 19, 2007
IT, Java, Oracle, Oracle Application Development Framework, Oracle WebLogic Server, Web HTML5 CSS3
14 Comments
November 2006 saw the announcement by ICEsoft that their ICEfaces library of JSF components was being released under an open source license. This basically means that a lot of …
Maven repository for Java EE 5 APIs
Those who use Maven for their project may be happy to hear that a Maven repository for the Java EE 5 APIs has been opened. For more info, see …
FNDCPASS ALLORACLE
FNDCPASS is an EBS tool to change passwords of database schema’s within the Oracle EBS. For example, you can change the APPS password using FNDCPASS, but also any other …
Solving SOA Suite installation issues
The last months I’ve been a frequent visitor of the SOA Suite forum on OTN. The reason for this is that I’ve been busy getting acquainted with new SOA …
Example of using the ADF Faces ChooseColor component with a SelectInputColor for picking a color
January 10, 2007
IT, Java, Oracle, Oracle Application Development Framework, Oracle WebLogic Server, Web HTML5 CSS3
2 Comments
One of the components in the ADF Faces library you may not make use of on a daily base is the . In this article, I will give you …
Project Experience with Acegi Security, Spring MVC and Oracle MapViewer
For a customer with an interesting business we had to build a web application that has a RIA front end, displays data on maps, authenticates thru a web service …
Changing background in Oracle EBS 11i
It would be nice to have your own company logo as background in the Oracle E-business suite. Default the background is white, but the following steps will put your …
Use the ESBREQUEST parameter to enrich and filter Routing Services in Oracle ESB
Every developer must have those moments when you feel you are completely stuck with some problem. You feel like you are never going to solve the issue at hand. …
SQL Tracing in Self Service Applications (CRM) within Oracle Applications 11i
In a lot of cases it is very interesting to be able to trace Self Service Applications (CRM) in Oracle Applications 11i. Most of the time it is very …
Create a WebApplication secured with custom JAAS Database LoginModule & Deploy on JDeveloper 10.1.3 Embedded OC4J 10.1.3.1, Stand Alone OC4J and OPMN Managed OC4J (10g AS)
January 2, 2007
IT, Java, Oracle, Oracle Application Development Framework, Oracle WebLogic Server, Web HTML5 CSS3
16 Comments
For one of the projects I was recently involved in, we had to implement JAAS based authentication & authorization for our JSF Web Application, and we wanted to base …
Dynamic switch between radiobuttons and dropdownlist – create a new custom JSF component
January 1, 2007
IT, Java, Oracle, Oracle Application Development Framework, Oracle WebLogic Server, Web HTML5 CSS3
No Comments
In keeping with a short tradition, today is another day during my Christmas break on which I had some time to dabble in Java Server Faces and particularly the …
How to create a New Custom JSF Component that randomly displays select items in SelectOne… and SelectMany components
December 30, 2006
IT, Java, Oracle, Oracle Application Development Framework, Oracle WebLogic Server, Tools, Web HTML5 CSS3
1 Comment
Selection components, such as Radio Buttons. Dropdown-lists, Lists, Shuttles and Check Boxes, are key elements of many a web page. Java Server Faces has a pretty wide range of …
ADF BC – Fun with Bind Parameters Part Four – Choosing between various Pre-Canned Queries by leveraging the View Link bind-parameter
December 29, 2006
IT, Oracle, Oracle Application Development Framework, Oracle WebLogic Server, Tools
1 Comment
In this article on bind parameter usage in ADF Business Components, we will discuss a feature that I recently found out about and that I think offers a lot …
Deploying Custom JSF Components – and using them in new JSF Applications
December 29, 2006
IT, Java, Oracle, Oracle Application Development Framework, Oracle WebLogic Server, Tools, Web HTML5 CSS3
1 Comment
In several previous posts – and some articles yet to be published – I discuss the development of new JSF Components. Of course the true potential of such components …
Implementing Client Side Validation for Custom Validators in ADF Faces
December 28, 2006
IT, Java, Oracle, Oracle Application Development Framework, Oracle WebLogic Server, Web HTML5 CSS3
1 Comment
The SUN Reference Implementation of Java Server Faces has a limited number of Validators. The framework has plenty support for creation and integration of custom validators. It does not …
How to create a custom JSF Validator – The Greater Than Validator to enforce one component's value being larger than some other's
December 28, 2006
IT, Java, Oracle, Oracle Application Development Framework, Oracle WebLogic Server, Web HTML5 CSS3
4 Comments
One of the major benefits of Java Server Faces (JSF) in comparison to other View frameworks is its easy extensibility. UI Components can be incorporated, custom converters and page-life-cycles …
Funny ESB?
Hi all, I’ve used my ESB system – installed on SuSE9, connected to a 10.2 E.E. on the same machine – for a few months now, so I thought …
Fun with ADF BC Bind Parameters – Part Three: Support for generic bind-parameters in ADF Business Components
December 26, 2006
IT, Java, Oracle, Oracle Application Development Framework, Oracle WebLogic Server, Tools
No Comments
It can easily be the case that in your ADF BC application many ViewObjects make use of the same bind-parameters, for example a bind parameter referring to the current …
ADF BC and Faces: Fun with Bind Parameters Part Two – Locale specific database querying from the ViewObjects
December 24, 2006
IT, Java, Oracle, Oracle Application Development Framework, Oracle WebLogic Server, Tools
No Comments
In this article I would like to demonstrate another unexpected usage of ADF BC bind-parameters. In a previous entry I argued that bind parameters are typically seen as good …
ADF BC: Fun with Bind Parameters – Part One – Complex Order By clauses
December 23, 2006
IT, Java, Oracle, Oracle Application Development Framework, Oracle WebLogic Server, Tools
1 Comment
Bind parameters (:paramName) are typically used in the Where clause of SQL queries underlying ADF BC ViewObjects. However, there is no rule that they can only occur in the …
Quickly (temporarily) disabling role based authorization in JHeadstart Applications
December 22, 2006
IT, Java, Oracle, Oracle Application Development Framework, Oracle WebLogic Server, Tools
No Comments
Implementing role based authorization, linked either to JAAS or your home grown authentication and authorization approach, is pretty simple using JHeadstart. All it takes is configuring the JhsAuthorizationProxy bean …
ADF Business Components, Resfresh After Insert/Update and Instead Of triggers
December 22, 2006
IT, Java, Oracle, Oracle Application Development Framework, Oracle WebLogic Server, Tools
2 Comments
Some things are almost to tiny to blog about. Then again, if a blog can save you a lot of work and frustration then, even it is about something …