Uploaded image for project: 'Content IO'
  1. Content IO
  2. CONTENTIO-200

Import NUMBER types from SQL database are always stored as Double

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Major Major
    • 3.7.0
    • 3.6.0
    • 4.5 M5

      SQL number values are casted to Double values and set with the ExternalizableMetadataHelper to Double inside JCR repository but this kind of types can be Long or Double.
      We should use the new synchronization API in BaseSynchroComponent to avoid this kind of problems.

      I discovered it while updating AbstractSQLSCCTestCase._testSyncUser() by using getValue() instead of getMetadataHolder().getLong(). A FIXME has been added.

      NB: It can have impacts on Apogée synchronization.

          [CONTENTIO-200] Import NUMBER types from SQL database are always stored as Double

          Bérénice Maurel added a comment -

          No, it works for your case but if there is a type different than the SQL database, it fails in the same way.

          For example, you have a number in your database and a string in your model, it isn't set normally.

          Bérénice Maurel added a comment - No, it works for your case but if there is a type different than the SQL database, it fails in the same way. For example, you have a number in your database and a string in your model, it isn't set normally.

          Cédric Damioli added a comment -

          This is only an Oracle issue, with MySQL it works as expected.

          Cédric Damioli added a comment - This is only an Oracle issue, with MySQL it works as expected.

            cbayle Caroline Bayle
            bmaurel Bérénice Maurel
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: