8.1 Supported Configurations: HP NonStop Server on MIPS
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
This section provides the following information:
http://www.hp.com/go/WLS81SP2
and http://www.hp.com/go/WLI81SP2
.
WebLogic Platform supports the SQL/MX database on NonStop server configurations, but not all WebLogic Platform components support the same versions: WebLogic Server supports SQL/MX 2.0 and SQL/MX 1.8.5; WebLogic Integration supports only SQL/MX 2.0.
This section provides important information about configuring the SQL/MX database for use with WebLogic Server and WebLogic Integration on HP NonStop server:
For detailed information, see BEA WebLogic Server and WebLogic Platform 8.1 SP2 Software on HP NonStop servers: Installation guide:
http://h71028.www7.hp.com/ERC/downloads/BEA%20WLS-WLP.pdf
This section provides descriptions of limitations that have been identified and, whenever possible, workarounds for them. Issues have been identified in the following areas:
JDBC/MX driver version V31 is supported for use with SQL/MX 2.0. The following limitations apply to using SQL/MX 2.0 with WebLogic Server:
Problem: NonStop SQL/MX 2.0 does not support cascade deletions on a table. As a result, any Container Managed Persistence EJB that relies on the database cascade delete feature to delete the data from the SQL/MX database fails.
Workaround: The deployment descriptor of an EJB should not contain db-cascade-delete in its weblogic-cmp-jar.xml. This enables the WebLogic Server to delete rows using explicit SQL delete statements.
This problem may arise under two situations:
Situation (a): Automatic table creation for a CMP EJB using the deployment descriptor tag create-default-dbms-tables
fails if the table has column names which are keywords in NonStop SQL/MX.
Workaround: The CMP deployment descriptor should not use SQL/MX keywords as table column names.
Situation (b): Automatic table creation for a CMP EJB using the deployment descriptor tag create-default-dbms-table
fails if the table has a primary key column. NonStop SQL/MX 2.0 expects the primary key column to be qualified as NOT NULL NOT DROPPABLE
; however, automatic table creation does not generate the NOT NULL NOT DROPPABLE
clause.
Workaround: The table should be pre-created before the EJB is deployed so that the table schema exists when WebLogic Server checks for table information for the EJB.
Problem: Sequences/Identity columns are not supported in NonStop SQL/MX. Hence, automatic key generation for an EJB in WebLogic Server using sequences is not supported.
Workaround: The automatic key can be generated using NamedSequenceTable
as the value of the generator-type
in the automatic-key-generation
section of the weblogic-cmp-jar.xml
. The schema for the table name specified in the generator-name should have one column sequence of type Integer. The following code shows a sample entry:
CREATE TABLE SEQUENCETABLE (SEQUENCE INTEGER);
Problem: When an EJB has a WebLogic Server 5.1-style deployment descriptor, the EJB fails to deploy on the WebLogic Server. Any EJB that uses a WebLogic Server 5.1-style deployment descriptor fails to deploy. The doctype for a 5.1-style descriptor is as follows:
<!DOCTYPE weblogic-rdbms-bean PUBLIC '-//BEA Systems, Inc.//DTD WebLogic 5.1.0 EJB RDBMS Persistence//EN' http://www.bea.com/servers/wls510/dtd/weblogic-rdbms-persistence.dtd'>
Workaround: Convert the 5.1-style deployment descriptor to a WebLogic Server 7.0 (or later) style deployment descriptor. Some of the changes required are conversion of the pool-name
tag to data-source-name
and conversion of the attribute-map
to a field-map
. WebLogic Server provides a DDConverter utility to convert the beans from earlier versions of WebLogic Server. For further documentation about how to use the DDConverter utility, see the BEA Web site.
Problem: Certain instances of CMP-generated code based on the assumption of implicit type cast conversion fail. If the CMP-generated code assumes implicit type cast conversion (for example from string to integer), the SQL execution at runtime fails. Implicit type casting of data types is not supported in NonStop SQL/MX. 2.0.
Problem: Any EJB-QL that uses the SQL SUBSTRING
function fails to execute because the parameters of the SQL/MX SUBSTRING
function are different from the parameters used by other databases supported by WebLogic Server.
Problem: Container Managed Relationships (CMR) caching cannot be specified when using NonStop SQL/MX 2.0.
Problem: For CMP, no database types other than the default type are supported.
Problem: The use of SQL/MX 2.0 triggers is affected by several restrictions:
Problem: SQL/MX 2.0 does not support large objects (BLOBs and CLOBs) without the use of special additional tables.
Workaround: Special additional tables must be used. When a table contains a BLOB or CLOB column:
JdbcMxLobAdmin
utility is the recommended facility for pre-creating tables that contain BLOB or CLOB columns, as well as for creating the special tables used to store the LOB data._JAVA_OPTIONS
environment variable. This is true for users of both WebLogic Server and WebLogic Integration.ZZWLI_BLOBTABLE
and ZZWLI_CLOBTABLE
. For production mode, these tables, as well as the tables used for WebLogic Integration internal use, can be pre-created by using the scripts located in the integration/dbscripts/nsk
directory. These scripts are executed by entering the following at the oss
prompt:mxci
>>control query default JDBC_PROCESS `TRUE';
>>obey /usr/bea/weblogic81/integration/dbscripts/nsk/wli_runtime.sql;
>>obey /usr/bea/weblogic81/integration/dbscripts/nsk/wli_archive.sql;
>>exit;
Alternatively, WebLogic Integration startup in development mode can be used to pre-create the ZZWLI_BLOBTABLE
, ZZWLI_CLOBTABLE
, and WebLogic Integration internal tables.
Problem: Native SQL/MX utilities (including mxci
) cannot be used to insert, delete, or update data in tables that contain LOB columns.
Workaround: Use the JDBC/MX V31 driver to perform these operations.
JDBC/MX driver version V30 is supported for use with SQL/MX 1.8.5. All the limitations described for SQL/MX 2.0 also apply to SQL/MX 1.8.5.
In addition, the use of SQL/MX 1.8.5 with WebLogic Server is affected by the following limitations:
Problem: SQL/MX 1.8.5 does not support triggers.
Problem: This problem is manifested in the following ways:
Problem: SQL/MX 1.8.5 does not support !=
as an inequality operator. Therefore, if the generated code for a CMP EJB contains !=
as an inequality operator, SQL execution fails during runtime.
Problem: Any EJB-QL that uses either the ABS or LOCATE function fails to execute because the parameters of these functions for SQL/MX 1.8.5 are different from the parameters used by other databases supported by WebLogic Server.
This section describes general limitations that affect the use of WebLogic Server on a NonStop server configuration:
Problem: The first time you try to view the printable graph of a WebLogic Integration process instance from the WebLogic Integration Administration Console, a server exception is displayed in the browser window. This problem is due to the fact that the NonStop server platform is headless.
Workaround: Try again. The printable graph is displayed but with icons that are less descriptive than those provided through the interactive process view graph. It is recommended that users print using the Interactive Process View.
Problem: When WebLogic Transaction Manager performs a recovery after a restart, it may try to redrive a second-phase commit of transactions that have already been committed and forgotten by the resources, but that are still present in the transaction logs. If the resource managers have already forgotten a transaction, they respond with an XAER_NOTA
error code that WebLogic ServerTM ignores. Under some conditions, WebLogic ServerTM does not ignore this error code from the XA resources, and it throws an XAER_HEURHAZ
exception. This behavior does not affect the outcome of these transactions, however, because the transactions are already committed and forgotten.
Problem: Occasionally, when a WebLogic Integration instance (configured to use SQL/MX as the data store) fails and is restarted, a duplicate attempt may be made, during recovery, to insert a row into the message tracking table. This attempt fails with a database unique constraint violation. This failure can be ignored because no data is lost.
Problem: Filter values may not exceed 2000 bytes. This restriction may preclude the use of complex XML.
The rule name cannot exceed 140 bytes. It is derived from the consuming WebLogic Integration process type that invokes the dynamic subscription control. Its total length (in bytes) is:
This formula restricts the length of the process type name to:
Problem: Worklist comments may not exceed 3950 bytes.
The following limitations, for which there are no workarounds, apply to the use of B2B functionality:
The use of WebLogic Integration with SQL/MX 2.0 is affected by the following limitations:
Problem: For its internal tables, WebLogic Integration can only use SQL/MX 2.0 ANSI-tables; SQL/MX 1.8.5 is not supported for use with WebLogic Integration internal tables. A number of WebLogic Integration SQL objects have been modified for SQL/MX 2.0, principally because of the following SQL/MX 2.0 restrictions:
WebLogic Integration applications should perceive only the effects of the 255-byte combined key length limit in their use of core WebLogic Integration functions. The two most general and significant effects are:
Problem: The AI sample adapter, supplied with WebLogic Integration, is not available for use with SQL/MX.
See 10: Large Objects (BLOBs and CLOBs) Require Use of Special Tables.
For more information about known issues, see the Release Notes for the appropriate product:
On the HP NonStop server, only WebLogic Server and WebLogic Integration are supported; no other components of the WebLogic Platform product are supported. This section provides instructions for users who plan to use (a) both WebLogic Server and WebLogic Integration 8.1 SP2 or (b) WebLogic Server 8.1 SP2. To install both WebLogic Server and WebLogic Integration, follow the download instructions for BEA WebLogic Platform 8.1 SP2. To install only WebLogic Server, follow the download instructions for BEA WebLogic Server 8.1 SP2.
Note: To successfully install BEA WebLogic Platform 8.1 SP2 or BEA WebLogic Server 8.1 SP2 on the NonStop server, you must download and install the NonStop Server Toolkit, as instructed in Downloading the HP NonStop Server Toolkit.
The following sections provide instructions for these tasks:
Before you begin, review all instructions.
platform81sp2_hpns_supp.jar
. This JAR file contains HP NonStopTM server-specific modifications to the standard BEA WebLogic Server 8.1 SP2 files. ftp
to copy BEA WebLogic Server 8.1 SP2 (pj_server812_generic.jar
) and the supplemental JAR file (platform81sp2_hpns_supp.jar
) to an empty directory on the NonStop server. If such a directory does not already exist, create one now:$ mkdir -p /usr/tandem/wlhpns/download81sp2
http://commerce.bea.com/showallversions.jsp?family=WLP
platform81sp2_hpns_supp.jar
. This JAR file contains HP NonStopTM server-specific modifications to the standard BEA 8.1 SP2 files.ftp
to copy BEA WebLogic Platform 8.1 SP2 (pj_platform812_generic.jar
) and the supplemental JAR file (platform81sp2_hpns_supp.jar
) to an empty directory on the NonStop server. If such a directory does not already exist, create one now:$ mkdir -p /usr/tandem/wlhpns/download81sp2
weblogic81sp2_hpns_v12.zip
) from the "Resources" section of either of the following HP download sites: http://h30163.www3.hp.com/NTL/library/Independent_Products/BEA_WebLogic_Products
You must have already downloaded the following:
pj_server812_generic.jar)
for installing only WebLogic Server, or pj_platform812_generic.jar)
for installing both WebLogic Server and WebLogic Integrationplatform81sp2_hpns_supp.jar
)weblogic81sp2_hpns_v12.zip
)The HP NonStop server platform can be used with the NonStop SQL/MX database. The following table shows which versions of the NonStop SQL/MX database are supported by WebLogic Server 8.1 SP2 and WebLogic Integration 8.1 SP2.
If you are using the NonStop SQL/MX database, then you must have configured the database as specified in SQL/MX Database Configuration.
java_public_lib
directory, and the root directory in which you plan to install 8.1 SP2 and the NonStop Server Toolkit..profile
.$ export JAVA_HOME=/usr/tandem/java
$ export JREHOME=$JAVA_HOME/jre
$ export PATH=$JAVA_HOME/bin:$PATH
$ export WL_HOME=/usr/bea/weblogic81
$ export JDBCMX_DIR=/usr/tandem/jdbcMx
$ export JAVA_PUBLIC_LIB=/usr/tandem/java_public_lib
$ add_define =PTCPIP^FILTER^KEY class=map file=mykey
Note: The environment variables JAVA_HOME
, JREHOME
, PATH
, and WL_HOME
do not have default values. Set the variables to actual or intended locations before executing the check-wl-hpns.sh
and install-wl-hpns.sh
scripts.
$ZTC0
, create a define to indicate the process name. For example, in the following add_define
statement, the TCP/IP process name is $ZSM1
. You must include an escape character before the $
that precedes ZSM1
:$ add_define =TCPIP^PROCESS^NAME class=map file=\$ZSM1
weblogic81sp2_hpns_v12.zip
):$ cd /usr/tandem/wlhpns/download81sp2
$ jar -xvf weblogic81sp2_hpns_v12.zip
$ chmod 755 *sh
$ ./check-wl-hpns.sh
Note: Installation of WebLogic Server on a NonStop server system takes approximately one hour. Installation of both WebLogic Server and WebLogic Integration on a NonStop server system takes a total of approximately one and one-half hours.
The supplemental JAR file (platform81sp2_hpns_supp.jar
) is installed with the NonStop Server Toolkit.
$ ./install-wl-hpns.sh
Note: Use the -h
option to see a complete list of options for this script. If, earlier, you ran the installation script install-wl-hpns.sh
with the -j n
options, you now need to rebuild the JVM before proceeding.
http://h30163.www3.hp.com/NTL/library/Independent_Products
For more information about how to install and configure WebLogic Server 8.1 SP2 on HP NonStop server, see the following links:
http://h30163.www3.hp.com/NTL/library/Independent_Products/BEA_WebLogic_Products/WebLogic_Server__WLS__8_1
http://download.oracle.com/docs/cd/E13222_01/wls/docs81/config_xml/index.html
http://download.oracle.com/docs/cd/E13222_01/wls/docs81/ejb/DDreference-cmp-jar.html
http://h30163.www3.hp.com/NTL/legal.asp?redirect_page=/NTL/library/Independent_Products/BEA_WebLogic_Products
![]() |
![]() |
![]() |