EPC - 132200

Date : September 2014

EPC132200 Updates to IBM i and Windows LANSA Integrator

  • SOAP Wizard enhancements:
    • SOAP Server Types can now be edited within the SOAP Server Wizard
    • Ad-hoc Server Type parameters can now be created within the SOAP Server Wizard
    • SOAP Agent Wizard can now handle input, output and input/output parameters
    • Publish jar, properties and service
  • New PGPFileService
  • New RDMLX BIFs JSMX_BEGIN and JSMX_END (requires Visual LANSA EPC132300)
  • ZipService performance improvements
  • ExcelService can now read both XLS and XLSX files
  • JSMDirect and JSMProxy can now take name-value pairs on the URL
  • JSMDirect and JSMProxy on IBMi Apache server can now receive chunked transfer encoded content
ProductLANSA Integrator
Version13 SP2
Pre-Requisite Details131900 (V13 SP2)
Related ProductsNone
Document UpdatesThis EPC will install an updated version of the "LANSA Integrator Guide" (lansa093.chm) with LANSA Integrator Studio.

You can manually copy this guide to the LANSA documentation location as installed with Visual LANSA. This default location is ...\x_win95\x_lansa\execute\eng directory.

The latest guides also available at http://www.lansa.com/support/docs/update.htm

Instructions to install the EPC

EPC132200 includes software to be installed on an IBM i machine and on a Windows machine. These instructions describe the installation and use of all delivered items.

  1. Download EPC132200.EXE file from the Web site or email.
  2. Unzip (double click) EPC132200.EXE. These files will be extracted:
    • EPC132200 - IBM i Save file
    • EPC132200w.exe - Windows Visual LANSA install executable

Instructions provided for:

Detailed changes

CCS id.Description
0150250
 
Add SSL support to JMS MQSeries/WebSphere

The CIPHER-SUITE keyword has been added to JMS CONNECT command to specify the SSL cipher to be used to connect to the message queue.
0150256
0151956
"Not Licensed" messages appear in STDOUT.TXT

Change "Not Licensed" to "Supported Feature"
0151191Add sample entries to XML service properties file

Add the following sample to the XML service properties files

#
# Parser validation
#
# validation.parser=*no
# validation.schema=*yes
#
# Parser entity resolver
#
# schema.dir=
# systemid.file://jsm/instance/order.dtd=file:dtd/order.dtd
# systemid.http://nasdaq.com/reference/NasdaqDotCom.dtd=file:dtd/nasdaq.dtd
#
0151295Upgrade Apache POI to version 3.10

The Apache POI classes are used by the ExcelService to read and write XLS and XLSX files.
0151328
Enhance SOAP Agent service to handle output holder parameters

SOAPAgentService now supports input, output and input/output operation parameters.
0151383Change AS2/SMTP/POP3 generic .der extension to .p8 or .cer

In the AS2, SMTP and POP3 documentation and properties samples the generic extension .der is used.
This extension has been changed to .p8 for PKCS#8 files and to .cer for certificate files.
0151384Ship JDK 5.0, 6.0 and 7.0 jar files with JDK 1.4 LI

Ship the following services and 3rd party jar files.

ExcelService (JDK 5.0)

jsmxlsx.jar
jsmpoi.par
jsmpoi-ooxml.jar
jsmpoi-ooxml-schemas.jar
jsmdom4j.jar
jsmxmlbeans.jar

XMLQueryService (JDK 5.0)

jsmxmlquery.jar

AxesTerminalService (JDK 5.0)

jsmrobot.jar
jsmterminal.jar

DirectoryWatchService (JDK 7.0)

jsmwatch.jar
0151494
0151404
XMLBindWizard generated sample code is using incorrect command keyword

The generated sample code should be using the URI keyword and not the URL keyword.
This defect has now been rectified
0151505Number of SOAP ServerTypes exceeds Java compiler command limit

The number of SOAP ServerTypes exceeds the Java compiler command limit for individual source files.
The source files are now added to an @source file command option.
0151550Upgrade JSch to version 0.1.51


0151579Add support for Thai combine characters to PDFSpoolFileService

Write out previous CSF page before incrementing page count.
0151639Add new JSMX_BEGIN and JSMX_END BIFs

JSMX_BEGIN and JSMX_END BIFs available for pre/post processing cleanup.

Note: VL EPC132300 is required to support these new BIFs.
0151651New tab for server types in SOAP Wizard

A new tab has been added to the SOAP Server Wizard to allow editing of SOAP Server Types with the current project.
0151663
0151647
Add read, write and connection timeout to SMTP and POP3 mail services

The timeout.read, timeout.write and timeout.connection properties have been added to the service properties file. Uncomment a property to set the particular timeout value. The property value is read at SERVICE_LOAD.
0151664
0151660
Add justified and justifiedall as possible text alignment values

Add justified and justifiedall as PDFDocumentService text alignment values.
0151716Add FileQueueService entry to service.properties file

The FileQueueService entry was missing from the service.properties file.
0151717Improve PDF page tracing for PDF spool file services


0151718Enhance SQLService to support multiple result sets from stored procedures

The SQLService can now handle mulitple result sets being return by a stored procedure.
This feature has only been tested using IBM's JDBC driver and IBM i stored procedures.
The implementation of returned output parameters on calls have been changed.
0151762Add UTF-16LE and UTF-16BE encodings to XML and text editors


0151825Enhance STRJSM command to use sorted jar file names

When constructing the CLASSPATH value, jar files are now sorted in alphabetical order.
0151880Include scale in Packed and Zoned validation exception message


0151886Upgrade JTOpen to version 8.2


0151913Change STRJSM and RUNJSM GCHINL keyword default value to 131072K

The previous value of 40000K was too small, the new default value is 131072K or 128M.
Add *JVM8032 and *JVM8064 as version options.
0152019Create new PGPFileService

The PGPFileService allows files to be encrypted and decrypted using the PGP format.
0152020
Enhance SOAPWizard to support adhoc parameter server types

Server types (Bean) can now be created directly within the SOAPServerWizard project.
This means you do not need to create a SOAP Server Type for a parameter.
0152030Refactor ZipService to use the ZipFile class instead of the ZipInputStream class

This reworking of the ZipService has made a dramatic improvement in the single entry read of zip files that contain a large number of entries.
0152033Remove unassigned sections from system and service .properties files

Existing unassigned sections are removed from the properties file.
No more unassigned sections are created.
Lines outside a studio section are lost.
During an upgrade a backup of files in the instance system and properties folders is made to a UPGRADE-BACKUP-YYYY-MM-DD-HHMMSS.ZIP file.
Also the #AllowOptions is automatically added to the system/SystemDefault.properties file.
0152055Enhance Studio java compiler for cross compilation support

Studio folders .\lib\java\ext, \lib\javac\ext and \lib\javac\bootstrap folders have been added to the Studio start-in folder.
The Java compilers used by XMLBindingWizard, JSONBindingWizard and SOAPWizard have been enhanced to use these folders as bootclasspath and extdirs arguments.
0152057Allow SOAP and JSON server type elements to be moved up and down

It is now possible to move type element locations up and down within a server type.
The Sort option needs to be unchecked. If the Sort option is checked then elements are sorted alphabetically.
The SOAPServerWizard has been enhanced to allow editing of SOAP server types within the project.
0152086Add capability to ExcelService to get a list of nameareas

Enhance the GET command to allow retrieval of namearea names: GET OBJECT(*NAMES) #WRKLST
Enhance the GET command to allow retrieval of a single cell value using a row,column value of a defined name whose reference formula refers to a single cell in A1 reference style: GET OBJECT(*CELL) R1C1() NAME()
0152098
Enhance SOAPWizard to publish jar, properties and service

After a build, the user is prompted to publish the generated jar, properties and JSMDirect service record
0152116Backup system and properties folders before applying upgrade

During an upgrade, a backup of files in the instance system and properties folders is made to a UPGRADE-BACKUP-YYYY-MM-DD-HHMMSS.ZIP file.
0152117
0152031
Add OFFSET keyword to PDFDocumentService ADD command

Add OFFSET( *NONE | *MARGIN ) keyword to PDFDocumentService ADD command.
This allows the x,y coordinate to be be offset by the current page margin.
0152140
JSMDirect and JSMProxy to accept chunked transfer encoding

JSMDIRECT and JSMPROXY programs can now accept chunked transfer encoding.

Note: Only IBM i Apache server is supported.
0152176JSMDirect and JSMProxy to accept standard name-value pair parameters

The JSMDirect and JSMProxy CGI programs can now accept name-value pair query string parameters on the URL as well as the original parameter format.

For example:

/cgi-bin/jsmdirect?service=upload&name1=value1&name2=value2

Note: Because of codepage and URL encoding issues, the service value should only contain A to Z, a-z, 0 to 9, - _ characters. Any characters outside these ranges should be avoided.

/cgi-bin/jsmdirect?upload
/cgi-bin/jsmdirect?service=upload

The service value is stored in the fields W29SRV and W30SRV

DC@W29 - W29SRV CHAR(30)
DC@W30 - W30SRV CHAR(30)

Note: A to Z, a-z, 0 to 9, - _ are the same across all IBMi CCSID codepages.
0152190Enhance UserAgent to allow name-value pairs on the uri string

UserAgent can now prompt and send name-value pair query string data.

For example:

uri=/cgi-bin/jsmdirect?service=uploadfile&id=A1001&type=*prompt&pass=*promptsecure
0152239Enhance ExcelService to read XLS files

The ExcelService can now read XLS and XLSX files.
0152257Add SERVICE_GET PROPERTY(*SERVICE) to return service class name

Add SERVICE_GET PROPERTY(*SERVICE|*SERVICECLASS) to return service class name.
*SERVICE returns the class name without the package name.
*SERVICECLASS returns package and class name.
0152290Ship apache xml commons xml-apis.jar ( jsmxmlapi.jar ) version 1.4.01


0152351Add anyType Object field mapping to SOAPAgentService

The SOAPAgentWizard and SOAPAgentService can now send and recieve field values that map to an anyType element.

Install Instructions

  1. Backup all the LANSA Integrator library and ALL the Integrator IFS objects (LANSA_jsmlib/jsm) before applying this EPC (this IFS is backed up by the EPC load program)
  2. End the JSM server to be upgraded before installing EPC132200.
  3. Display your current library list. If QTEMP is not shown, then add it to your library list using the ADDLIBLE (add library list entry) command.
  4. Move the unzipped file EPC132200 to an IFS folder on the IBM i. ( e.g. /LANSA_jsmlib(pgmlib)/tmp/epc132200' )
  5. For this EPC use the following options:
    1. Install the EPC from = *IFS
    2. Apply this EPC to = LANSA_INTEGRATOR
  6. Run the command LOADEPC with the following parameters:
    jsmlib
    /LOADEPC and press command 4 (F4) to prompt the command (This command also can be run in batch)

    EPC number . . . . . . . . . . . > 132200

    Install the EPC from . . . . . . > *IFS
    IFS Path and object name . . . . eg: /LANSA_jsmlib(pgmlib)/tmp/epc132200
    Apply this EPC to . . . . . . . > LANSA_INTEGRATOR
    LANSA Integrator library . . . jsmlib
    LANSA program librar . . . pgmlib (This is optional)

  1. End the JSM server to be upgraded before installing EPC131300.
  2. Make a backup of the JSM directory from the IBM i. The current JSM directory will also be saved in the backout library.
  3. EPC131300 must be extracted onto a Windows machine then uploaded onto the iSeries server.
    For iSeries shared folders:
  • in Explorer, map to the shared folder drive
  • create a folder named EPC131300
  • copy unzipped file EPC131300 to folder EPC131300
  1. Get the EPC131300 file into IBM i as ta save file. Can use FTP or CPYFRMSTMF command
  2. Use the OS/400 RSTOBJ (restore object) command to restore all objects from library QTEMP into library QTEMP.

For a save file you will use the following command:
RSTOBJ OBJ(*ALL) SAVLIB(QTEMP) DEV(*SAVF) SAVF(EPC131300) RSTLIB(QTEMP)

  1. Display your current library list. If QTEMP is not shown, then add it to your library list using the ADDLIBLE (add library list entry) command.

    Install the EPC using the command:
    LOADEPC EPCNUM(131300) USE(*SVF) SAVF(EPC131300) SELECT(LANSA_INTEGRATOR) JSMLIB(<jsmlib>) PGMLIB(<LANSA_pgmlib>)

    Where <jsmlib> is the name of the LANSA Integrator JSM library. This is often JSMLIB but it may be different on your system.

    Where <LANSA_pgmlib> is LANSA program library name and is optional.
  2. Press enter to continue processing.
  1. End the JSM server to be upgraded before installing EPC132200.
  2. Make a backup of the Integrator directory from Windows.
  3. Unzip (double click) EPC132200w.exe to start the upgrade of LANSA Integrator on Windows.
    NOTE: Please view the Additional Install Notes section in this document for important post-installation/upgrade checks.
  1. When the JSM instance starts it will process the files in the upgrade directory. If the upgrade is successful the JSM instance will restart else the instance will end. Check the file UPGRADE-LOG.txt in the JSM instance directory for upgrade messages.

    An example of the upgrade messages :
    --------------------------------------------
    manager: version : 13.2.1
    upgrade: version : 13.2.1
    -
    java.class.path : ./jar/jsm.jar:./jar/jsmide.jar:./jar/jsmjaf.jar
    -
    Upgrade instance : /LANSA_inxpgmlib/jsm/instance
    -
    Backup instance : /LANSA_inxpgmlib/jsm/instance
    -
    System file deleted : device-davifs.txt
    ...
    -
    System file already exists : ClassCache.jar
    ...
    -
    Add system file : device-unknown.txt
    ...
    -
    Replace system file : httpd-template.xml
    ...
    -
    Upgrade properties file : manager.properties
    Properties file upgraded
    ...
    -
    Instructions
    PRODUCT=JSM
    -
    Integrator upgrade
    -
    Add system file : httpd.xml
    -
    Add system file : webifs.html
    -
    Add system file : webifs-search.html
    -
    Upgrade integrator manager properties
    -
    Upgrade completed
    --------------------------------------------
    Remove upgrade files
    -
    File removed : /LANSA_inxpgmlib/jsm/instance/upgrade/AS2CertificateService.properties
    ...
    -
    Remove upgrade directory
    -
    Removal completed
    --------------------------------------------

© 2014 LANSA