Details

    • Type: Technical Task
    • Status: Closed
    • Priority: Trivial
    • Resolution: Inactive
    • Affects Version/s: 6.1.0 CE RC1
    • Fix Version/s: None
    • Labels:
      None
    • Environment:
      At revision 72531

      Description

      same improvement was addressed as LEP-841.

      Details got addressed at https://www.liferay.com/community/forums/-/message_boards/message/7459432.

      Any application or portlet dealing with currencies should really use the java BigDecimal class. Thus It would be nice for the Service-Builder to support data-type BigDecimal.

      A proposal:

      1) provide data type called big_decimal in service-builder DTD

      e.g.,
      <column name="field6" type="big_decimal" convert-null="false" />
      <column name="field7" type="big_decimal" convert-null="true" />

      It would be better to add two elements for type BigDecimal in service-builder.

      constraint-precision: the precision
      constraint-scale: the scale

      For example,

      salary DECIMAL(5,2)

      constraint-precision: 5
      constraint-scale: 2

      It can be presented as
      <column name="salary" type="big_decimal"
      constraint-precision="5" constraint-scale="2" convert-null="false" />

      2) add new data type in Liferay core called BigDecimalType, where specifies default value;

      3) map big_decimal into NUMERIC or DECIMAL as part of SQL scripts

      4) map big_decimal into data type BigDecimalType

        Attachments

          Activity

            People

            • Votes:
              7 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Days since last comment:
                4 years, 26 weeks, 2 days ago