This week's book giveaway is in the Agile and Other Processes forum.
We're giving away four copies of The Little Book of Impediments (e-book only) and have Tom Perry on-line!
See this thread for details.
Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • 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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic