• Post Reply Bookmark Topic Watch Topic
  • New Topic

Problem with UPDATE statement in HSQLDB

 
Velika Srbija
Ranch Hand
Posts: 172
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 172
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Problem solved.

In fact, I don't know what caused the problem. After restarting the server, everything had worked correctly.
 
my overalls have superpowers - they repel people who think fashion is important. Tiny ad:
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!