We are using XDOCLET to generate our database scripts. Now we have the requirement to generate the table-Create-Statements with the "tablespace"-attribute for an Oracle-Database. I know that there is a schema-attribute but this puts a table in a dedicated schema. We would like to keep all tables in the same schema but the tables should be stored in different tablespace regions.

using

/**
* @hibernate.class table="customer"
*
* I know that this exactly does not exist, only here to express what I am looking for
* @hibernate.tablespace="MYTABLESPACE"
*
*/

The output should be as follows:

create table CUSTOMER
(
...
)
tablespace MYTABLESPACE;

I looked through the dts and the docs but could find exactly what I am looking for. Is there a way to to do that?

If not, could it be easily added to the XDOCLET Generator? If yes, and I had a short guideline I would even volunteer to contribute.

Stefan

not possible now, but you should be able to very easily hack Hibernate to support this - it would be trivial

In Hibernate3 there is actually a hook to append something Dialect-specific to the end of a create table statement

Gavin, can you give a short hint, where I would implement that and I go forward and do that :-)

stefan.hoehn : Did you find what to add (and where) to solve your problem about tablespaces ?

No, not really.

I met Gavin and we discussed it. As it is really oracle-specific he said he wouldn't like to put that in. We actually did it finally with an ant-script that added the needed information after the script has been generated.

Stefan

I think PostgreSQL uses tablespaces, too, so it's certainly not an Oracle-only thing. Was that the only reason for not putting it in? I think it would be a nice feature.

Gavin, if someone submitted a patch, are you still against putting it in (would it be a waste of time)?

Hi,
I am also looking for a way to specify the tablespace in the DDL using XDoclet.

I would apreciate it if someone could give us a hint to know how we could hack hibernate to support it.

Thanks in advance,
sylvain_2020

Hi again,

Still completly stuck with this problem of tablespace. I am not expecting to get directly the answer but I just would like to get some help.

Is it just a modification to do on hibernate or on XDoclet as well ?

Any piece of help will be very very apreciated.

sylvain_2020

As mentioned above, post processing the DDL would be your best (and shortest) bet.

I would say it needs some modification in hibernate AND in xDoclet.
Having look at how to implement this feature, I confirm it is certainly easier to use an Ant script to post processing your ddl file.
(But I hope someone will implement it "one day").