Hello Experts,

Thanks for Reading and Solving this Problem.

My question is:
for eg. get all the records from single Table:

hibernate query is : from <table name>

that's fine.

How can I connect two tables and get the results. Pls give me some idea.

Thanks

Hi,

read this,

http://www.hibernate.org/hib_docs/v3/re ... rycriteria

List cats = sess.createCriteria(Cat.class)
.createAlias("kittens", "kt")
.createAlias("mate", "mt")
.add( Restrictions.eqProperty("kt.name", "mt.name") )
.list();

To do the same thing using a query instead of Criteria, useOf course, there must be a relationship called RelatedEntity in your mapping file (relationshsip = any of one-to-one, one-to-many, many-to-one, many-to-many, set, map, list, bag, idbag.. and probably a few others that I've forgotten).

If you want to join two tables that aren't related in mapping (e.g. their mappings include ids, not entities) you could use SQL-like syntax:

for eg. I have a two table.

1. DEPTS
2. EMPLOYEE

BOTH FILES LOOK LIKE
**********************************************************
DEPTS.HBM.XML
**********************************************************
<class name="Depts" table="DEPTS">
<id name="deptno" column="DEPTNO" type="short">
<generator class="assigned"/>
</id>

<property name="deptname" column="DEPTNAME" type="string" />
<property name="location" column="LOCATION" type="string" />

<set name="employeeSet" inverse="true">
<key column="DEPTNO"/>
<one-to-many class="Employee"/>
</set>
</class>

**********************************************************
EMPLOYEE.HBM.XML
**********************************************************
<class name="Employee" table="EMPLOYEE">
<id name="empno" column="EMPNO" type="short">
<generator class="assigned"/>
</id>

<property name="empname" column="EMPNAME" type="string" />
<property name="salary" column="SALARY" type="float" />

<many-to-one name="depts" column="DEPTNO" class="Depts" />
</class>
**********************************************************

I am using oracle 9i
for ordinary query

select * from employee e, depts d where d.deptno=e.deptno is working.
but how to write in Hibernate?

Pls reply this. Thanks

This selects all Employees, along with their departments. There are many ways to do this in Hiberante.
This selects all departments. When you access the employeeSet in each Dept object, the relevant employees will be loaded.
This returns a list/iterator of Object[2]s: the Object[1] will be an Employee, and Object[0] will be the Dept that the Employee is in. This is a little over the top, because the employeeSet in each Dept will still fetch Employees, but it does make certain loops a little more readable.This selects all employees. Employee.getDepts() will return the Dept that the employee is in.

Hi,

StringBuffer query = new StringBuffer(" from Employee as E,Depts as D Where D.deptno=E.depts");
String strQuery = query.toString();
Query q = session.createQuery( strQuery );
System.out.println(q.toString());
List students = q.list();

The above query is working fine. i got a correct list.size();

But how to get all the fields of two tables.

i wrote like this

Iterator itrStud = students.iterator();
for( int index = 0 ; itrStud.hasNext() ; index++){
Object s1 = (Object) itrStud.next();
System.out.println("values :"+s1);
}

but i got values like

values: [Ljava.lang.Object;@1a116c9
values: from(depts)[Ljava.lang.Object;@1d1e730

How can i get all this fields?

Thanks

To quote my earlier post:

Though I wrote my query the other way around, so for the way you wrote your query, the employee will be Object[0] and the dept will be Obect[1].

please tell me clearly, Could u send me how to get those two object in hibernate.

please tell me clearly, Could u send me how to get those two object in hibernate.

This is the code you wrote:Change it to this: