-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 3 posts ] 
Author Message
 Post subject: optimistic-lock="dirty" causing ORA-01008: not all
PostPosted: Fri Aug 20, 2004 2:55 pm 
Newbie

Joined: Mon Mar 08, 2004 8:57 pm
Posts: 6
Hibernate version: 2.1.6

Mapping documents:
<?xml version="1.0"?>

<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 2.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">

<hibernate-mapping>
<class
name="com.frontiercorp.bss.cap.eso.hibernate.State"
table="STATE"
schema="ESOMGR"
dynamic-update="true"
optimistic-lock="dirty"
>

<id
name="state"
column="STATE"
type="java.lang.String"
>
<generator class="assigned">
</generator>
</id>

<property
name="stateName"
type="java.lang.String"
column="STATE_NAME"
not-null="true"
/>

<property
name="createdBy"
type="java.lang.String"
column="CREATED_BY"
not-null="true"
/>

<property
name="createdDate"
type="java.util.Date"
column="CREATED_DATE"
not-null="true"
/>

<property
name="modifiedBy"
type="java.lang.String"
column="MODIFIED_BY"
/>

<property
name="modifiedDate"
type="java.util.Date"
column="MODIFIED_DATE"
/>

<property
name="activeInd"
type="java.lang.String"
column="ACTIVE_IND"
not-null="true"
/>

<!--
To add non XDoclet property mappings, create a file named
hibernate-properties-State.xml
containing the additional properties and place it in your merge dir.
-->

</class>

</hibernate-mapping>


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

Full stack trace of any exception that occurs:

Name and version of the database you are using:Oracle 8i

Debug level Hibernate log excerpt:

11:47:44,888 DEBUG [cap.core.hibernate.HibernateUtil] find() HQL: FROM State st ORDER BY st.state
11:47:44,966 DEBUG [net.sf.hibernate.impl.SessionImpl] opened session
11:47:44,966 DEBUG [net.sf.hibernate.impl.SessionImpl] find: FROM State st ORDER BY st.state
11:47:44,982 DEBUG [net.sf.hibernate.hql.QueryTranslator] compiling query
11:47:45,013 DEBUG [net.sf.hibernate.impl.SessionImpl] flushing session
11:47:45,013 DEBUG [net.sf.hibernate.impl.SessionImpl] Flushing entities and processing referenced collections
11:47:45,013 DEBUG [net.sf.hibernate.impl.SessionImpl] Processing unreferenced collections
11:47:45,013 DEBUG [net.sf.hibernate.impl.SessionImpl] Scheduling collection removes/(re)creates/updates
11:47:45,013 DEBUG [net.sf.hibernate.impl.SessionImpl] Flushed: 0 insertions, 0 updates, 0 deletions to 0 objects
11:47:45,013 DEBUG [net.sf.hibernate.impl.SessionImpl] Flushed: 0 (re)creations, 0 updates, 0 removals to 0 collections
11:47:45,013 DEBUG [net.sf.hibernate.impl.SessionImpl] Dont need to execute flush
11:47:45,013 DEBUG [net.sf.hibernate.hql.QueryTranslator] HQL: FROM com.frontiercorp.bss.cap.eso.hibernate.State st ORDER BY st.state
11:47:45,029 DEBUG [net.sf.hibernate.hql.QueryTranslator] SQL: select state0_.STATE as STATE, state0_.STATE_NAME as STATE_NAME, state0_.CREAT
ED_BY as CREATED_BY, state0_.CREATED_DATE as CREATED_4_, state0_.MODIFIED_BY as MODIFIED5_, state0_.MODIFIED_DATE as MODIFIED6_, state0_.ACTI
VE_IND as ACTIVE_IND from ESOMGR.STATE state0_ order by state0_.STATE
11:47:45,029 DEBUG [net.sf.hibernate.impl.BatcherImpl] about to open: 0 open PreparedStatements, 0 open ResultSets
11:47:45,029 DEBUG [net.sf.hibernate.SQL] select state0_.STATE as STATE, state0_.STATE_NAME as STATE_NAME, state0_.CREATED_BY as CREATED_BY,
state0_.CREATED_DATE as CREATED_4_, state0_.MODIFIED_BY as MODIFIED5_, state0_.MODIFIED_DATE as MODIFIED6_, state0_.ACTIVE_IND as ACTIVE_IND
from ESOMGR.STATE state0_ order by state0_.STATE
11:47:45,029 INFO [STDOUT] Hibernate: select state0_.STATE as STATE, state0_.STATE_NAME as STATE_NAME, state0_.CREATED_BY as CREATED_BY, sta
te0_.CREATED_DATE as CREATED_4_, state0_.MODIFIED_BY as MODIFIED5_, state0_.MODIFIED_DATE as MODIFIED6_, state0_.ACTIVE_IND as ACTIVE_IND fro
m ESOMGR.STATE state0_ order by state0_.STATE
11:47:45,029 DEBUG [net.sf.hibernate.impl.BatcherImpl] preparing statement
11:47:45,326 DEBUG [net.sf.hibernate.loader.Loader] processing result set
11:47:45,326 DEBUG [net.sf.hibernate.type.StringType] returning 'AZ' as column: STATE
11:47:45,326 DEBUG [net.sf.hibernate.loader.Loader] result row: AZ
11:47:45,326 DEBUG [net.sf.hibernate.loader.Loader] Initializing object from ResultSet: AZ
11:47:45,326 DEBUG [net.sf.hibernate.loader.Loader] Hydrating entity: com.frontiercorp.bss.cap.eso.hibernate.State#AZ
11:47:45,326 DEBUG [net.sf.hibernate.type.StringType] returning 'Arizona' as column: STATE_NAME
11:47:45,326 DEBUG [net.sf.hibernate.type.StringType] returning 'xxxx' as column: CREATED_BY
11:47:45,341 DEBUG [net.sf.hibernate.type.TimestampType] returning '2004-08-04 10:05:03' as column: CREATED_4_
11:47:45,341 DEBUG [net.sf.hibernate.type.StringType] returning 'xxxx' as column: MODIFIED5_
11:47:45,341 DEBUG [net.sf.hibernate.type.TimestampType] returning '2004-08-18 14:13:05' as column: MODIFIED6_
11:47:45,341 DEBUG [net.sf.hibernate.type.StringType] returning 'Y' as column: ACTIVE_IND
11:47:45,341 DEBUG [net.sf.hibernate.type.StringType] returning 'CA' as column: STATE
11:47:45,341 DEBUG [net.sf.hibernate.loader.Loader] result row: CA
11:47:45,341 DEBUG [net.sf.hibernate.loader.Loader] Initializing object from ResultSet: CA
11:47:45,341 DEBUG [net.sf.hibernate.loader.Loader] Hydrating entity: com.frontiercorp.bss.cap.eso.hibernate.State#CA
11:47:45,341 DEBUG [net.sf.hibernate.type.StringType] returning 'California' as column: STATE_NAME
11:47:45,357 DEBUG [net.sf.hibernate.type.StringType] returning 'xxxx' as column: CREATED_BY
11:47:45,357 DEBUG [net.sf.hibernate.type.TimestampType] returning '2004-08-04 10:04:44' as column: CREATED_4_
11:47:45,357 DEBUG [net.sf.hibernate.type.StringType] returning null as column: MODIFIED5_
11:47:45,357 DEBUG [net.sf.hibernate.type.TimestampType] returning null as column: MODIFIED6_
11:47:45,357 DEBUG [net.sf.hibernate.type.StringType] returning 'Y' as column: ACTIVE_IND
11:47:45,357 DEBUG [net.sf.hibernate.type.StringType] returning 'EU' as column: STATE
11:47:45,357 DEBUG [net.sf.hibernate.loader.Loader] result row: EU
11:47:45,357 DEBUG [net.sf.hibernate.loader.Loader] Initializing object from ResultSet: EU
11:47:45,357 DEBUG [net.sf.hibernate.loader.Loader] Hydrating entity: com.frontiercorp.bss.cap.eso.hibernate.State#EU
11:47:45,357 DEBUG [net.sf.hibernate.type.StringType] returning 'Euphoria' as column: STATE_NAME
11:47:45,357 DEBUG [net.sf.hibernate.type.StringType] returning 'xxxx' as column: CREATED_BY
11:47:45,373 DEBUG [net.sf.hibernate.type.TimestampType] returning '2004-08-09 16:23:44' as column: CREATED_4_
11:47:45,373 DEBUG [net.sf.hibernate.type.StringType] returning null as column: MODIFIED5_
11:47:45,373 DEBUG [net.sf.hibernate.type.TimestampType] returning null as column: MODIFIED6_
11:47:45,373 DEBUG [net.sf.hibernate.type.StringType] returning 'Y' as column: ACTIVE_IND
11:47:45,373 DEBUG [net.sf.hibernate.type.StringType] returning 'ID' as column: STATE
11:47:45,373 DEBUG [net.sf.hibernate.loader.Loader] result row: ID
11:47:45,373 DEBUG [net.sf.hibernate.loader.Loader] Initializing object from ResultSet: ID
11:47:45,373 DEBUG [net.sf.hibernate.loader.Loader] Hydrating entity: com.frontiercorp.bss.cap.eso.hibernate.State#ID
11:47:45,373 DEBUG [net.sf.hibernate.type.StringType] returning 'Idaho' as column: STATE_NAME
11:47:45,373 DEBUG [net.sf.hibernate.type.StringType] returning 'xxxx' as column: CREATED_BY
11:47:45,373 DEBUG [net.sf.hibernate.type.TimestampType] returning '2004-08-04 10:04:21' as column: CREATED_4_
11:47:45,373 DEBUG [net.sf.hibernate.type.StringType] returning null as column: MODIFIED5_
11:47:45,388 DEBUG [net.sf.hibernate.type.TimestampType] returning null as column: MODIFIED6_
11:47:45,388 DEBUG [net.sf.hibernate.type.StringType] returning 'Y' as column: ACTIVE_IND
11:47:45,388 DEBUG [net.sf.hibernate.type.StringType] returning 'NV' as column: STATE
11:47:45,388 DEBUG [net.sf.hibernate.loader.Loader] result row: NV
11:47:45,388 DEBUG [net.sf.hibernate.loader.Loader] Initializing object from ResultSet: NV
11:47:45,388 DEBUG [net.sf.hibernate.loader.Loader] Hydrating entity: com.frontiercorp.bss.cap.eso.hibernate.State#NV
11:47:45,388 DEBUG [net.sf.hibernate.type.StringType] returning 'Navada' as column: STATE_NAME
11:47:45,388 DEBUG [net.sf.hibernate.type.StringType] returning 'xxxxxx' as column: CREATED_BY
11:47:45,388 DEBUG [net.sf.hibernate.type.TimestampType] returning '2004-08-09 09:43:51' as column: CREATED_4_
11:47:45,388 DEBUG [net.sf.hibernate.type.StringType] returning null as column: MODIFIED5_
11:47:45,388 DEBUG [net.sf.hibernate.type.TimestampType] returning null as column: MODIFIED6_
11:47:45,388 DEBUG [net.sf.hibernate.type.StringType] returning 'Y' as column: ACTIVE_IND
11:47:45,388 DEBUG [net.sf.hibernate.type.StringType] returning 'OR' as column: STATE
11:47:45,404 DEBUG [net.sf.hibernate.loader.Loader] result row: OR
11:47:45,404 DEBUG [net.sf.hibernate.loader.Loader] Initializing object from ResultSet: OR
11:47:45,404 DEBUG [net.sf.hibernate.loader.Loader] Hydrating entity: com.frontiercorp.bss.cap.eso.hibernate.State#OR
11:47:45,404 DEBUG [net.sf.hibernate.type.StringType] returning 'Oregon' as column: STATE_NAME
11:47:45,404 DEBUG [net.sf.hibernate.type.StringType] returning 'xxxxx' as column: CREATED_BY
11:47:45,404 DEBUG [net.sf.hibernate.type.TimestampType] returning '2004-08-03 14:55:00' as column: CREATED_4_
11:47:45,404 DEBUG [net.sf.hibernate.type.StringType] returning null as column: MODIFIED5_
11:47:45,404 DEBUG [net.sf.hibernate.type.TimestampType] returning null as column: MODIFIED6_
11:47:45,404 DEBUG [net.sf.hibernate.type.StringType] returning 'Y' as column: ACTIVE_IND
11:47:45,404 DEBUG [net.sf.hibernate.type.StringType] returning 'WA' as column: STATE
11:47:45,404 DEBUG [net.sf.hibernate.loader.Loader] result row: WA
11:47:45,404 DEBUG [net.sf.hibernate.loader.Loader] Initializing object from ResultSet: WA
11:47:45,404 DEBUG [net.sf.hibernate.loader.Loader] Hydrating entity: com.frontiercorp.bss.cap.eso.hibernate.State#WA
11:47:45,420 DEBUG [net.sf.hibernate.type.StringType] returning 'Washington' as column: STATE_NAME
11:47:45,420 DEBUG [net.sf.hibernate.type.StringType] returning 'xxxxx' as column: CREATED_BY
11:47:45,420 DEBUG [net.sf.hibernate.type.TimestampType] returning '2004-08-03 14:55:00' as column: CREATED_4_
11:47:45,420 DEBUG [net.sf.hibernate.type.StringType] returning 'xxxxxx' as column: MODIFIED5_
11:47:45,420 DEBUG [net.sf.hibernate.type.TimestampType] returning '2004-08-09 16:23:49' as column: MODIFIED6_
11:47:45,420 DEBUG [net.sf.hibernate.type.StringType] returning 'Y' as column: ACTIVE_IND
11:47:45,498 DEBUG [net.sf.hibernate.loader.Loader] done processing result set (7 rows)
11:47:45,498 DEBUG [net.sf.hibernate.impl.BatcherImpl] done closing: 0 open PreparedStatements, 0 open ResultSets
11:47:45,498 DEBUG [net.sf.hibernate.impl.BatcherImpl] closing statement
11:47:45,560 DEBUG [net.sf.hibernate.loader.Loader] total objects hydrated: 7
11:47:45,560 DEBUG [net.sf.hibernate.impl.SessionImpl] resolving associations for [com.frontiercorp.bss.cap.eso.hibernate.State#AZ]
11:47:45,560 DEBUG [net.sf.hibernate.impl.SessionImpl] done materializing entity [com.frontiercorp.bss.cap.eso.hibernate.State#AZ]
11:47:45,560 DEBUG [net.sf.hibernate.impl.SessionImpl] resolving associations for [com.frontiercorp.bss.cap.eso.hibernate.State#CA]
11:47:45,576 DEBUG [net.sf.hibernate.impl.SessionImpl] done materializing entity [com.frontiercorp.bss.cap.eso.hibernate.State#CA]
11:47:45,576 DEBUG [net.sf.hibernate.impl.SessionImpl] resolving associations for [com.frontiercorp.bss.cap.eso.hibernate.State#EU]
11:47:45,576 DEBUG [net.sf.hibernate.impl.SessionImpl] done materializing entity [com.frontiercorp.bss.cap.eso.hibernate.State#EU]
11:47:45,576 DEBUG [net.sf.hibernate.impl.SessionImpl] resolving associations for [com.frontiercorp.bss.cap.eso.hibernate.State#ID]
11:47:45,576 DEBUG [net.sf.hibernate.impl.SessionImpl] done materializing entity [com.frontiercorp.bss.cap.eso.hibernate.State#ID]
11:47:45,576 DEBUG [net.sf.hibernate.impl.SessionImpl] resolving associations for [com.frontiercorp.bss.cap.eso.hibernate.State#NV]
11:47:45,576 DEBUG [net.sf.hibernate.impl.SessionImpl] done materializing entity [com.frontiercorp.bss.cap.eso.hibernate.State#NV]
11:47:45,576 DEBUG [net.sf.hibernate.impl.SessionImpl] resolving associations for [com.frontiercorp.bss.cap.eso.hibernate.State#OR]
11:47:45,576 DEBUG [net.sf.hibernate.impl.SessionImpl] done materializing entity [com.frontiercorp.bss.cap.eso.hibernate.State#OR]
11:47:45,576 DEBUG [net.sf.hibernate.impl.SessionImpl] resolving associations for [com.frontiercorp.bss.cap.eso.hibernate.State#WA]
11:47:45,576 DEBUG [net.sf.hibernate.impl.SessionImpl] done materializing entity [com.frontiercorp.bss.cap.eso.hibernate.State#WA]
11:47:45,576 DEBUG [net.sf.hibernate.impl.SessionImpl] initializing non-lazy collections
11:47:47,935 DEBUG [net.sf.hibernate.impl.SessionImpl] closing session
11:47:47,935 DEBUG [net.sf.hibernate.impl.SessionImpl] disconnecting session
11:47:47,951 DEBUG [net.sf.hibernate.impl.SessionImpl] transaction completion
11:48:26,968 DEBUG [net.sf.hibernate.impl.SessionImpl] running Session.finalize()
11:48:39,094 DEBUG [cap.eso.busobj.StateObj] applyUpdate() submitSource is apply
11:48:39,094 DEBUG [net.sf.hibernate.impl.SessionImpl] opened session
11:48:39,094 DEBUG [net.sf.hibernate.transaction.JTATransaction] Looking for UserTransaction under: UserTransaction
11:48:39,109 DEBUG [net.sf.hibernate.transaction.JTATransaction] Obtained UserTransaction
11:48:39,109 DEBUG [net.sf.hibernate.transaction.JTATransaction] beginning new transaction
11:48:39,125 DEBUG [cap.core.hibernate.HibernateUtil] lock(): com.frontiercorp.bss.cap.eso.hibernate.State@d4694f[state=AZ]
11:48:39,125 DEBUG [net.sf.hibernate.engine.Cascades] id unsaved-value strategy NULL
11:48:39,140 DEBUG [net.sf.hibernate.impl.SessionImpl] reassociating transient instance: [com.frontiercorp.bss.cap.eso.hibernate.State#AZ]
11:48:39,140 DEBUG [cap.core.hibernate.HibernateUtil] lock(): com.frontiercorp.bss.cap.eso.hibernate.State@f61227[state=CA]
11:48:39,140 DEBUG [net.sf.hibernate.engine.Cascades] id unsaved-value strategy NULL
11:48:39,156 DEBUG [net.sf.hibernate.impl.SessionImpl] reassociating transient instance: [com.frontiercorp.bss.cap.eso.hibernate.State#CA]
11:48:39,156 DEBUG [cap.core.hibernate.HibernateUtil] lock(): com.frontiercorp.bss.cap.eso.hibernate.State@121dba8[state=EU]
11:48:39,156 DEBUG [net.sf.hibernate.engine.Cascades] id unsaved-value strategy NULL
11:48:39,156 DEBUG [net.sf.hibernate.impl.SessionImpl] reassociating transient instance: [com.frontiercorp.bss.cap.eso.hibernate.State#EU]
11:48:39,156 DEBUG [cap.core.hibernate.HibernateUtil] lock(): com.frontiercorp.bss.cap.eso.hibernate.State@1dc049d[state=ID]
11:48:39,172 DEBUG [net.sf.hibernate.engine.Cascades] id unsaved-value strategy NULL
11:48:39,172 DEBUG [net.sf.hibernate.impl.SessionImpl] reassociating transient instance: [com.frontiercorp.bss.cap.eso.hibernate.State#ID]
11:48:39,172 DEBUG [cap.core.hibernate.HibernateUtil] lock(): com.frontiercorp.bss.cap.eso.hibernate.State@1b2e165[state=NV]
11:48:39,172 DEBUG [net.sf.hibernate.engine.Cascades] id unsaved-value strategy NULL
11:48:39,187 DEBUG [net.sf.hibernate.impl.SessionImpl] reassociating transient instance: [com.frontiercorp.bss.cap.eso.hibernate.State#NV]
11:48:39,187 DEBUG [cap.core.hibernate.HibernateUtil] lock(): com.frontiercorp.bss.cap.eso.hibernate.State@ebdfff[state=OR]
11:48:39,187 DEBUG [net.sf.hibernate.engine.Cascades] id unsaved-value strategy NULL
11:48:39,187 DEBUG [net.sf.hibernate.impl.SessionImpl] reassociating transient instance: [com.frontiercorp.bss.cap.eso.hibernate.State#OR]
11:48:39,187 DEBUG [cap.core.hibernate.HibernateUtil] lock(): com.frontiercorp.bss.cap.eso.hibernate.State@1bef24f[state=WA]
11:48:39,203 DEBUG [net.sf.hibernate.engine.Cascades] id unsaved-value strategy NULL
11:48:39,203 DEBUG [net.sf.hibernate.impl.SessionImpl] reassociating transient instance: [com.frontiercorp.bss.cap.eso.hibernate.State#WA]
11:48:39,203 DEBUG [cap.core.hibernate.HibernateUtil] update() hibernateClass: com.frontiercorp.bss.cap.eso.hibernate.State@1bef24f[state=WA]

11:48:39,219 DEBUG [net.sf.hibernate.impl.SessionImpl] object already associated with session
11:48:39,219 DEBUG [net.sf.hibernate.impl.SessionImpl] flushing session
11:48:39,219 DEBUG [net.sf.hibernate.impl.SessionImpl] Flushing entities and processing referenced collections
11:48:39,219 DEBUG [net.sf.hibernate.persister.AbstractEntityPersister] com.frontiercorp.bss.cap.eso.hibernate.State.activeInd is dirty
11:48:39,234 DEBUG [net.sf.hibernate.impl.SessionImpl] Updating entity: [com.frontiercorp.bss.cap.eso.hibernate.State#WA]
11:48:39,234 DEBUG [net.sf.hibernate.impl.SessionImpl] Processing unreferenced collections
11:48:39,234 DEBUG [net.sf.hibernate.impl.SessionImpl] Scheduling collection removes/(re)creates/updates
11:48:39,234 DEBUG [net.sf.hibernate.impl.SessionImpl] Flushed: 0 insertions, 1 updates, 0 deletions to 7 objects
11:48:39,250 DEBUG [net.sf.hibernate.impl.SessionImpl] Flushed: 0 (re)creations, 0 updates, 0 removals to 0 collections
11:48:39,250 DEBUG [net.sf.hibernate.impl.Printer] listing entities:
11:48:39,250 DEBUG [net.sf.hibernate.impl.Printer] com.frontiercorp.bss.cap.eso.hibernate.State{createdDate=2004-08-03 14:55:00, activeInd=N,
modifiedBy=xxxxx, modifiedDate=2004-08-09 16:23:49, createdBy=xxxxxx, stateName=Washington, state=WA}
11:48:39,265 DEBUG [net.sf.hibernate.impl.Printer] com.frontiercorp.bss.cap.eso.hibernate.State{createdDate=2004-08-03 14:55:00, activeInd=Y,
modifiedBy=null, modifiedDate=null, createdBy=xxxxx, stateName=Oregon, state=OR}
11:48:39,265 DEBUG [net.sf.hibernate.impl.Printer] com.frontiercorp.bss.cap.eso.hibernate.State{createdDate=2004-08-04 10:04:21, activeInd=Y,
modifiedBy=null, modifiedDate=null, createdBy=xxxxx, stateName=Idaho, state=ID}
11:48:39,265 DEBUG [net.sf.hibernate.impl.Printer] com.frontiercorp.bss.cap.eso.hibernate.State{createdDate=2004-08-09 16:23:44, activeInd=Y,
modifiedBy=null, modifiedDate=null, createdBy=xxxxxx, stateName=Euphoria, state=EU}
11:48:39,281 DEBUG [net.sf.hibernate.impl.Printer] com.frontiercorp.bss.cap.eso.hibernate.State{createdDate=2004-08-04 10:05:03, activeInd=Y,
modifiedBy=xxxxx, modifiedDate=2004-08-18 14:13:05, createdBy=xxxxx, stateName=Arizona, state=AZ}
11:48:39,281 DEBUG [net.sf.hibernate.impl.Printer] com.frontiercorp.bss.cap.eso.hibernate.State{createdDate=2004-08-09 09:43:51, activeInd=Y,
modifiedBy=null, modifiedDate=null, createdBy=xxxxxx, stateName=Navada, state=NV}
11:48:39,297 DEBUG [net.sf.hibernate.impl.Printer] com.frontiercorp.bss.cap.eso.hibernate.State{createdDate=2004-08-04 10:04:44, activeInd=Y,
modifiedBy=null, modifiedDate=null, createdBy=xxxxxx, stateName=California, state=CA}
11:48:39,297 DEBUG [net.sf.hibernate.impl.SessionImpl] executing flush
11:48:39,312 DEBUG [net.sf.hibernate.persister.EntityPersister] Updating entity: [com.frontiercorp.bss.cap.eso.hibernate.State#WA]
11:48:39,312 DEBUG [net.sf.hibernate.impl.BatcherImpl] about to open: 0 open PreparedStatements, 0 open ResultSets
11:48:39,375 DEBUG [net.sf.hibernate.SQL] update ESOMGR.STATE set ACTIVE_IND=? where STATE=? and ACTIVE_IND=?
11:48:39,390 INFO [STDOUT] Hibernate: update ESOMGR.STATE set ACTIVE_IND=? where STATE=? and ACTIVE_IND=?
11:48:39,390 DEBUG [net.sf.hibernate.impl.BatcherImpl] preparing statement
11:48:39,469 DEBUG [net.sf.hibernate.persister.EntityPersister] Dehydrating entity: [com.frontiercorp.bss.cap.eso.hibernate.State#WA]
11:48:39,469 DEBUG [net.sf.hibernate.type.StringType] binding 'N' to parameter: 1
11:48:39,469 DEBUG [net.sf.hibernate.type.StringType] binding 'WA' to parameter: 2
11:48:39,469 DEBUG [net.sf.hibernate.impl.BatcherImpl] Adding to batch
11:48:39,484 DEBUG [net.sf.hibernate.impl.BatcherImpl] Executing batch size: 1
11:48:39,640 DEBUG [net.sf.hibernate.util.JDBCExceptionReporter] SQL Exception
java.sql.BatchUpdateException: ORA-01008: not all variables bound

at oracle.jdbc.dbaccess.DBError.throwBatchUpdateException(DBError.java:441)
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:3364)
at org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:701)
at net.sf.hibernate.impl.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:54)
at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:126)
at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2421)
at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2372)
at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2240)
at com.frontiercorp.bss.cap.core.hibernate.HibernateUtil.update(HibernateUtil.java:150)
at com.frontiercorp.bss.cap.eso.busobj.StateObj.applyUpdate(StateObj.java:239)
at com.frontiercorp.bss.cap.eso.web.action.StateAction.apply(StateAction.java:83)
at com.frontiercorp.bss.cap.eso.web.action.MaintainTableAction.performAction(MaintainTableAction.java:58)
at com.frontiercorp.bss.cap.core.web.BaseStrutsAction.perform(Unknown Source)
at org.apache.struts.action.Action.execute(Action.java:420)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at com.frontiercorp.bss.cap.core.hibernate.HibernateServletFilter.doFilter(HibernateServletFilter.java:76)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at com.frontiercorp.bss.cap.core.SystemServletFilter.doFilter(SystemServletFilter.java:124)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.jboss.web.tomcat.security.JBossSecurityMgrRealm.invoke(JBossSecurityMgrRealm.java:220)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:553)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.jboss.web.tomcat.tc4.statistics.ContainerStatsValve.invoke(ContainerStatsValve.java:76)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2416)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:65)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:577)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:601)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:392)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619)
at java.lang.Thread.run(Thread.java:534)
11:48:39,844 WARN [net.sf.hibernate.util.JDBCExceptionReporter] SQL Error: 1008, SQLState: 72000
11:48:39,844 ERROR [net.sf.hibernate.util.JDBCExceptionReporter] ORA-01008: not all variables bound

11:48:39,844 WARN [net.sf.hibernate.util.JDBCExceptionReporter] SQL Error: 1008, SQLState: 72000
11:48:39,859 ERROR [net.sf.hibernate.util.JDBCExceptionReporter] ORA-01008: not all variables bound

11:48:39,859 DEBUG [net.sf.hibernate.impl.BatcherImpl] done closing: 0 open PreparedStatements, 0 open ResultSets
11:48:39,859 DEBUG [net.sf.hibernate.impl.BatcherImpl] closing statement
11:48:39,937 DEBUG [net.sf.hibernate.util.JDBCExceptionReporter] SQL Exception
java.sql.BatchUpdateException: ORA-01008: not all variables bound

at oracle.jdbc.dbaccess.DBError.throwBatchUpdateException(DBError.java:441)
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:3364)
at org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:701)
at net.sf.hibernate.impl.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:54)
at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:126)
at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2421)
at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2372)
at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2240)
at com.frontiercorp.bss.cap.core.hibernate.HibernateUtil.update(HibernateUtil.java:150)
at com.frontiercorp.bss.cap.eso.busobj.StateObj.applyUpdate(StateObj.java:239)
at com.frontiercorp.bss.cap.eso.web.action.StateAction.apply(StateAction.java:83)
at com.frontiercorp.bss.cap.eso.web.action.MaintainTableAction.performAction(MaintainTableAction.java:58)
at com.frontiercorp.bss.cap.core.web.BaseStrutsAction.perform(Unknown Source)
at org.apache.struts.action.Action.execute(Action.java:420)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at com.frontiercorp.bss.cap.core.hibernate.HibernateServletFilter.doFilter(HibernateServletFilter.java:76)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at com.frontiercorp.bss.cap.core.SystemServletFilter.doFilter(SystemServletFilter.java:124)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.jboss.web.tomcat.security.JBossSecurityMgrRealm.invoke(JBossSecurityMgrRealm.java:220)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:553)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.jboss.web.tomcat.tc4.statistics.ContainerStatsValve.invoke(ContainerStatsValve.java:76)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2416)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:65)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:577)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:601)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:392)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619)
at java.lang.Thread.run(Thread.java:534)
11:48:40,109 WARN [net.sf.hibernate.util.JDBCExceptionReporter] SQL Error: 1008, SQLState: 72000
11:48:40,109 ERROR [net.sf.hibernate.util.JDBCExceptionReporter] ORA-01008: not all variables bound

11:48:40,125 WARN [net.sf.hibernate.util.JDBCExceptionReporter] SQL Error: 1008, SQLState: 72000
11:48:40,125 ERROR [net.sf.hibernate.util.JDBCExceptionReporter] ORA-01008: not all variables bound

11:48:40,125 ERROR [net.sf.hibernate.util.JDBCExceptionReporter] Could not execute JDBC batch update
java.sql.BatchUpdateException: ORA-01008: not all variables bound

at oracle.jdbc.dbaccess.DBError.throwBatchUpdateException(DBError.java:441)
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:3364)
at org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:701)
at net.sf.hibernate.impl.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:54)
at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:126)
at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2421)
at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2372)
at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2240)
at com.frontiercorp.bss.cap.core.hibernate.HibernateUtil.update(HibernateUtil.java:150)
at com.frontiercorp.bss.cap.eso.busobj.StateObj.applyUpdate(StateObj.java:239)
at com.frontiercorp.bss.cap.eso.web.action.StateAction.apply(StateAction.java:83)
at com.frontiercorp.bss.cap.eso.web.action.MaintainTableAction.performAction(MaintainTableAction.java:58)
at com.frontiercorp.bss.cap.core.web.BaseStrutsAction.perform(Unknown Source)
at org.apache.struts.action.Action.execute(Action.java:420)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at com.frontiercorp.bss.cap.core.hibernate.HibernateServletFilter.doFilter(HibernateServletFilter.java:76)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at com.frontiercorp.bss.cap.core.SystemServletFilter.doFilter(SystemServletFilter.java:124)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.jboss.web.tomcat.security.JBossSecurityMgrRealm.invoke(JBossSecurityMgrRealm.java:220)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:553)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.jboss.web.tomcat.tc4.statistics.ContainerStatsValve.invoke(ContainerStatsValve.java:76)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2416)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:65)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:577)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:601)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:392)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619)
at java.lang.Thread.run(Thread.java:534)
11:48:40,297 ERROR [net.sf.hibernate.impl.SessionImpl] Could not synchronize database state with session
net.sf.hibernate.JDBCException: Could not execute JDBC batch update
at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:133)
at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2421)
at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2372)
at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2240)
at com.frontiercorp.bss.cap.core.hibernate.HibernateUtil.update(HibernateUtil.java:150)
at com.frontiercorp.bss.cap.eso.busobj.StateObj.applyUpdate(StateObj.java:239)
at com.frontiercorp.bss.cap.eso.web.action.StateAction.apply(StateAction.java:83)
at com.frontiercorp.bss.cap.eso.web.action.MaintainTableAction.performAction(MaintainTableAction.java:58)
at com.frontiercorp.bss.cap.core.web.BaseStrutsAction.perform(Unknown Source)
at org.apache.struts.action.Action.execute(Action.java:420)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at com.frontiercorp.bss.cap.core.hibernate.HibernateServletFilter.doFilter(HibernateServletFilter.java:76)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at com.frontiercorp.bss.cap.core.SystemServletFilter.doFilter(SystemServletFilter.java:124)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.jboss.web.tomcat.security.JBossSecurityMgrRealm.invoke(JBossSecurityMgrRealm.java:220)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:553)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.jboss.web.tomcat.tc4.statistics.ContainerStatsValve.invoke(ContainerStatsValve.java:76)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2416)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:65)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:577)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:601)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:392)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619)
at java.lang.Thread.run(Thread.java:534)
Caused by: java.sql.BatchUpdateException: ORA-01008: not all variables bound

at oracle.jdbc.dbaccess.DBError.throwBatchUpdateException(DBError.java:441)
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:3364)
at org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:701)
at net.sf.hibernate.impl.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:54)
at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:126)
... 62 more
11:48:40,469 INFO [cap.eso.busobj.StateObj] JDBCException: 1008,72000, java.sql.BatchUpdateException: ORA-01008: not all variables bound

11:48:40,484 ERROR [cap.eso.busobj.StateObj] rolling back transaction
11:48:40,484 DEBUG [net.sf.hibernate.transaction.JTATransaction] rollback
11:48:40,547 DEBUG [net.sf.hibernate.impl.SessionImpl] transaction completion
11:48:40,562 DEBUG [net.sf.hibernate.impl.SessionImpl] closing session
11:48:40,562 DEBUG [net.sf.hibernate.impl.SessionImpl] disconnecting session
11:48:40,562 DEBUG [net.sf.hibernate.impl.SessionImpl] transaction completion


Top
 Profile  
 
 Post subject: Found problem
PostPosted: Fri Aug 20, 2004 5:41 pm 
Newbie

Joined: Mon Mar 08, 2004 8:57 pm
Posts: 6
It seems that the change identified as "added support for enabling batching of versioned data (configurable)" in version 2.1.5 is the culprit. Before, even if the entity was not versioned, if the optimistic-lock="dirty" was used, it would supply the changed fields in the where clause. Now, it will only do this if the class uses the version attribute. It would be great to have this feature back. With legacy database tables, I can't just use the primary key in the where clause for updating, I need to make sure the data hasn't been changed by someone else.


Top
 Profile  
 
 Post subject:
PostPosted: Fri Aug 20, 2004 8:02 pm 
Hibernate Team
Hibernate Team

Joined: Tue Aug 26, 2003 12:50 pm
Posts: 5130
Location: Melbourne, Australia
Thanks, fixed in CVS.


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 3 posts ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.