Hi,

I've got a problem when reverse-engineering my PostgreSQL base with seam 
1.2.0PATCH1.
Entity beans are well generated but when I restart my server I got the 
following error :

--- MBeans waiting for other MBeans ---
  | ObjectName: persistence.units:ear=bourseEmploi.ear,unitName=bourseEmploi
  |   State: FAILED
  |   Reason: javax.persistence.PersistenceException: 
org.hibernate.HibernateException: Wrong column type: agtdna, expected: 
varchar(10)
  |   I Depend On:
  |     jboss.jca:service=DataSourceBinding,name=bourseEmploiDatasource
  | 

It appears on all database fields that are of type character(X) where X is more 
than 1. No problem with varchar(X) types.

I've found a work around : for each field of that type, I modify manually the 
Column definition in the entity bean file :
Generated code is :
@Column(name = "agtdna", nullable = false, length = 10)
  |     @NotNull
  |     @Length(max = 10)
  |     public String getAgtdna() {
  |             return this.agtdna;
  |     }

After my modification :
@Column(name = "agtdna", columnDefinition = "bpchar(10)", nullable = false, 
length = 10)
  |     @NotNull
  |     @Length(max = 10)
  |     public String getAgtdna() {
  |             return this.agtdna;
  |     }

Is there a way to parameter the mapping-types before calling seam 
generate-entities so that I wouldn't have to modify manually all files? In the 
same idea, is there a way to parameter which fields are primary key or foreign 
keys for a table?




View the original post : 
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4028290#4028290

Reply to the post : 
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4028290
_______________________________________________
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user

Reply via email to