OpenOffice Won't recognize Java JRE in windows 7

While playing around with OpenOfficeBase 4.1.1, I have encountered a strange error. "There is no JRE environment." even though latest jre is installed in my system.

Cause:  incompatible JRE version.   
OpenOffice requires 32-bit JRE version

Solution:
----------------
Check the JRE version installed in your system, using the following command:

JAVA -version

The above output clearly indicates that the JRE installed in my system is 64-bit, but OpenOffice requires only 32-bit version.

So, download a 32-bit JRE version from the url (http://www.oracle.com/technetwork/java/javase/downloads/jre6-downloads-1637595.html), install it.

In case there are multiple JRE's installed in your system, and the current JRE loaded is not the one which is being referred by OpenOffice, then this issue may a raise.

To locate a 32-bit JRE in your system, run the following command:

Java -d32

If a 32-bit JRE is available in the system, this command shows us that JRE details.

If there is no 32-bit version of JRE in the system, it shows the error as shown above.

Once, the desired JRE version is installed, Open OpenOfficeBase

Goto Tools -> options -> Java

and try to select the available JRE.

Work Around:
----------------

Open OpenOfficeBase

Goto Tools -> options -> Java

uncheck "use Java run time environment"