Hello,
We are using jboss and postgres as db-backend. In one entity bean i have explicitly set a property to be mapped as "longvarchar" in the database
Code:
@Column(columndifinition="longvarchar")
public String getName(){
return name;
}
On Jboss startup i get following error:
Code:
13:28:42,370 ERROR [SchemaUpdate] Unsuccessful: create table TAudit_Changed_Field (id int8 not null, field varchar(255), afterValue LONGVARCHAR, beforeValue LONGVARCHAR, timeMillis int8 not null, auditRecord_identifier varchar(255), auditRecord_action int4, auditRecord_entity varchar(255), auditRecord_timeMillis int8, auditRecord_changedBy varchar(255), primary key (id))
13:28:42,370 ERROR [SchemaUpdate] ERROR: type "longvarchar" does not exist
Of course i could simply change the column-type to "text" for postgres, but i have to be also compatible to hsqldb - and hsqldb only knows "longvarchar". What must i do, that jboss/postgres accepts/knows type "longvarchar" ?