TITLE
    EOF 2.2 Database Adaptor Patch Overview
Article ID:
Created:
Modified:
72611
9/14/98
4/26/99

TOPIC

    This patch is now obsolete. Please see the WebObjects Current Patch List, TIL article 70037 , for information on the most current patches for WebObjects and Enterprise Objects Framework. This obsolete patch is provided here as a convenience to our customers who have not yet upgraded to the most current patch level.


DISCUSSION

    About the EOF 2.2 Sybase Adaptor Patch
    The Sybase Adaptor patch fixes two bugs:

    All parameters required for Sybase stored procedures
    Apple reference # 2203081

    PROBLEM:
    If you did not supply all values when executing a Sybase stored procedure, the execution would fail with an exception like:
    Feb 19 11:23:53 WOF_3_5_Sybase_Patch[1027] Caught exception:EOGeneralAdaptorException
    Sybase: Server:unknown Procedure:NEXT_MOVIE_PRIMARY_KEY Line:0 Procedure NEXT_MOVIE_PRIMARY_KEY expects parameter @A_MOVIE_ID, which was not supplied.

    This happens even though A_MOVIE_ID is not required for the stored procedure.

    RESOLUTION:
    The Sybase adaptor no longer requires optional arguments to stored procedures.


    Cannot fetch float-NSDecimalNumbers along with text columns
    Apple reference # 2208497

    PROBLEM:
    If you have an attribute with external type float, and internal type NSDecimalNumber, it will not fetch properly if a text column is also in the fetch. The attribute will be blank.

    RESOLUTION:
    The Sybase adaptor now correctly fetches these attributes.


    Installing the EOF 2.2 Sybase Adaptor Patch


    Windows NT
    Download the Sybase patch for Windows NT from Apple's FTP servers at ftp.info.apple.com. The patch is located at:

    /Apple_Support_Area/Apple_Software_Updates/MultiCountry/Enterprise/EOF/

    patches/2.2/Sybase_Patch.NT.gtar.gz


    To install the patch, open up a shell (from the WebObjects start menu) and issue the following commands as root, replacing the patch file name with the full path of the patch file you downloaded:

    cd $NEXT_ROOT

    gunzip -c Sybase_Patch.NT.gtar.gz | gnutar xvf -


    OPENSTEP/Mach
    Download the Sybase patch for Mach from Apple's FTP servers at ftp.info.apple.com. The patch is located at:

    /Apple_Support_Area/Apple_Software_Updates/MultiCountry/Enterprise/EOF/

    patches/2.2/Sybase_Patch.mach.gtar.gz

    To install the patch, open up a Terminal and issue the following commands as root, replacing the patch file name with the full path of the patch file you downloaded:

    cd /

    gnutar xvzf Sybase_Patch.mach.gtar.gz


    Solaris
    Download the Sybase patch for Solaris from Apple's FTP servers at ftp.info.apple.com. The patch is located at:

    /Apple_Support_Area/Apple_Software_Updates/MultiCountry/Enterprise/EOF/

    patches/2.2/Sybase_Patch.Solaris.gtar.gz

    To install the patch, open up a Terminal and issue the following commands as root, replacing the patch file name with the full path of the patch file you downloaded:

    cd $NEXT_ROOT

    zcat Sybase_Patch.Solaris.gtar.gz | gnutar xvf -


    HP-UX
    Download the Sybase patch for HP-UX from Apple's FTP servers at ftp.info.apple.com. The patch is located at:

    /Apple_Support_Area/Apple_Software_Updates/MultiCountry/Enterprise/EOF/

    patches/2.2/Sybase_Patch.HP-UX.gtar.gz


    To install the patch, open up a Terminal and issue the following commands as root, replacing the patch file name with the full path of the patch file you downloaded:

    cd $NEXT_ROOT

    zcat Sybase_Patch.HP-UX.gtar.gz | gnutar xvf -



    About the EOF 2.2 ODBC Adaptor Patch


    The ODBC Adaptor patch fixes two bugs:

    ODBC Adaptor cannot execute stored procedures with output parameters
    Apple reference # 2208503

    PROBLEM:
    The EOF 2.2 (WebObjects 3.5) version of ODBCEOAdaptor.framework introduced a bug which causes an error when using a stored procedure with an output parameter.

    RESOLUTION:
    The ODBC adaptor now handles output parameters correctly.


    ODBC adaptor leaks connections with Microsoft Access
    Apple reference # 2209574

    PROBLEM:
    The EOF 2.2 (WOF 3.5) and earlier versions of ODBCEOAdaptor.framework did not release ODBC connections when using Microsoft Access (or any JET based data source) in order to work around a bug in the Microsoft odbcjt32.dll library; this bug caused a crash when SQLFreeConnect was called. The SQLFreeConnect bug was discovered in version 3.40.2829 of the DLL. Newer versions of the DLL (beyond 3.50) no longer exhibit the crashing problem.

    RESOLUTION:
    The patched version of this framework now checks the version of the DLL more carefully and allows SQLFreeConnect to be called unless the DLL version is 3.4X. The adaptor no longer leaks the ODBC Connection when running with fixed versions of odbcjt32.dll.


    Installing the EOF 2.2 ODBC Adaptor Patch


    Windows NT
    Download the ODBC adaptor patch for Windows NT from Apple's FTP server at ftp.info.apple.com. The patch is located at:

    /Apple_Support_Area/Apple_Software_Updates/MultiCountry/Enterprise/EOF/

    patches/2.2/ODBC_Patch.NT.gtar.gz


    To install the patch, open a shell (from the WebObjects start menu) and issue the following commands as root: (replacing the patch file name with the full path of the patch file you downloaded)

    cd $NEXT_ROOT

    gunzip -c ODBC_Patch.NT.gtar.gz | gnutar xvf -


    Disclaimer

    THE SOFTWARE PATCH PROVIDED FROM APPLE IS PROVIDED "AS IS" AND WITHOUT WARRANTY, EXPRESS OR IMPLIED. APPLE SPECIFICALLY DISCLAIMS ANY IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT WILL APPLE BE LIABLE FOR ANY DAMAGES, INCLUDING BUT NOT LIMITED TO ANY LOST PROFITS, LOST SAVINGS OR ANY INCIDENTAL OR CONSEQUENTIAL DAMAGES, WHETHER RESULTING FROM IMPAIRED OR LOST DATA, SOFTWARE OR COMPUTER FAILURE OR ANY OTHER CAUSE, EVEN IF APPLE IS ADVISED OF THE POSSIBILITY OF SUCH DAMAGES, OR FOR ANY OTHER CLAIM BY CUSTOMER OR FOR ANY THIRD PARTY CLAIM.


Document Information
Product Area: Apple Software; WebObjects
Category: Enterprise Objects Framework
Sub Category: Patches

Copyright © 2000 Apple Computer, Inc. All rights reserved.