This week's book giveaway is in the Agile and other Processes forum.
We're giving away four copies of The Mikado Method and have Ola Ellnestam and Daniel Brolund on-line!
See this thread for details.
The moose likes JDBC and the fly likes Problem with UPDATE statement in HSQLDB Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "Problem with UPDATE statement in HSQLDB" Watch "Problem with UPDATE statement in HSQLDB" New topic
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.
 
I agree. Here's the link: http://zeroturnaround.com/jrebel - it saves me about five hours per week
 
subject: Problem with UPDATE statement in HSQLDB
 
Similar Threads
SQL query problem with MySQL
updating rows in table error
Null date merge problem
javascript calculating between 2 dates
Mckoi database