Uploaded image for project: 'Apache Trafodion (Retired)'
  1. Apache Trafodion (Retired)
  2. TRAFODION-157

LP Bug: 1252809 - DCS-ODBC-Getting 'Invalid server handle' after bound hstmt is used for a while.

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • 2.4
    • client-odbc-linux
    • None

    Description

      Using ODBC 64 bit Linux driver.
      'Invalid server handle' is returned and insert fails when using SQLBindParameter/Prepare/Execute. The SQLExecute is done in a loop. It works for a while, but fails within 10 minutes. Changed the program to reconnect every 5 mins, but still seeing this error. It works on SQ.

      Have attached simple test program to recreate this. To run on SQ remove the SQLExecDirect calls to set CQDs, those are specific to Traf.

      Attachments

        Activity

          People

            ryzuo RuoYu Zuo
            saruna Aruna Sadashiva
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: