Skip to end of metadata
Go to start of metadata

Message

During the installation of the Loftware Connector for Oracle (LCfO), the following error can be caused by an incompatible version of Java installed for the JDK:

Message

Error loading classes with loadjava utility. Please click 'Previous' and verify ORACLE_HOME directory and the Oracle JDBC connection properties.

 

 

The LWCONN.LOG will also show the following entries:

May 06, 2013 01:39:38 PM :: Install :: Installing and populating the filter sample tables...
May 06, 2013 01:39:38 PM :: Install :: Inserting sample types, labels and groups...
May 06, 2013 01:39:38 PM :: Install :: Finished inserting sample label types.
May 06, 2013 01:39:38 PM :: Install :: Finished inserting labels.
May 06, 2013 01:39:38 PM :: Install :: Finished inserting sample groups.
May 06, 2013 01:39:38 PM :: Install :: Inserting filter samples...
May 06, 2013 01:39:38 PM :: Install :: The filter samples have been successfully installed.
May 06, 2013 01:39:38 PM :: Install :: Exiting --> AddLoftwareFilterSamplesAction
May 06, 2013 01:39:38 PM :: Install :: Entering <-- AddLoftwarePropertiesAction
May 06, 2013 01:39:38 PM :: Install :: Getting Connector Product properties...
May 06, 2013 01:39:38 PM :: Install :: Connection version to install is 4.0.2.0
May 06, 2013 01:39:38 PM :: Install :: Configuration Completed
May 06, 2013 01:39:39 PM :: Install :: Entering <-- ValidateLoadJava
May 06, 2013 01:39:39 PM :: Install :: Validating Loftware and XDK Java classes...
May 06, 2013 01:39:39 PM :: Install :: Loftware connection..
May 06, 2013 01:39:39 PM :: Install :: User Name --> loftware
May 06, 2013 01:39:39 PM :: Install :: HostName --> 172.16.81.12
May 06, 2013 01:39:39 PM :: Install :: Port --> 1521
May 06, 2013 01:39:39 PM :: Install :: SID --> JMacora
May 06, 2013 01:39:39 PM :: Install :: Service -->
May 06, 2013 01:39:39 PM :: Install :: Found 0 Java classes
May 06, 2013 01:39:39 PM :: Install :: Returning false
May 06, 2013 01:39:39 PM :: Install :: Exiting --> ValidateLoadJava
May 06, 2013 01:39:46 PM :: Install :: Entering <-- OracleHomePanel
May 06, 2013 01:39:46 PM :: Install :: Entering <-- OracleHomePanel
May 06, 2013 01:42:30 PM :: Install :: Exiting --> OracleHomePanel
May 06, 2013 01:42:30 PM :: Install :: Entering <-- AddLoftwareUserAction
May 06, 2013 01:42:30 PM :: Install :: Creating Loftware user...
May 06, 2013 01:42:30 PM :: Install :: Entered TableSpace is => users
May 06, 2013 01:42:30 PM :: Install :: Create loftware user account...

This shows the schema has been installed, but the java classes have not.

Solution

The installation document for the LCfO Version 4.0.2 outlines the requirement for a Java JDK version 1.6, but an incompatibility with the installer used for LCfO and Java JDK, version 1.6.0.43 and higher, will prevent the successful installation of this package.

According to the Flexera (installAnywhere) Knowledge Base, the last version of JRE 1.6 certified for use is JDK 1.6.0_26, all later releases of 1.6 are untested.

Using JDK 1.6.0.38 or earlier (limited to as early as 1.6.0.21). All seem to work correctly when installing the connector.

The correct LWCONN.LOG should look like this:

May 07, 2013 06:05:43 PM :: Install :: Installing and populating the filter sample tables...
May 07, 2013 06:05:43 PM :: Install :: Inserting sample types, labels and groups...
May 07, 2013 06:05:43 PM :: Install :: Finished inserting sample label types.
May 07, 2013 06:05:43 PM :: Install :: Finished inserting labels.
May 07, 2013 06:05:43 PM :: Install :: Inserting filter samples...
May 07, 2013 06:05:43 PM :: Install :: The filter samples have been successfully installed.
May 07, 2013 06:05:43 PM :: Install :: Exiting --> AddLoftwareFilterSamplesAction
May 07, 2013 06:05:44 PM :: Install :: Entering <-- AddLoftwarePropertiesAction
May 07, 2013 06:05:44 PM :: Install :: Getting Connector Product properties...
May 07, 2013 06:05:44 PM :: Install :: Connection version to install is 4.0.2.0
May 07, 2013 06:05:44 PM :: Install :: Configuration Completed
May 07, 2013 06:06:12 PM :: Install :: Entering <-- ValidateLoadJava
May 07, 2013 06:06:12 PM :: Install :: Validating Loftware and XDK Java classes...
May 07, 2013 06:06:12 PM :: Install :: Loftware connection..
May 07, 2013 06:06:12 PM :: Install :: User Name --> loftware
May 07, 2013 06:06:12 PM :: Install :: HostName --> 172.16.81.12
May 07, 2013 06:06:12 PM :: Install :: Port --> 1521
May 07, 2013 06:06:12 PM :: Install :: SID --> JMacora
May 07, 2013 06:06:12 PM :: Install :: Service -->
May 07, 2013 06:06:12 PM :: Install :: Found 1131 Java classes
May 07, 2013 06:06:12 PM :: Install :: Returning true
May 07, 2013 06:06:12 PM :: Install :: Exiting --> ValidateLoadJava
May 07, 2013 06:06:12 PM :: Install :: Entering <-- AddLoftwarePkgBodyAction
May 07, 2013 06:06:12 PM :: Install :: Create or replace inv_sync_print_request package body...
May 07, 2013 06:06:12 PM :: Install :: Create or replace clob_sync_print_request package body...
May 07, 2013 06:06:12 PM :: Install :: Create or replace loftware_lps package body...
May 07, 2013 06:06:12 PM :: Install :: Completed

This shows the schema and the Java classes have been successfully loaded.

The LCfO 4.0.2 documentation doesn't specify which subversion of Java 1.6 to use, and the download site for Java offers the latest version of 1.6, which was 1.6.0.45 at the time of this article. 

This version will not work to install the connector properly.  You will need to find the previous versions section to download version 1.6.0.38 or earlier (limited to as early as 1.6.0.21).

Previous versions are available here:

http://www.oracle.com/technetwork/java/javasebusiness/downloads/java-archive-downloads-javase6-419409.html

Article Number

 2013057

Versions

 Loftware Connector for Oracle, version 4.0.2

Environment

Windows Server 2008R2 environments.

  • No labels