Uploaded image for project: 'QuickFIX/J'
  1. QuickFIX/J
  2. QFJ-586

SQL error when restarting QuickFIX/J session (java.sql.SQLException: ORA-00001: unique constraint violated)

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.3.3, 1.5.0
    • Fix Version/s: 1.5.3
    • Component/s: Engine
    • Labels:
      None
    • Environment:
      Windows/Linux

      Description

      I am using both 1.3.3 and 1.5.0 with an Oracle DB session/message store. I have set JdbcSessionIdDefaultPropertyValue="NA" and am seeing the row get created properly, but the imcoming_seqnum and outgoing_seqnum are not being updated, and when I restart the session I get a unique constraint violation. It appears that QuickFIX/J is using the 'null' session_qualifier rather than the JdbcSessionIdDefaultPropertyValue value for evaluating whether or not to create a new row. Am I going to be forced to set all of the session fields (LocId and SessionQualifier) to non-null values to get QuickFIX/J working properly with Oracle?

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              thomas.kinch@theice.com Thomas Kinch
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: