This week's book giveaway is in the Kotlin forum.
We're giving away four copies of Kotlin in Action and have Dmitry Jemerov & Svetlana Isakova on-line!
See this thread for details.
Win a copy of Kotlin in Action this week in the Kotlin forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Problem with UPDATE statement in HSQLDB  RSS feed

 
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
Boost this thread!