lukefitzwolfgang / icatproject

Automatically exported from code.google.com/p/icatproject
0 stars 0 forks source link

Loss of precision with Oracle #119

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
As explained in http://docs.oracle.com/cd/E19159-01/819-3672/gbxjk/index.html 
the JPA mapping to Oracle maps float and double onto NUMBER(19,4). This gives 
only 4 digits after the decimal point - which is very bad if you want to store 
small numbers! MySQL does it sensibly and maps double to double.

Ideally it would map simply to a NUMBER - which I have not been able to do. 
However with an appropriate annotation I can make it map onto NUMBER(38, 127) 
which is equivalent to simply NUMBER. This will be addressed in 4.3.0 as it 
will require an update script to change existing schemas.

Original issue reported on code.google.com by dr.s.m.f...@gmail.com on 8 May 2013 at 4:05

GoogleCodeExporter commented 9 years ago
Code changes made but not yet checked in.

Original comment by dr.s.m.f...@gmail.com on 16 May 2013 at 10:59

GoogleCodeExporter commented 9 years ago

Original comment by dr.s.m.f...@gmail.com on 22 Aug 2013 at 1:44

GoogleCodeExporter commented 9 years ago

Original comment by dr.s.m.f...@gmail.com on 25 Oct 2013 at 10:05