sql script generation

hiberNateUser1_2_3 · **Joined:** Wed Jun 18, 2008 9:07 am **Posts:** 6

The show_sql shows the sql statements but doesn't show the Create Table statements (the table definitions) on creation??
is there any way to do that in hibernate?
Generate the sql script for tables creation ?and if this available can i do it - generate the sql creation table statements - to a file?

hiberNateUser1_2_3 · **Joined:** Wed Jun 18, 2008 9:07 am **Posts:** 6

plz it is argent ...

Cameron McKenzie · **Posted:** Tue Jul 22, 2008 10:00 am

Use the Hibernate SchemaExport class. It will create scripts like this:

Code:

drop table if exists User
create table User 
(id integer not null auto_increment, 
password varchar(255), 
primary key (id))

It's easy to use if you have a Configuration object already configured, and you can control it programatically. Here's a tutorial I put together on verifying your Hibernate3 configuration with the SchemaExport:

http://www.hiberbook.com/HiberBookWeb/learn.jsp?tutorial=02validatingthehibernateenvironment

Code:

  public static void main(String args[]) {
    AnnotationConfiguration config = 
                 new AnnotationConfiguration();
    config.addAnnotatedClass(User.class);
    config.configure();
    new SchemaExport(config).create(true, true);
  }

Here's the Hibernate tutorial link from which this code originates. Check it out!

[url]
http://www.hiberbook.com/HiberBookWeb/learn.jsp?tutorial=02validatingthehibernateenvironment[/url]

hiberNateUser1_2_3 · **Joined:** Wed Jun 18, 2008 9:07 am **Posts:** 6

Thaaaaaaaaaaaaaanks alot
this is really helped

live216 · **Joined:** Thu Mar 17, 2005 2:06 pm **Posts:** 12

Yes, you can have the sql statements put into a file, as well as hbm files. There are many tools, like the one listed above. I like http://www.javatosql.com because it analyzes your Java objects and creates everything from that. You don't need to write additional code to get the sql or schema.

hiberNateUser1_2_3 · **Joined:** Wed Jun 18, 2008 9:07 am **Posts:** 6

hi Mr.Cameron McKenzie
I noticed that i can generate the sql script using:
AnnotationConfiguration config =
new AnnotationConfiguration();
config.configure();
new SchemaExport(config).setOutputFile("output").create(true,false);

i don't have to add annotations to my classes and i don't have to use
config.addAnnotatedClass(user.class);

Can I know plz what are the uses of these annotations ??and the use of using
config.addAnnotatedClass(user.class);