Home Services Partners Company

OpenAccess SDK 5.0 SP1 (September 2003)

ATIqa01050:

JDBC: Port JDBC SDK on HP-UX11

ATIqa01790:

JDBC: Remove JDBC SDK limitation

ATIqa01791:

JDBC: Unicode version of JDBC SDK

ATIqa01793:

SDK: Unicode changes

ATIqa02311:

SDK: Allow the IP to associate a void * with column handles - ICOL_DA

ATIqa02320:

ODBC: Pass ODBC DSN value as part of User Connect String that is passed to the IP

ATIqa02350:

DAM: Join Order Optimization based on Search Condition should verify that inner tables have indexes defined on the join columns

ATIqa02372:

.NET: Support Unicode

ATIqa02409:

DAM: Scalar function registration is optional in passthrough mode

ATIqa02424:

DAM: Support expressions in ORDER BY clause

ATIqa02440:

SDK: Subset of autotest distribution

ATIqa02486:

SDK: Support the use of DDL commands for static schema management

ATIqa02487:

SDK: Support scalar functions sign() and datediff()

ATIqa02503:

ODBC: ODBC API enable/disable flags for SQLExtendedFetch and SQLMoreResults

ATIqa02559:

DQP: Optimization of queries targeted to a single database

ATIqa02561:

DQP: Enhance jdeDirect IP to support views

ATIqa02562:

DQP: Test DQP with 8-bit support in 5.0U build in preparation for unicode support in jdeDirect

ATIqa02572:

SDK: JAVA SDK limitations

ATIqa02578:

ODBC: Uninstalling OpenRDA ODBC Driver should remove all current DSNs that are based on it

ATIqa02617:

JDBC: Support calling of stored procedures that return values -- ? = call test()

ATIqa02619:

SDK: Optimize binary schema storage and lookup

ATIqa02623:

SDK: Support OpenAccess API SDK for Java with the sample JDBC IP on Solaris

ATIqa02626:

SDK: Support unicode version on Windows 95/98

ATIqa02628:

SDK: Support customizing error message file for Unicode build

ATIqa02631:

ODBC: Increase custom connect property size from 127 to 255

ATIqa02632:

SDK: Support openrda.ini customization using custom.ini

ATIqa02633:

SDK: Support custom file distribution using IS 6.0

ATIqa02644:

DAM: Support expressions in GROUP BY and ORDER BY

ATIqa02653:

DAM: Support Option to hide Qualifier and Owner in Catalog query results

ATIqa02670:

SDK: Porting JSQL IP on Solaris

ATIqa02679:

SDK: Port JDBC on digital unix

ATIqa02680:

JDBC: Make JDBC ISQL interface same as other ISQL

ATIqa02681:

SDK: Prepare JDBC user's guide

ATIqa02682:

JDBC: Execution of query in the loop with same stmt, returns null result set

ATIqa02685:

SDK: Make JSQL IP Unicode enable

ATIqa02686:

SDK: MsQuery failed with Japanese character

ATIqa02687:

SDK: Support Max Rows options in ISQLs

ATIqa02688:

JDBC: Add Local & C/S JDBC in autotest using JDBC isql

ATIqa02689:

DQP: Allow DQP IP to establish connections with backend DB

ATIqa02692:

ODBC: SQLProcedure query call is not use alias in ORDER BY clause

ATIqa02693:

SDK: JSQL server on Solaris crash with CR9

ATIqa02694:

JDBC: Fix input parameter problems

ATIqa02695:

OLEDB: .NET application is not working for binary parameter value more than 32K

ATIqa02697:

SDK: Change server executable name using custom.ini

ATIqa02698:

JDBC: Support SQLWarning object

ATIqa02700:

JDBC: Get connection object from statement object

ATIqa02701:

JDBC: Testing with DbVisualizer 3.1.1

ATIqa02702:

JDBC: Testing with different applications

ATIqa02703:

JDBC: Distribute JAR file instead of classes

ATIqa02709:

SDK: SQLMoreResult is not working with ODBC.NET

ATIqa02710:

SDK: oasconf should accept parameter

ATIqa02711:

ODBC: ODBC driver is not working correctly with ODBC.NET for empty string

ATIqa02713:

JDBC: Testing with JDBC Test 1.03

ATIqa02714:

JDBC: getUpdateCount with Rowset is not returning -1

ATIqa02715:

JDBC: getPropertyInfo() crashes Db Visualizer 3.2

ATIqa02718:

JDBC: Column header of Schema methods is not matching with JDBC specs

ATIqa02721:

JDBC: Testing with Forte for Java CE (Release 3.0)

ATIqa02722:

.NET: Dataset errors for more than one table

ATIqa02723:

JDBC: Testing with TableGen 1.8

ATIqa02732:

JDBC: Testing with SQLConnect 1.6.2

ATIqa02733:

JDBC: Support setObject method

ATIqa02734:

JDBC: Testing with ONE Studio 4 , update 1 (CE)

ATIqa02736:

ODBC: Support configurable SQL_ATTR_CURRENT_CATALOG/SQL_CURRENT_QUALIFIER & SQL_USER_NAME

ATIqa02737:

JDBC: Testing with VisualAge 3.5

ATIqa02742:

DAM: Support Scalar function result type to be based on input argument type

ATIqa02744:

JDBC: Testing with JBuilder 8

ATIqa02748:

DAM: Improve pushing schema search object when IP does not support schema search pattern

ATIqa02752:

SDK: Build single server using JSQL & Java

ATIqa02755:

JDBC: ISO 8859-1 string is not handle properly

ATIqa02757:

JDBC: getxxx(ColumnName) is case sensitive

ATIqa02758:

SDK: QA of Installations

ATIqa02761:

JDBC: getCatalog connect property is not working properly

ATIqa02762:

SDK: Porting JAVA SDK on AIX

ATIqa02763:

DAM: Support DAM_copyRow() to allow IP to copy/clone a result row

ATIqa02765:

DAM: Binary Schema should support Unicode Schema

ATIqa02774:

DAM: Support configurable SQL_DATABASE_NAME

ATIqa02779:

OLEDB: ADO.NEt application CLOB parameter values are truncated to 16 bytes

ATIqa02781:

OLEDB: Set ISLONG flag for BLOB/CLOB column/parameter

ATIqa02783:

SDK: Port JAVA SDK on Linux

ATIqa02784:

SDK: Port JAVA SDK on HP-UX 11

ATIqa02789:

DAM: Allow IP to specify multiple values for same column based on Result Alias Name

ATIqa02790:

SDK: We should change our ISQL tool to support same command length as our ODBC Driver.

ATIqa02798:

SDK: OpenAccess SDK and Windows 2000 Terminal Server.

ATIqa02802:

DAM: Simplify Schema Management DAM API

ATIqa02804:

DAM: Improve Block Join Performance when handling Table Rowsets

ATIqa02805:

DAM: Modify scalar functions in Unicode SDK to support both ASCII and WCHAR arguments

ATIqa02811:

ODBC: Improve tm_tracew() function to trace multiple arguments

ATIqa02813:

DAM: Improve result sorting in post-processing options like ORDER BY, DISTINCT

ATIqa02827:

SDK: Check memory leaks in JAVA IP

ATIqa02828:

OLEDB: Numeric & SetLocale problem in Unicode version

ATIqa02829:

ODBC: ODBC server isn't supporting Return value output parameter

ATIqa02831:

SDK: Java doc for JDAM

ATIqa02833:

SDK: JSQL IP server is not working with Oracle's JDBC driver for Oracle

ATIqa02834:

SDK: ISQLs should allow setting query options like SQL_QUERY_TIMEOUT, SQL_MAX_ROWS

ATIqa02837:

ODBC: Query with no parameters reports error if statement has bound parameters

ATIqa02839:

SDK: Testing of SQL IP with OTS

ATIqa02843:

DAM: Improve DDL to validate SQL limits

ATIqa02845:

SDK: SQL Windows fails for some DATE/TIMESTAMP value

ATIqa02847:

SDK: JSQL IP crashing on Solaris after any error occurs

ATIqa02851:

ODBC: Parameter execution of query followed by non-parameter execution of a query error out

ATIqa02852:

ODBC: outer join support information is not read from OA_INFO table

ATIqa02853:

ODBC: Transaction error out after connection and before executing any statement

ATIqa02864:

JDBC: Unicode JDBC driver on Solaris has problem

ATIqa02865:

SDK: Passing client version to the server

ATIqa02869:

DAM: Support for multiple schemas during query validation

ATIqa02870:

DAM: Allow IP to specify if numeric strings should be adjusted to match scale

ATIqa02872:

ODBC: ODBC isql (Unicode) is not working on Solaris

ATIqa02881:

SDK: Release OpenAccess User's Guide

ATIqa02882:

SDK: Port Unicode SDK on Linux

ATIqa02884:

JDBC: Profiling & optimizing JDBC driver

ATIqa02904:

ODBC: Support SQLSetConnectOption(SQL_MAX_ROWS) and SQLSetConnectOption(SQL_QUERY_TIMEOUT)

ATIqa02906:

SDK: Query Tool with simple interface for querying ODBC & OLE DB providers

ATIqa02917:

.NET: Support connection string editor

ATIqa02919:

.NET: Support parameter object

ATIqa02920:

OTM: OpenAccess Query Tool should check if OA product is installed

ATIqa02962:

SDK: Pass AutoCommit connect options to the IP Issues addressed by this release

ATIqa01459:

DAM: HAVING clause with no set functions in HAVING or select list is not handled properly when results are disk cached

ATIqa02253:

DAM: Group By on aggregated result field should report error

ATIqa02573:

SDK: Server gets a Disconnect if client system is not on network, SO_KEEPALIVE settings

ATIqa02584:

ODBC: Run Microsoft ODBC SDK quicktest and document

ATIqa02609:

SDK: Build on OpenVMS 7.1 with HP TestDrive setup

ATIqa02614:

SDK: Server does not respond to kill -2 after a connection has been performed

ATIqa02629:

SDK: JNI gives ClassCircularError when you execute statement second time

ATIqa02630:

ODBC: Driver crashes when connect string have any attribute name/value more than 50 characters

ATIqa02636:

SDK: OpenRDA Server Service Control Program is not responding in a timely manner to STOP request

ATIqa02637:

DAM: Problem if inner query in FROM clause uses column alias of simple columns in GROUP BY

ATIqa02638:

SDK: Nan and Inf float/double values not handled correctly in C/S version

ATIqa02641:

SDK: Server as DLL is not working with openrda.ini in the same directory as DLL

ATIqa02642:

DAM: NULLs are not being ignored in set functions AVG() and COUNT(column)

ATIqa02643:

SDK: OS/390 linker problem

ATIqa02645:

SDK: Support -q option in server also

ATIqa02647:

DAM: SELECT DISTINCT should not add hidden columns to make results distinct

ATIqa02648:

ODBC: If driver encounters errors writing to log file, it causes application to hang

ATIqa02649:

OLEDB: Blob parameter with BYREF is not supported

ATIqa02652:

DAM: Result type of expressions with set functions in HAVING is not being set correctly

ATIqa02658:

OLEDB: BLOB parameter passed as DBTYPE_VARIANT is not working with .NET

ATIqa02659:

SDK: Trace the PORT number

ATIqa02660:

DAM: Binary Schema is not handling pattern match search conditions

ATIqa02661:

JDBC: Schema functions are not working properly with JBuilder

ATIqa02662:

JDBC: getTableTypes returns more columns

ATIqa02666:

.NET: .NET provider is not working with ASCII server

ATIqa02667:

DAM: Set functions SUM(DISTINCT), AVG(DISTINCT) returns invalid results for short and real fields

ATIqa02668:

DAM: Problem handling NULL WCHAR values when results are written to disk cache

ATIqa02671:

SDK: DAAdmin tool crashes if we try to remove any entry from the database entries

ATIqa02672:

SDK: Porting Unicode on Solaris8

ATIqa02673:

ODBC: Special SQLTables() query won't work with Qualifier set using openrda.ini

ATIqa02674:

DAM: String Scalar functions (REPEAT, CONCAT etc.) are returning the result value as XO_TYPE_CHAR. Causes problem with disk cache if length exceeds 255.

ATIqa02683:

DAM: Modify type number for XO_TYPE_VARIANT to match with Unicode SDK

ATIqa02699:

ODBC: Modify ODBC driver and SDK installs to remove FILE DSN during uninstall

ATIqa02707:

ODBC: SQLGetData( SQL_WVARCHAR --> SQL_CHAR) does not work correctly for multiple calls

ATIqa02716:

JDBC: Install JDK on Digital Unix, HP-11 and SCO OpenServer

ATIqa02719:

DAM: Large Join queries with ORDER BY when processed on disk reports error

ATIqa02724:

DQP: Pushdown mode is not supporting disk cache

ATIqa02725:

DAM: Subquery in FROM clause is not supporting apostrophe in literals

ATIqa02727:

ODBC: Locale sensitive handling of decimal point

ATIqa02730:

DAM: Query with GROUP BY and no set functions when processed on disk does not handle ORDER BY & HAVING correctly

ATIqa02749:

RDA: Memory used for LOGNVARBINARY data field handling are not being released until FetchBlock data is processed

ATIqa02750:

DQP: Allow DQP IP to specify if scalar function should be sent to backend DB

ATIqa02751:

DAM: Catalog Schema Query can cause crash with Dynamic Schema when Views are enabled with FILTER_VIEWS_WITH_QUALIFIER_NAME

ATIqa02753:

DAM: Union queries should not support UNIQUE ROWS option

ATIqa02767:

DAM: COUNT(col) causes crash with Disk Cache queries

ATIqa02768:

DAM: Expressions in ORDER BY cause crash with disk cache queries

ATIqa02769:

ODBC: MS Access shows #deleted when accessing Uni IP with greek or Japanese characters

ATIqa02771:

SDK: Numeric values should not be modified based on the scale of the numeric data type

ATIqa02776:

SDK: Allow 5.0 Unicode ODBC driver to work with 5.0 ASCII server

ATIqa02785:

SDK: Referencing a linked server using four parts in SQL Server causes a full table scan

ATIqa02795:

DAM: HAVING clause is not handled correctly when Having exp refers to columns not in result

ATIqa02797:

OLEDB: DBCOL_SPECIALCOL guid is not return for hidden columns

ATIqa02799:

DAM: DAM ISQL is not supporting "-i" option for openrda configuration file

ATIqa02803:

ODBC: Server compatibility error message improvement (WITH CHECK OPTION violation)

ATIqa02812:

DQP: Problem with formatting of mixed inner & outer join query

ATIqa02823:

SDK: JSQL Server is not linking table with MS ACCESS

ATIqa02824:

JDBC: Check for memory leaks

ATIqa02825:

SDK: Check memory leaks in JSQL IP

ATIqa02841:

DAM: Metadata information (precision, length) of system tables is invalid

ATIqa02844:

DAM: SQL query limit for queries with subquery-in-from or views is not being handled correctly

ATIqa02857:

ODBC: Remove SQL_FLOAT from OA_TYPES so that SQLGetTypeInfo() does not report it

ATIqa02860:

SDK: Time literals as parameters supplied at execution time (DATA AT EXEC) are not normalized

ATIqa02879:

DAM: Group BY when handled by IP causes crash with disk cache queries if group columns are not in select list

ATIqa02897:

SDK: Connect String read from oadrd config file is being truncated to 127

ATIqa02901:

JDBC: Distribute Squirrel with JDBC

ATIqa02902:

SDK: Limitation of GetPrivateProfileString on Unix and spaces before/after =

ATIqa02907:

ODBC: SQLTables is not correctly handling length of TableType argument

ATIqa02913:

DAM: DAM_getValueOfExp() should support conversion of data to WCHAR

ATIqa02918:

DAM: Long column alias causes buffer overrun

ATIqa02923:

SDK: Invalid file handle error in tr_log -- reported by Bounds Checker before a crash

ATIqa02927:

ODBC: SQLDriverConnect returns OutConnectionString with repeated entries for the keywords DSN, UID, PWD etc.

ATIqa02931:

SDK: Merge Unix ODBC/JDBC driver installation guide to SDK

ATIqa02935:

DAM: Modify SQL_DATABASE_NAME/SQL_DBMS_NAME from "OpenRDA DAM" to "OpenRDA"

ATIqa02948:

DAM: Conditions on number (INTEGER, DOUBLE) fields and VARCHAR not supported

ATIqa02950:

DAM: Scalar expressions in outer join conditions cause crash

ATIqa02951:

ODBC: SQLMoreResults is not supported with iODBC Driver Manager 2.x

ATIqa02952:

ODBC: Extended functions value for new ODBC DSN is not getting set correctly

ATIqa02953:

OLEDB: Distributed transaction problem with linked server of SQL Server

ATIqa02958:

ODBC: SQLDriverConnect(SQL_DRIVER_NOPROMPT) causes crash in Redundant Server configuration

ATIqa02967:

DQP: Catalog information is not working with MS Analysis Services

ATIqa02969:

DAM: Double literal values in Scientific E notation are not handled correctly when they do not have decimal point

ATIqa02970:

DAM: Locale Sensitive handling of decimal point in DAM

ATIqa02972:

OLEDB: Bug in OLE-DB provider schema

ATIqa02979:

ODBC: Unicode SQLGetFunctions incorrectly reports support for unsupported functions(SQLMoreResults)

ATIqa02980:

ODBC: Extra Rollback call during disconnect

patch-whats-new

Read Next

What's new