Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate 3.1.2:

I am not able to receive any dat when I run the sql query "select * from MOBASEPARAMS_T"
whereas when I run this query from SQL promt, data is present.
Database is oracle 10g on linux.
Even Hibernate logs are not showing any error or exception just that final outcome is NULL.
Pls help

I have the following mapping file
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- from src -->
<hibernate-mapping>
<class name="com.hns.gem.backend.services.managedobject.mo1" table="MOBASEPARAMS_T">
<composite-id name="id" class="com.hns.gem.backend.services.managedobject.ManagedObjectIndex">
<key-property name="motype" column="motype"/>
<key-property name="moid" column="moid"/>
</composite-id>

<property name="param1">
<column name="param1" />
</property>
<property name="param2">
<column name="param2" />
</property>
<property name="param3">
<column name="param3" />
</property>
<one-to-one name="gemSNMPAgentAttributes" class="com.hns.gem.backend.services.managedobject.GEMSNMPAgentAttributes" cascade="all" lazy="false"/>
<one-to-one name="gemAttributes" class="com.hns.gem.backend.services.managedobject.GEMAttributes" cascade="all" lazy="false"/>
</class>

<class name="com.hns.gem.backend.services.managedobject.GEMAttributes" table="MOGEMPARAMS_T">
<composite-id name="id" class="com.hns.gem.backend.services.managedobject.ManagedObjectIndex">
<key-property name="motype" column="motype"/>
<key-property name="moid" column="moid"/>
</composite-id>
<property name="moOpState">
<column name="moopstate" />
</property>
<property name="moAdminState">
<column name="moadminstate" />
</property>
</class>

<class name="com.hns.gem.backend.services.managedobject.GEMSNMPAgentAttributes" table="MOGEMSNMPPARAMS_T">
<composite-id name="id" class="com.hns.gem.backend.services.managedobject.ManagedObjectIndex">
<key-property name="motype" column="motype"/>
<key-property name="moid" column="moid"/>
</composite-id>
<property name="ipaddress">
<column name="ipaddress" />
</property>
<property name="port">
<column name="port" />
</property>
<property name="readc">
<column name="readc" />
</property>
<property name="writec">
<column name="writec" />
</property>
<property name="version">
<column name="version" />
</property>
</class>
</hibernate-mapping>



Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Oracle 10g

generated SQL is select * from MOBASEPARAMS_T

Debug level Hibernate log excerpt:

Hi,

Post your Java code.

You can also us Criterai API for this.

Criteria criteria = session.createCriteria(YourClassName.class);
List list = criteria.list();

or HQL or SQL etc