Hi,

I am using XDoclet and hbm2ddl. In my classes, I have something like

/**
* @return Returns the strFirstName.
*
* @hibernate.property
* type="character"
* column="FIRSTNAME"
* length="32"
* not-null="true"
*/
public String getStrFirstName() {
return strFirstName;
}
...

The generated mapping looks fine:

<property
name="strFirstName"
type="character"
update="true"
insert="true"
access="property"
column="FIRSTNAME"
length="32"
not-null="true"
/>
...

However, if I generate the ddl using SchemaExport, the sql output is

create table PERSON (
...
FIRSTNAME char(1) not null,
...
);

Obviously the column length has been changed to 1. If I am using "string" as type, then the generated length is 32. Any idea?

thx.
sven

use type="string" sql-type="whatever"

does not work either. I have the following changes:

/**
* @return Returns the strLastName.
*
* @hibernate.property
* type="string"
*
* @hibernate.column
* name="LASTNAME"
* sql-type="char"
* length="32"
* not-null="true"
*/
public String getStrLastName() {
return strLastName;
}


generated mapping:

<property
name="strLastName"
type="string"
update="true"
insert="true"
access="property"
>
<column
name="LASTNAME"
length="32"
not-null="true"
sql-type="char"
/>
</property>


generated sql:

create table PERSON (
PERSON_ID bigint generated by default as identity (start with 1),
...
LASTNAME char not null
...
);


now there is no specified column length at all. any help appreciated.

sven

I did some research and found on

http://cephas.net/blog/2004/06/29/hiber ... ength.html

some interesting stuff related to this topic. Although the author there was not sure whether this is a bug or a feature, I am pretty sure now this is a bug.

Other considerations?

Its correct. If you are defining an SQL type then this over rides the other properties that are DDL type related. So you should include the length if is approrpriate for the type being defined.