I have an entity associated with an Oracle database table that has one column
of type VarChar2(20) as the Primary Key which is used to store Java 1.5 enum
values. The env. I am using is Jboss 4.1.2-GA as app server. I am getting an
exception whenever I try to retrieve and store the values to another table.
The enum, entity and exception follows:
----
/**
* List contains all Inspection Member Types
*/
public enum InspectionPersonnelTypeEnum implements Serializable {
AIRCREW("Air Crew Member"), INSPECTOR("Inspector"), MONITOR("Monitor");
private String displayName;
private InspectionPersonnelTypeEnum(String displayName) {
this.displayName = displayName;
}
public String getDisplayName() {
return displayName;
}
}
------
@Entity
@Table(name = "STR_INSP_PERSON_TYPE")
public class InspectionPersonnelTypeEntityEJB implements Serializable {
private InspectionPersonnelTypeEnum inspectionPersonType;
@Id
@Column(name = "INSPECTION_PERSON_TYPE"
@Enumerated(value = EnumType.STRING)
public InspectionPersonnelTypeEnum getInspectionPersonType() {
return inspectionPersonType;
}
public void setInspectionPersonType(InspectionPersonnelTypeEnum
inspectionPersonType) {
this.inspectionPersonType = inspectionPersonType;
}
------
When trying to retrieve value from that column (e.g. populate the entity with a
EntityManager.find()) I get the following exception:
Caused by: org.hibernate.type.SerializationException: could not deserialize
at
org.hibernate.util.SerializationHelper.deserialize(SerializationHelper.java:217)
at
org.hibernate.util.SerializationHelper.deserialize(SerializationHelper.java:240)
at org.hibernate.type.SerializableType.fromBytes(SerializableType.java:82)
at org.hibernate.type.SerializableType.get(SerializableType.java:39)
at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:163)
at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:154)
at org.hibernate.loader.Loader.getKeyFromResultSet(Loader.java:1097)
at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:565)
at org.hibernate.loader.Loader.doQuery(Loader.java:701)
at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
at org.hibernate.loader.Loader.loadCollection(Loader.java:1994)
at
org.hibernate.loader.collection.CollectionLoader.initialize(CollectionLoader.java:36)
at
org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:565)
at
org.hibernate.event.def.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:60)
at org.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java:1716)
at
org.hibernate.collection.AbstractPersistentCollection.forceInitialization(AbstractPersistentCollection.java:454)
at
org.hibernate.engine.StatefulPersistenceContext.initializeNonLazyCollections(StatefulPersistenceContext.java:797)
at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:241)
at org.hibernate.loader.Loader.doList(Loader.java:2220)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
at org.hibernate.loader.Loader.list(Loader.java:2099)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:64)
----
When I try to save a value stored in the table (@OneToMany
@JoinTable(name = "STR_INSP_PERSON_ROLE",
joinColumns = [EMAIL PROTECTED](name = "INSP_PERSON_ID")},
inverseJoinColumns = [EMAIL PROTECTED](name =
"INSPECTION_PERSON_TYPE")})
public List getInspPersonTypes() {
return this.inspPersonTypes;
})
I get the following exception:
Caused by: java.sql.BatchUpdateException: ORA-12899: value too large for column
"ACES_LIVE"."STR_INSP_PERSON_ROLE"."INSPECTION_PERSON_TYPE" (actual: 274,
maximum: 20)
at
oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
at
oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10698)
at
org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:519)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)
---
Is this a known issue? Any help would be most welcomed.
Thanks
Frezer
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4083409#4083409
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4083409
_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user
