Nothing. All works. And all values are in the right field but only the concentration field is 0
On 15 Jan., 12:58, Christoph Läubrich <[email protected]> wrote: > What is the respone to your query from the DB server? > > Am 15.01.2012 12:55, schrieb Jochen Schreiber: > > > > > > > > > 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.
