Hi All,

We just started a project which will use Hibernate 3.0 for persistence. Currently we are using the annotations to create the schema using hbm2ddl.auto property. I understand that this is NOT meant for production. In our organization, we need to provide the DDL for each and every table separately that include schema, table space indexes etc. In that case, using SchemaExport will i be able to generate a .sql file for each Entity class? Also, i noticed that SchemaExport gives some NUMBER for constraints and our requirement is to have a name for that. Is there a way i could change that?


Thanks in advance!

You can generate the schema using SchemaExport, them dump your schema to a .sql file. After that you're free to edit the file and change the constraints names.

you can name all constraints AFAIK. (e.g. via foreign-key atttribute)

Hi max,

In the hibernate generated DDL, we've a table called WORKGROUP.

create table WORKGROUP (
id number(19,0) not null,
NAME varchar2(255),
IS_ACTIVE number(1,0),
DESCRIPTION varchar2(255),
CREATED_BY_ID varchar2(255),
ESCALATION_FLAG number(1,0),
P0_PREFERENCE number(1,0),
P1_PREFERENCE number(1,0),
P2_PREFERENCE number(1,0),
P3_PREFERENCE number(1,0),
EMAIL_PAGER varchar2(255),
APPLICATION_ESCALATION_TEAM_ID number(19,0),
primary key (id)
);

alter table WORK_GROUP
add constraint FK31D2CFB1362EF931
foreign key (APPLICATION_ESCALATION_TEAM_ID)
references APPLICATION_ESCALATION_TEAM;

SchemaExport generates some number for constraint. I'm not sure how we could change that to a user defined "NAME"


We are using annoations.

Please advice.

grep the DTD for foreign-key attribute

Gavin, i just saw this post as well http://forum.hibernate.org/viewtopic.ph ... +manytoone


But i don't see any such equivalent for @ManyToOne annotation.


For now, in the WorkGroup class which has One to many relationship with the applicationEscalationTeam, we've defined the annotation as follows.

@ManyToOne
@JoinColumn(name="APPLICATION_ESCALATION_TEAM_ID", insertable = false, updatable = false)

I don't see any way to define "foreign-key" attribute for this.

I did check the ManyToOne.class in the eclipse and it doesn't seem to have any foreignKey method too. Could you please let me know how do i define this?

Thanks in advance!

Could someone please tell me how to give a valid name for the constraint name in the schemaexport generated schema?

Here's what the schema export generates.





I would like to give a valid name for the constraint.


As Gavin mentioned, i couldn't find any equivalent for foreign-key using hibernate annotations.

Thanks for any help in advance!

It is currently not supported using Hibernate Annotations.

See:
http://forum.hibernate.org/viewtopic.php?t=946026

You'll have to stick to XML Mappings or create the schema on your own.

Best regards
Sven

Thanks Sven.

I hope this feature is implemented soon!

Me too... provide a patch :-D