Hello I'm working with Hibernate 3.2.4, and I'm working with some database issues that I have have implemented using it. The question is if I can perform tables creation with Hibernate so: "CREATE TABLE 'table-name' ('id-name' 'id-type', 'field1-name' "field1-type", ...)". Off course using SQLQuery. Is this possible to do with Hibernate? How?

you can Map the table/class in a *.hbm.xml.
Add this to you hibernate.cfg.xml

and set

<hibernate-configuration>

<session-factory>

<property name="hibernate.hbm2ddl.auto">create</property>


Hibernate then will create all tables which are referenced in you mapping.

Thanks so much but that's not exactly what I'm looking for. The problem is that my application will perform dynamic tables creation. For example, my application receives information on what I want this new table to look like, number of fields or columns, datatypes for each of them, their names and all elements in a table creation. Then, I must have a method, that constructs the sentence dynamically with the provided information and executes it. So with each new calling to that method the sentence will be different. And I want to achieve the table creation with Hibernate, because I don't want this to be platform-dependant, and as I am also using Hibernate for other issues in the application, I tried to do it using SQLQuery. I realized that SQLQuery only works for SELECT sentences, so I am not able to do it and I will not perform dynamic inserts into these new tables (which is the next step). I just wanna know if it is not possible in any other way with Hibernate so I can stop trying and start to implement another solution for this issue. Thanks!!

One option is to bank on underlying JDBC connection.
session.connection().createStatement().execute("my_ddl") ;

other than using JDBC code, we have anything alternate for that ...

if u use JDBC code, u will lose ur abstraction of hibernate. my option u will go with hbm2ddl.auto property.

Thank you for your instant reply friend