-----Ursprüngliche Nachricht-----
Von: Kamil
Gesendet am: Montag, 23. April 2001 17:52
An: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Betreff: problems with SQL UPDATE
I have a problems with SQL UPDATE statements within an Java programm which
establish a connection to a Mysql Server via JDBC (org.gjt.mm.mysql.Driver)
.
The table and a copy of log file, which was created by safe_mysql ( mysqld
) are listed below. In this case, the value of the column "foerdermenge"
and "k2omenge" should be near by zero ,
but it does not. The both values are increasing instead. If i execute this
SQL commands over mysql client interface, they create the proper value.
What can be the reason, do you have any idea
>>>> This is the Table <<<<<<<<
CREATE TABLE kali1.bunkerwerte (
bunkerwertnr INT UNSIGNED NOT NULL
AUTO_INCREMENT
PRIMARY KEY,
bunkernr INT UNSIGNED NOT NULL,
zeitstempel INT UNSIGNED NOT NULL,
foerdermenge DOUBLE(16,5) NOT NULL,
k2omenge DOUBLE(16,5) NOT NULL,
kalibriert TINYINT UNSIGNED NOT NULL DEFAULT 0,
INDEX (bunkernr, zeitstempel)
);
>>>>> This are the SQL questions, which are produced by my Java
application <<<<<<
2 Query UPDATE bunkerwerte SET zeitstempel = 988031400,
foerdermenge = foerdermenge + 20.64156745, k2omenge = k2omenge +
2.93739511, kalibriert = 0 WHERE bunkernr = 17
2 Query UPDATE bunkerwerte SET zeitstempel = 988031340,
foerdermenge = foerdermenge + 17.20130621, k2omenge = k2omenge +
2.44782926, kalibriert = 0 WHERE bunkernr = 17
2 Query UPDATE bunkerwerte SET zeitstempel = 988031280,
foerdermenge = foerdermenge + 13.76104496, k2omenge = k2omenge + 1.9582
6341, kalibriert = 0 WHERE bunkernr = 17
2 Query UPDATE bunkerwerte SET zeitstempel = 988031400,
foerdermenge = foerdermenge + -20.64156745, k2omenge = k2omenge +
-2.93739511, kalibriert = 0 WHERE bunkernr = 17
2 Query UPDATE bunkerwerte SET zeitstempel = 988031340,
foerdermenge = foerdermenge + -13.76104496, k2omenge = k2omenge +
-1.95826341, kalibriert = 0 WHERE bunkernr = 17
2 Query UPDATE bunkerwerte SET zeitstempel = 988031280,
foerdermenge = foerdermenge + -6.88052248, k2omenge = k2omenge +
-0.9791317, kalibriert = 0 WHERE bunkernr = 17
2 Query UPDATE bunkerwerte SET zeitstempel = 988031460,
foerdermenge = foerdermenge + 20.64156745, k2omenge = k2omenge +
2.93739511, kalibriert = 0 WHERE bunkernr = 17
2 Query UPDATE bunkerwerte SET zeitstempel = 988031460,
foerdermenge = foerdermenge + -20.64156745, k2omenge = k2omenge +
-2.93739511, kalibriert = 0 WHERE bunkernr = 17
2 Query UPDATE bunkerwerte SET zeitstempel = 988031520,
foerdermenge = foerdermenge + 20.64156745, k2omenge = k2omenge +
2.93739511, kalibriert = 0 WHERE bunkernr = 17
2 Query UPDATE bunkerwerte SET zeitstempel = 988031520,
foerdermenge = foerdermenge + -20.64156745, k2omenge = k2omenge +
-2.93739511, kalibriert = 0 WHERE bunkernr = 17
2 Query UPDATE bunkerwerte SET zeitstempel = 988031580,
foerdermenge = foerdermenge + 20.64156745, k2omenge = k2omenge +
2.93739511, kalibriert = 0 WHERE bunkernr = 17
2 Query UPDATE bunkerwerte SET zeitstempel = 988031580,
foerdermenge = foerdermenge + -20.64156745, k2omenge = k2omenge +
-2.93739511, kalibriert = 0 WHERE bunkernr = 17
2 Query UPDATE bunkerwerte SET zeitstempel = 988031640,
foerdermenge = foerdermenge + 20.64156745, k2omenge = k2omenge +
2.93739511, kalibriert = 0 WHERE bunkernr = 17
2 Query UPDATE bunkerwerte SET zeitstempel = 988031640,
foerdermenge = foerdermenge + -20.64156745, k2omenge = k2omenge +
-2.93739511, kalibriert = 0 WHERE bunkernr = 17
2 Query UPDATE bunkerwerte SET zeitstempel = 988031700,
foerdermenge = foerdermenge + 20.64156745, k2omenge = k2omenge +
2.93739511, kalibriert = 0 WHERE bunkernr = 17
2 Query UPDATE bunkerwerte SET zeitstempel = 988031700,
foerdermenge = foerdermenge + -20.64156745, k2omenge = k2omenge +
-2.93739511, kalibriert = 0 WHERE bunkernr = 17
2 Query UPDATE bunkerwerte SET zeitstempel = 988031760,
foerdermenge = foerdermenge + 20.64156745, k2omenge = k2omenge +
2.93739511, kalibriert = 0 WHERE bunkernr = 17
2 Query UPDATE bunkerwerte SET zeitstempel = 988031760,
foerdermenge = foerdermenge + -20.64156745, k2omenge = k2omenge +
-2.93739511, kalibriert = 0 WHERE bunkernr = 17
2 Query UPDATE bunkerwerte SET zeitstempel = 988031820,
foerdermenge = foerdermenge + 20.64156745, k2omenge = k2omenge +
2.93739511, kalibriert = 0 WHERE bunkernr = 17
2 Query UPDATE bunkerwerte SET zeitstempel = 988031820,
foerdermenge = foerdermenge + -20.64156745, k2omenge = k2omenge +
-2.93739511, kalibriert = 0 WHERE bunkernr = 17
2 Query UPDATE bunkerwerte SET zeitstempel = 988031880,
foerdermenge = foerdermenge + 20.64156745, k2omenge = k2omenge +
2.93739511, kalibriert = 0 WHERE bunkernr = 17
2 Query UPDATE bunkerwerte SET zeitstempel = 988031880,
foerdermenge = foerdermenge + -20.64156745, k2omenge = k2omenge +
-2.93739511, kalibriert = 0 WHERE bunkernr = 17
2 Query UPDATE bunkerwerte SET zeitstempel = 988031940,
foerdermenge = foerdermenge + 20.64156745, k2omenge = k2omenge +
2.93739511, kalibriert = 0 WHERE bunkernr = 17
2 Query UPDATE bunkerwerte SET zeitstempel = 988031940,
foerdermenge = foerdermenge + -20.64156745, k2omenge = k2omenge +
-2.93739511, kalibriert = 0 WHERE bunkernr = 17
2 Query UPDATE bunkerwerte SET zeitstempel = 988032000,
foerdermenge = foerdermenge + 20.64156745, k2omenge = k2omenge +
2.93739511, kalibriert = 0 WHERE bunkernr = 17
2 Query UPDATE bunkerwerte SET zeitstempel = 988032000,
foerdermenge = foerdermenge + -20.64156745, k2omenge = k2omenge +
-2.93739511, kalibriert = 0 WHERE bunkernr = 17
2 Query UPDATE bunkerwerte SET zeitstempel = 988032060,
foerdermenge = foerdermenge + 20.64156745, k2omenge = k2omenge +
2.93739511, kalibriert = 0 WHERE bunkernr = 17
2 Query UPDATE bunkerwerte SET zeitstempel = 988032060,
foerdermenge = foerdermenge + -20.64156745, k2omenge = k2omenge +
-2.93739511, kalibriert = 0 WHERE bunkernr = 17
2 Query UPDATE bunkerwerte SET zeitstempel = 988032120,
foerdermenge = foerdermenge + 20.64156745, k2omenge = k2omenge +
2.93739511, kalibriert = 0 WHERE bunkernr = 17
2 Query UPDATE bunkerwerte SET zeitstempel = 988032120,
foerdermenge = foerdermenge + -20.64156745, k2omenge = k2omenge +
-2.93739511, kalibriert = 0 WHERE bunkernr = 17
2 Query UPDATE bunkerwerte SET zeitstempel = 988032180,
foerdermenge = foerdermenge + 20.64156745, k2omenge = k2omenge +
2.93739511, kalibriert = 0 WHERE bunkernr = 17
2 Query UPDATE bunkerwerte SET zeitstempel = 988032180,
foerdermenge = foerdermenge + -20.64156745, k2omenge = k2omenge +
-2.93739511, kalibriert = 0 WHERE bunkernr = 17
2 Query UPDATE bunkerwerte SET zeitstempel = 988032240,
foerdermenge = foerdermenge + 20.64156745, k2omenge = k2omenge +
2.93739511, kalibriert = 0 WHERE bunkernr = 17
2 Query UPDATE bunkerwerte SET zeitstempel = 988032240,
foerdermenge = foerdermenge + -20.64156745, k2omenge = k2omenge +
-2.93739511, kalibriert = 0 WHERE bunkernr = 17
2 Query UPDATE bunkerwerte SET zeitstempel = 988032300,
foerdermenge = foerdermenge + 20.64156745, k2omenge = k2omenge +
2.93739511, kalibriert = 0 WHERE bunkernr = 17
2 Query UPDATE bunkerwerte SET zeitstempel = 988032300,
foerdermenge = foerdermenge + -20.64156745, k2omenge = k2omenge +
-2.93739511, kalibriert = 0 WHERE bunkernr = 17
2 Query UPDATE bunkerwerte SET zeitstempel = 988032360,
foerdermenge = foerdermenge + 20.64156745, k2omenge = k2omenge +
2.93739511, kalibriert = 0 WHERE bunkernr = 17
2 Query UPDATE bunkerwerte SET zeitstempel = 988032360,
foerdermenge = foerdermenge + -20.64156745, k2omenge = k2omenge +
-2.93739511, kalibriert = 0 WHERE bunkernr = 17
2 Query UPDATE bunkerwerte SET zeitstempel = 988032420,
foerdermenge = foerdermenge + 20.64156745, k2omenge = k2omenge +
2.93739511, kalibriert = 0 WHERE bunkernr = 17
2 Query UPDATE bunkerwerte SET zeitstempel = 988032420,
foerdermenge = foerdermenge + -20.64156745, k2omenge = k2omenge +
-2.93739511, kalibriert = 0 WHERE bunkernr = 17
2 Query UPDATE bunkerwerte SET zeitstempel = 988032480,
foerdermenge = foerdermenge + 20.64156745, k2omenge = k2omenge +
2.93739511, kalibriert = 0 WHERE bunkernr = 17
2 Query UPDATE bunkerwerte SET zeitstempel = 988032480,
foerdermenge = foerdermenge + -20.64156745, k2omenge = k2omenge +
-2.93739511, kalibriert = 0 WHERE bunkernr = 17
2 Query UPDATE bunkerwerte SET zeitstempel = 988032540,
foerdermenge = foerdermenge + 20.64156745, k2omenge = k2omenge +
2.93739511, kalibriert = 0 WHERE bunkernr = 17
2 Query UPDATE bunkerwerte SET zeitstempel = 988032540,
foerdermenge = foerdermenge + -20.64156745, k2omenge = k2omenge +
-2.93739511, kalibriert = 0 WHERE bunkernr = 17
2 Query UPDATE bunkerwerte SET zeitstempel = 988032600,
foerdermenge = foerdermenge + 20.64156745, k2omenge = k2omenge +
2.93739511, kalibriert = 0 WHERE bunkernr = 17
2 Query UPDATE bunkerwerte SET zeitstempel = 988032600,
foerdermenge = foerdermenge + -20.64156745, k2omenge = k2omenge +
-2.93739511, kalibriert = 0 WHERE bunkernr = 17
2 Query UPDATE bunkerwerte SET zeitstempel = 988032660,
foerdermenge = foerdermenge + 20.64156745, k2omenge = k2omenge +
2.93739511, kalibriert = 0 WHERE bunkernr = 17
2 Query UPDATE bunkerwerte SET zeitstempel = 988032660,
foerdermenge = foerdermenge + -20.64156745, k2omenge = k2omenge +
-2.93739511, kalibriert = 0 WHERE bunkernr = 17
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
