Archive for February, 2005

Rosalia Tamer Helmy Salama

Posted February 11, 2005 * Comments(3)


I’ve always wanted to post some personal stuff on this blog, so, as a very good start, and a wonderful addition to the blog, introducing Rosalia, my wonderful daughter.
rosalia-tamer-helmy-salama.jpg
Rosy was born on 31 December 2002 at 11:59 AM in Boston, Massachusetts, USA, at this hospital.
On that night, we went to see that movie, after a walk in this mall, and a snack at that outlet.It’s fun to see the world through her learning and playful eyes, I’ll keep readers posted with her info.

JRoller W.Bloggar Comments Problem

Posted February 11, 2005 * Comments(0)

It seems that when posting with w.bloggar (version 3.x at least) all my comments settings were adjusted to “Allow comments for 7 day” on the postings.
When checking with the JRoller editor, comments setting were defaulted to “allow comments for unlimited days”

Had a quick look on w.bloggar's forums, but was not mentioned.

Any suggestions?

DB2/400 and Hibernate Order By

Posted February 11, 2005 * Comments(0)

I Hate DB2/400 (iSeries) or at least V5R1

SEVERE: SQLException occurred
java.sql.SQLException: [SQL0208] ORDER BY column WRID or expression not in result table.

Discovered that was because Hibernate “auto generated” alias for any column in its select clause is not used in the ORDER BY clause (real column name is used instead).
A DB2/400 deficiency as many other databases understands the original column name in the Order By part.
As a workaround I used an integer in the Order By clause (ORDER BY 1) and it worked with HQL (from <table> order by 1 asc) but not in the criteria API (Order.asc(”1″));

The problem is seemingly resolved in DB2/400 V5R2 and I'm on V5R1.

I'll add this to my list of DB2/400 hate reasons (No DB autogenerated IDs, no recursive queries, no resultset offest)… and the list goes on.

Hibernate Forum (DB2/400 Order By) …

It also seems that not many DB2 users are using Hibernate (scarce postings and forums). I hope I made the right decision by choosing Hibernate to go with this DB.