Hi all,
I have DB View. and using hibernate to retrieve some data from view.
I am sending simple query like
Code:
"from ViewContent where blessUid=1"
And it is returning me only 1 same row * count(*).. e.g. like if there are 35 rows then I am getting first row 35 times... is fine or i am missing something???
and exe. same query (sql logged by hibernate) on mysql returns all fine results.
HBM
Code:
<hibernate-mapping package="com.deamon.model">
<class name="ViewContent" table="view_content" mutable="false">
<cache usage="read-only"/>
<!--<synchronize table="SnsUser"/>
<synchronize table="Pariticipant"/>
<synchronize table="Interaction"/>
<synchronize table="Content"/>
--><id name="snsUid" type="java.lang.Integer">
<column name="sns_uid" />
<generator class="identity" />
</id>
<property name="blessUid" type="java.lang.Integer">
<column name="bless_uid" />
</property>...
thank you.