No data

[Ananth Ram]

Hi All,

I am a newbie to hibernate. I created a simple table as below.

TEST
Tid -- PK
ReportId
IndexId

I am able to insert data successfully. When I retrieve the same record. It does not return anything. Please look at the code below.

private void getReport() {

Session session = startSession();
List result = null;
try {
      Query hQry = null;
      String sql = "select * from TEST where ReportId = :reportId";
      hQry = session.createQuery(sql);
      hQry.setParameter("reportId", 7); // I am hard coding the value 
     result = hQry.list();
     
} catch(Exception ex) {
       // TODO

}

When I look at the List, no data is returned. Where am I wrong? Please advise on the same.

The hbm.xml file is as below

<hibernate-mapping>
	<class name="com.test.TestReportIndex" table="TEST">
		<id name="tid" column="Tid" type="int">
            <generator class="native"/>
        </id>
        <property name="reportid" type="int">
            <column name="ReportId" not-null="true" />
        </property>
        <property name="indexid" type="int">
            <column name="IndexId" not-null="true" />
        </property>
        
	</class>
</hibernate-mapping>

Thanks,
Ananth Ram

[Paul Sturrock]

After you inserted your data did you commit the transaction? Are there any test objects that exists in the database with the report id you are using?

[Charan kumar sarvepalli]

you have written SQL query (not HQL) so try to get data using session.createSQLQuery(sql);

[Paul Sturrock]

Charan kumar sarvepalli wrote:you have written SQL query (not HQL) so try to get data using session.createSQLQuery(sql);

The above statement is valid in both languages.

[Ananth Ram]

Yeah, the inserted data exists in the database.

Thanks,
Ananth Ram

[Paul Sturrock]

Then it should work. Any reason you are not logging any exception that may be thrown?

[Ananth Ram]

Thanks all,

it works...

Thanks,
Ananth Ram

[Charan kumar sarvepalli]

Ananth what makes solves your problem. can you post.

[Ananth Ram]

Hi Charan,

First the createSQLQuery in stead of SQLQuery. Thanks for pointing out.
then the next step is casting the object[] from the result List.

Let me know if you need more info.

Thanks,
Ananth Ram

[Charan kumar sarvepalli]

just to know that solved your problem or you found any other solution.