Hibernate Preparinginsurancedatabase

How can i select the data using hql from the table contains multiple primary keys

Posted by nagendra on Wednesday, 10.15.08 @ 10:24am | #81090

can i use sun.jdbc.odbc.JdbcOdbcDriver for hibernate

Posted by tapan on Friday, 12.14.07 @ 13:48pm | #42227

hi,

i want to know where the most of collection interface and reflection-api is used and plz send me some examples for collection and reflection-api interface along with materilas

Posted by allabakash on Wednesday, 10.17.07 @ 12:00pm | #34259

hi,

one thing i want to know that most of the hibernate applications run in my eclipse i want to run my application in tomcat or weblogic will u tell me how hiberante applications runs in tomcat or weblogic plz give me a small example for this

Posted by sreenivaasarao.s on Wednesday, 10.17.07 @ 11:57am | #34258

iam new to hibernate techonolgy one thing to know that

in hibernate if we want to map the mapping between two tables then how to configure data(i mean where to map)will u plz give one with example

Posted by sreenivaasarao.s on Wednesday, 10.17.07 @ 11:50am | #34257

Dear i m new in hibernate technology. now i am trying to delete data from my table but it is not working. i tried to delete by the following example test

package roseindia.tutorial.hibernate;

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;

public class DeleteHQLExample {
/**
* @author vinod Kumar
*
* http://www.roseindia.net Hibernate Criteria Query Example
*
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
Session sess = null;
try {
SessionFactory fact = new Configuration().configure().buildSessionFactory();
sess = fact.openSession();
String hql = "delete from Insurance insurance where id = 1";
Query query = sess.createQuery(hql);
int row = query.executeUpate();
if (row == 0){
System.out.println("Doesn't deleted any row!");
}
else{
System.out.println("Deleted Row: " + row);
}
sess.close();
}
catch(Exception e){
System.out.println(e.getMessage());
}
}
}


please help me hoe can i delete data in hibernate

Posted by akter on Thursday, 10.4.07 @ 11:00am | #31348

I am new for the Hibernate Technology.
I have a 2 tables called 'bank' and 'branch' one to many relationship.
When I delete a bank details then It want to check related branches.

So, how can I implement this delete function

pls help any one

Posted by nayeem on Friday, 09.28.07 @ 15:20pm | #30146

"SELECT sum(sessioncount) from sta_attendancedetail sad,sta_attendancemaster sam where staffid=? and reason='CASUAL LEAVE' and year(absentdt)=year(?)and sad.attid=sam.attid"

How i convert SQL to HQL?

plz help me.....

thanks
Mohan

Posted by mohan on Wednesday, 06.27.07 @ 17:32pm | #20281

its a gr8 site....... whenever i need help i turn to roseindia.........

Posted by Som on Tuesday, 05.22.07 @ 10:50am | #16977

I have tables like
=>Country_Master
Country_Id
Name
=>State_Master
State_Id
State_Name
Country_Id
=>Town_Master
Town_Id
Town_Name
State_Id

Like this many hierarchy.

I want to know how i will get the selected fields from table.
SQL: select Name,State_Name,Town_Name from Country_Master C,State_Master S, Town_Master T where S.Country_Id=C.Country_Id and T.State_Id=S.State_Id

I want to know how i will get information.

Posted by Prabhat Kumar Krishna on Friday, 05.4.07 @ 13:06pm | #15260

hi
i have one doubt.i want to retrive data from table
in single value.like in sql i write select max(id) from table; for this what query i write in hql

Posted by madhuchilipi on Wednesday, 03.7.07 @ 11:58am | #10945

how to retrive two tables into a single table using hql & what is the query of join two tables.

Posted by NITIN KUMAR UPADHYAY on Wednesday, 01.31.07 @ 12:20pm | #4860

Its a good site for have an overview about anything you want to learn.
But it need to improved alot in the sense of alignment of the content we dont understand which are the tutorials and which are the advertisement.
even explain bit deep...

Posted by deepak on Wednesday, 12.20.06 @ 15:27pm | #1332