Home  ·  Contact Us  ·  Search  ·  Site Map  
 
 

OpenAccess™ SDK Release History

OpenAccess SDK 5.6
OpenAccess SDK 5.5 SP2
OpenAccess SDK 5.5 SP1 
OpenAccess SDK 5.5
OpenAccess SDK 5.0 SP2

OpenAccess SDK 5.0 SP1
OpenAccess SDK 5.0
OpenAccess SDK 4.8
OpenAccess SDK 4.7
OpenAccess SDK 4.6
OpenAccess SDK 4.5
OpenAccess SDK 4.0
OpenAccess SDK 3.5

OpenAccess SDK 5.6 (July 2007)

What's New

  • New Schema Storage Manager - Static schema data and view definitions are now stored in an optimized text file format and no longer use dBase format. This results in faster operations and uniform support for schema related features across all 32-bit and 64-bit platforms. Previously views were not supported on 64-bit platforms.

  • Compatibility with DataDirect ODBC Driver Manager - The OpenAccess ODBC Driver is now compatible with the DataDirect ODBC driver manager on UNIX when the driver is run in ANSI mode.

  • Enhanced data type support - Support BIT and TINYINT data types.

  • DataDirect Branding - The components and end user license agreements now bear the DataDirect Technologies company name and the DataDirect OpenAccess product name.

Enhancements

OPR# 3379 Schema search object should filter '%' search pattern when it is used to read all tables. Previously the SCHEMA call would be required to handle this pattern and return all objects.
OPR# 3430 Allow PWD to be 512 characters. Previously the limit was 256 characters.
OPR# 3448 Support system views - validation should use default owner name as "SYSTEM"
OPR# 3458 Improve join ordering to support Star join query
OPR# 3466 Use CSV file format for Schema Management instead of Dbase format

Issues addressed by this release

OPR# 3408 DQP is not correctly handling conditions on translated date columns and scalar functions that return date values
OPR# 3424 Loading of libcrypto.so is not supported on a HP-UX build (PARISC and Itanium)
OPR# 3429 DQP is not handling View definition format of 5.5 SP2 release
OPR# 3438 dam_addValToRow reports error when BIT and TINYINT field values are provided as C data type "char"
OPR# 3441 Fail Over and Load Balancing is not working from UNIX (Solaris) client to Windows Server
OPR# 3449 Correlated queries are not supporting Views
OPR# 3462 Query translation is not correct when multiple views are used. Related to alias being generated for translated view subqueries.
OPR# 3464 Native error code is not returned correctly on Solaris
OPR# 3467 Union reports invalid results when union queries are Joins and FetchBlockSize is smaller than result set size
OPR# 3471 Once TableRowset size exceeds limit, DAM should disable TableRowset for future calls
OPR# 3474 SQLError should return SqlState as a null terminated string
OPR# 3480 Join queries without INNER qualifier gives syntax error
OPR# 3484 dam_describeCondEx is not returning correct length for BIT and TINYINT types
OPR# 3485 Queries with substring functions are not returning data going to 64-bit server on Sun Solaris
OPR# 3486 "TraceOptions=all:200" in the Server section of openrda.ini causes trace lines to be produced in sqlserv.c and tp0tcp_s.c
OPR# 3489 A too long SQL statement causes a crash in DAM
OPR# 3490 getString() call in JDBC for a string > 4096 characters causes an exception
OPR# 3491 Disk cache reports Invalid xo datatype (247) when query has WVARCHAR data on z/OS and AIX
OPR# 3498 Subquery in FROM clause - Issue when set functions in subquery are used in Search condition of outer query

OpenAccess SDK 5.5 SP2 (December 2006)

What's New

  • 64-bit support on additional platforms - Support 64-bit SDK on Windows and HP-UX/Itanium. Support 64-bit ODBC driver on Windows.

  • Enhanced SQL Support - Support CASE expression, CONVERT and CAST functions, and SELECT query without FROM clause.

  • Enhanced data type support - Support BIT and TINYINT data types.

  • Hybrid query execution mode - allow IP to operate in normal or pass through mode on query by query basis.

  • Large file support - Disk Cache module can now take advantage of large file system on Windows.

  • Flexible handling of custom scalar function evaluation - provide scalar function value as column value.

  • Improved Schema support for multiple catalogs - Allows query validation to be based on current qualifier and owner. Allow system table schema to use current qualifier.

  • OpenSSL support on additional platforms - This version extends support for OpenSSL to AIX 5.3 and HP-UX 11.23 on Itanium.

  • Enhancements and bug fixes - over 20 enhancements and over 30 bug fixes.

Enhancements

OPR#767 DAM: Expose TOP N select option to IP
OPR#962 DAM: Support condition expression CASE
OPR#2238 DAM: Support CONVERT and CAST functions
OPR#2849 DAM: Allow IP to get OA_SUPPORT information of column using dam_getColOption
OPR#2969 DQP: Support set functions (aggregate functions) in expressions in DQP mode
OPR#2972 SDK: Allowing the SQL IP to handle certain OA_INFO calls
OPR#3048 NDAM: NDAM should support customization of QUALIFIER_TERM and OWNER_TERM using ip_getInfo
OPR#3083 SDK: Support option to run Installations in Silent Mode
OPR#3148: SDK: Support SQL_BIT and SQL_TINYINT data types
OPR#3149 JDBC: Support NULL data type in SQL IP mode
OPR#3150 DAM:Allow IP to map scalar function as a column. Value can be passed when building the row
OPR#3172 ODBC: Support SQLCancel in Local mode with DAM IP
OPR#3178 ODBC: Allow Custom Driver connect interface to return error messages
OPR#3250 DAM: Support SELECT query without FROM clause
OPR#3287 DAM: Support Large (>2GB) disk cache file on Windows
OPR#3288 DAM: Allow IP to get column handle by searching for it by name and type
OPR#3303 DAM: Allow IP to check if target row matches condition list returned from dam_getSetOfConditionListsEx
OPR#3310 DAM: Support Qualifier(Catalog) of System table to be same as current qualifier of the connection
OPR#3334 DAM: Allow query validation to be based on current Qualifier
OPR#3358 SDK: Support option to disable hex tracing of Unicode messages in log files
OPR#3401 SDK: Include milliseconds in the time-stamps of the trace messages

Issues addressed by this release

OPR#2578 DAM: Views do not support DISTINCT quantifier
OPR#3129 WRDAADMIN: wrdaadmin is not allowing 0 for MAX_SIZE setting of Disk cache options.
OPR#3181 SDK: Conversion from a MBCS char string (SQL_CHAR/SQL_VARCHAR/SQL_LONGVARCHAR) to SQL_C_WCHAR is not correct
OPR#3207 Java SDK: In JSQL IP mode, PREPARE does not result in column spec or parameter specs being returned
OPR#3209 Java SDK: JSQLDRV is not passing the COL ATTRIBUTES returned by the JSQL IP up to SQLS layer
OPR#3211 Java SDK: SQLColumns call to JSQL layers truncates number of columns to 12 -- ODBC 3.x requires more columns
OPR#3219 Java SDK: setInfo in JDBC IP is not handling the query timeout and max rows settings
OPR#3258 ODBC: iusql program that comes with unixODBC driver manager fails to connect to OpenAccess ODBC - Database keyword not found error
OPR#3279 SDK: Binding of parameters to SQL_WVARCHAR or SQL_WCHAR is limited - support basic types to WCHAR and WVARCHAR
OPR#3286 DAM: Comments in original query string are not retained when query is transformed to remove subquery in FROM (or View query)
OPR#3297 SDK: ODBC driver cannot be loaded (system error 998) when full tracing is enabled and environment variables (PATH, CLASSPATH) are larger than 1000 bytes
OPR#3311 DAM: Subquery validation to check if query result has single result is not valid. Its applied even to validate subqueries in FROM clause of nested queries.
OPR#3312 DAM: Support correlated column reference that is not qualified by parent table name
OPR#3314 DAM: Exists and Unique predicates are not handled in subquery translation
OPR#3315 DAM: Correlated columns are not properly translated in subquery translation
OPR#3316 SDK: Query on system tables reports Unicode license error when table name is qualified
OPR#3318 ODBC: Invalid license error reported by Local ODBC driver - Key is not valid for more connections
OPR#3319 DAM: CREATE TABLE DDL command is not correctly handling multi-column index
OPR#3342 ODBC: SQLSetConnectAttr(SQL_ATTR_MAX_ROWS) is not supported
OPR#3357 ODBC: Modify SchemaQualifier configuration key as SchemaOwner
OPR#3342 ODBC: SQLSetConnectAttr(SQL_ATTR_MAX_ROWS) is not supported
OPR#3344 SDK: Install should use Windows drive for default install folder
OPR#3357 SDK: Modify SchemaQualifier configuration key as SchemaOwner
OPR#3361 OLE DB: OLE DB is truncating last unicode character when returning data for WLONGVARCHAR fields
OPR#3365 OLE DB: OLE DB Provider returns garbage data for WVARCHAR field with zero length
OPR#3366 SDK: Zero length Binary field causes connection failure on Client
OPR#3368 DAM: Join query - incorrect processing of search condition involving OR expression with AND expression on seperate tables
OPR#3369 DAM: Result column name of Scalar function mapped as column is not being reported properly
OPR#3373 DAM: Union query returns empty results when the subquery has search condition which is always FALSE
OPR#3374 DQP: Query with CASE expression containing constant condition crashes
OPR#3378 SDK: Crash in oaisql on Itanium 64-bit HP-UX -- Bus error in rda_cliGetClientAddress
OPR#3380 SDK: Join query with multiple views where only some views are transformed and some pre-evaluated is not handled correctly
OPR#3383 DAM: Join query with multiple views where only some views are transformed and some pre-evaluated is not handled correctly
OPR#3384 JDBC: getInt method in JDBC is not correct for 64-bit - in testing EMPNO value is returned as 0
OPR#3385 JDBC: Logging of JDBC driver on HP-UX/Itanium goes to console
OPR#3386 SDK: rda_aeRcv causes crash when handling P_S_ABORT event
OPR#3391 DAM: UNION is returning ALL results when the UNION subquery has empty results
OPR#3400 SDK: Problem with find command during install on Linux
OPR#3403 DQP: DQP is not correctly formatting dateadd and datediff functions in query being passed to backend DB
OPR#3416 NDAM: Calling .NET scalar function on a new connection can cause a crash
OPR#3402 ODBC: ODBC Driver setup DLL is not supporting OPENRDA_INI environment variable
OPR#3421 DAM: Compare function is not set. Issue with IN condition dam_getSetOfConditionListsEx creates UNION condition lists
OPR#3422 DAM: Provide option to enable support for Locale specific decimal character in query literals
OPR#3423 Standard version of Local ODBC SDK 5.5 SP1 and 5.5 SP2 is not working with SQL Server 2005
OPR#3426 DAM: Binary Schema is not correctly reading OPENRDA.INI settings

OpenAccess SDK 5.5 SP1 (June 2006)

What's New

  • Improved robustness in client and server code - Various improvements in the client and server code allow for more robust operations under heavy loads. Improved object reference handling in the Java SDK limit memory usage.

  • Support for 64-bit AIX and 64-bit Solaris - OpenAccess SDK for C/C++ is now available for use with 64-bit code for AIX on IBM pSeries and Solaris on Sparc based systems.

  • Improved user defined scalar function specification - Allows IP to specify precision, length, and scale of result. In the previous version the SQL engine supplied default data type mapping.

  • Improvements to trace information - log version and configuration information before logging any error messages. Truncated log files are clearly marked at the end as being truncated.

  • Support for Views implemented by IP - IP can now mark objects as Views and handle CREATE VIEW, DROP VIEW commands.

  • Flexible Index Optimization - IP can choose to mark indexes only for internal query optimization and not expose to client applications. This is useful to prevent client applications like Microsoft Access from trying to optimize on columns that are exposed as indexes.

  • Improved support for subquery in FROM clause and Views - Execute subquery in FROM clause and execute the parent query using the subquery result table. Previous implementation of this feature expanded the nested query into a single query and this is some cases resulted in wrong results and limitations. The new implementation will first process the inner query and save the results and then execute the outer query on the saved results.

  • Improvements to how join ordering checks for index on inner tables - If IP marks that index should be checked on inner tables (CheckIndexOnJoinCond), DAM checks for index on join condition of inner table or index on any other search condition on the inner table. Previous versions only checked for index on join condition.

  • Flexible Block Join support - Block join mode is enabled for inner tables which are block join compatible. Previous versions enabled block join mode for entire query only if all inner tables were block join compatible. The new version provides improved performance to queries which are not fully block join compatible.

Enhancements

OPR#450 DAM Allow Length, Precision & Scale to be specified for Scalar Function Return value
OPR#1190 ODBC:Return data type name column attribute from IP to client
OPR#2886 JDBC Driver:Extend URL for standard & custom attributes
OPR#3017 SDK:Trace "Log File Truncated" as last message in the log file
OPR#3039 SDK:Support Query on View objects implemented by IP
OPR#3060 SDK:Allow IP to use indexes only for index optimization and not for exposing as Statistics in Schema API
OPR#3061 SDK:Index conditions with non-constant Scalar functions on outer table columns should be exposed to IP
OPR#3071 SDK:Support Binary data types in disk cache
OPR#3076 SDK:Improved support for subquery in FROM clause. Remove limitations caused due to query transformation
OPR#3088 SDK:Logging -- even if only the errors are logged we need to write out header in log file with version information
OPR#3104 SDK:Support Scientific E notation in Numeric literals
OPR#3106 SDK:Allow validation of License Key file for a specific ProductName
OPR#3108 SDK:Allow IP DDL Interface to handle CREATE VIEW, DROP VIEW commands
OPR#3113 DQP:DQP needs to allow configuration of scalar function format in query string for backend database
OPR#3127 SDK:Support correlated subquery in UPDATE query
OPR#3141 SDK:Allow scalar functions with no arguments to be used as identifiers (skip the empty function bracket) in query
OPR#3143 ODBC Driver:SQLColAttribute() for Catalog, Schema and Table Name should be supported - SQL_DESC_CATALOG_NAME, SQL_DESC_SCHEMA_NAME, SQL_DESC_TABLE_NAME
OPR#3147 SDK:Improved support for Views. Remove limitations caused due to query transformation
OPR#3163 SDK:ODBCISQL should allow making multiple connections
OPR#3165 SDK:Hex numeric literals should be supported in query string
OPR#3221 SDK:Join Order Optimization based on Search Condition should allow index check on inner table to accept index on join condition or a search condition on inner table
OPR#3264 SDK:Allow DQP to reverse translate simple scalar function values used as condition on translated columns
OPR#3268 Support SQLColAttribute(SQL_DESC_OCTET_LENGTH) in ODBC 3.x API

Issues addressed by this release

OPR#1185 DAM:All computed expressions (scalar functions etc) in inner GROUP BY must also be in outer SELECT - limitation of subquery in FROM clause
OPR#1398 ODBC:SQL_VARCHAR to SQL_DATE conversion is not supported
OPR#2253 SDK:NULL value specified for VARIANT column is not being handled correctly
OPR#2298 SDK:CHAR parameter of exact length 32000 causes crash
OPR#2351 ODBC:iODBC Driver Manager 3.51.1 build on Solaris8 is not exporting ODBC W API (SQLPrepareW etc.)
OPR#2374 DAM:Long formatted name for result column causes crash due to buffer overflow
OPR#2944 SDK:Conversion of Parameter data from SQL_BINARY/SQL_VARBINARY to SQL_LONGVARBINARY is not supported
OPR#2954 SDK:UID and PWD are visible in RDA event tracing - Connect string contains UID and PWD
OPR#2975 SDK:dam_addError and dam_addErrorW crash if message exceeds XO_ERROR_MESSAGE_LENGTH
OPR#2976 SDK:MSQuery is not allowing query with criteria on TIMESTAMP field to be edited by the Query Wizard
OPR#2981 SDK:Server is not reading LogFileClose trace setting for each connection. Tracing is slow if tracing is enabled after server startup
OPR#2987 SDK:Memory leak in handling of LONGVARBINARY, LONGVARCHAR, WLONGVARCHAR data in non-SQL IP mode
OPR#2992 ODBC Driver:File DSN configuration is not prompting with Custom Connect dialog - SQLDriverConnect used with Driver keyword has same issue
OPR#3005 ODBC Driver:SQL_C_LONG to SQL_SMALLINT conversion error
OPR#3007 SDK:Improve validation of Schema Queries when Unicode Product is not licensed
OPR#3009 SDK:odbcisql crashes when large customconnect command is executed
OPR#3011 ODBC Driver:Use of word with letters PASSWORD in the connect string causes crash in ODBC Driver
OPR#3012 .NET Driver:OaDataReader.GetChars is not returning correct size data
OPR#3023 JDBC Driver:getLong method of oacallablestatement is not handling large numbers correctly
OPR#3033 ODBC Driver:Second connection fails from odbcisql on AIX
OPR#3034 SDK:Pushdown join rowset provided by IP is not being used in cases where consecutive outer join rows have same join column value
OPR#3035 SDK:Support dam_freeRowSet
OPR#3037 SDK:Modify IP support option name of Pass Through query mode to IP_SUPPORT_PASSTHROUGH_QUERY
OPR#3038 SDK:Modify Administration tool to improve handling of MaxFileSize Trace setting
OPR#3040 OLEDB Driver:OLE DB data source uninitialization is not correct when there is failure at the open (uid/pwd) authentication
OPR#3052 SDK:damex_getFirstValExp() is not returning NULL when argument list is empty
OPR#3064 SDK:Timestampadd/dateadd scalar function is not correctly handling operations on TIME fields
OPR#3065 ODBC:SQLGetData Conversion of SQL_TIME to SQL_C_TIMESTAMP should set the date portion
OPR#3069 SDK:Validate Schema to check Column Types passed for Procedure Columns (OA_COLUMNTYPE field of OA_PROCCOLUMNS)
OPR#3070 SDK:Usage of table alias in nested SUBQUERY IN FROM is not being used in transformed query
OPR#3072 SDK:Stored Procedures with Return Value or Output Value causes crash during multiple execution of prepared query
OPR#3080 ODBC Driver:ODBC driver does not support conversion of SQL_VARCHAR to SQL_C_TIMESTAMP
OPR#3081 SDK:RowCount returned by IP Stored Procedure execution causes actual row count reported to be double the result set size
OPR#3096 JDBC Driver:JDBC layer tracing is not enabled on UNIX
OPR#3102 SDK:Quiet Mode argument of OpenRDA Server - syntax is not proper on Unix
OPR#3107 SDK:OA_USERDATA value of TABLE and COLUMN schema is not being returned completely in Schema Queries
OPR#3130 SDK:AL_surDeleteACB causes a crash because it makes unprotected access to a shared UCB list
OPR#3135 JAVA SDK:Calling java scalar function on a new connection can cause a crash
OPR#3138 JDBC Driver:Parameter value set using setString is not being passed correctly
OPR#3139 ODBC Driver:ODBC driver is crashing when SQLBindParameter passes empty string (SQL_C_CHAR) for date/time Parameter type SQL_DATE/SQL_TIME
OPR#3151 SDK:ODBCISQL is truncating Unicode data results (WCHAR/WVARCHAR) when displaying results
OPR#3155 SDK:On solaris server exits if the number of files (nofiles setting) is exceeded
OPR#3156 JDBC Driver:Subsequent execution of prepared statement with multiple results returns a null result set
OPR#3160 SDK:dam_getSetOfConditionListsEx does not set *pbPartial correctly when the IP_INFO_COND_LIST_NORMALIZATION_LIMIT is reached
OPR#3162 SDK:Server should not exit if a socket or file resource is not available
OPR#3164 SDK:Hex value passed as string literal in query is not correctly converted for short binary data fields
OPR#3167 SDK:Modify dam_describeCondEx to return proper length for all data types
OPR#3168 DAM:DAM is not correctly handling parameters during repeated query execution if parameters are converted
OPR#3170 ODBC:ODBC driver is returning -1 (SQL_NULL_DATA) as length when SQL_WVARCHAR data cannot be converted to SQL_C_CHAR
OPR#173 SDK:Crash during repeated execution of dynamic stored procedure if procedure only has Result columns and no input/output arguments
OPR#3174 DQP:Unique identifying column is being added as extra column to queries in DQP mode
OPR#3180 JAVA SDK:Java SDK has incorrect implementation for dam_setInfo(DAM_INFO_STMT_IP_CONTEXT)
OPR#3181 SDK:Conversion from a MBCS char string (SQL_CHAR/SQL_VARCHAR/SQL_LONGVARCHAR) to SQL_C_WCHAR is not correct
OPR#3214 JAVA SDK:Certain JDAM calls result in the creation of Global References that are not freed
OPR#3231 SDK: Could not found RdaCli TLS for 2E4 thread - Message logged when using SQL reporting services
OPR#3237 SDK: Binding of parameters from SQL_C_WCHAR to SQL_WVARCHAR is not handled correctly - we copy extra bytes
OPR#3238 SDK: Binding of parameter from SQL_C_WCHAR to SQL_TIME, SQL_DATE, SQL_TIMESTAMP copies extra bytes and fails at RDA layer
OPR#3253 ODBC: CustomProperties and other information read from odbc.ini is limited to 127 on UNIX
OPR#3265 SDK: DQP should not pushdown search expression with scalar functions that have translated column as Arguments
OPR#3272 Problem with subquery in FROM clause when IP supports Views
OPR#3273 setlocale usage on Unix is not correct when locale not set in openrda.ini

 

OpenAccess SDK 5.5 (May 2005)

What's New

  • New license manager - allows us to provide single build of our product in which a license file controls access to optional features.
  • Data encryption - Support for Windows cryptography and OpenSSL cryptography to enable up to 128-bit encryption.
  • Faster logging - improved logging implementation allows running with full logging without major performance impact. Earlier versions drastically added to the time required to perform operations.
  • Windows authentication - a Windows authentication enabled server can now accept connections using both Windows and the OpenAccess authentication.
  • Concurrent connections - OpenAccess server can now handle faster rate of connections through an increased listen queue.
  • Compatibility with load balancers - previously the OpenAccess server was not able to clean up all resources when a low level abort of a socket connection occurred. This situation occurs when a load balancing hardware does socket connections to monitor the server processes.
  • Clients can randomly select a server to connect to - the enhancement to the load balancing and fail over feature now allows a client to randomly connect to two or more servers running on the same system or different systems.
  • Internationalization - the IP can support client specific error messages from a single server.
  • Join processing - various improvements for standard and block join processing modes.
  • SQL engine tracing - new trace feature to detail the operations being performed by the SQL engine and the interaction with the IP.
  • Java JSQL IP - batch row fetching interface to allow a Java SQL IP to return batches of rows in a single call. This results in more than 30% improvement and greatly reduced CPU usage.
  • SQL data types - handling of large char fields has been optimized by adding support for SQL _LONGVARCHAR to be used for > 4K field sizes. Also added SQL_BINARY and SQL_VARBINARY for smaller binary fields.
  • Documentation - documentation has been reorganized to better handle the C/C++, Java, and .NET flavors.

  • Installation - on Windows installer has been upgraded to InstallShield 10.5.

Enhancements

OPR#709 SDK: Support SQL_BINARY and SQL_VARBINARY data types
OPR#783 SDK: Support SQL_LONGVARCHAR and SQL_WLONGVARCHAR data types
OPR#1527 ODBC: Support CustomProperties on Non-Windows platforms
OPR#1862 DAM: Support TIMESTAMPDIFF and TIMESTAMPDD scalar function ( defined by ODBC)
OPR#2051 SDK: Allow Numeric results to be rounded
OPR#2070 JAVA SDK: Enhance Example1 Java IP to support INSERT/UPDATE/DELETE queries
OPR#2130 SDK: Allow IP to get entire search expression as normalized list of condition list - walk list using passthrough API
OPR#2265 SDK: Error prefix customization
OPR#2270 JSQL: BLOB parameter support
OPR#2306 SDK: Data encryption ( AES/Rijndael) for client/server communications using OpenRDA protocol
OPR#2320 DAM: Support Comments in Query string -- (comment) /* comment */ - extend it for HINTs
OPR#2352 ODBC Driver: Support SQLGetDiagRec
OPR#2373 SDK: Support Verbose mode SQL engine tracing in Server and Local Drivers
OPR#2380 SDK: Improve performance of logging
OPR#2473 SDK: Support configurable SQL_ATTR_TXN_ISOLATION and SQL_OWNER_TERM
OPR#2516 SDK: Allow ip_endTransaction to return error message in addition to Native error code
OPR#2561 SDK: Allow setting default query timeout value in openrda.ini and through connection string keyword
OPR#2664 ODBC Driver: Support conversion to SQL_C_TINYINT
OPR#2670 JAVA SDK: Distribute JAR for Java SDK
OPR#2687 JDAM: Extend JDAM to include full API for SQL pass through
OPR#2721 SDK: Support Negotiate_DBMS security mode
OPR#2729 SDK: Allowing the Server to return error messages in different languages to handle clients with different locale settings
OPR#2741 SDK: Expose literal expressions involving Multiple & Divide operators to IP
OPR#2743 SDK: Limiting number of errors that get reported per query
OPR#2758 SDK: Support locale specific decimal character in numeric literals
OPR#2768 SDK: Allows configuration of Cryptographic Service Provider when Windows cryptography is selected for encryption
OPR#2775 SDK: Upgrade Install Shield Projects from 6.x to 10.5
OPR#2793 SDK: Use Primary Key and ROWID Pseudo column as Unique index for query optimization
OPR#2795 SDK: Optimize use of memory allocations for small varbinary data
OPR#2799 JDAM: Synchronized changes in DAM and JDAM since SP2 release
OPR#2830 JAVA SDK: Add support for Scalar functions in Java SDK
OPR#2831 JAVA SDK: Support VARBINARY , LONGVARCHAR, and LONGVARBINARY to Java SDK
OPR#2832 SDK: Support ISNULL, NVL scalar functions
OPR#2833 SDK: Allow IP scalar function to get the scalar function name - dam_describeScalar
OPR#2835 ODBC: Clients should be able to select randomly or in sequential fashion the server to connect to
OPR#2836 SDK: Improve join order when join condition is on foreign key table with multiple primary key tables
OPR#2838 SDK: Simplify IP interface registration and custom scalar function registration
OPR#2858 SDK: Allow IP to use DAM API to parse query and get the parse tree details - sqldrv_getQuery
OPR#2884 SDK: Allow Block Join to be used for some of the tables in the join whose join conditions are block join compatible
OPR#2895 SDK: Support UserName (UID) and Password (PWD) strings upto 256
OPR#2898 SDK: Support conditions on Binary Fields
OPR#2950 DQP: Support IP getInfo and setInfo interface in DQP mode

Issues addressed by this release

OPR#154 ODBC: ODBC Driver - SQLBindCol - incorrect implementation in one case
OPR#865 SDK: Use aamallocFromPage instead of aamalloc from more places in rdaxidu and other layers to improve decoding speed.
OPR#1028 DAM: DAM should skip normalization of WHERE clause into condition lists for complex expressions
OPR#1435 .NET Driver: Change the name of the namespace
OPR#1487 SDK: Symbols Boolean & BOOL cause conflict with user symbols - build errors on Linux
OPR#1528 SDK: Modify ODBC SQL IP to process AUTOCOMMIT setting in sqlip_setInfo and sqlip_connect
OPR#1534 SDK: ODBCISQL/OAISQL report NULL for fields with large precision
OPR#1805 ODBC Driver: Verification of length argument in Unicode ODBC API as per Microsoft article #294169
OPR#1807 ODBC Driver: Custom.ini in Unicode C/S ODBC install has entries that don't apply to client/server
OPR#1831 SDK: Allow SQL_QUALIFIER_TERM to be customized from ip_getInfo() and not cache in oainfo.ini
OPR#1901 SDK: Display the current LC_ALL locale settings in the log files
OPR#1970 DAM: Move FETCHBLOCK_SIZE, JOINBLOCK_SIZE, RdaStmtOptimizeLevel and SessPollWaitTime from the CLIENT section to Common section in openrda.ini
OPR#1977 ODBC Driver: Allow option for ODBC driver to return SQL_WCHAR as SQL_C_CHAR when SQL_C_DEFAULT is used - Only getting 1 character of string fields in ReportSmith
OPR#2001 SDK: tr_trace should not generate logs for ERROR level when TraceLevel is 0
OPR#2017 OLEDB Driver: OLE DB Driver uninstall is not unregistering the Provider
OPR#2028 SDK: Modify dam_getValueToSet() to return corresponding sizeof the data type instead of XO_NTS
OPR#2044 ODBC DRIVER: SQLRowCount returns -1 when result set size is large
OPR#2050 JSQL: Select Count(*) from table with more then 32000 records returns wrong results using JSQL IP
OPR#2054 DQP: DQP is not pushing down JoinExp when join is processed as a single query
OPR#2064 SDK: Syntax error reported on a mixed join query generated by MSAccess
OPR#2073 SDK: Improve Join Order to continue checking other option even if its finds conflicting FKEY information
OPR#2074 SDK: Improve Join Order to individually check index on join condition for each FKEY/search condition being applied and ignore when there is no match
OPR#2084 JSQL: Java SDK for Solaris - 5.0 SP2 hangs with Squirrel - problem with getTableTypes
OPR#2092 OLEDB: RowsetViewer reports numeric type values as 0.0 when using IOpenRowset::OpenRowset(TYPES)
OPR#2094 OLEDB: RowsetViewer - Using OpenRowset on table with more columns followed by table with fewer columns is not working
OPR#2100 SDK: ODBCISQLW is not printing new lines after error message
OPR#2104 ODBC DRIVER: ODBC driver causes client application to crash when openrda.ini is not found
OPR#2125 DAM: Improve Join Order to process FKEY table first and PKEY table next when index is only on PKColumn and no index on FKColumn
OPR#2132 SDK: Problem with implementation of cToWV
OPR#2136 SDK: DAMISQL on linux (ILINUX 7.3) does not work when Database name is not specified as argument
OPR#2138 SDK: OAISQL on linux (ILINUX 7.3) does not display result column names and echo is also not working
OPR#2157 SDK: Allow ip_endTransaction to return a native error code to the ODBC layer
OPR#2179 SDK: Expose Unicode API to process DCL and DDL commands
OPR#2183 SDK: View operations are not working in Unicode SDK on Linux and Solaris
OPR#2185 JAVA SDK: Start up server java classes must be in package to work with application server
OPR#2186 JDAM: Command line options (like -i) is not working with Java start-up files with server as DLL.
OPR#2192 SDK: DAMISQL on Linux does not display result column names and does not support parameters
OPR#2208 JAVA SDK: Long strings crashes the server - alignment problem in xm module
OPR#2221 JDAM: JSQL Server Crashes on Solaris 8 with Multiple connections.
OPR#2224 SDK: Invalid SQL syntax - using AVG, SUM set functions on non-numeric fields in ORDER BY and HAVING is cauing access violation
OPR#2235 SDK: Numeric literals longer than maximum supported numeric length causes access violation
OPR#2242 ODBC DRIVER: Error setting up CustomProperties while creating ODBC DSN on windows
OPR#2258 SDK: SQLColumns should not expose PSEUDO columns. Allow NULL values to be specified for Psuedo columns during INSERT
OPR#2262 JDBC Driver: Error Message Prefix Customization in JDBC
OPR#2264 ODBC DRIVER: Application buffer overrun
OPR#2266 SDK: Views and subquery in from clause do not work when identifiers contain # character
OPR#2276 JDAM: JAVA SDK Server (UC Version) SP2 crashes with Multiple connection in the first time using OAStressW program.
OPR#2280 DAM: Query with BETWEEN reports error when value of end condition is NULL
OPR#2281 DAM: Query with BETWEEN join condition causes error to be reported - "Invalid condition. Can't reverse"
OPR#2282 ODBC DRIVER: SQLGetInfo(SQL_ACTIVE_STATEMENTS) causes crash if application calls this before SQLConnect and tracing is enabled
OPR#2295 JAVA SDK: Java Server (JSQL) crashes when query has string data longer than 255 and returns more than one record
OPR#2300 DAM: Scalar function week is not returning correct result
OPR#2302 DQP: Views with large query string cause crash due to buffer overflow
OPR#2319 SDK: OpenRDA Server causes crash due to memory leak on repeated execution of OA Special Commands - SetConnectOption(AUTOCOMMIT)
OPR#2343 SDK: Connect string and authorization tracing issue
OPR#2350 ODBC Driver: Error reporting is not working when OpenRDA Unicode ODBC driver 5.0 SP2 is used with iODBC Driver Manager 3.5
OPR#2354 .NET: Change System.Data.OaClient name space
OPR#2365 DAM: Join Problem - Incorrect processing when mixed inner join expression has condition on outer join column
OPR#2385 SDK: OpenAccess IP Demo - Build errors on Linux
OPR#2411 JSQL: Pass AUTO_COMMIT option to JSQL IP
OPR#2416 SDK: Template/samples for Unicode IP - Update example IPs to expose both UNICODE Interface and NO_UNICODE Interface
OPR#2434 SDK: Allow new logging settings to be read during connection
OPR#2442 DQP: DQP mode - IN predicate should not be transformed into to OR condition list
OPR#2454 SDK: END_QUERY is not being called for all tables in JOIN when query execution fails in disk cache
OPR#2456 SDK: sys_deps.h build error
OPR#2488 SDK: Connections at fast rate cause server to exceed its limit of five backlog in the listen() call
OPR#2509 JAVA SDK: JVM_OPTIONS values that contain "-" characters do not get parsed correctly
OPR#2513 JAVA SDK: Java Server has a limit of 5 options in JVM_OPTIONS
OPR#2522 SDK: Join queries between IP exposed tables and System Tables is not supported when IP does not implement START_QUERY and END_QUERY
OPR#2524 JAVA SDK: Make Java samples (which are distributed as part of installation) thread safe
OPR#2527 NDAM: Make NDAM samples thread safe
OPR#2553 SDK: Executing a order by/group by query on a view crashes when order by column has string literal
OPR#2554 DAM: Binary Schema mode TABLE_PATH is not compatible with DB3 IP
OPR#2566 SDK: Modify ODBCISQL to set SQL_QUERY_TIMEOUT only if user explicitly uses QueryTimeout command
OPR#2580 SDK: Modify tracing to provide timestamp information for Error messages independent of the tracing level
OPR#2596 ODBC Driver: Data Type mismatch error reported by GROUP BY, ORDER BY post-processing options when column value gets converted
OPR#2597 SDK: DDL and nested query operations hang due to nested locking of DB3 IP Mutex from same thread
OPR#2611 SDK: Enhance RDA Admin for encryption options
OPR#2616 SDK: Enhance trace level setting from OpenRDA Admin to include ERROR|SNO|FATAL and to rename the levels
OPR#2621 SDK: Terminating a connection at server due to wrong TPDU version causes client to hang on Linux
OPR#2644 ODBC Driver: UID/PWD limit in default Driver login dialog is 32
OPR#2645 SDK: Handle leak in the server
OPR#2649 SDK: JDBC fixes related to Application Server
OPR#2655 SDK: Conversion error reported when query uses disk cache
OPR#2685 SDK: Compile of memory IP on Linux AS 3.0 /x86_64 gives warnings and errors in strnicmp
OPR#2695 DQP: DQP with changes to support large query string has memory leak
OPR#2704 SDK: oaisql depends on oaodbc32.dll.
OPR#2709 SDK: Numeric strings longer than 32+5 (37) cause client side parsing routines to report an error
OPR#2710 SDK: Numeric value size is not validated at the SQLS layer
OPR#2727 SDK: oaisql hangs during exit
OPR#2730 SDK: Socket probem on Linux with select()
OPR#2736 ODBC Driver: Calling SQLPrepare multiple times without a SQLFreeStmt(SQL_CLOSE) or SQL_DROP in between keeps increasing number of columns reported by SQLNumResultCols
OPR#2740 SDK: Precision of column data is being lost when query involves conversions
OPR#2742 SDK: Expose Join condition that has expression on outer table columns to IP - dam_describeCondEx
OPR#2745 SDK: Remove TIMESTAMP level from ERRORS using rdaadmin
OPR#2752 SDK: Tracing - function sqlu_createResSpec is not tracing the argument values for precision, etc.
OPR#2753 SDK: odbcisql results in RDA_CONFIG not set error when openrda.ini file is in C:\WINNT folder
OPR#2757 SDK: String literal in query should be treated as Unicode literals even without N prefix
OPR#2764 SDK: OpenOffice on UNIX fails for SQLTables
OPR#2773 SDK: Solaris hanging - when thread creation fails and/or acccept fails
OPR#2789 ODBC: Change meaning of PromptForUID
OPR#2796 SDK: Function sqlu_addResVal does not free data chain for W LONGVARCHAR
OPR#2800 SDK: Scalar function round is not working correctly for negative numbers
OPR#2801 ODBC: odbcisql problem displaying wide chars
OPR#2811 SDK: crash in wrdadml.exe, version 5.0.81.0
OPR#2812 ODBC Driver: Unicode ODBC Driver does not report SQLMoreResults correctly when application calls SQLFreeStmt(SQL_CLOSE) before getting all results
OPR#2814 JAVA SDK: Propagate the Java IP return code as is without doing mapping
OPR#2816 DQP: Extend support for unicode literals without N prefix in DQP mode
OPR#2824 SDK: Modify ODBCISQL to allow control of Unicode data display with separate options
OPR#2825 SDK: Use of any word in the connect string with the letters "type" in it confuse the sqls_attach function
OPR#2827 JSQL: SQL State shouldn't be null
OPR#2837 JDBC Driver: OpenAccess jdbcisql & REPEAT command
OPR#2839 JSQL: OAServer stop running
OPR#2840 JAVA SDK: Enhance SQL IP getColVal call to include the type of the column being accessed so that JSQL can be optimized
OPR#2841 SDK: Modify damex_describeVal to expose length of the literal value - required for Binary data types
OPR#2847 SDK: "disk1" should have new files of IS 10.5 during installations of SDK
OPR#2853 SDK: Char data types returned to SQLS through GET_COLVAL shoud not require NULL termination
OPR#2855 SDK: Improve handing of SQL_LONGVARBINARY data in non-SQL IP mode
OPR#2859 SDK: OpenRDA Administration tool and Trace settings
OPR#2861 ODBC: Accesing VARBINARY/BINARY from Crystal and MS Access requires Binary to WCHAR conversion
OPR#2862 SDK: Modify ODBCISQL to bind DATE, TIME, TIMESTAMP as SQL_C_DATE, SQL_C_TIME, SQL_C_TIMESTAMP
OPR#2863 JSQL: Schema query problem with ORDER BY clause not using alias name
OPR#2864 OLEDB Driver: Event viewer message
OPR#2865 SDK: Memory leaks for key buffer
OPR#2866 SDK: Crash when processng INSERT query
OPR#2868 SDK: Primary Key information should be requested using DAMOBJ_TYPE_PKEY
OPR#2871 SDK: Install the IS 10.5 project during SDK install
OPR#2877 SDK: rdaadmin changes for LogFileClose option
OPR#2888 ODBC: Failure of VARCHAR to WCHAR when getting data in chunks using SQLGetData
OPR#2894 SDK: END_QUERY error is not being reported for JOIN queries
OPR#2906 SDK: Memory leak with conversion of column value when the data type is not same as column data type
OPR#2907 ODBC Driver: Output length for std. ODBC driver isn't set properly.
OPR#2910 RDA: Client crash on SCO
OPR#2912 SDK: Query on View with WHERE clause and GROUP BY report syntax error. Same issue with nested subquery in FROM clause
OPR#2915 SDK: Modify Static Schema implementation to support both ODBC2x and ODBC3x client applications
OPR#2917 SDK: ODBCISQL/OLEDBISQL should set program locale based on openrda.ini configuration
OPR#2920 ODBC: odbcisql is not showing Spanish character correctly
OPR#2928 SDK: Installation missing LogFileClose entry in openrda.ini
OPR#2929 SDK: Installation icon in Add/Remove program
OPR#2931 .NET Driver: .NET Provider tracing problem
OPR#2932 .NET Driver: NULL value in DateTime problem
OPR#2933 ODBC: ODBC client driver installation problem
OPR#2934 SDK: Rdaadmin creates incorrect openrda.ini file
OPR#2935 ODBC: ASCII ODBC Driver problem
OPR#2955 .NET Driver: 5.0 SP2 .NET Data Provider is not working with 4.8 server
OPR#2956 ODBC: Remove -p option from odbcisql
OPR#2957 ODBC: SQLColAttribute(SQL_DESC_TYPE_NAME) is not reporting results when data type is date/timestamp types (SQL_DATE, SQL_TIME, SQL_TIMESTAMP)
OPR#2958 SDK: ODBCISQL is not supporting Unicode UID (username), PWD (password) and custom connect string
OPR#2959 SDK: Unicode error messages generated during connect are not being handled correctly
OPR#2960 SDK: Nested subquery has a limit of 256 for each column definition
OPR#2963 .NET Driver: Multiple results is not working

OpenAccess SDK 5.0 SP2 (April 2004)

Enhancements

OPR#859 SDK: Web services - design a solution to allow any data source to be queried using SOAP and XML.
OPR#1138 DAM: Add new API in JDAM
OPR#1357 SDK: Make JAVA (JDAM) IP Unicode
OPR#1416 SDK: Allow server configuration parameters like Port to be passed as command line arguments
OPR#1559 DQP: Support Stored Procedures in DQP SDK
OPR#1596 ODBC Customizer: Customizeable ODBC to ODBC Bridge
OPR#1606 SDK: Allow tm_trace to disable printing time in the logs
OPR#1620 SDK: Sample IP for accessing C# objects through C++ extensions for .NET
OPR#1633 SDK: Modifying ISQL output to indicate MAXROWS
OPR#1661 SDK: Example of table expression push-down in C++
OPR#1686 SDK: XA transaction support in OLE DB and JDBC
OPR#1691 SDK: Allow HQUERY of the current table being processed to be retrieved in regular IP mode
OPR#1708 JAVA SDK: Optimize JSQL IP to use fewer object create/destroy opetations when fetching data
OPR#1724 ODBC: Implement a component oaMTS to enable OpenRDA ODBC driver and others to participate in distributed transactions
OPR#1784 DAM: Reduce usage of Global Mutex ( BEGIN_GLOBAL_SERIALIZE) in DAM.
OPR#1818 JDBC: Customization of JDBC URL subprotocol
OPR#1874 SDK: Allow IP to remove error added by DAM
OPR#1916 ODBC: Allow UID/PWD to be prompted when using NTLM for authentication
OPR#1977 ODBC: Allow option for ODBC driver to return SQL_WCHAR as SQL_C_CHAR when SQL_C_DEFAULT is used - Only getting 1 character of string fields in ReportSmith

Issues addressed by this release

OPR#54 DAM: Does not verify the size of NESTED SubQuery used in COMPARISON PREDICATE
OPR#331 DAM: LEFT OUTER JOINS on multiple tables ( t1, t2, t3 where t1.c1=t2.c1 and t1.c2=t3.c2) is not implemented properly
OPR#1316 DAM: Multiple Result Sets is not working when Paging is disabled (UsePages=0)
OPR#1364 DAM: UNION subquery in FROM clause is not supported
OPR#1415 ODBC: 3.50 ODBC application crashes in SQLColAttributes when use with 2.0 ODBC driver
OPR#1462 OLEDB: LinkedServer problems with