DdlUtils
  1. DdlUtils
  2. DDLUTILS-263

JDBC type NUMERIC - Database type NUMBER - But "Will be read back as DECIMAL"!?

    Details

    • Type: Improvement Improvement
    • Status: Open
    • Priority: Major Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Core - Oracle
    • Labels:
      None

      Description

      I am using the Ddlutils API to migrate a database model from Sybase to Oracle.

      The IDENTITY columns (of NUMERIC type) I have in Sybase are being migrated to Oracle with the proper behaviour: creation of a sequence and a trigger on those columns, with the type conversion from NUMERIC to NUMBER.

      However, when going back from Oracle to Sybase, I cannot retrieve those IDENTITY columns because of the following problem: NUMBER in Oracle is read back as DECIMAL which causes the following error in Sybase during the table creation:

      Identity field [..] must be a numeric with a scale of 0. It may not be nullable or encrypted.

      I don't understand the purpose of this "Will be read back as DECIMAL" behaviour!

        Activity

        There are no comments yet on this issue.

          People

          • Assignee:
            Thomas Dudziak
            Reporter:
            Shant Bozian
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:

              Development