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

DataSet.insert() returns false when successful, true when it fails

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: P3 P3
    • None
    • 6
    • core-libs
    • None
    • x86
    • windows_2000

      Tested with build 92, derby snapshot db-derby-snapshot-10.2.0.4-423199. The output of the attached reproduction case is listed here.

      CLASSPATH = ;c:/db-derby-snapshot-10.2.0.4-423199/lib/derby.jar;c:/db-derby-snap
      shot-10.2.0.4-423199/lib/derbyclient.jar;c:/db-derby-snapshot-10.2.0.4-423199/li
      b/derbynet.jar;c:/db-derby-snapshot-10.2.0.4-423199/lib/derbyTesting.jar
      JAVA_HOME = c:/Program Files/Java/jdk1.6.0
      Dropping table...
      Creating table...

      insertAddresses(): DataSet addresses size is 0
      insertAddress(): DataSet addresses size after insert = 1
      insertAddress(): Address = 1, 505 Main Street, Pomona, NH, 90909, U.S.
      Insert of address1 success = false

      insertAddresses(): DataSet addresses size is 1
      insertAddress(): DataSet addresses size after insert = 2
      insertAddress(): Address = 1, 505 Main Street, Pomona, NH, 90909, U.S.
      insertAddress(): Address = 2, 606 Center Street, Winona, AK, 70707, U.S.
      Insert of address2 success = false

      insertAddresses(): DataSet addresses size is 2
      insertAddress(): DataSet addresses size after insert = 3
      insertAddress(): Address = 1, 505 Main Street, Pomona, NH, 90909, U.S.
      insertAddress(): Address = 2, 606 Center Street, Winona, AK, 70707, U.S.
      insertAddress(): Address = 3, 707 First Street, Ramona, NC, 50505, U.S.
      Insert of address3 success = false

      insertAddresses(): DataSet addresses size is 3
      insertAddress(): DataSet addresses size after insert = 4
      insertAddress(): Address = 1, 505 Main Street, Pomona, NH, 90909, U.S.
      insertAddress(): Address = 2, 606 Center Street, Winona, AK, 70707, U.S.
      insertAddress(): Address = 3, 707 First Street, Ramona, NC, 50505, U.S.
      insertAddress(): Address = 4, 808 A Street, Marcona, OH, 30303, U.S.
      Insert of address3 success = false
      **************************************
      Found these addresses in the database:
      selectAddressesJDBC: Address is 1 505 Main Street Pomona NH 90909 U.S.
      selectAddressesJDBC: Address is 2 606 Center Street Winona AK 70707 U.S.
      selectAddressesJDBC: Address is 3 707 First Street Ramona NC 50505 U.S.
      selectAddressesJDBC: Address is 4 808 A Street Marcona OH 30303 U.S.



      Close query object and Connection, get new DataSet instance

      insertAddresses(): DataSet addresses size is 0
      insertAddress(): DataSet addresses size after insert = 1
      insertAddress(): Address = 5, 11 Shady Wood Alley, Schwenksville, PA, 19066, U.S
      .
      Insert of address5 success = true

      insertAddresses(): DataSet addresses size is 1
      insertAddress(): DataSet addresses size after insert = 2
      insertAddress(): Address = 5, 11 Shady Wood Alley, Schwenksville, PA, 19066, U.S
      .
      insertAddress(): Address = 6, 22 Pleasant Valley Lane, Merkleesville, PA, 19333,
       U.S.
      Insert of address3 success = true

      insertAddresses(): DataSet addresses size is 2
      insertAddress(): DataSet addresses size after insert = 3
      insertAddress(): Address = 5, 11 Shady Wood Alley, Schwenksville, PA, 19066, U.S
      .
      insertAddress(): Address = 6, 22 Pleasant Valley Lane, Merkleesville, PA, 19333,
       U.S.
      insertAddress(): Address = 7, 33 Windy Hill Circle, Lutztown, PA, 19444, U.S.
      Insert of address5 success = true
      **************************************
      Found these addresses in the database:
      selectAddressesJDBC: Address is 1 505 Main Street Pomona NH 90909 U.S.
      selectAddressesJDBC: Address is 2 606 Center Street Winona AK 70707 U.S.
      selectAddressesJDBC: Address is 3 707 First Street Ramona NC 50505 U.S.
      selectAddressesJDBC: Address is 4 808 A Street Marcona OH 30303 U.S.
      See issue 6452083 for repro, output
      When the static modifier is added to the inner class Address definition, the test works. Therefore, this case is a duplicate of 6457325.

            ssharmasunw Sushmita Sharma (Inactive)
            duke J. Duke
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved:
              Imported:
              Indexed: