Hibernate Community • View topic - HQL queries with property names

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

HQL queries with property names

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

vagif

Post subject: HQL queries with property names

Posted: Sun Dec 28, 2003 4:41 am

Newbie

Joined: Sun Dec 28, 2003 4:37 am
Posts: 2

Excuse me for dumb lamer question.
Why in HQL queries i have to provide real column names instead of property names ?
For example column name is logname while corresponding property is LoginName. Is it possible to use LoginName in queries, not logname ?

Top

michael

Post subject:

Posted: Sun Dec 28, 2003 7:44 am

Hibernate Team

Joined: Tue Sep 09, 2003 2:10 pm
Posts: 3246
Location: Passau, Germany

I dont really get what you mean. Of course you use propertys in a HQL query, if you have a mapped class like this:

Code:

public class Foo {
        public String getBar() {...}
}

You can of course do a HQL query like

Code:

FROM Foo f WHERE f.bar = "whatever"

even if your bar property is mapped to any_table_column

Top

vagif

Post subject:

Posted: Sun Dec 28, 2003 2:05 pm

Newbie

Joined: Sun Dec 28, 2003 4:37 am
Posts: 2

Thank you. It works. My problem was that i did not use object alias. i.e. LoginName = :login instead of w.LoginName = :login

It looks like if you do not provide alias with property names, hibernate works directly with table columns.

Top

Page 1 of 1

[ 3 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum