Uploaded image for project: 'JDK'
  1. JDK
  2. JDK-6180475

Connection not reflecting commited changes with MS access DB

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: P2
    • Resolution: Won't Fix
    • Affects Version/s: 1.4.2_06
    • Fix Version/s: None
    • Component/s: core-libs
    • Labels:
      None

      Description

      Using connection pools a set of connections are initialised and later some of the connections insert/update DB (MS Access) and commit, other connections are not returning updated value if they are initialised before update/insert.

      Please see attached testcase.
      In the testcase, ConnectionA inserts data to TABLE_B and after that
      connectionB is initialised.
      Then ConnectionB returns 1 row from TABLE_B (which is expected)
      If we try inserting one more row. (that is after initialising ConnectionB)
      & retrieve data from TABLE_B using connectionB, then it will return only 1 row. (where 2 is expected)

      Please unzip the attachment into a folder and run it using startTest.bat
      Use the attached TestDatabase.mdb instead of that in zip file since the attached one contains table structure also.
      ###@###.### 10/18/04 12:54 GMT

        Attachments

          Activity

            People

            Assignee:
            ahandasunw Amit Handa (Inactive)
            Reporter:
            psreekumsunw Priya Sreekumar (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Imported:
              Indexed: