Middiu`s Blog

Oracle Webcenter Spaces and web.xml issue

2012-02-21T22:22:00.001+01:00

I would like to share with you the solution to acommon issue about extension of Oracle Webcenter Spaces. In this post I’m notgoing to explain the steps to extend your spaces instance, my purpose is justto give you a tip to resolve this unpleasant error:

OracleJSP error:oracle.jsp.parse.JavaCodeException: Line # 6,oracle.jsp.parse.JspParseTagScriptlet@54e237e9 Error:Java code in jsp source files is not allowed in ojsp.next mode.

This issue attempts when you create a custom task flow to use inWebCenter Spaces. The typical steps are:

Build your custom task flow
Deploy custom task flow as an ADF Library
Add generated jar into the WebCenterSpacesSharedLibExtension project
Deploy WebCenterSpacesSharedLibExtension project to Spaces Domain

You don’t get any error message during these steps, but when you try toopen Webcenter Spaces login page, the browser displays the message above!

To fix this problem you simply need to“clean” the web.xml file of WebCenterSpacesSharedLibExtension project. In factwhen you add your custom task flow jar to extension project, Jdeveloper adds somewrong lines in web.xml. You can override the broken file with the vanillaweb.xml that ships with the WebCenterSpacesSharedLibExtension project and redeploythe project!

It is just a ‘stupid’ problem but It cantook many hours to get the solution. I hope this post can help you!

Bye bye

Emilio

ADF - Create and Populate new Rows on ViewObject with Multiple Updateable Dependent Entity Objects

2012-02-10T19:45:00.000+01:00

This is my first post on my new Blog and I would like to share with you the solution for a very common ADF BC case study: Create and Populate new Rows on ViewObjectwith Multiple Updateable Dependent Entity Objects.

Image that you need to build a form page thatallows users to provide the data for creating both a new Supplier and its “Principal Contact”. To do this, you can build a single view object that joinsboth the supplier and contact entity object where you can find a SupplierId column thatrepresents the foreign key with supplier table.

I'm not going to talk about creation of entityobject and view object - I take for granted you have built your ViewObjectcorrectly and that you can query it in the Application Module tester.

A basic step is enabling the secondary entity object (ContactEOin our example) to be updatable by selecting it in the Selected list of theEntity Objects page of the view object overview editor and:

• Deselecting the Reference checkbox

• Selecting the Updatable checkbox

Nowyou can start by editing SupplierVORowImpl.java class, you need override the framework create()method as shown in the following code:

/** [In file: SupplierVORowImpl.java]

@Override

protected void create(AttributeList attributeList) {

SupplierEOImpl newSupplier = this.getSupplierEO();

ContactEOImpl newContact = this.getContactEO();

try {

newSupplier.create(attributeList);

newContact.create(newSupplier);

}

catch (JboException ex) {

newSupplier.revert();

newContact.revert();

throw ex;

}

catch (Exception otherEx) {

newSupplier.revert();

newContact.revert();

throw new RowCreateException(true /* EO Row? */,

"Supplier" /* EO Name */,

otherEx /* Details */);

}

The above code dosen’t work untilwe override the create() method in SupplierEOImpl and ContactEOImpl class. TheBC4J framework base class for entity objects, oracle.jbo.server.EntityImpl,has the create() method with protected member access so if yourentity object is in another package compared to view object, you need to widenthe access of the create() method to public. The overridden create()methods class looks like this:

/** [In file: SupplierEOImpl.java]

protected void create(AttributeList attributeList) {

super.create(attributeList);

}

/** [In file: ContactEOImpl.java]

protected void create(AttributeList attributeList) {

super.create(attributeList);

DBSequence supplierId = (DBSequence)attributeList.getAttribute("Id");

if (supplierId!= null) {

setSupplierId(supplierId.getSequenceNumber());

}

Pay attention to the create() method ofContactEOImpl where we retrieve the DBSequence value of Id Attribute from the newSupplierEOImpl instance passed-in, and the way we set the "SupplierId"foreign key attribute of the contact with this temporary value. In next steps overriding refreshFKInNewContainees()and postChanges() method of SupplierEOImpl class we force the new supplier topost first and refresh temporary foreign key value to the final(database-trigger-assigned) sequence number.

If the primary key of SupplierEOImpl is notdefined as DBSequence Attribute - but as Number for example - you don’t need to override refreshFKInNewContainees()and postChanges() method, but you can retrieve the database sequence in create()method of SupplierEOImpl using SequenceImpl class, and then you can use thisvalue in create() method of ContactEOImpl.java to populate the foreign keyattribute.

The following code represent the refreshFKInNewContainees()and postChanges() method of SupplierEOImpl class:

/** [In file: SupplierEOImpl.java]

private RowIterator newContactBeforePost = null;

public void postChanges(TransactionEvent e) {

if (getPostState() == STATUS_NEW) {

newContactBeforePost = getContacts();

}

super.postChanges(e);

}

protected void refreshFKInNewContainees() {

Number newSupplierId = getId().getSequenceNumber();

if (newContactBeforePost!= null) {

while (newContactBeforePost.hasNext()) {

ContactEOImpl curContact = (ContactEOImpl) newContactBeforePost.next();

curContact.setSupplierId(newSupplierId);

}

newContactBeforePost = null;

}

The code is now ok, you should beable to use the BC4J Tester to test your application module and to create a newSupplier with it Principal Contact!!

I advise you to read the following post because I found It very useful to write mine: HOWTO: Implementing a ViewObject with Multiple Updateable Dependent Entity Objects or you can read the official Oracle Documentation about this issue here.

I hope you appreciated my post. Feel free to comment it.
bye
Emilio

New year, new life

2011-12-26T21:02:00.000+01:00

The 2012 is coming and I know - and I hope - It will be a very important year for me so I decided to write a new Blog. My purpose is to write technical posts in order to share my experience in IT world, but also keeping in touch with all those who want It.

I wish you a merry christmas, and happy new year!

How check RAM info like type and speed?

2010-02-07T11:00:00.000+01:00

Hi Friends,
today I want tell you a little trick to find information about the RAM ( or others device/components ) installed on your system by unix os.
These information are very useful if you don't know you RAM type (DDR or DDR2 ecc ecc) and speed (400 or 800 MHz) and you need upgrade you system for example. You can find this information from a shell prompt on your unix system with dmidecode utility.

dmidecode is a tool for dumping a computers DMI (some say SMBIOS) table contents in a human-readable format. This table contains a description of the systems hardware components, as well as other useful pieces of information such as serial numbers and BIOS revision.

You can check info on your RAM with the following command by root user:

dmidecode --type 17

the output will be like this:

Handle 0x002D, DMI type 17, 27 bytes
Memory Device
        Array Handle: 0x002A
        Error Information Handle: No Error
        Total Width: 64 bits
        Data Width: 64 bits
        Size: 1024 MB
        Form Factor: DIMM
        Set: None
        Locator: Slot-2
        Bank Locator: Channel B
        Type: DDR2
        Type Detail: Synchronous
        Speed: 800 MHz (1.2 ns)
        Manufacturer: Samsung
        Serial Number: 621127BA
        Asset Tag: 53510838
        Part Number: 4D332037385432383633515A532D43463720

Handle 0x002E, DMI type 17, 27 bytes
Memory Device
        Array Handle: 0x002A
        Error Information Handle: No Error
        Total Width: 64 bits
        Data Width: 64 bits
        Size: 2048 MB
        Form Factor: DIMM
        Set: None
        Locator: Slot-4
        Bank Locator: Channel B
        Type: DDR2
        Type Detail: Synchronous
        Speed: 800 MHz (1.2 ns)
        Manufacturer: Hyundai Electronics
        Serial Number: 00002223
        Asset Tag: 41410843
        Part Number: 48594D503132355536344350382D53362020

Using dmidecode you can check info about other devices installed in your pc too. You need only change the parameter --type from 17 to another values.... The SMBIOS specification defines the following DMI types:

Type   Information
       ----------------------------------------
          0   BIOS
          1   System
          2   Base Board
          3   Chassis
          4   Processor
          5   Memory Controller
          6   Memory Module
          7   Cache
          8   Port Connector
          9   System Slots
         10   On Board Devices
         11   OEM Strings
         12   System Configuration Options
         13   BIOS Language
         14   Group Associations
         15   System Event Log
         16   Physical Memory Array
         17   Memory Device
         18   32-bit Memory Error
         19   Memory Array Mapped Address
         20   Memory Device Mapped Address
         21   Built-in Pointing Device
         22   Portable Battery
         23   System Reset
         24   Hardware Security
         25   System Power Controls
         26   Voltage Probe
         27   Cooling Device
         28   Temperature Probe
         29   Electrical Current Probe
         30   Out-of-band Remote Access
         31   Boot Integrity Services
         32   System Boot
         33   64-bit Memory Error
         34   Management Device
         35   Management Device Component
         36   Management Device Threshold Data
         37   Memory Channel
         38   IPMI Device
         39   Power Supply

Integrate Oracle BIEE Server with LDAP(OID) over SSL

2009-11-02T13:34:00.000+01:00

Surfing on the web I found a lot of guides to integrate Oracle BIEE Server with LDAP Repos but I didn't find any guide to integrate Oracle BIEE Server with LDAP Repos over SSL so I decided to write a little HOW-TO to describe how to do it.

There are two ways to integrate BIEE with a LDAP repo, the first one is to entrust to OID the authentication user list, the second one is to sync the BIEE user repo with LDAP repo. In this article I'm describing the first way!

Config SSL on OBIEE:

Install GSKit7 on Server machine and Client machine

Create the key_file with the utility sk7ikm ( for details follow Generating a CMS Key Database Using IBM GSKit ), when you generate the key file you need to import the OCA cert of OID

Copy the generated file "key.kdb" to Server machine in the path $BIEE_HOME/server/Config

In BIee Administrator`s Menu go to: Tools –> Options –> Repository and fill out the form with the Key File Name and Password like the image below:

Config OBIEE LDAP server:

Go to Manage -> Security -> LDAP Server

Select "New LDAP Servers..." and fill out the two tabs as follow:

It's very important to check the SSL option!!!

Now your BIEE is integrated with your ldap repo.

The next step is to configure your Initialization Block, this isn't a topic of my article so if you need an exhaustive guide about Initialization Block of BIEE you can read the section "Configure initialization block for user authentication" in this page.

I hope you find this article useful for you, feel free to comment it!

bye bye!

Encrypt/Decrypt String in Java Property File

2009-10-29T16:30:00.000+01:00

Hi all,
I think It would be very useful to know how to encrypt/decrypt a password/general string when we store it in flat file.

In java the common way to store settings properties, like a username or a password, is to use the Java Property File class using the standard methods: setProperty, getProperty or put. Below a simple example of text file generated from java:

 username=MyUsername
 password=MyPassword
 host=myhost

The evident security problem is that password string is readable by everybody, this is not a good thing :) , the solution is to encrypt the password into the file. We can do it simply with few rows of code. The follow example explains how encrypting end decrypting string when we are working with Property Files.

We need to write a "helper" class in order to encrypt/decrypt a string through the use of a custom key. In the following sample the class name is EncryptionHelper. In this case we use a source written by Jakelite not by me (PS: thanks Jakelite). You can download it from here.

With the following code I'm writing a property file with the password field encrypted:

 ...
 String prefFileName= "config.ini"; //Name of file
 Properties prop=new Properties();
 FileInputStream file=null;

 file =new FileInputStream(prefFileName);
 prop.load(file);

 EncryptionHelper encryptionHelper; //Class wrote by Jakelite
 prop.put("username", "MyUsername");
 prop.put("password", encryptionHelper.encrypt(":!MyPassword!:"));
 prop.put("host", "myhost");
 ...

This is the content of generated file "config.ini":

 username=MyUsername
 password=xRS5JsvgsdFv1dFj5HBZVpHhk+FfesDKyXPTAR3hY\=
 host=myhost

the rows below show how to read the encrypted password field from property file:

 ...
 String prefFileName= "config.ini"; //Name of file
 Properties prop=new Properties();
 FileInputStream file=null;

 file =new FileInputStream(prefFileName);
 prop.load(file);

 String username;
 String password;
 String host;

 EncryptionHelper encryptionHelper; //Class wrote by Jakelite
 username = prop.getProperty("username");
 password = encryptionHelper.decrypt( prop.getProperty("password");
 host = prop.getProperty("host");
 ...

I hope I made myself clear, feel free to comment and/or suggest me everything!

Cheers!

New Adium 1.3.7 and MSNPlus xtra

2009-10-19T23:52:00.000+02:00

New version of Adium is out, you can download it from officiale site.
The new release solves a bug on iChat and some bug on libpurple. Details:

Updated libpurple
- Fix a crash when some clients send contacts in a format we don't understand on ICQ.
- Fix blocking and other privacy lists on AIM/ICQ.
- Fixed CAPTCHA not working properly on Facebook.

Fixed iChat emoticons on Snow Leopard.

Now the Xtra of Tiziano Carotti ( MSNPlus ) works perfectly, the msnplus nick names have been decoded perfectly so we don't need the patched release of Adium any more.

You can download the MSNPlus Xtras here or you can install it directly!

Grazie mille Tiziano! ;)

bye bye

NEW Adium 1.3.6 With colored nick ( SDK 10.4 )

2009-09-05T21:10:00.000+02:00

I built the new release of Adium 1.3.6 with GIANDREA`s patch with SDK 10.4, I didn't test it, I hope It works perfectly, if not you can write me for fix the package!

Click here for download!

bye bye

Middiu

Adium 1.3.5 With colored nick ( SDK 10.4 )

2009-07-21T20:44:00.000+02:00

I re-built Adium 1.3.5 with GIANDREA`s patch with SDK 10.4, I can't try it, I hope It works perfectly...

Click here for download!

I'll be waiting for your comments!!!

bye bye

Middiu

MIDDIU.DYNDNS.ORG IN SCIOPERO

2009-07-14T12:11:00.000+02:00

La legge sulle intercettazioni è una chiaro bavaglio alla Rete.
Questo blog aderisce allo sciopero.

ADIUM 1.3.5 WITH COLORED NICK

2009-07-09T18:11:00.000+02:00

I built the new version of Adium 1.3.5 with GIANDREA`s patch, so the Adium`s user can see the Colored Nick like MSN Plus! I hope that GIANDREA and you like my (little) work!

Click here for download! Thanks to GIANDREA!!! bye bye

2009-07-09T10:19:00.001+02:00

Hi folks,
this isn't my principal blog, I have opened this blog only to reserve my nick Middiu.

You can follow me on my official blog: Middiu's Blog

bye bye