I have been looking up and down for handling a table with the following ROWID as a primary key.

Following is the table:

PRCS_ATT_ID ROWID NOT NULL
GENERATED ALWAYS,
PRCS_PR_ID INTEGER NOT NULL WITH DEFAULT,
PRCS_FILE_NAME VARCHAR(100) NOT NULL WITH DEFAULT,
PRCS_FILE_DESC VARCHAR(500) NOT NULL WITH DEFAULT,
PRCS_CONTENT BLOB(100M) NOT NULL WITH DEFAULT,
PRCS_FILE_TYPE VARCHAR(50) NOT NULL WITH DEFAULT,
PRCS_DOC_TYPE VARCHAR(100) NOT NULL WITH DEFAULT,
PRCS_ATT_DATE DATE NOT NULL WITH DEFAULT


What would the mapping file and the java bean look like?

Following is what I came up with but it does not work because Hibernate gives a generate primary key error.

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd" >

<hibernate-mapping>


<class
name="org.navyfcu.prs.bean.form.Attachment"
table="VWPARATTACHDUI01"
lazy="false"
rowid="PRCS_ATT_ID"
>
<meta attribute="class-description" inherit="false">
Stores binary data as attachments for the PAR table
</meta>

<id name="attachmentId" type="binary" column="PRCS_ATT_ID">
<generator class="native" />
</id>



<property
name="reviewID"
type="java.lang.Integer"
column="PRCS_PR_ID"
not-null="true"
length="10"
/>
....
....
<property
name="content"
type="java.sql.Blob"
column="PRCS_CONTENT"
not-null="true"
length="104857600"
/>
<property
name="fileType"
type="java.lang.String"
column="PRCS_FILE_TYPE"
not-null="true"
length="50"
/>

...
<!-- Associations -->

</class>
</hibernate-mapping>

Following is the java bean object:

public class Attachment implements Serializable {
private static Logger log = Logger.getLogger(Attachment.class);
/** identifier field */
private byte[] attachmentId;

private int reviewID;

/** persistent field */
private String fileName;

/** nullable persistent field */
private String fileDescription;

/** persistent field */
private Blob content;


private String fileType;

private String documentType;

private Date dateAttached;

private ParPerformanceReview review;

/** default constructor */
public Attachment() {
}
public int getReviewID() {
return reviewID;
}
public void setReviewID(int reviewID) {
this.reviewID = reviewID;
}
/**
* This is the primary Key
*
*/
public byte[] getAttachmentId() {
return this.attachmentId;
}

public void setAttachmentId(byte[] prcsAttId) {
this.attachmentId = prcsAttId;
}

public String getFileName() {
return this.fileName;
}

.
.
.
So when I try to save an object I get the following error . My question is WHY is hibernate trying to generate an ID when the generator is NATIVE? Secondly how do I tackle this mapping? I tried midgen but it cannot apparently access the table:

[7/19/06 14:45:54:156 EDT] 00000021 SystemOut O 23359 [ERROR]BasicHibernateAccess--Problem saving object - org.navyfcu.prs.bean.form.Attachment [07/19/06 14:45:54][WebContainer : 0]
org.hibernate.id.IdentifierGenerationException: this id generator generates long, integer, short or string
at org.hibernate.id.IdentifierGeneratorFactory.get(IdentifierGeneratorFactory.java:59)
at org.hibernate.id.IdentifierGeneratorFactory.getGeneratedIdentity(IdentifierGeneratorFactory.java:35)
at org.hibernate.id.IdentityGenerator.getResult(IdentityGenerator.java:27)
at org.hibernate.id.AbstractPostInsertGenerator.getGenerated(AbstractPostInsertGenerator.java:44)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:1994)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2405)

Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version: 3.0

Mapping documents: mentioned above

Code between sessionFactory.openSession() and session.close():
just a call to save object


Full stack trace of any exception that occurs:

[7/19/06 14:45:47:047 EDT] 00000021 SystemOut O Hibernate: select parperform0_.PRCS_PR_ID as PRCS1_4_, parperform0_.PRCS_EMPL_ID as PRCS2_4_, parperform0_.PRCS_BILLET_NO as PRCS3_4_, parperform0_.PRCS_FIRST_NAME as PRCS4_4_, parperform0_.PRCS_MID_NAME as PRCS5_4_, parperform0_.PRCS_LAST_NAME as PRCS6_4_, parperform0_.PRCS_TITLE as PRCS7_4_, parperform0_.PRCS_GRADE as PRCS8_4_, parperform0_.PRCS_SUPERVISOR as PRCS9_4_, parperform0_.PRCS_SUP_EMPL_ID as PRCS10_4_, parperform0_.PRCS_REVIEW_DT as PRCS11_4_, parperform0_.PRCS_START_DT as PRCS12_4_, parperform0_.PRCS_COMP_DT as PRCS13_4_, parperform0_.PRCS_DAY_30_DT as PRCS14_4_, parperform0_.PRCS_TO_EMPL_DT as PRCS15_4_, parperform0_.PRCS_TO_SUP_DT as PRCS16_4_, parperform0_.PRCS_HR_DT as PRCS17_4_, parperform0_.PRCS_REV_TYPE as PRCS18_4_, parperform0_.PRCS_ORG_LOC as PRCS19_4_ from VWPRFMNCE_REVDUI01 parperform0_ where parperform0_.PRCS_PR_ID=?
[7/19/06 14:45:47:141 EDT] 00000021 SystemOut O Hibernate: select srsform0_.PRCS_SRS_ID as PRCS1_7_0_, srsform0_.PRCS_DEPT_CO as PRCS2_7_0_, srsform0_.PRCS_PR_ID as PRCS3_7_0_, srsform0_.PRCS_ANNUAL_RT as PRCS4_7_0_, srsform0_.PRCS_HOURLY_RT as PRCS5_7_0_, srsform0_.PRCS_NEW_ANN_RT as PRCS6_7_0_, srsform0_.PRCS_NEW_HOUR_RT as PRCS7_7_0_, srsform0_.PRCS_FLSA_ST as PRCS8_7_0_, srsform0_.PRCS_EFF_DT as PRCS9_7_0_, srsform0_.PRCS_SAL_RNG_PO as PRCS10_7_0_, srsform0_.PRCS_STATUS as PRCS11_7_0_, srsform0_.PRCS_REC_AWARD as PRCS12_7_0_, srsform0_.PRCS_PER_MERIT as PRCS13_7_0_, srsform0_.PRCS_BONUS as PRCS14_7_0_, srsform0_.PRCS_DEADLINE as PRCS15_7_0_, srsform0_.PRCS_REMARKS as PRCS16_7_0_, srsform0_.PRCS_APPROVAL_REQ as PRCS17_7_0_, srsform0_.PRCS_MIN_ANN_RT as PRCS18_7_0_, srsform0_.PRCS_MAX_ANN_RT as PRCS19_7_0_, srsform0_.PRCS_MIN_HOUR_RT as PRCS20_7_0_, srsform0_.PRCS_MAX_HOUR_RT as PRCS21_7_0_ from VWSRS_FORMDUI01 srsform0_ where srsform0_.PRCS_SRS_ID=?
[7/19/06 14:45:47:156 EDT] 00000021 SystemOut O Hibernate: select parform0_.PRCS_PAR_ID as PRCS1_3_0_, parform0_.PRCS_PR_ID as PRCS2_3_0_, parform0_.PRCS_PAR_TYPE as PRCS3_3_0_, parform0_.PRCS_PAR_NUM as PRCS4_3_0_, parform0_.PRCS_RATING_FRM as PRCS5_3_0_, parform0_.PRCS_RATING_TO as PRCS6_3_0_, parform0_.PRCS_EMP_SIG_DT as PRCS7_3_0_, parform0_.PRCS_ROUTE_CMT as PRCS8_3_0_, parform0_.PRCS_READ_COE as PRCS9_3_0_, parform0_.PRCS_READ_FRAUD as PRCS10_3_0_, parform0_.PRCS_OVERALL_RT as PRCS11_3_0_, parform0_.PRCS_OTHER_SUPP as PRCS12_3_0_, parform0_.PRCS_PERF_AWARD as PRCS13_3_0_ from VWPAR_FORMDUI01 parform0_ where parform0_.PRCS_PAR_ID=?
[7/19/06 14:45:47:203 EDT] 00000021 SystemOut O Hibernate: select parformexe0_.PRCS_PAR_ID as PRCS1_8_3_, parformexe0_.PRCS_PR_ID as PRCS2_8_3_, parformexe0_.PRCS_EMP_TYPE as PRCS3_8_3_, parformexe0_.PRCS_ANNUAL_RT as PRCS4_8_3_, parformexe0_.PRCS_PAR_TYPE as PRCS5_8_3_, parformexe0_.PRCS_CURSAL_DT as PRCS6_8_3_, parformexe0_.PRCS_NXTREVEFF_DT as PRCS7_8_3_, parformexe0_.PRCS_TOTAL_SCORE as PRCS8_8_3_, parformexe0_.PRCS_NEW_ANN_RT as PRCS9_8_3_, parformexe0_.PRCS_OTHER_SUPP as PRCS10_8_3_, parformexe0_.PRCS_REC_PCT as PRCS11_8_3_, parformexe0_.PRCS_REC_TYPE as PRCS12_8_3_, parformexe0_.PRCS_SAL_RNG_PO as PRCS13_8_3_, parperform1_.PRCS_PR_ID as PRCS1_4_0_, parperform1_.PRCS_EMPL_ID as PRCS2_4_0_, parperform1_.PRCS_BILLET_NO as PRCS3_4_0_, parperform1_.PRCS_FIRST_NAME as PRCS4_4_0_, parperform1_.PRCS_MID_NAME as PRCS5_4_0_, parperform1_.PRCS_LAST_NAME as PRCS6_4_0_, parperform1_.PRCS_TITLE as PRCS7_4_0_, parperform1_.PRCS_GRADE as PRCS8_4_0_, parperform1_.PRCS_SUPERVISOR as PRCS9_4_0_, parperform1_.PRCS_SUP_EMPL_ID as PRCS10_4_0_, parperform1_.PRCS_REVIEW_DT as PRCS11_4_0_, parperform1_.PRCS_START_DT as PRCS12_4_0_, parperform1_.PRCS_COMP_DT as PRCS13_4_0_, parperform1_.PRCS_DAY_30_DT as PRCS14_4_0_, parperform1_.PRCS_TO_EMPL_DT as PRCS15_4_0_, parperform1_.PRCS_TO_SUP_DT as PRCS16_4_0_, parperform1_.PRCS_HR_DT as PRCS17_4_0_, parperform1_.PRCS_REV_TYPE as PRCS18_4_0_, parperform1_.PRCS_ORG_LOC as PRCS19_4_0_, srsform2_.PRCS_SRS_ID as PRCS1_7_1_, srsform2_.PRCS_DEPT_CO as PRCS2_7_1_, srsform2_.PRCS_PR_ID as PRCS3_7_1_, srsform2_.PRCS_ANNUAL_RT as PRCS4_7_1_, srsform2_.PRCS_HOURLY_RT as PRCS5_7_1_, srsform2_.PRCS_NEW_ANN_RT as PRCS6_7_1_, srsform2_.PRCS_NEW_HOUR_RT as PRCS7_7_1_, srsform2_.PRCS_FLSA_ST as PRCS8_7_1_, srsform2_.PRCS_EFF_DT as PRCS9_7_1_, srsform2_.PRCS_SAL_RNG_PO as PRCS10_7_1_, srsform2_.PRCS_STATUS as PRCS11_7_1_, srsform2_.PRCS_REC_AWARD as PRCS12_7_1_, srsform2_.PRCS_PER_MERIT as PRCS13_7_1_, srsform2_.PRCS_BONUS as PRCS14_7_1_, srsform2_.PRCS_DEADLINE as PRCS15_7_1_, srsform2_.PRCS_REMARKS as PRCS16_7_1_, srsform2_.PRCS_APPROVAL_REQ as PRCS17_7_1_, srsform2_.PRCS_MIN_ANN_RT as PRCS18_7_1_, srsform2_.PRCS_MAX_ANN_RT as PRCS19_7_1_, srsform2_.PRCS_MIN_HOUR_RT as PRCS20_7_1_, srsform2_.PRCS_MAX_HOUR_RT as PRCS21_7_1_, parform3_.PRCS_PAR_ID as PRCS1_3_2_, parform3_.PRCS_PR_ID as PRCS2_3_2_, parform3_.PRCS_PAR_TYPE as PRCS3_3_2_, parform3_.PRCS_PAR_NUM as PRCS4_3_2_, parform3_.PRCS_RATING_FRM as PRCS5_3_2_, parform3_.PRCS_RATING_TO as PRCS6_3_2_, parform3_.PRCS_EMP_SIG_DT as PRCS7_3_2_, parform3_.PRCS_ROUTE_CMT as PRCS8_3_2_, parform3_.PRCS_READ_COE as PRCS9_3_2_, parform3_.PRCS_READ_FRAUD as PRCS10_3_2_, parform3_.PRCS_OVERALL_RT as PRCS11_3_2_, parform3_.PRCS_OTHER_SUPP as PRCS12_3_2_, parform3_.PRCS_PERF_AWARD as PRCS13_3_2_ from VWPAREXECMGRDUI01 parformexe0_ left outer join VWPRFMNCE_REVDUI01 parperform1_ on parformexe0_.PRCS_PR_ID=parperform1_.PRCS_PR_ID left outer join VWSRS_FORMDUI01 srsform2_ on parperform1_.PRCS_PR_ID=srsform2_.PRCS_SRS_ID left outer join VWPAR_FORMDUI01 parform3_ on parperform1_.PRCS_PR_ID=parform3_.PRCS_PAR_ID where parformexe0_.PRCS_PR_ID=?
[7/19/06 14:45:47:219 EDT] 00000021 SystemOut O Hibernate: select signaturew0_.PRCS_PR_ID as PRCS7_1_, signaturew0_.PRCS_SIGNATURE_ID as PRCS1_1_, signaturew0_.PRCS_SIGNATURE_ID as PRCS1_5_0_, signaturew0_.PRCS_EMPL_ID as PRCS2_5_0_, signaturew0_.PRCS_SIGN_ORD as PRCS3_5_0_, signaturew0_.PRCS_SIGN_TYPE as PRCS4_5_0_, signaturew0_.PRCS_COMPLETED as PRCS5_5_0_, signaturew0_.PRCS_AVAILABLE as PRCS6_5_0_, signaturew0_.PRCS_PR_ID as PRCS7_5_0_ from VWSIGNTREFLOWDUI01 signaturew0_ where signaturew0_.PRCS_PR_ID=? order by signaturew0_.PRCS_SIGN_ORD asc
[7/19/06 14:45:47:250 EDT] 00000021 SystemOut O Hibernate: select editlogs0_.PRCS_PR_ID as PRCS2_1_, editlogs0_.PRCS_EDIT_LOGID as PRCS1_1_, editlogs0_.PRCS_EDIT_LOGID as PRCS1_1_0_, editlogs0_.PRCS_PR_ID as PRCS2_1_0_, editlogs0_.PRCS_FORM_ID as PRCS3_1_0_, editlogs0_.PRCS_EMPL_ID as PRCS4_1_0_, editlogs0_.PRCS_LOG_DATE as PRCS5_1_0_, editlogs0_.PRCS_LOG_CD as PRCS6_1_0_, editlogs0_.PRCS_DESC as PRCS7_1_0_ from VWEDIT_LOGIDDUI01 editlogs0_ where editlogs0_.PRCS_PR_ID=? order by editlogs0_.PRCS_EDIT_LOGID asc
[7/19/06 14:45:47:266 EDT] 00000021 SystemOut O Hibernate: select attachment0_.PRCS_PR_ID as PRCS2_1_, attachment0_.PRCS_ATT_ID as PRCS1_1_, attachment0_.PRCS_ATT_ID as PRCS1_9_0_, attachment0_.PRCS_PR_ID as PRCS2_9_0_, attachment0_.PRCS_FILE_NAME as PRCS3_9_0_, attachment0_.PRCS_DOC_TYPE as PRCS4_9_0_, attachment0_.PRCS_FILE_DESC as PRCS5_9_0_, attachment0_.PRCS_CONTENT as PRCS6_9_0_, attachment0_.PRCS_FILE_TYPE as PRCS7_9_0_, attachment0_.PRCS_ATT_DATE as PRCS8_9_0_, attachment0_.PRCS_ATT_ID as rowid_0_ from VWPARATTACHDUI01 attachment0_ where attachment0_.PRCS_PR_ID=?
[7/19/06 14:45:47:297 EDT] 00000021 SystemOut O Hibernate: select signatures0_.PRCS_PR_ID as PRCS3_1_, signatures0_.PRCS_SIGNID as PRCS1_1_, signatures0_.PRCS_SIGNID as PRCS1_6_0_, signatures0_.PRCS_EMPL_ID as PRCS2_6_0_, signatures0_.PRCS_PR_ID as PRCS3_6_0_, signatures0_.PRCS_SIGN_TYPE as PRCS4_6_0_, signatures0_.PRCS_SIGN_DT as PRCS5_6_0_, signatures0_.PRCS_SIGN_CMT as PRCS6_6_0_, signatures0_.PRCS_LAST_NAME as PRCS7_6_0_, signatures0_.PRCS_MID_NAME as PRCS8_6_0_, signatures0_.PRCS_FIRST_NAME as PRCS9_6_0_, signatures0_.PRCS_EMAIL as PRCS10_6_0_, signatures0_.PRCS_TITLE as PRCS11_6_0_ from VWPRS_SIGNDUI01 signatures0_ where signatures0_.PRCS_PR_ID=?
[7/19/06 14:45:47:297 EDT] 00000021 SystemOut O Hibernate: select parfactors0_.PRCS_PAR_ID as PRCS2_1_, parfactors0_.PRCS_FACTOR_ID as PRCS1_1_, parfactors0_.PRCS_FACTOR_ID as PRCS1_2_0_, parfactors0_.PRCS_PAR_ID as PRCS2_2_0_, parfactors0_.PRCS_FACTR_TYPE as PRCS3_2_0_, parfactors0_.PRCS_RATING as PRCS4_2_0_, parfactors0_.PRCS_LAST_EMPID as PRCS5_2_0_, parfactors0_.PRCS_LAST_DATE as PRCS6_2_0_, parfactors0_.PRCS_COMMENT as PRCS7_2_0_ from VWPAR_FACTORSDUI01 parfactors0_ where parfactors0_.PRCS_PAR_ID=?
[7/19/06 14:45:47:312 EDT] 00000021 SystemOut O Hibernate: select comments0_.PRCS_PAR_ID as PRCS2_1_, comments0_.PRCS_CMT_ID as PRCS1_1_, comments0_.PRCS_CMT_ID as PRCS1_0_0_, comments0_.PRCS_PAR_ID as PRCS2_0_0_, comments0_.PRCS_EMPL_ID as PRCS3_0_0_, comments0_.PRCS_CMT_CD as PRCS4_0_0_, comments0_.PRCS_CMT_DT as PRCS5_0_0_, comments0_.PRCS_COMMENT as PRCS6_0_0_ from VWPAR_COMMNTSDUI01 comments0_ where comments0_.PRCS_PAR_ID=?
[7/19/06 14:45:47:328 EDT] 00000021 SystemOut O 16531 [DEBUG]AttachFiles--review 10195 [07/19/06 14:45:47][WebContainer : 0]
[7/19/06 14:45:47:328 EDT] 00000021 SystemOut O 16531 [DEBUG]AttachFiles--in do attachlink review 10195 [07/19/06 14:45:47][WebContainer : 0]
[7/19/06 14:45:47:344 EDT] 00000021 LocalTranCoor W WLTC0033W: Resource jdbc/UNITWB01 rolled back in cleanup of LocalTransactionContainment.
[7/19/06 14:45:47:344 EDT] 00000021 LocalTranCoor W WLTC0032W: One or more local transaction resources were rolled back during the cleanup of a LocalTransactionContainment.
[7/19/06 14:45:47:359 EDT] 00000022 ServletWrappe A SRVE0242I: [PRS_EAR] [/PRS] [/forms/AttachFiles.jsp]: Initialization successful.
[7/19/06 14:45:53:812 EDT] 00000021 SystemOut O 23015 [DEBUG]AttachFiles--file type image/gif [07/19/06 14:45:53][WebContainer : 0]
[7/19/06 14:45:53:828 EDT] 00000021 SystemOut O Hibernate: insert into VWPARATTACHDUI01 (PRCS_PR_ID, PRCS_FILE_NAME, PRCS_DOC_TYPE, PRCS_FILE_DESC, PRCS_CONTENT, PRCS_FILE_TYPE, PRCS_ATT_DATE, PRCS_ATT_ID) values (?, ?, ?, ?, ?, ?, ?, default)
[7/19/06 14:45:54:141 EDT] 00000021 SystemOut O Hibernate: select identity_val_local() from sysibm.sysdummy1
[7/19/06 14:45:54:156 EDT] 00000021 SystemOut O 23359 [ERROR]BasicHibernateAccess--Problem saving object - org.navyfcu.prs.bean.form.Attachment [07/19/06 14:45:54][WebContainer : 0]
org.hibernate.id.IdentifierGenerationException: this id generator generates long, integer, short or string
at org.hibernate.id.IdentifierGeneratorFactory.get(IdentifierGeneratorFactory.java:59)
at org.hibernate.id.IdentifierGeneratorFactory.getGeneratedIdentity(IdentifierGeneratorFactory.java:35)
at org.hibernate.id.IdentityGenerator.getResult(IdentityGenerator.java:27)
at org.hibernate.id.AbstractPostInsertGenerator.getGenerated(AbstractPostInsertGenerator.java:44)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:1994)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2405)
at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:37)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)
at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:269)
at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:167)
at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:101)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:186)
at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:175)
at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:530)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:518)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:514)
at org.navyfcu.prs.dao.BasicHibernateAccess.saveObject(BasicHibernateAccess.java:74)
at pagecode.forms.AttachFiles.doAttachBttnAction(AttachFiles.java:131)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:85)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:58)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled Code))
at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
at com.sun.faces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:127)
at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:73)
at javax.faces.component.UICommand.broadcast(UICommand.java:312)
at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:302)
at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:416)
at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:77)
at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:220)
at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:91)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:197)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1284)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1241)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:113)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:82)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:671)
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:89)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1924)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:88)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:472)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:411)
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:101)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java:566)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java:619)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java:952)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java:1039)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1470)
[7/19/06 14:45:54:172 EDT] 00000021 SystemOut O 23359 [DEBUG]DBErrorLog--getSuperClass:org.hibernate.HibernateException [07/19/06 14:45:54][WebContainer : 0]



Name and version of the database you are using:
DB2 on a mainframe z os
The generated SQL (show_sql=true):
Hibernate: insert into VWPARATTACHDUI01 (PRCS_PR_ID, PRCS_FILE_NAME, PRCS_DOC_TYPE, PRCS_FILE_DESC, PRCS_CONTENT, PRCS_FILE_TYPE, PRCS_ATT_DATE, PRCS_ATT_ID) values (?, ?, ?, ?, ?, ?, ?, default)

Debug level Hibernate log excerpt: