When using Hibernate with DB2, I cannot get the tables to be created in the tablespace specified in the default schema. It creates the default schema correctly, but then uses the next available tablespace for creation which is not what I want. Does anyone know where I would specifiy the tablespace?

I specify the defaults in: hibernate.default_schema and also in my .hbm.xml file as schema="XXXXX"

Is there something that I am missing?

Thanks.

What is current schema when tables get created?

Are you specifying the schema in the connection URL? Something like following:
//hostname:port/my_schema/

An alternative would be to add schema to create statements.
E.g. create table my_schema.my_table ....

Regards, feester

After speaking with my DBA, he thinks that Hibernate just picks the tablespace that was created first, with the lowest number, and creates the tables there. I am using Hibernate to create the tables and didn't know that I could manipulate the statements to insert a using clause.