generate DML statements dynamically in hibernate

royalrishi07 · **Joined:** Sat Oct 11, 2008 3:31 am **Posts:** 11

How to generate DML statements dynamically in hibernate?

Madan_Prabhu · **Posted:** Sat Oct 18, 2008 5:25 am

U can use Hibernate Query Language to dynamically create DML statements in hibernate..
use this following link as reference
http://www.hibernate.org/hib_docs/refer ... ryhql.html

For eg.,

Code:

Session session=HibernateSessionFactory.getSession();
Transaction txt=session.beginTransaction();
Iterator results=session.createQuery("select u.name,u.age from Users u where u.userId =:uId").setParameter("uId", Integer.parseInt(uid)).iterate();
if(results.hasNext())
{
  Object[]  e = (Object[]) results.next();
  System.out.println("Name: " +e[0].toString());
  System.out.println("Age: " +e[1].toString());
}

Like that you can dynamically create queries as you like...
Take a view the link i specified in the first pace of the post...it's very useful for studying HQL basics and ideas..

royalrishi07 · **Joined:** Sat Oct 11, 2008 3:31 am **Posts:** 11

Madan_Prabhu wrote:

U can use Hibernate Query Language to dynamically create DML statements in hibernate..
use this following link as reference
http://www.hibernate.org/hib_docs/refer ... ryhql.html

For eg.,

Code:

Session session=HibernateSessionFactory.getSession();
Transaction txt=session.beginTransaction();
Iterator results=session.createQuery("select u.name,u.age from Users u where u.userId =:uId").setParameter("uId", Integer.parseInt(uid)).iterate();
if(results.hasNext())
{
  Object[]  e = (Object[]) results.next();
  System.out.println("Name: " +e[0].toString());
  System.out.println("Age: " +e[1].toString());
}

Like that you can dynamically create queries as you like...
Take a view the link i specified in the first pace of the post...it's very useful for studying HQL basics and ideas..

Thanks for the quick reply Actually,my problem is that
i want to take backup of all data using hibernate

i m using postgreSql 8.1 as database
Geneally we take database backup using jst right click on database or schema say "Public" and then take backup. Backup is then taken in .backup file.

I want to perform the same operation but using hibernate....

Thanking you!!!!!

parmendratyagi · **Posted:** Sat Oct 18, 2008 9:02 am

You can generate Database schema by hibernate.

Download pdf document from http://www.manning.com/bauer2/chapter2.pdf and search for "
Exporting the database schema" in this document. Section 2.3 is also give some more information about this.

Hope this will help you.

royalrishi07 · **Joined:** Sat Oct 11, 2008 3:31 am **Posts:** 11

parmendratyagi wrote:

You can generate Database schema by hibernate.

Download pdf document from http://www.manning.com/bauer2/chapter2.pdf and search for "
Exporting the database schema" in this document. Section 2.3 is also give some more information about this.

Hope this will help you.

My task is:
1. To generate schema of current database(DDL script) and write to file.
2. To take backup of all data of that reside in the all tables of current database and restore it whenever I requied.

I have already Exported automatic Schema using SchemaExport class that means my part(1) is done

I m looking for solution of part(2)

I go through your specified link also but i couldnt find desired content in that pdf for solution of part(2)

Thanking You!!!