Category Archives: JDeveloper

Where do the JDeveloper extensions go?

Where does the downloaded stuff go after you installed JDeveloper extensions, like SOA Composite Editor, Oracle BPM Studio, or AIA Service Constructor?

On Windows you can find them here:
JDeveloper extensions location

C:\Users\_your_username_\AppData\Roaming\JDeveloper\tmp\update

Shouldn’t you be able to access the AppData directory, follow these instructions:

  • Go to the folder options, on Windows7 by clicking the Organize menu and the Folder and search options.
  • Choose the tab view.
  • Choose Show hidden files, folders and drives.

SOA Suite delete instances for specific composite

There are fine resources on how to purge SOA Suite instances. However there are case where you want to delete the instances for a specific composite deployed in the SOA Suite. An example could be after an extensive test or test load on a specific service implemented in a SCA composite.

Here is the PL/SQL we used to purge instances of the productservice composite in the test partition. It is based on the default packages that are bundled with the SOA Suite to purge instance data:

DECLARE
   l_min_creation_date   TIMESTAMP     := to_timestamp('2010-01-01','yyyy-mm-dd');
   l_max_creation_date   TIMESTAMP     := to_timestamp('2012-09-10 1600','yyyy-mm-dd hh24mi');
   l_batch_size          INTEGER       := 100;
   l_max_runtime         INTEGER       := 60;
   l_soa_partition_name  varchar2(100) := 'test';
   l_composite_name      varchar2(100) := 'productservice';
 
BEGIN
-- delete instances for specific composite
soa.delete_instances( min_creation_date => l_min_creation_date
                    , max_creation_date => l_max_creation_date
                    , batch_size => l_batch_size 
                    , max_runtime => l_max_runtime
                    --, retention_period =>
                    , purge_partitioned_component => FALSE
                    , composite_name => l_composite_name
                    --, composite_revision => 
                    , soa_partition_name => l_soa_partition_name
                    );
commit;
END;

You can use the instances tab to track the progress of the delete script:
Composite instance count

Installing an all 64 bit JDK JDeveloper set on Windows7

You might know that JDeveloper is supported on 64 bit versions of Java and Windows since release 11.1.1.4. Fusion Middleware is supported on JDK7 both 11g and 12c versions since May 2012. So I decided to try to install an 64 bit JDK7, 64 bit JDeveloper on Windows 7 64 bit.

Since most of my JDeveloper work is aimed at SOA Suite, BPM and non-ADF Java, I choose the JDeveloper 11g IDE. On the JDK site I started with JDK7u6. However a security thingie got in the way and I switch to JDK7u7. I’m assuming you have a PC/laptop/VirtualMachine running a 64 bit version of Windows7.

Install JDK7 update 7


The latest JDeveloper support/certification info states:

  • 64 bit JDK supported for Windows as of JDeveloper 11.1.1.4.0
  • For JDK 6, update 24 or later is recommended
  • For JDK 7, update 3 or later is recommended

However due to the security vulnerabilities in all earlier JDK 7 versions (on all OSes and their browsers) it is recommended to install only JDK7 update 7 and up.

Download JDK 7 for Windows 7 64bit. To install JDK7 on Windows7 double click the downloaded file.

Install JDeveloper 11.1.1.6


Since we have chosen a 64 bit JDK ourselves we downloading the jdevstudio11116install.jar from OTN Developer Tools site.

Before installing we check whether the correct JDK version will be used (from the command prompt (cmd)):
C:\Oracle\jdk7u7\bin>java -version
java version "1.7.0_07"
Java(TM) SE Runtime Environment (build 1.7.0_07-b10)
Java HotSpot(TM) 64-Bit Server VM (build 23.3-b01, mixed mode)

C:\Oracle\jdk7u6\bin>

And then to install JDeveloper from the command prompt (cmd):

C:\Users\deltalounge\Downloads>java -jar jdevstudio11116install.jar
Extracting 0%...................................................................
.................................100%

Then a GUI starts and the most important screens are:

Install SOA Suite, BPM and AIA extensions


Follow the guidance of these post to install JDeveloper extensions:

And you are ready to go.

Uninstall JDeveloper

Uninstall JDeveloperQuick tip: In case you need to uninstall JDeveloper for example when installing a new version of JDeveloper or WebLogic Server, here is how:
Locate and run from the JDeveloper / Middleware home (eg C:\Oracle\Middleware ):

  • On Windows: \utils\uninstall\uninstall.exe
  • On Linux, Unix and Mac OS: /utils/uninstall/uninstall

You can use the silent mode parameter: -mode=silent to uninstall JDeveloper on all supported systems.

JDeveloper 11g with BPM Studio extension

To create Oracle BPM processess with JDeveloper you need to install the BPM Studio extension. This is similar to installing the SOA Suite extension.

Ensure that the desired version of JDeveloper is installed. You can download JDeveloper here. Should you be unsure on how to install JDeveloper check the SOA Suite quick start guide to guide you.

Install JDeveloper BPM Studio extension

Install JDeveloper in a seperate Middleware Home. When starting JDeveloper choose the “Default” role. To enable JDeveloper to perform development for the SOA Suite and develop and deploy SCA composites you have to install an extension called SOA Composite Editor. When you want to develop BPM processess you need to install BPM Studio extension following these steps:

  • Select Help > Check for Updates
  • Click Next
  • Select Oracle Fusion Middleware Products and Official Oracle Extensions and Updates and click Next
  • Select Oracle SOA Composite Editor and Oracle BPM Studio 11g and click Next
  • Check the update has finished and click finished
  • Restart JDeveloper and you’re good to go

JDeveloper BPM Studio extensionShould you choose to install these extensions from a local file make shure you have the correct version for your JDeveloper and SOA Suite install. You can find these extensions in the JDeveloper Update Center. There is also a JDev extensions blog.

Fusion Middleware supported on JDK7

JDK7Trying to keep up with Java versions that are supported for JDeveloper and SOA Suite, like in JDeveloper now supports 64 bit Windows and Java. Redstack pointed me to the OFM supported systems configurations that show that Fusion Middleware is supported on JDK7. The XLS showing certification with OS etc can be found:

Upgrading to SOA Suite PS5 on Oracle XE

Installing PS5 (11.1.1.6) can cause some problems when using Oracle XE as the infrastucture database. The solution is described in this SOA Suite / BPM blog by Niall Commiskey.

More tips on upgrading OFM 11g to patch set 5

My colleague Laurens van der Starre published a serie of tips and tricks on upgrading Oracle Fusion Middleware to PS5 on the Whitehorses blog.

More considerations on upgrading to OFM 11.1.1.6.0

There is an additional article on upgrading to OFM 11.1.1.6 on the Whitehorses blog. It goes into more detail on JDK 7 support, OWSM in SOA Suite, the combination of OSB en OWSM and for example the PSA (Patch Set Assistant) performance.

Java memory arguments in OFM 11.1.1.6.0

More on setting Java memory arguments in SOA Suite 11.1.1.6.0.

Good practises for SOA Database Adapter

Sharing some things we learned while working with SOA Suite 10g database adapters.

  • Restrict the number of rows that will be returned by the query that is used in the database adapter. If you do not restrict the number of rows that is returned that could lead to high CPU and memory usage and time outs due to extreme processing time. These conditions can appear when a query results in severla thousand of rows returned.
  • Changes the this_toplink_mappings.xml file. If a toplink:read-all-query is used, change it to toplink:max-rows like
  • <toplink:max-rows>100</toplink:max-rows>
  • In case you forgot… if the audit level of the BPEL domain is still on Development level change it to the production level.

For links to File and FTP adapter stuff.

SOA Suite Installation Quick Start

There are always quite some blog posts on installing SOA Suite on several platforms. Recently I discovered that Oracle publishes a Quick Start Guide on the SOA Suite (PDF!) that mainly deals with the installation process (and de-installation should you need it).

This guide is aimed at installations for developers and not for production machines. Unfortunately the installation of OSB is out of scope. I expect it to be upgraded to PS4 (11.1.1.5) soon. I could find any missing instructions while installing PS4 on a Windows7 VirtualBox.

This document looks very similar to the installation chapter in Getting Started with Oracle SOA Suite 11g R1.

Update

It was confirmed by Simone Geib, Product Manager in the Oracle SOA team, that both the OSB part and the PS4 update are coming soon.

Update September

The update for SOA Suite PS4 (11.1.1.5) including Oracle Service Bus is now available.