[kkantola]

Hello all,
I am new to the forums, just joined today. What brings me here are my new adventures in learning hibernate, HQL, and Oracle at the same time.
I have sucessfully written my first HQL but am curious about comparing dates. If I say as part of my query

where myDate >= sysdate

will this return rows where the data in column myDate has a date that occurs at any time during "today" ? For example, if there are three rows in the table, and all of the myDate value's are dates that are at various times during today, 8AM, 10AM, 5PM, will that date compare return all three rows ? Does the time portion of sysdate matter?

Thank you!
Kim

[kkantola]

My coworker just helped me to find the problem.

Turns out I am using a tool called "Oracle SQL Developer" which I used to manually set the date to make a row that would be returned by my query. I was not aware that this tool did not change the actual date in the table, I guess it just makes a "working" version for the time I am using the tool. I am still confused by this but I guess my HQL was fine, and there really was not a proper row in the database for it to return.

[jwenting]

SQL Developer (like all such tools, I use a commercial alternative instead that's more powerful) will not do anything.
You issue SQL commands through it, which get executed on the database.

Unless and until you execute a commit command however, all changes are exclusive to your own session and don't affect anyone else.
So when you closed SQL Developer your update was gone, permanently. No other client ever got to see it.

[kkantola]

Thank you jwenting, I had to learn this the hard way! I was used to using a gui called SQLYog to attach to a mysql database, the updates were automatically commited there, so I am not accustomed to using the commit command.

Now I will not forget!

[jwenting]

mySQL until quite recently didn't operate transactional so there was no need to commit (essentially it had autocommit with no option to turn it off).