java - 10-digits BigDecimal cannot be saved in NUMBER(10, 2) column -


in oracle 12 database, 1 of column defined number(10,2). goal store numbers one: 12345678.12. actually, can store such number thank oracle sql developer, format matching.

through hibernate-java app, when update entity containing following values, works:

1.12 12.12 123.12 1234.12 12345.12 123456.12

but following, error

1234567.12 12345678.12  ora-01438: value larger specified precision allowed column

it looks number(8, 2)...

the field in @embeddable class, type bigdecimal, without field annotation:

@entity @table(...) public class classa implements serializable {      @embedded     private classb bobject; }  @embeddable public class classb implements serializable {      @embedded     private classc cobject; }  @embeddable public class classc implements serializable {      private bigdecimal myfield; }

is there other things can override column definition?

the first number in decimal type precision, second digit scale.
oracle's documentation:

you can specify precision (the total number of digits, both left , right of decimal point) , scale (the number of digits of fractional component).

if have 10 digits before fraction, need decimal(12,2).

the error see comes oracle, not hibernate, doubt changing entity configuration solve issue.


Comments

Post a Comment

Popular posts from this blog

'hasOwnProperty' in javascript -

i use obj.hasownproperty judge whether object has property, when replaced obj[prop] !== undefined , not normal implementation, ask, why behind method can not use it? object.hasownproperty(prop); object[prop] !== undefined; obj[prop] !== undefined wrong 2 reasons: you can explicitly set property undefined , obj[prop] = undefined; . obj.hasownproperty(prop) return true in case. obj[prop] follow prototype chain, return property that's inherited. obj.hasownproperty(prop) returns true if property exists directly in object, returns false inherited properties.
Read more

How to understand 2 main() functions after using uftrace to profile the C++ program? -

i trying uftrace profile following simple c++ program: #include <iostream> class { public: a() {std::cout << "a created" << std::endl;} ~a() {std::cout << "a destroyed" << std::endl;} }; int main() { a; return 0; } the profile result this: # uftrace a.out created destroyed # duration tid function 2.026 [ 4828] | __cxa_atexit(); [ 4828] | main() { [ 4828] | __static_initialization_and_destruction_0() { 89.397 [ 4828] | std::ios_base::init::init(); 0.768 [ 4828] | __cxa_atexit(); 93.029 [ 4828] | } /* __static_initialization_and_destruction_0 */ 94.425 [ 4828] | } /* main */ [ 4828] | main() { [ 4828] | a::a() { 11.104 [ 4828] | std::operator <<(); 10.825 [ 4828] | std::basic_ostream::operator <<(); 24.514 [ 4828] | } /* a::a */ [ 4828] | a::~a() { 0.978 [ 4828] | ...
Read more

android - Unable to generate FCM token from dynamically instantiated Firebase -

our business logic requires instantiate firebase during runtime. fetch firebase credentials (app id, api key etc.) default firebase location after knowing user's public key , create firebase instance using credentials. this means there 2 firebase instances used within app: the default "index" firebase gives credentials second the actual firebase intend use point forward the second firebase initialised this: firebaseapp app = firebaseapp.initializeapp(<context>, <options>, <app_label>); our problem traditional method of retrieving fcm token using firebaseinstanceidservice , ontokenrefresh() fails since ontokenrefresh() method called first firebase instance. directly calling string token = firebaseinstanceid.getinstance(app).gettoken(); returns null never ready when called. have tried polling test if token generated @ point. no luck. how can generate fcm token reliably firebase instance instantiated during runtime? i...
Read more