How can I see the SQL which creates the TABLE?
i am using hibernate 3.1 on linux with Mysql 5.0.
I set these 2 lines in my hibernate.cfg.xml file:
Code:
<property name="show_sql">true</property>
<property name="hbm2ddl.auto">create</property>
But i don't see the SQL which hibernate uses to create the tables in the database.
i have also tried to use the schemaexport ANT task to see the database schema, but i get this error. I have make sure the file is located at '/home/ken/eclipseworkspace3/Hibernate/src/events/Event.hbm.xml' and the 'Event.hbm.xml' is from the hibernate.
Code:
BUILD FAILED
/home/ken/eclipseworkspace3/Hibernate/build.xml:45: Schema text failed: Could not read mapping document from file: /home/ken/eclipseworkspace3/Hibernate/src/events/Event.hbm.xml
I am not sure why either way does not work. Anyhelp to get one of the way to work is appreciated.
[/code]