Hasn't solve the first problem.
Here is the complete definition of the table
CREATE TABLE HTS.RSC_ALL_RETESTS
( "FELD1" NUMBER(4),
"FELD2" NUMBER(2),
"FELD3" VARCHAR(13),
"FELD4" VARCHAR(13),
"FELD5" VARCHAR(13),
"FELD6" VARCHAR(13),
"FELD7" VARCHAR(13),
"FELD8" DATE,
"FELD9" VARCHAR(20),
"FELD10" NUMBER(8),
"FELD11" VARCHAR(1),
"FELD12" NUMBER(12),
"FELD13" NUMBER(12),
"FELD14" NUMBER(12),
"FELD15" NUMBER(12),
"FELD16" NUMBER(8),
"FELD17" NUMBER(5),
"CONCENTRATION" DECIMAL(8,7)
);
Insert into HTS.RSC_ALL_RETESTS
(FELD1,FELD2,FELD3,FELD17,FELD10,FELD11,FELD13,FELD7,CONCENTRATION)
values (623,1,'3BSP20465N09',464,'s',24.61,262.32,hts.to_date('25-
MAY-11','DD-MON-RR'),0.0000008);
But this entry doesn't exists....and i don't know why
On 15 Jan., 12:38, Christoph Läubrich <[email protected]> wrote:
> Definition should be:
>
> DECIMAL(8,7) (8 digits, scale 7)
>
> Beside this, you should use getBigDecimal instead of floats which would
> result in rounding errors.
>
> Am 15.01.2012 12:35, schrieb Jochen Schreiber:
>
>
>
>
>
>
>
> > Hello everybody,
>
> > i have such values: 0.0000008 etc. They have all the same length etc.
>
> > If i insert this in the database they will not be in the database and
> > i think it is because of the wrong datatype of the field where they
> > would be inserted.
>
> > I have tested DECIMAL(8,8) and NUMBER(15,8) etc. but a half of the
> > values with the format above will not be inserted and i don't know
> > how.
>
> > Another problem is then that if i read it out with java and a
> > ResultSet (see below) i gained crazy outputs:
>
> > JavaCode:
>
> > rs = session.connection().createStatement().executeQuery(sql);
> > while (rs.next()){
> > Float bl = rs.getFloat("concentration");
> > System.out.println(bl + ": " + rs.getInt("protocol_id"));
> > }
>
> > Output:
>
> > 0.0000035000: 33
> > 2.000E-7: 132
> > 0.0000047000: 132
> > 0.0000010000: 132
> > 0.0000056000: 132
> > 0.0000013000: 431
> > 0.0000069000: 431
> > 2.000E-7: 431
> > 0.0000059000: 431
> > 9.000E-7: 8
> > 0.0000046000: 8
> > 2.000E-7: 8
> > 0.0000039000: 8
> > 2.000E-7: 339
> > 9.000E-7: 339
> > 0.0000048000: 339
> > 0.0000040000: 339
> > 0.0000010000: 352
> > 0.0000051000: 352
> > 2.000E-7: 352
> > 0.0000043000: 352
> > 0.0000010000: 58
> > 0.0000051000: 58
> > 2.000E-7: 58
> > 0.0000043000: 58
> > 0E-10: 370
> > 3.000E-7: 405
> > 0.0000015000: 405
> > 0.0000066000: 405
> > 0.0000078000: 405
> > 0.0000075000: 449
> > 0.0000089000: 450
> > 0.0000075000: 450
> > 0.0000089000: 449
> > 0.0000018000: 449
> > 3.600E-7: 450
>
> > But what is wrong? I don't see it
>
> > Greetz
>
> > Jochen Schreiber
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
