-->
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.

View unanswered posts | View active topics


Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]


Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 1 post ] 
  Previous topic | Next topic 
Author Message
arnieAustin
 Post subject: Why do an update after a read?
PostPosted: Tue Jan 17, 2006 6:46 pm 
Beginner
Beginner

Joined: Thu Jan 12, 2006 6:32 pm
Posts: 39
Location: Austin, Tx, USA, NA, Sol 3
Hibernate version: 3.1.0

Mapping documents:

JBoss Service File

<?xml version="1.0" encoding="UTF-8"?>
<server>
<mbean code="org.jboss.hibernate.jmx.Hibernate" name="jboss.har:service=Hibernate"> -->
<!-- datasource settings -->
<attribute name="DatasourceName">java:/appsec</attribute>
<attribute name="Dialect">org.hibernate.dialect.SybaseDialect</attribute>

<!-- bind the hibernate service to jndi -->
<attribute name="SessionFactoryName">java:/hibernate/txoagPortalSessionFactory</attribute>

<attribute name="CacheProviderClass">org.hibernate.cache.HashtableCacheProvider</attribute>

<!-- logging -->
<attribute name="ShowSqlEnabled">true</attribute>
</mbean>
</server>
Mapping File
<?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.AppSecMgmt.Info_User_Table"
table="info_users" entity-name="Info_Users">

<id name="userID"
type="big_decimal" column="user_id" unsaved-value="null">
<generator class="select">
<param name="key">CN</param>
</generator>
</id>
<property name="userCN" column="user_cn" type="string" update="false" insert="false"/>
<property name="isActive" column="is_active" type="integer" update="true" insert="true"/>
<property name="isDeployed" column="is_deployed" type="integer" update="true" insert="true"/>
<property name="isEmployee" column="is_employee" type="integer" update="true" insert="true"/>
<property name="dateEffective" column="dt_eff" type="date" update="true" insert="true"/>
<property name="dateInactive" column="dt_inactive" type="date" update="true" insert="true"/>
<property name="employeeID" column="emplid" type="string" update="true" insert="true"/>
<property name="firstName" column="first_name" type="string" update="true" insert="true"/>
<property name="lastName" column="last_name" type="string" update="true" insert="true"/>
<property name="title" column="title" type="string" update="true" insert="true"/>
<property name="crUser" column="cr_user" type="string" update="true" insert="true"/>
<property name="crDate" column="cr_date" type="date" update="true" insert="true"/>
<property name="upUser" column="up_user" type="string" update="true" insert="true"/>
<property name="upDate" column="up_date" type="date" update="true" insert="true"/>

<!-- note: named parameters are not supported in SP call syntax.
though Hibernate recommends using the named parameter
approach, it isn't supported here as of 3.1.0 -->
<sql-query name="users_find">
<return class="Info_Users"> <!-- matches the entity-name above -->
<return-property name="userID" column="user_id"/>
<return-property name="userCN" column="user_cn"/>
<return-property name="employeeID" column="emplid"/>
<return-property name="firstName" column="first_name"/>
<return-property name="lastName" column="last_name"/>
</return>
{ call info_users_find_spr ( ?,?,?,?, ?,?,? ) }
</sql-query>

<sql-query name="user_read" callable="true">
<return class="Info_Users"> <!-- matches the entity-name above -->
<return-property name="userID" column="user_id"/>
<return-property name="userCN" column="user_cn"/>
<return-property name="isActive" column="is_active"/>
<return-property name="isDeployed" column="is_deployed"/>
<return-property name="isEmployee" column="is_employee"/>
<return-property name="dateEffective" column="dt_eff"/>
<return-property name="dateInactive" column="dt_inactive"/>
<return-property name="employeeID" column="emplid"/>
<return-property name="firstName" column="first_name"/>
<return-property name="lastName" column="last_name"/>
<return-property name="title" column="title"/>
<return-property name="crUser" column="cr_user"/>
<return-property name="crDate" column="cr_date"/>
<return-property name="upUser" column="up_user"/>
<return-property name="upDate" column="up_date"/>
</return>
{ call info_users_spr ( ?,?,?, ?,?,? ) }
</sql-query>

<sql-query name="user_add" callable="true">
{ call info_users_spa ( ?,?,?,?,?,?,?,?,?,?,?,?, ?,?,? ) }
</sql-query>

<sql-query name="user_update" callable="true">
{ call info_users_spu ( ?,?,?,?,?,?,?,?,?,?,?,?, ?,?,? ) }
</sql-query>

<sql-query name="user_delete" callable="true">
{ call info_users_spd ( ?,?, ?,?,? ) }
</sql-query>

</class>

</hibernate-mapping>

Code between sessionFactory.openSession() and session.close():
Not using - JBoss environment

Full stack trace of any exception that occurs:

Here is the JBoss log showing the two things happening in this program: A Read, followed by another Read - only for some reason it wants to update a record it thinks is dirty. Funny - I don't have any code to update the fields yet!

2006-01-17 16:35:23,000 DEBUG [org.hibernate.impl.SessionFactoryObjectFactory] JNDI lookup: hibernate/txoagPortalSessionFactory
2006-01-17 16:35:23,000 DEBUG [org.hibernate.impl.SessionFactoryObjectFactory] lookup: uid=4cc0aa3e08da7cd60108da7cdac70000
2006-01-17 16:35:23,125 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:35:23,125 DEBUG [org.hibernate.impl.SessionImpl] opened session at timestamp: 4659352875008000
2006-01-17 16:35:23,140 INFO [STDOUT] PortletLog|1|1/17/06|16:35:23:125|
UserTable - UserTable - EXIT
2006-01-17 16:35:23,140 INFO [STDOUT] PortletLog|1|1/17/06|16:35:23:140|
OagAppSecMgmtPortlet - init - EXIT
2006-01-17 16:35:23,140 INFO [STDOUT] PortletLog|1|1/17/06|16:35:23:140|
OagAppSecMgmtPortlet - doView - ENTER
2006-01-17 16:35:23,156 INFO [STDOUT] PortletLog|1|1/17/06|16:35:23:156|
OagAppSecMgmtPortlet - getCurrentSideBar - ENTER
2006-01-17 16:35:23,156 INFO [STDOUT] PortletLog|1|1/17/06|16:35:23:156|
OagAppSecMgmtPortlet - getCurrentSideBar - EXIT
2006-01-17 16:35:23,156 INFO [STDOUT] PortletLog|1|1/17/06|16:35:23:156|
OagAppSecMgmtPortlet - doView - EXIT
2006-01-17 16:35:24,765 INFO [STDOUT] PortletLog|1|1/17/06|16:35:24:765|
OagAppSecMgmtPortlet - doView - ENTER
2006-01-17 16:35:24,765 INFO [STDOUT] PortletLog|1|1/17/06|16:35:24:765|
OagAppSecMgmtPortlet - getCurrentSideBar - ENTER
2006-01-17 16:35:24,765 INFO [STDOUT] PortletLog|1|1/17/06|16:35:24:765|
OagAppSecMgmtPortlet - getCurrentSideBar - EXIT
2006-01-17 16:35:24,781 INFO [STDOUT] PortletLog|1|1/17/06|16:35:24:781|
UserManagement - FindUsers - ENTER
2006-01-17 16:35:24,781 INFO [STDOUT] PortletLog|1|1/17/06|16:35:24:781|
UserManagement - AddUserShowForm - EXIT
2006-01-17 16:35:24,781 INFO [STDOUT] PortletLog|1|1/17/06|16:35:24:781|
OagAppSecMgmtPortlet - doView - EXIT
2006-01-17 16:35:27,312 INFO [STDOUT] PortletLog|1|1/17/06|16:35:27:312|
OagAppSecMgmtPortlet - processAction - ENTER
2006-01-17 16:35:27,312 INFO [STDOUT] PortletLog|1|1/17/06|16:35:27:312|
FormValidation - getFieldsFromRequest - ENTER
2006-01-17 16:35:27,312 INFO [STDOUT] PortletLog|1|1/17/06|16:35:27:312|
FormValidation - getFieldsFromRequest - EXIT
2006-01-17 16:35:27,312 INFO [STDOUT] PortletLog|1|1/17/06|16:35:27:312|
FormValidation - listFields - ENTER
2006-01-17 16:35:27,312 INFO [STDOUT] Parameter frm_OagAppSecMgmtPortlet_EmplID =
2006-01-17 16:35:27,312 INFO [STDOUT] Parameter frm_OagAppSecMgmtPortlet_FirstName =
2006-01-17 16:35:27,312 INFO [STDOUT] Parameter frm_OagAppSecMgmtPortlet_LastName =
2006-01-17 16:35:27,328 INFO [STDOUT] Parameter frm_OagAppSecMgmtPortlet_Sql_Error =
2006-01-17 16:35:27,328 INFO [STDOUT] Parameter frm_OagAppSecMgmtPortlet_Sql_Rows =
2006-01-17 16:35:27,328 INFO [STDOUT] Parameter frm_OagAppSecMgmtPortlet_userCN = ac
2006-01-17 16:35:27,328 INFO [STDOUT] PortletLog|1|1/17/06|16:35:27:328|
FormValidation - listFields - EXIT
2006-01-17 16:35:27,328 INFO [STDOUT] PortletLog|1|1/17/06|16:35:27:328|
UserManagement - validateUserFormFind - ENTER
2006-01-17 16:35:27,328 INFO [STDOUT] PortletLog|1|1/17/06|16:35:27:328|
FormValidation - inError - ENTER
2006-01-17 16:35:27,328 INFO [STDOUT] PortletLog|1|1/17/06|16:35:27:328|
FormValidation - inError - EXIT
2006-01-17 16:35:27,328 INFO [STDOUT] PortletLog|1|1/17/06|16:35:27:328|
UserManagement - validateUserFormFind - EXIT
2006-01-17 16:35:27,328 INFO [STDOUT] PortletLog|1|1/17/06|16:35:27:328|
UserManagement - findUsers - ENTER
2006-01-17 16:35:27,328 INFO [STDOUT] PortletLog|1|1/17/06|16:35:27:328|
UserTable - usersFind - ENTER
2006-01-17 16:35:27,328 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:35:33,625 DEBUG [org.hibernate.engine.query.QueryPlanCache] located native-sql query plan in cache ({ call info_users_find_spr ( ?,?,?,?, ?,?,? ) })
2006-01-17 16:35:33,625 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:35:33,625 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:35:33,625 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:35:33,625 DEBUG [org.hibernate.impl.SessionImpl] SQL query: { call info_users_find_spr ( ?,?,?,?, ?,?,? ) }
2006-01-17 16:35:33,640 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:35:33,640 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:35:33,640 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:35:33,640 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:35:33,671 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:35:33,671 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2006-01-17 16:35:33,671 DEBUG [org.hibernate.jdbc.ConnectionManager] opening JDBC connection
2006-01-17 16:35:33,671 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:35:33,671 DEBUG [org.hibernate.SQL] { call info_users_find_spr ( ?,?,?,?, ?,?,? ) }
2006-01-17 16:35:33,671 INFO [STDOUT] Hibernate: { call info_users_find_spr ( ?,?,?,?, ?,?,? ) }
2006-01-17 16:35:33,671 DEBUG [org.hibernate.jdbc.AbstractBatcher] preparing statement
2006-01-17 16:35:33,671 DEBUG [org.hibernate.type.StringType] binding 'ac' to parameter: 1
2006-01-17 16:35:33,671 DEBUG [org.hibernate.type.StringType] binding '' to parameter: 2
2006-01-17 16:35:33,671 DEBUG [org.hibernate.type.StringType] binding '' to parameter: 3
2006-01-17 16:35:33,671 DEBUG [org.hibernate.type.StringType] binding '' to parameter: 4
2006-01-17 16:35:33,671 DEBUG [org.hibernate.type.SerializableType] binding null to parameter: 5
2006-01-17 16:35:33,687 DEBUG [org.hibernate.type.SerializableType] binding null to parameter: 6
2006-01-17 16:35:33,687 DEBUG [org.hibernate.type.SerializableType] binding null to parameter: 7
2006-01-17 16:35:33,687 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:35:33,890 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to open ResultSet (open ResultSets: 0, globally: 0)
2006-01-17 16:35:33,906 DEBUG [org.hibernate.loader.Loader] processing result set
2006-01-17 16:35:33,906 DEBUG [org.hibernate.loader.Loader] result set row: 0
2006-01-17 16:35:33,937 DEBUG [org.hibernate.type.BigDecimalType] returning '1' as column: user_id
2006-01-17 16:35:33,937 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:35:33,953 DEBUG [org.hibernate.loader.Loader] result row: EntityKey[Info_Users#1]
2006-01-17 16:35:33,953 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:35:33,953 DEBUG [org.hibernate.loader.Loader] Initializing object from ResultSet: [Info_Users#1]
2006-01-17 16:35:33,984 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:35:34,031 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:35:34,062 DEBUG [org.hibernate.persister.entity.AbstractEntityPersister] Hydrating entity: [Info_Users#1]
2006-01-17 16:35:34,062 DEBUG [org.hibernate.type.StringType] returning 'ACM3' as column: user_cn
2006-01-17 16:35:34,062 DEBUG [org.hibernate.type.IntegerType] returning '1' as column: is_active
2006-01-17 16:35:34,062 DEBUG [org.hibernate.type.IntegerType] returning '1' as column: is_deployed
2006-01-17 16:35:34,062 DEBUG [org.hibernate.type.IntegerType] returning '1' as column: is_employee
2006-01-17 16:35:34,109 DEBUG [org.hibernate.type.DateType] returning '29 November 2005' as column: dt_eff
2006-01-17 16:35:34,109 DEBUG [org.hibernate.type.DateType] returning null as column: dt_inactive
2006-01-17 16:35:34,109 DEBUG [org.hibernate.type.StringType] returning 'ACM3' as column: emplid
2006-01-17 16:35:34,109 DEBUG [org.hibernate.type.StringType] returning 'arnie' as column: first_name
2006-01-17 16:35:34,109 DEBUG [org.hibernate.type.StringType] returning 'morein' as column: last_name
2006-01-17 16:35:34,109 DEBUG [org.hibernate.type.StringType] returning 'programmer' as column: title
2006-01-17 16:35:34,109 DEBUG [org.hibernate.type.StringType] returning 'acm3' as column: cr_user
2006-01-17 16:35:34,109 DEBUG [org.hibernate.type.DateType] returning '29 November 2005' as column: cr_date
2006-01-17 16:35:34,109 DEBUG [org.hibernate.type.StringType] returning 'acm3' as column: up_user
2006-01-17 16:35:34,109 DEBUG [org.hibernate.type.DateType] returning '29 November 2005' as column: up_date
2006-01-17 16:35:34,140 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:35:34,140 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:35:34,140 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:35:34,140 DEBUG [org.hibernate.loader.Loader] done processing result set (1 rows)
2006-01-17 16:35:34,140 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:35:34,140 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to close ResultSet (open ResultSets: 1, globally: 1)
2006-01-17 16:35:34,140 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
2006-01-17 16:35:34,140 DEBUG [org.hibernate.jdbc.AbstractBatcher] closing statement
2006-01-17 16:35:34,140 DEBUG [org.hibernate.jdbc.ConnectionManager] aggressively releasing JDBC connection
2006-01-17 16:35:34,140 DEBUG [org.hibernate.jdbc.ConnectionManager] closing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
2006-01-17 16:35:34,156 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:35:34,187 DEBUG [org.hibernate.loader.Loader] total objects hydrated: 1
2006-01-17 16:35:34,187 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:35:34,187 DEBUG [org.hibernate.engine.TwoPhaseLoad] resolving associations for [Info_Users#1]
2006-01-17 16:35:34,234 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:35:34,234 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:35:34,234 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:35:34,234 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:35:34,234 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:35:34,234 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:35:34,234 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:35:34,234 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:35:34,234 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:35:34,234 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:35:34,234 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:35:34,234 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:35:34,234 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:35:34,234 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:35:34,234 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:35:34,234 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:35:34,250 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:35:34,250 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:35:34,250 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:35:34,250 DEBUG [org.hibernate.engine.TwoPhaseLoad] done materializing entity [Info_Users#1]
2006-01-17 16:35:34,250 DEBUG [org.hibernate.engine.StatefulPersistenceContext] initializing non-lazy collections
2006-01-17 16:35:34,250 DEBUG [org.hibernate.jdbc.JDBCContext] after autocommit
2006-01-17 16:35:34,250 DEBUG [org.hibernate.impl.SessionImpl] after transaction completion
2006-01-17 16:35:39,859 INFO [STDOUT] PortletLog|1|1/17/06|16:35:39:859|
UserTable - usersFind - EXIT
2006-01-17 16:35:46,500 INFO [STDOUT] PortletLog|1|1/17/06|16:35:46:484|
UserManagement - findUsers - EXIT
2006-01-17 16:35:46,500 INFO [STDOUT] PortletLog|1|1/17/06|16:35:46:500|
FormValidation - sendFieldsToResponse - ENTER
2006-01-17 16:35:46,500 INFO [STDOUT] PortletLog|1|1/17/06|16:35:46:500|
FormValidation - sendFieldsToResponse - EXIT
2006-01-17 16:35:46,500 INFO [STDOUT] PortletLog|1|1/17/06|16:35:46:500|
OagAppSecMgmtPortlet - processAction - EXIT
2006-01-17 16:35:46,640 INFO [STDOUT] PortletLog|1|1/17/06|16:35:46:640|
OagAppSecMgmtPortlet - doView - ENTER
2006-01-17 16:35:46,640 INFO [STDOUT] PortletLog|1|1/17/06|16:35:46:640|
OagAppSecMgmtPortlet - getCurrentSideBar - ENTER
2006-01-17 16:35:46,640 INFO [STDOUT] PortletLog|1|1/17/06|16:35:46:640|
OagAppSecMgmtPortlet - getCurrentSideBar - EXIT
2006-01-17 16:35:46,640 INFO [STDOUT] PortletLog|1|1/17/06|16:35:46:640|
UserManagement - ShowUserListForm - ENTER
2006-01-17 16:35:46,640 INFO [STDOUT] PortletLog|1|1/17/06|16:35:46:640|
UserManagement - ShowUserListForm - EXIT
2006-01-17 16:35:46,640 INFO [STDOUT] PortletLog|1|1/17/06|16:35:46:640|
OagAppSecMgmtPortlet - doView - EXIT
2006-01-17 16:36:45,718 INFO [STDOUT] PortletLog|1|1/17/06|16:36:45:718|
OagAppSecMgmtPortlet - doView - ENTER
2006-01-17 16:36:45,718 INFO [STDOUT] PortletLog|1|1/17/06|16:36:45:718|
OagAppSecMgmtPortlet - getCurrentSideBar - ENTER
2006-01-17 16:36:45,718 INFO [STDOUT] PortletLog|1|1/17/06|16:36:45:718|
OagAppSecMgmtPortlet - getCurrentSideBar - EXIT
2006-01-17 16:36:45,718 INFO [STDOUT] PortletLog|1|1/17/06|16:36:45:718|
UserManagement - ShowUserForm - ENTER
2006-01-17 16:36:45,718 INFO [STDOUT] PortletLog|1|1/17/06|16:36:45:718|
UserTable - userRead - ENTER
2006-01-17 16:36:45,718 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:36:45,718 DEBUG [org.hibernate.engine.query.QueryPlanCache] located native-sql query plan in cache ({ call info_users_spr ( ?,?,?, ?,?,? ) })
2006-01-17 16:36:45,718 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:36:45,718 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:36:45,718 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:36:45,718 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] flushing session
2006-01-17 16:36:45,718 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:36:45,718 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:36:45,718 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] processing flush-time cascades
2006-01-17 16:36:45,718 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:36:45,734 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:36:45,734 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:36:45,734 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] dirty checking collections
2006-01-17 16:36:45,734 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:36:45,734 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] Flushing entities and processing referenced collections
2006-01-17 16:36:45,734 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:36:45,734 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:36:45,734 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:36:45,734 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:36:45,734 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:36:45,734 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:36:45,734 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:36:45,734 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:36:45,734 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:36:45,734 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:36:45,734 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:36:45,734 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:36:45,734 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:36:45,734 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:36:45,734 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:36:45,734 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:36:45,734 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:36:45,734 DEBUG [org.hibernate.persister.entity.AbstractEntityPersister] Info_Users.isEmployee is dirty
2006-01-17 16:36:45,734 DEBUG [org.hibernate.persister.entity.AbstractEntityPersister] Info_Users.upUser is dirty
2006-01-17 16:36:45,734 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:36:45,734 DEBUG [org.hibernate.event.def.DefaultFlushEntityEventListener] Updating entity: [Info_Users#1]
2006-01-17 16:36:45,734 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:36:45,750 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:36:45,750 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:36:45,750 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] Processing unreferenced collections
2006-01-17 16:36:45,750 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:36:45,750 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] Scheduling collection removes/(re)creates/updates
2006-01-17 16:36:45,750 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:36:45,750 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:36:45,750 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:36:45,750 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:36:45,750 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:36:45,750 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] Flushed: 0 insertions, 1 updates, 0 deletions to 1 objects
2006-01-17 16:36:45,750 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:36:45,750 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:36:45,765 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:36:45,765 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] Flushed: 0 (re)creations, 0 updates, 0 removals to 0 collections
2006-01-17 16:36:45,765 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:36:45,765 DEBUG [org.hibernate.pretty.Printer] listing entities:
2006-01-17 16:36:45,765 DEBUG [org.hibernate.pretty.Printer] us.tx.state.oag.AppSecMgmt.Info_User_Table
2006-01-17 16:36:45,765 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:36:45,765 DEBUG [org.hibernate.engine.ActionQueue] changes must be flushed to space: info_users
2006-01-17 16:36:45,765 DEBUG [org.hibernate.event.def.DefaultAutoFlushEventListener] Need to execute flush
2006-01-17 16:36:45,765 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] executing flush
2006-01-17 16:36:45,765 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:36:45,765 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:36:45,765 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:36:45,765 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:36:45,765 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:36:45,765 DEBUG [org.hibernate.persister.entity.AbstractEntityPersister] Updating entity: [Info_Users#1]
2006-01-17 16:36:45,765 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:36:45,765 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2006-01-17 16:36:45,765 DEBUG [org.hibernate.jdbc.ConnectionManager] opening JDBC connection
2006-01-17 16:36:45,765 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:36:45,765 DEBUG [org.hibernate.SQL] update info_users set is_active=?, is_deployed=?, is_employee=?, dt_eff=?, dt_inactive=?, emplid=?, first_name=?, last_name=?, title=?, cr_user=?, cr_date=?, up_user=?, up_date=? where user_id=?
2006-01-17 16:36:45,765 INFO [STDOUT] Hibernate: update info_users set is_active=?, is_deployed=?, is_employee=?, dt_eff=?, dt_inactive=?, emplid=?, first_name=?, last_name=?, title=?, cr_user=?, cr_date=?, up_user=?, up_date=? where user_id=?
2006-01-17 16:36:45,765 DEBUG [org.hibernate.jdbc.AbstractBatcher] preparing statement
2006-01-17 16:36:45,765 DEBUG [org.hibernate.persister.entity.AbstractEntityPersister] Dehydrating entity: [Info_Users#1]
2006-01-17 16:36:45,765 DEBUG [org.hibernate.type.IntegerType] binding '1' to parameter: 1
2006-01-17 16:36:45,765 DEBUG [org.hibernate.type.IntegerType] binding '1' to parameter: 2
2006-01-17 16:36:45,765 DEBUG [org.hibernate.type.IntegerType] binding '0' to parameter: 3
2006-01-17 16:36:45,765 DEBUG [org.hibernate.type.DateType] binding '29 November 2005' to parameter: 4
2006-01-17 16:36:45,765 DEBUG [org.hibernate.type.DateType] binding null to parameter: 5
2006-01-17 16:36:45,765 DEBUG [org.hibernate.type.StringType] binding 'ACM3' to parameter: 6
2006-01-17 16:36:45,765 DEBUG [org.hibernate.type.StringType] binding 'arnie' to parameter: 7
2006-01-17 16:36:45,765 DEBUG [org.hibernate.type.StringType] binding 'morein' to parameter: 8
2006-01-17 16:36:45,765 DEBUG [org.hibernate.type.StringType] binding 'programmer' to parameter: 9
2006-01-17 16:36:45,765 DEBUG [org.hibernate.type.StringType] binding 'acm3' to parameter: 10
2006-01-17 16:36:45,765 DEBUG [org.hibernate.type.DateType] binding '29 November 2005' to parameter: 11
2006-01-17 16:36:45,765 DEBUG [org.hibernate.type.StringType] binding null to parameter: 12
2006-01-17 16:36:45,765 DEBUG [org.hibernate.type.DateType] binding '29 November 2005' to parameter: 13
2006-01-17 16:36:45,765 DEBUG [org.hibernate.type.BigDecimalType] binding '1' to parameter: 14
2006-01-17 16:36:45,765 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:36:45,781 DEBUG [org.hibernate.jdbc.JDBCContext] no active transaction, could not register Synchronization
2006-01-17 16:36:45,781 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
2006-01-17 16:36:45,781 DEBUG [org.hibernate.jdbc.AbstractBatcher] closing statement
2006-01-17 16:36:45,781 DEBUG [org.hibernate.jdbc.ConnectionManager] aggressively releasing JDBC connection
2006-01-17 16:36:45,781 DEBUG [org.hibernate.jdbc.ConnectionManager] closing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
2006-01-17 16:36:45,781 DEBUG [org.hibernate.util.JDBCExceptionReporter] could not update: [Info_Users#1] [update info_users set is_active=?, is_deployed=?, is_employee=?, dt_eff=?, dt_inactive=?, emplid=?, first_name=?, last_name=?, title=?, cr_user=?, cr_date=?, up_user=?, up_date=? where user_id=?]
com.sybase.jdbc3.jdbc.SybSQLException: The column up_user in table info_users does not allow null values.

Name and version of the database you are using:
db: application_security
table: info_users
stored procedures: info_users_find_spr and info_users_spr
dbms: Sybase 12.5.3
Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 1 post ] 

Board index » Hibernate & Java Persistence » Hibernate Users

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.