Does any one know how to change the column information on an ID field. We have a legacy system that uses Oracle, and we currently key most of our objects with a Number(38). The schema tool generates Number(19,0) for id fields. I have tried using a property but that did not work.

Any ideas?

Mike...

Its documented for Properties only though it works fine for IDs, eg, use the sql-type attribute of the column. For example;

<id name="id" type="long" unsaved-value="null" >
<column name="id" sql-type="NUMBER(38)" />
<generator class="native"/>
</id>

I tried what you suggested ...

<class name="com.pts.ietms.data.om.DataDomain" table="DataDomain">
<id name="id" type="long" column="id">
<column name="id" sql-type="NUMBER(38)"/>
<generator class="hilo"/>
</id>
<property name="description" column="description" type="string"/>
<property name="refId" column="refId" type="string"/>
</class>

but it produced ....

] create table DataDomain (
] id NUMBER(19,0) not null,
] description VARCHAR2(255),
] refId VARCHAR2(255),
] primary key (id)
] );

The class definition is:

public class DataDomain
{

private Long id;
private String description;
private String refId;

public DataDomain()
{
}

public Long getId()
{
return id;
}

public void setId(Long id)
{
this.id = id;
}

....

}

Any ideas?

Mike...

<id name="id" type="long" >
<column name="id" sql-type="NUMBER(38)"/>
<generator class="hilo"/>
</id>

works ...

<id name="id" type="long" column="id">
<column name="id" sql-type="NUMBER(38)"/>
<generator class="hilo"/>
</id>
did not ...

so I guess have a column attribute must make the system ignore a column enclosed entity.....

Thanks...

The column tag describes the sql column while the id type attribute is the hibernate type to use which is then mapped to Java using the database dialect. Its also a case of first found is used first. Gald you worked it out.