JPA - How to get any produced sql code programmatically?

Question

JPA gurus, let say I have the following entity :

@Entity
class MyEntity {
    @Id
    private Long id;

    // setters and getters here
}

through JPA on an Oracle database something similar would be generated :

CREATE TABLE MyEntity {
    -- table definition generated by JPA provider goes here
}

How can I get the code generated by the JPA provider ?

If it's not possible to get the sql code in a standard way defined by JPA, how can I achieve this with Hibernate 3.6.8.Final or greater ?

Note, that it's not the `JPA` duty to generate DDL. Some providers such as `Hiberhate` allow schema generation, some don't. Anyways, your question has nothing to do with JPA. — jFrenetic, Feb 29 '12 at 17:30
According to the JPA spec, `It is permitted, but not required, that DDL generation be supported by an implementation of this specification`. So your real question should probably sound more specific, like `How do I access the DDL generated by Hibernate from JPA entities?` — jFrenetic, Mar 01 '12 at 18:52

score 1 · Accepted Answer · answered Mar 01 '12 at 09:23

1

Look at classes in hbm2ddl package

Especially SchemaExport class.

answered Mar 01 '12 at 09:23

score 0 · Answer 2 · answered Feb 29 '12 at 17:22

0

  <property name="show_sql">true</property>

In hibernate config

answered Feb 29 '12 at 17:22

NimChimpsky

2 Answers2