Hi!

Sorry for asking again, but nobody has answered.....

I have to select some data from a database view, which has no id column.
Is there any pattern it could be applied in this case. My mapping file contains:

<id type="java.lang.String">
<generator class="assigned"/>
</id>

I have a find class with a static method for the query:

public static List findxxx(Session session,String filterVal) throws SQLException, HibernateException
{
return session.find("from package.class where filterCol='"+filterVal+"'");
}

The query built contains reference to the id column, too, so the sql statement can not be executed( i don't want to use "select table.column...." returning Object[]).

Any suggestions?

Is that really ALL your mapping file has in it?

Does your view have nothing that makes a row unique? If it has some combination of fields they could be a composite-id.

Hope that helps. Your question is on the confusing side. :)

Jenica

If there is no PK, you should find a combination of columns which are unique, and map them as an "embedded" composite id.


P.S. The query you showed is probably incorrect. Property names should *always* be prefixed by an alias.

Thank you for your answers.

>>Is that really ALL your mapping file has in it?

No, the column mappings are there,too :).


>>If there is no PK, you should find a combination of columns which are unique, and map them as an "embedded" composite id.

I do not have desinger access to the view, so i cannot change it.

>> P.S. The query you showed is probably incorrect. Property names should *always* be prefixed by an alias.

Sorry it is my failure, I have an alias. The generated sql was absolute OK, the only problem was,that the id column was in the generated sql, too.

The documentation for "id" tag says:

"If the name attribute is missing, it is assumed that the class has no identifier property. "

That's why i thought, if one doesn't specify a name for the "id" tag, the generated sql will not contain the id column.
Do i understand it false?