Hibernate version: 3.x

Code between sessionFactory.openSession() and session.close(): Using JBoss

Name and version of the database you are using: Sybase 12.x

Error:
2006-07-25 11:24:34,375 ERROR [org.hibernate.property.BasicPropertyAccessor] IllegalArgumentException in class: us.tx.state.oag.WfPersonnelAction.hbm.HbmWfPaCodeActionStatusTable, getter method of property: ActionStatusId

Mapping documents:

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

<hibernate-mapping default-cascade="none" default-access="property" auto-import="true">

<class name="us.tx.state.oag.WfPersonnelAction.hbm.HbmWfPaActionBatchTable"
table="info_wf_action_batch">

<id name="BatchId" column="batch_id" type="big_decimal">
<generator class="us.tx.state.oag.WfPersonnelAction.hbm.HbmWfPaNextBatchId">
<param name="JndiDbName">java:/workflows</param>
<param name="DbFieldName">next_action_batch_id</param>
</generator>
</id>

<many-to-one name="ActionStatusId" column="action_status_id" cascade="all" not-null="true" update="false" insert="false"
class="us.tx.state.oag.WfPersonnelAction.hbm.HbmWfPaCodeActionStatusTable"/>

<many-to-one name="ActionSubstatusId" column="action_substatus_id" cascade="all" not-null="true" update="false" insert="false"
class="us.tx.state.oag.WfPersonnelAction.hbm.HbmWfPaCodeActionSubstatusTable"/>

<property name="BusinessUnit" column="business_unit" type="string" update="true" insert="true"/>
<property name="CreationDate" column="creation_date" type="timestamp" update="true" insert="true"/>
<property name="DesiredEffectiveDate" column="desired_effective_date" type="timestamp" update="true" insert="true"/>
<property name="EffectiveDate" column="effective_date" type="timestamp" update="true" insert="true"/>
<property name="PortalWorkflowId" column="portal_workflow_id" type="string" update="true" insert="true"/>
<property name="WorkflowId" column="workflow_id" type="big_decimal" update="true" insert="true"/>

<property name="CreatedWho" column="cr_who" type="string" update="true" insert="true"/>
<property name="CreatedWhen" column="cr_when" type="timestamp" update="true" insert="true"/>
<property name="UpdatedWho" column="up_who" type="string" update="true" insert="true"/>
<property name="UpdatedWhen" column="up_when" type="timestamp" update="true" insert="true"/>
</class>

</hibernate-mapping>


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

<hibernate-mapping default-cascade="none" default-access="property" auto-import="true">

<class name="us.tx.state.oag.WfPersonnelAction.hbm.HbmWfPaCodeActionStatusTable"
table="code_wf_action_status">

<id name="ActionStatusId" column="action_status_id" type="big_decimal">
<generator class="us.tx.state.oag.WfPersonnelAction.hbm.HbmWfPaNextActionStatusId">
<param name="JndiDbName">java:/workflows</param>
<param name="DbFieldName">next_action_status_id</param>
</generator>
</id>

<property name="Description" column="description" type="string" update="true" insert="true"/>
<property name="WorkflowId" column="workflow_id" type="string" update="true" insert="true"/>

<property name="CreatedWho" column="cr_who" type="string" update="true" insert="true"/>
<property name="CreatedWhen" column="cr_when" type="timestamp" update="true" insert="true"/>
<property name="UpdatedWho" column="up_who" type="string" update="true" insert="true"/>
<property name="UpdatedWhen" column="up_when" type="timestamp" update="true" insert="true"/>
</class>

</hibernate-mapping>
Information:
The problem surfaces when I try to save a record in the HbmWfPaActionBatchTable table. It has a foreign key on the HbmWfPaCodeActionStatusTable table and my guess is its looking up the value in the code table to enforce integrity. But I cannot tell where/why its happening. The getter has a debug stop on it and it never gets called so its like Hibernate hasn't even tried to get the value out of the field...it is hitting the error before it tries to make the call.

The record to be saved's field is initialized with this value:

public static final BigDecimal CBD_ACTION_BATCH_DEFAULT_STATUS = new BigDecimal(14.0).setScale(0, BigDecimal.ROUND_UNNECESSARY);

Which does exist in the database.

Can someone tell me what is going on?

Oh, here are the custom identifier classes:

Descendant per table class

package us.tx.state.oag.WfPersonnelAction.hbm;

import java.util.Properties;

import org.hibernate.MappingException;
import org.hibernate.dialect.Dialect;
import org.hibernate.type.Type;

import us.tx.state.oag.util.OagStringUtils;
import us.tx.state.oag.util.HbmNextDbId;

public class HbmWfPaNextActionStatusId
extends HbmNextDbId {

public void configure(Type type, Properties params, Dialect dialect)
throws MappingException {
String ls_short_class_name = OagStringUtils.getShortClassName(this.getClass().getName());
params.put("className", ls_short_class_name);
super.configure(type, params, dialect);
}

} // HbmWfPaNextActionStatusId

Common ancestor class

package us.tx.state.oag.util;

import java.io.Serializable;
import java.math.BigDecimal;
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.Properties;

import org.hibernate.HibernateException;
import org.hibernate.MappingException;
import org.hibernate.dialect.Dialect;
import org.hibernate.engine.SessionImplementor;
import org.hibernate.id.Configurable;
import org.hibernate.id.IdentifierGenerator;
import org.hibernate.type.Type;
import org.hibernate.Transaction;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;

public class HbmNextDbId
implements IdentifierGenerator, Configurable {
private static final String CS_SP_CALL = "{ call sys_get_next_id_value_spf (?,?,?,?,?) }";
// logger
private static final Log log = LogFactory.getLog(HbmNextDbId.class);
/* name of the jndi connection pool to use in callnig the SP to get the
* next id, and the field name of the id to ask for
*/
private String cs_jndi_db_name = null;
private String cs_db_field_name = null;
private String cs_class_name = null;

public HbmNextDbId() {
super();
}

public Serializable generate(SessionImplementor session, Object object)
throws HibernateException {
/* call the stored procedure w/i the database in question to get the next
* id out of the specific table that stores them. this method needs
* the jndi name of the connection pool to use and the name of the
* field that stores the next id in question, which is passed to the SP
*/

BigDecimal lbd_result = null;
boolean lb_temp = true;
Transaction lo_transaction = null;
if ( log.isTraceEnabled() ) { log.trace(cs_class_name + " - generate - ENTER"); }
try {
lo_transaction = session.beginTransaction();
Connection lo_db_connection = session.connection();
if ( log.isTraceEnabled() ) {
log.trace("*** INFO: Connection information: " + lo_db_connection.getCatalog());
}

CallableStatement lo_cs = lo_db_connection.prepareCall(CS_SP_CALL);
//CallableStatement lo_cs = session.getBatcher().prepareCallableStatement(CS_SP_CALL);
lo_cs.setString("@pTxtFieldName", cs_db_field_name);
lo_cs.registerOutParameter("@pDcNextId", java.sql.Types.DECIMAL);
lo_cs.registerOutParameter("@pIntError", java.sql.Types.INTEGER);
lo_cs.registerOutParameter("@pIntRowCount", java.sql.Types.INTEGER);
lo_cs.registerOutParameter("@pTxtMsg", java.sql.Types.VARCHAR);
lo_cs.executeUpdate();
lbd_result = lo_cs.getBigDecimal("@pDcNextId");
lo_cs.close(); lo_cs = null;
} catch (Exception e) {
if ( log.isTraceEnabled() ) {
log.trace("*** ERROR in " + cs_class_name + " - generate - Exception");
log.trace(e.toString());
}
e.printStackTrace();
} finally {
lo_transaction.rollback();
}
if ( log.isTraceEnabled() ) { log.trace(cs_class_name + " - generate - EXIT"); }
return lbd_result;
}

public void configure(Type type, Properties params, Dialect dialect)
throws MappingException {
if ( log.isTraceEnabled() ) { log.trace("getNextDbId - configure - ENTER"); }
/* send the table and field name from the parameters to the
* class strings
*/
cs_class_name = params.getProperty("className");
if ( cs_class_name != null ) {
if ( log.isTraceEnabled() ) {
log.trace("getNextDbId - configure - Class Name = " + cs_class_name);
}
} else {
cs_class_name = "(unknown)";
}
cs_jndi_db_name = params.getProperty("JndiDbName");
if ( cs_jndi_db_name != null ) {
if ( log.isTraceEnabled() ) {
log.trace("getNextDbId - configure - DB Name = " + cs_jndi_db_name);
}
}
cs_db_field_name = params.getProperty("DbFieldName");
if ( cs_db_field_name != null ) {
if ( log.isTraceEnabled() ) {
log.trace("getNextDbId - configure - Field Name = " + cs_db_field_name);
}
}

if ( log.isTraceEnabled() ) { log.trace("getNextDbId - configure - EXIT"); }
}
} // HbmWfPaNextDbId

I think I have discovered part of the problem.

I commented out the two many-to-one relations in the BatchTable and the save action succeeded and it even had a value in the BatchId field (1.0).

When the next save call was encountered in code, it had the same error but with a different field:

[org.hibernate.property.BasicPropertyAccessor] IllegalArgumentException in class: us.tx.state.oag.WfPersonnelAction.hbm.HbmWfPaActionBatchTable, getter method of property: BatchId

Looks like Hibernate is trying to Save records in the remote tables rather than just lookup/verify that records exist in them w/those values.

So, are my declarations wrong?

I've gottent the code cleaned up so that the .save calls "work" but when I try to commit:

2006-07-25 15:55:40,421 INFO [STDOUT] PortletLog|1|7/25/06|15:55:40:421|
WfDbAccess - createNewWorkflow - COMMIT WORK
2006-07-25 15:55:41,500 INFO [STDOUT] Hibernate: insert into info_wf_action_batch (business_unit, creation_date, desired_effective_date, effective_date, portal_workflow_id, workflow_id, cr_who, cr_when, up_who, up_when, batch_id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2006-07-25 15:55:41,562 WARN [org.hibernate.util.JDBCExceptionReporter] SQL Error: 233, SQLState: 23000
2006-07-25 15:55:41,562 ERROR [org.hibernate.util.JDBCExceptionReporter] The column action_status_id in table info_wf_action_batch does not allow null values.

2006-07-25 15:55:41,562 WARN [org.hibernate.util.JDBCExceptionReporter] SQL Error: 233, SQLState: 23000
2006-07-25 15:55:41,562 ERROR [org.hibernate.util.JDBCExceptionReporter] The column action_substatus_id in table info_wf_action_batch does not allow null values.

2006-07-25 15:55:41,578 ERROR [org.hibernate.event.def.AbstractFlushingEventListener] Could not synchronize database state with session
org.hibernate.exception.ConstraintViolationException: could not insert: [us.tx.state.oag.WfPersonnelAction.hbm.HbmWfPaActionBatchTable]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:63)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1859)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:2190)
at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:46)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:223)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:136)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:274)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:680)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:309)
at org.hibernate.transaction.CacheSynchronization.beforeCompletion(CacheSynchronization.java:58)
at org.jboss.tm.TransactionImpl.doBeforeCompletion(TransactionImpl.java:1383)
at org.jboss.tm.TransactionImpl.beforePrepare(TransactionImpl.java:1075)
at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:296)
at org.jboss.tm.TxManager.commit(TxManager.java:200)
at org.jboss.tm.usertx.client.ServerVMClientUserTransaction.commit(ServerVMClientUserTransaction.java:126)
at org.hibernate.transaction.JTATransaction.commit(JTATransaction.java:130)
at us.tx.state.oag.WfPersonnelAction.WfDbAccess.createNewWorkflow(WfDbAccess.java:344)
at us.tx.state.oag.WfPersonnelAction.PersonnelActionManagement.processCommitBatch(PersonnelActionManagement.java:2455)
at us.tx.state.oag.WfPersonnelAction.PersonnelActionManagement.processAction(PersonnelActionManagement.java:2567)
at us.tx.state.oag.WfPersonnelAction.OagWfPersonnelActionPortlet.processAction(OagWfPersonnelActionPortlet.java:304)
at com.novell.afw.portlet.core.EboPortletContainer.processOperation(EboPortletContainer.java:646)
at com.novell.afw.portlet.core.EboPortletContainer.processOperation(EboPortletContainer.java:549)
at com.novell.afw.portlet.core.EboPortletContainer.performBlockingInteraction(EboPortletContainer.java:192)
at com.novell.afw.portlet.consumer.core.EboPortletConsumerContainer.processOperation(EboPortletConsumerContainer.java:311)
at com.novell.afw.portlet.consumer.core.EboPortletConsumerContainer.performBlockingInteraction(EboPortletConsumerContainer.java:148)
at com.novell.afw.portal.proxy.EboPortletContainerProxy.performBlockingInteraction(EboPortletContainerProxy.java:197)
at com.novell.afw.portal.aggregation.EboPortletProxyHelper.callPortletActionRequest(EboPortletProxyHelper.java:480)
at com.novell.afw.portal.aggregation.EboPortalAggregationControllerImpl.checkAndHandleActionURLType(EboPortalAggregationControllerImpl.java:1987)
at com.novell.afw.portal.aggregation.EboPortalAggregationControllerImpl.initiateRendering(EboPortalAggregationControllerImpl.java:1261)
at com.novell.afw.portal.aggregation.EboPortalAggregationControllerImpl.renderPortalResponse(EboPortalAggregationControllerImpl.java:531)
at com.novell.afw.portal.aggregation.EboPortalAggregationServlet.handlePortalContainerRequest(EboPortalAggregationServlet.java:761)
at com.novell.afw.portal.aggregation.EboPortalAggregationServlet.callService(EboPortalAggregationServlet.java:218)
at com.novell.afw.portal.aggregation.EboPortalAggregationServlet.doGet(EboPortalAggregationServlet.java:90)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at com.novell.afw.portal.xforms.EboXFormClientDetectionFilter.doFilter(EboXFormClientDetectionFilter.java:97)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:75)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:66)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:150)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:54)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:534)
Caused by: java.sql.SQLException: The column action_status_id in table info_wf_action_batch does not allow null values.

at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:633)
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:421)
at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:316)
at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1843)
... 71 more
2006-07-25 15:55:41,703 DEBUG [org.jboss.util.NestedThrowable] org.jboss.util.NestedThrowable.parentTraceEnabled=true
2006-07-25 15:55:41,718 DEBUG [org.jboss.util.NestedThrowable] org.jboss.util.NestedThrowable.nestedTraceEnabled=false
2006-07-25 15:55:41,718 DEBUG [org.jboss.util.NestedThrowable] org.jboss.util.NestedThrowable.detectDuplicateNesting=true
2006-07-25 15:55:41,687 ERROR [org.hibernate.transaction.JTATransaction] JTA commit failed
org.jboss.tm.JBossRollbackException: Unable to commit, tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=ACM3-60848/16, BranchQual=, localId=16] status=STATUS_NO_TRANSACTION; - nested throwable: (org.hibernate.exception.ConstraintViolationException: could not insert: [us.tx.state.oag.WfPersonnelAction.hbm.HbmWfPaActionBatchTable])
at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:344)
at org.jboss.tm.TxManager.commit(TxManager.java:200)
at org.jboss.tm.usertx.client.ServerVMClientUserTransaction.commit(ServerVMClientUserTransaction.java:126)
at org.hibernate.transaction.JTATransaction.commit(JTATransaction.java:130)
at us.tx.state.oag.WfPersonnelAction.WfDbAccess.createNewWorkflow(WfDbAccess.java:344)
at us.tx.state.oag.WfPersonnelAction.PersonnelActionManagement.processCommitBatch(PersonnelActionManagement.java:2455)
at us.tx.state.oag.WfPersonnelAction.PersonnelActionManagement.processAction(PersonnelActionManagement.java:2567)
at us.tx.state.oag.WfPersonnelAction.OagWfPersonnelActionPortlet.processAction(OagWfPersonnelActionPortlet.java:304)
at com.novell.afw.portlet.core.EboPortletContainer.processOperation(EboPortletContainer.java:646)
at com.novell.afw.portlet.core.EboPortletContainer.processOperation(EboPortletContainer.java:549)
at com.novell.afw.portlet.core.EboPortletContainer.performBlockingInteraction(EboPortletContainer.java:192)
at com.novell.afw.portlet.consumer.core.EboPortletConsumerContainer.processOperation(EboPortletConsumerContainer.java:311)
at com.novell.afw.portlet.consumer.core.EboPortletConsumerContainer.performBlockingInteraction(EboPortletConsumerContainer.java:148)
at com.novell.afw.portal.proxy.EboPortletContainerProxy.performBlockingInteraction(EboPortletContainerProxy.java:197)
at com.novell.afw.portal.aggregation.EboPortletProxyHelper.callPortletActionRequest(EboPortletProxyHelper.java:480)
at com.novell.afw.portal.aggregation.EboPortalAggregationControllerImpl.checkAndHandleActionURLType(EboPortalAggregationControllerImpl.java:1987)
at com.novell.afw.portal.aggregation.EboPortalAggregationControllerImpl.initiateRendering(EboPortalAggregationControllerImpl.java:1261)
at com.novell.afw.portal.aggregation.EboPortalAggregationControllerImpl.renderPortalResponse(EboPortalAggregationControllerImpl.java:531)
at com.novell.afw.portal.aggregation.EboPortalAggregationServlet.handlePortalContainerRequest(EboPortalAggregationServlet.java:761)
at com.novell.afw.portal.aggregation.EboPortalAggregationServlet.callService(EboPortalAggregationServlet.java:218)
at com.novell.afw.portal.aggregation.EboPortalAggregationServlet.doGet(EboPortalAggregationServlet.java:90)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at com.novell.afw.portal.xforms.EboXFormClientDetectionFilter.doFilter(EboXFormClientDetectionFilter.java:97)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:75)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:66)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:150)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:54)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:534)
Caused by: org.hibernate.exception.ConstraintViolationException: could not insert: [us.tx.state.oag.WfPersonnelAction.hbm.HbmWfPaActionBatchTable]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:63)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1859)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:2190)
at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:46)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:223)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:136)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:274)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:680)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:309)
at org.hibernate.transaction.CacheSynchronization.beforeCompletion(CacheSynchronization.java:58)
at org.jboss.tm.TransactionImpl.doBeforeCompletion(TransactionImpl.java:1383)
at org.jboss.tm.TransactionImpl.beforePrepare(TransactionImpl.java:1075)
at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:296)
... 58 more
Caused by: java.sql.SQLException: The column action_status_id in table info_wf_action_batch does not allow null values.

at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:633)
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:421)
at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:316)
at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1843)
... 71 more
2006-07-25 15:57:28,953 INFO [STDOUT] PortletLog|1|7/25/06|15:57:28:953|
WfDbAccess - *** ERROR in createNewWorkflow - COMMIT failed
2006-07-25 15:57:29,546 INFO [STDOUT] PortletLog|1|7/25/06|15:57:29:546|
WfDbAccess - org.hibernate.TransactionException: JTA commit failed:
2006-07-25 15:57:29,546 INFO [STDOUT] PortletLog|1|7/25/06|15:57:29:546|
WfDbAccess - createNewWorkflow - EXIT
2006-07-25 15:57:29,562 INFO [STDOUT] PortletLog|1|7/25/06|15:57:29:562|
PersonnelActionManagement - processCommitBatch - EXIT
2006-07-25 15:57:29,562 INFO [STDOUT] PortletLog|1|7/25/06|15:57:29:562|
PersonnelActionManagement - processAction - EXIT
2006-07-25 15:57:29,562 INFO [STDOUT] PortletLog|1|7/25/06|15:57:29:562|
OagWfPersonnelActionPortlet - processAction - EXIT