<tfoot id='lBmCV'></tfoot>
<i id='lBmCV'><tr id='lBmCV'><dt id='lBmCV'><q id='lBmCV'><span id='lBmCV'><b id='lBmCV'><form id='lBmCV'><ins id='lBmCV'></ins><ul id='lBmCV'></ul><sub id='lBmCV'></sub></form><legend id='lBmCV'></legend><bdo id='lBmCV'><pre id='lBmCV'><center id='lBmCV'></center></pre></bdo></b><th id='lBmCV'></th></span></q></dt></tr></i><div id='lBmCV'><tfoot id='lBmCV'></tfoot><dl id='lBmCV'><fieldset id='lBmCV'></fieldset></dl></div>

    1. <small id='lBmCV'></small><noframes id='lBmCV'>

      <legend id='lBmCV'><style id='lBmCV'><dir id='lBmCV'><q id='lBmCV'></q></dir></style></legend>

        <bdo id='lBmCV'></bdo><ul id='lBmCV'></ul>
    2. JPA 自动 BigDecimal 转换

      时间:2023-05-27
      <legend id='ApC6Q'><style id='ApC6Q'><dir id='ApC6Q'><q id='ApC6Q'></q></dir></style></legend>
        <tbody id='ApC6Q'></tbody>
      • <bdo id='ApC6Q'></bdo><ul id='ApC6Q'></ul>

        <small id='ApC6Q'></small><noframes id='ApC6Q'>

              <tfoot id='ApC6Q'></tfoot>
              1. <i id='ApC6Q'><tr id='ApC6Q'><dt id='ApC6Q'><q id='ApC6Q'><span id='ApC6Q'><b id='ApC6Q'><form id='ApC6Q'><ins id='ApC6Q'></ins><ul id='ApC6Q'></ul><sub id='ApC6Q'></sub></form><legend id='ApC6Q'></legend><bdo id='ApC6Q'><pre id='ApC6Q'><center id='ApC6Q'></center></pre></bdo></b><th id='ApC6Q'></th></span></q></dt></tr></i><div id='ApC6Q'><tfoot id='ApC6Q'></tfoot><dl id='ApC6Q'><fieldset id='ApC6Q'></fieldset></dl></div>
              2. 本文介绍了JPA 自动 BigDecimal 转换的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着跟版网的小编来一起学习吧!

                问题描述

                我们正在使用 MyEclipse 生成我们的 jpa 访问层.之后我们有了生成的模型和数据层访问服务.我们遇到了一些具有定义精度的字段的问题.

                We are generating our jpa access layers with MyEclipse. Afterwards we have the generated models and data layer access services. We ran into some problems for some fields with a defined precision.

                实体:

                @Entity
                public class TestEntity{
                   @Column(name="DECTEST", scale = 3, precision = 13)
                   BigDecimal decTest;
                
                }
                

                现在我们创建一个 bean 并尝试保存它:

                Now we create a bean and try to save it:

                TestEntity te = new TestEntity();
                te.setDecTest(new BigDecimal(1.2));
                
                TestEntityService.save(te);
                

                我们收到以下错误:原因:com.ibm.db2.jcc.c.SqlException: [ibm][db2][jcc][t4][1037][11190] BigDecimal 转换期间发生异常.详见附件 Throwable.

                We get the following error: Caused by: com.ibm.db2.jcc.c.SqlException: [ibm][db2][jcc][t4][1037][11190] Exception occurred during BigDecimal conversion. See attached Throwable for details.

                Caused by: com.ibm.db2.jcc.a.a: [ibm][db2][jcc][converters][608][10994] Overflow occurred during numeric data type conversion of "1.1999999999999999555910790149937383830547332763671875".
                at com.ibm.db2.jcc.a.e.a(e.java:61)
                at com.ibm.db2.jcc.b.jb.a(jb.java:1772)
                ... 73 more
                

                问题似乎是我们的 BigDecimals 规模高于数据库中的规模.

                The problem seems to be that our BigDecimals scale is higher then the one from the database.

                一个可行的解决方法是:

                A working workaround is:

                TestEntity te = new TestEntity();
                
                BigDecimal decTest = new BigDecimal(1.2);
                
                te.setDecTest(decTest.setScale(3,RoundingMode.HALF_UP);
                
                TestEntityService.save(te);
                

                通过这种解决方法,我们手动将 BigDecimals 精度降低到数据库中的一个.

                With this workaround we reduce the BigDecimals precicsion manually to the one of the database.

                但是,如果数据模型发生变化,我们将不得不手动调整比例.有没有办法让我们的 jpa/hibernate 实现自动为我们进行转换?例如.设置属性.在创建 bean 的地方做这件事无论如何都是错误的.

                However if the data model changes we would have to adjust the scale there manually. Is there a way to get our jpa / hibernate implementation to do that conversion for us automatically? E.g. with setting a property. Doing it at the spot where one is creating the bean would be the wrong spot to do it anyways.

                推荐答案

                您可以使用自定义用户类型,也可以像这样简单地实现属性的 setter:

                You could use a custom user type, or you could simply implement the setter of the property like this:

                public void setDecTest(BigDecimal decTest) {
                    this.decTest = decTest.setScale(3, RoundingMode.HALF_UP));
                }
                

                因此,这种舍入将被封装在实体中.

                This rounding would thus be encapsulated in the entity.

                请注意,使用 double 来初始化 BigDecimal 有点奇怪.如果您希望将 1.2 存储在 BigDecimal 中,请使用 new BigDecimal("1.2"),您将不会使用 1.19999999999999999555910790149937383830547332763671875 初始化 BigDecimal代码>.

                Note that using a double to initialize a BigDecimal is a bit strange. If you want 1.2 to be stored in the BigDecimal, use new BigDecimal("1.2"), and you won't have a BigDecimal initialized with 1.1999999999999999555910790149937383830547332763671875.

                这篇关于JPA 自动 BigDecimal 转换的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!

                上一篇:DB2 java 存储过程调用返回错误 SQLCODE=-440, SQLSTATE=42884 下一篇:更新 DB2 for iSeries 表时出错 SQL7008

                相关文章

                <tfoot id='LdTNZ'></tfoot>

                    <small id='LdTNZ'></small><noframes id='LdTNZ'>

                      <bdo id='LdTNZ'></bdo><ul id='LdTNZ'></ul>
                  1. <legend id='LdTNZ'><style id='LdTNZ'><dir id='LdTNZ'><q id='LdTNZ'></q></dir></style></legend>
                    <i id='LdTNZ'><tr id='LdTNZ'><dt id='LdTNZ'><q id='LdTNZ'><span id='LdTNZ'><b id='LdTNZ'><form id='LdTNZ'><ins id='LdTNZ'></ins><ul id='LdTNZ'></ul><sub id='LdTNZ'></sub></form><legend id='LdTNZ'></legend><bdo id='LdTNZ'><pre id='LdTNZ'><center id='LdTNZ'></center></pre></bdo></b><th id='LdTNZ'></th></span></q></dt></tr></i><div id='LdTNZ'><tfoot id='LdTNZ'></tfoot><dl id='LdTNZ'><fieldset id='LdTNZ'></fieldset></dl></div>