Hey

I am having problems getting a single row and setting it to a object.

I get no results with this query



The table looks like this:



moduleID is a Integer not an int

does anybody have a solution?

You're not getting back a Module from that method call. If you look at the JavaDoc APIs you'll notice that session.createQuery( String query ) returns a Query Object (I'm surprised you're not getting a ClassCastException). If you look at the Query JavaDoc you can use a few things to get a result:

.list() will return the results in a list (or an empty list if no results found)

.uniqueResult() will return a single instance (or a exception if more than one is found or null if none is found)

.iterate() will return the results as an iterator

For example:


Hope this helps,
B

____________________________________
Please rate me if you found my post useful.

Yes that was all I needed. Thank you.

I was stupid when assuming removing the .list() would only give me one result.

I will try reading the API next time :)