Welcome to jBASE's new documentation site! Many answers to your questions can be found by searching the Knowledgebase or viewing the jBASE Documentation. We also have a Google Group for peer discussion about jBASE. If you are unable to find the information you are looking for, jBASE Support will be glad to assist in resolving your technical problems. Enjoy and please provide comments and feedback .

How can we help you?

jBASE 5.6 RELEASE NOTES


WHAT'S NEW


NATIVE RESTFUL SERVICES

RESTful Services has become one of the most important technologies for integrating business applications with the web. As a universal way for applications to communicate with each other, every major development language now includes frameworks for building RESTful Services. Native RESTful Services in jBASE 5.6 allows us to bypass proprietary APIs and open up your jBASE database to any language environment, web service or application. Developers can now unleash the power of their application and communicate in a modern way with powerful web services and SaaS applications, like Salesforce, Dynamics or NetSuite. These innovations will allow our customers’ time-proven intellectual property to ride the latest technological trends that are transforming the world of business.

GRANULAR AUDIT LOGGING

Building on the success of jBASE 5.5, we’ve increased the granularity of logging options to enable deeper event audits for customers with even the most stringent compliance requirements. Now you can set logging options globally or at an individual file level. You can also apply audit logs to a remote copy of jBASE to accelerate the backup process and improve recovery point objectives.

UPDATED SYSTEM MANAGER

System Manager provides a single pane of glass from which to manage your jBASE database. We’ve updated this powerful web tool with improved file management capabilities, audit logging configuration capabilities, and user session management. From jBASE System Manager, you can now remotely manage all active user sessions and log out inactive users as needed.

NATIVE DATA ENCRYPTION

Get built-in data security and protection with the standard jBASE product for no additional cost. Native data encryption now makes it easy to meet increasing compliance requirements with granular encryption at the file level. Choose between file-level encryption and spooler-level encryption while maintaining the high performance your users expect.


COMPONENTS

  • Net OBjEX Provides VB/.Net interoperability
  • jRemote & jRCS Provide Native jBASE API’s for accessing jBC functions remotely from C#, Java or .NET

3rd Party Components

The jBASE 5.6 installation process includes installation of the following 3rd party components.

JAVA RUNTIME ENGINE

Built using the following Java versions:

  • AIX 6.0 Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_12-b04)
  • Solaris 10 SPARC Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_12-b04)
  • Linux RH-AS5 Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_22-b03)
  • Windows 64-bit Java(TM) 2 Runtime Environment, Standard Edition (build 1.6.0_45)


INTERNATIONALIZATION LIBRARY

Required for Locale and Multi Byte character set support

  • ICU 4.0.1


XML LIBRARY

Required for XML function support.

  • XERCES 3.0.1
  • XALAN 1.11.0


SUPPORTED PLATFORMS

This specific Patch Release provides support for the following platforms:

  • AIX 6.0 (64-bit) * (on request)
  • Red Hat Enterprise Linux 5 (64-bit) *
  • Solaris 10 SPARC (64-bit) * (on request)
  • Windows Server 2008 & 2012 (64-bit)

*This build is binary compatible with forward releases of the platform

  • (e.g. AIX 6.1 -> AIX 7.1)

*Running on Red Hat 6 required the SSL compatibility library to be installed; this can be done with the following command:

  • yum install openssl098e


Caveats

  • jDP / Attunity Connect is not available for the 64-bit jBASE 5.6 release, replaced by jAgent/jODBC


Compilation

jBASE 5.6 is brought to you by the following compilers:

PlatformCompiler version
AIX 6.0XL C/C++ Version 8.0.0.18
Windows 64-bitVisual Studio 2005 SP1
RH Linux AS5gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-44)
Solaris 10 SPARCSun Studio 11


PATCHES

All patches from previous jBASE releases have been included where appropriate in jBASE 5.6. All Patch details for the jBASE 5.6 release are provided from the links below.

jBASE 5.6 patch release includes Patches PN5_50468 through PN5_60512


PatchDescription
5_50468Add support for encryption to UD file types.
5_50469jQL not being able to access encrypted files.
5_50470Add support for encryption to spooler.
5_50471Add extensions to CREATE-FILE to enable encryption.
5_50504The Z and ZH commands do not allow concurrent background tasks
5_50507jQL: Null mutli-values do not display correctly
5_50508jRCS: Incorrect environment variable used for setting telnet parameter used in multi-session licensing
5_50509Case Independence: Extend J4 and JP file creation to allow case insensitive record IDs
5_50511jRCS: Additional code added to insert connection details into *NIX utmp login record. This facilitates correct identification of client for multi-session licensing.
5_50513Case Independence: The 'not equal' operator (# <> >< NE) fails when comparing a variable with the concatenation of a literal and a variable
5_50514LIST-ITEM command does not display an error when no records are selected
5_50515Case Independence: The CASING statement and CASE command work differently to D3
5_50516Case Independence: Allow SUBROUTINE names to be case insensitive.
5_50519Case Independence: Various changes to jFormatCode and jBC utilities related to case independence.
5_50520jSQL: ODBC dictionary parsing issue
5_50524Spooler: Update help page for the Windows lp command
5_50525jQL holding on to previous results
5_50526jQL issue with null associated multi-value sets when doing a division operation
5_50528jQL: Incorrect results when using BY-EXP expressions with Print Limiting
5_50533Fix to jed so that it recognizes DICT in any case, e.g. dict, Dict, etc.
5_50535Case Independence: Correct defaults for case insensitivity
5_50536Transaction Journaling: Automatic logset switching
5_50537Spooler: Provide compatibility with the D3 SP-ASSIGN syntax when assigning the number of copies
5_50538Transaction Journaling: Add 64 bit file support to TJ log files
5_60481Case Independence: Add a case insensitive version of HASH4 files
5_60487Enhance reliability of mutexes especially on Windows and with memory allocation
5_60493Indexes require 'write' permissions for other users to be able to access it with commands like LIST-INDEX and KEY-SELECT
5_60498Audit Logging: Don't log the DELETE statement if the item does not exist
5_60503Stop the Z command from consuming memory unnecessarily
5_60512D3 compatibility enhancements: ! in PERFORM/EXECUTE and SYSTEM(19)

NEW COMMANDS

NEW JBC STATEMENTS

CHANGES TO CURRENT BEHAVIOR

Modules

  • Transaction Journaling

Commands

  • CREATE-FILE
  • SP-CREATE
  • SP-ASSIGN
  • Z
  • ZH
  • PH-START
  • JLICENSINGINFO
  • CASE
  • JFORMATCODE
  • LP
  • JED
  • JLOGMONITOR
  • LIST-INDEX
  • KEY-SELECT

jBC Statements/Functions

  • CASING
  • DELETE


NEW MODULES

  • jAgent: RESTful Services
  • Encryption

CHANGES TO INSTALLERS

  • Changes have been made to the jBASE Installers to simplify the install process, see Installation Guides

INSTALLATION GUIDES

Windows Installation Guide

Linux Installation Guide

Was this article helpful?