| Author |
Problem with UPDATE statement in HSQLDB
|
Velika Srbija
Ranch Hand
Joined: Jan 15, 2002
Posts: 171
|
|
Hello, I have expirienced a strange behavior with the UPDATE statement in HSQLDB. When I update some record in my table, it changes my TIME and DATE columns to null despite the fact that I didn't mention them in the statement, e.g.: stmt.executeUpdate("UPDATE my_table SET age=15 WHERE user_name='malcom'"); and I get column "age" changed to "15", and also columns "time" and "date" changed to null? What is goin' on? Any idea? All other data manipulation works OK?
|
 |
Velika Srbija
Ranch Hand
Joined: Jan 15, 2002
Posts: 171
|
|
Problem solved. In fact, I don't know what caused the problem. After restarting the server, everything had worked correctly.
|
 |
 |
|
|
subject: Problem with UPDATE statement in HSQLDB
|
|
|