OpenAccess SDK 5.5 SP1 (June 2006)

  • 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.

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

 

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#3173

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

Connect any application to any data source anywhere

Explore all DataDirect Connectors

A product specialist will be glad to get in touch with you

Contact Us