I have the following .hbm.xml file ( part of it ):

<property name="classCode" column="classCode" type="string" length="250" not-null="true" unique="false"/>

<property name="companyCode" column="companyCode" type="string" length="250" not-null="true" unique="false"/>

<property name="fundCode" column="fundCode" type="string" length="250" not-null="true" unique="false"/>

<property name="fundSponsor" column="fundSponsor" type="string" length="250" not-null="true" unique="false"/>

And I have this query to lookup in the database, and this code to check
up the database for this object :

sql = "SELECT i.companyCode, i.fundSponsor FROM abpro.beans.Funds2 i WHERE i.fundCode = 'B91A' AND i.classCode = 'A'";

hql = session.createQuery(sql);
results = hql.scroll();

I can get out the types of the properties with :

results.getType(0).getName());
results.getType(1).getName());

BUT HOW DO I GET THE VALUES OF THE PROPERTIES ?

In this case :

companyCode should be ASEA //according to value in the database
fundSponsor should be NONE //according to value in the database

Thanks in advance.

where i is the number of the column (from 0)

Thanks, I thought results.get(int i ) would return the i:th row in the "resultSet". Anyway, when I am using, e.g results.get(1) I get the
following Exception :

net.sf.hibernate.util.JDBCExceptionReporter - SQLException occurred
java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0EM: End of data.

I also get this Exception when trying to do

Object obj [ ] = results.get( );

Ideas ?

Make sure that you have a valid row to process and haven't 'run off the end' of the resultset.

e.g.

Excellent ! Many thanks for helping me. The problem was me not using the results.first ( ).

Again, thanks for Your help.