Hibernate version: 322

Name and version of the database you are using:
oracle9i

The generated SQL (show_sql=true):
create table MESSAGE (MESSAGE_ID number(19,0) not null, MESSAGE_TEXT varchar2(255), NEXT_MESSAGE_ID number(19,0), primary key (MESSAGE_ID))

this way oracle assigns the PK a name from its internal name sequense (like SYS_C007385). Is it possible to set it a meaningful name?

I'd like to be able to configure H to generate:

create table MESSAGE (MESSAGE_ID number(19,0) not null, MESSAGE_TEXT varchar2(255), NEXT_MESSAGE_ID number(19,0);

ALTER TABLE MESSAGE ADD CONSTRAINT PK_MESSAGE
PRIMARY KEY (
MESSAGE_ID
);

I'm not sure, try unique-key attribute on the column tag.

Wy didn't you post your mapping file? Let us take a look to see if you are doing something weird.

I thought it was unnecessary, since it is copied from the H book. AFAIK the only change is different pacckage

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="prototype.Message" table="MESSAGE">
<id name="id" column="MESSAGE_ID">
<generator class="increment"/>
</id>

<property name="text" column="MESSAGE_TEXT"/>
<many-to-one name="nextMessage" cascade="all" column="NEXT_MESSAGE_ID"
foreign-key="FK_NEXT_MESSAGE"/>
</class>
</hibernate-mapping>