I have two table Dbr, Grouopdata. I have there mapping class and mapping file. Dbr table has DbrId as primary key which is a foreign Key in Groupdata.Mapping files does not contain the their link info

Now i am trying the following code :

Dim aliasCls As String() = {"l", "e"}
Dim clazz As System.Type() = {GetType(Databaseobj.Dbr), GetType(Databaseobj.Groupdata)
mySelectQuery = "select * from Dbr inner join Groupdata on Groupdata.Groupid =Dbr.GroupID" 'where Groupdata.groupid=" + Convert.ToString(16)
Dim Qry As IList = nhibersession2.CreateSQLQuery(mySelectQuery, aliasCls, clazz).List()


this giving the following error :
System.IndexOutOfRangeException: DbrId0_


what to do ?

Gaurav

Read chapter 9.3.6 in Hibernate docs:


Or better, rewrite the query in HQL
BTW, I also recommend you to use parameterized queries.

Cheers,
Radu