-->
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
  [ 3 posts ] 
  Previous topic | Next topic 
Author Message
urswag
 Post subject: dentifier of an instance of ... was altered
PostPosted: Mon Jun 12, 2006 5:58 am 
Newbie

Joined: Wed Apr 05, 2006 9:08 am
Posts: 6
What means this exception?
java.lang.RuntimeException: org.jboss.tm.JBossRollbackException: Unable to commit, tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=Ursus/34, BranchQual=, localId=34] status=STATUS_NO_TRANSACTION; - nested throwable: (org.hibernate.HibernateException: identifier of an instance of org.person.ejb.Login was altered from 1 to 0)


Quote:
type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

javax.servlet.ServletException: org.jboss.tm.JBossRollbackException: Unable to commit, tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=Ursus/34, BranchQual=, localId=34] status=STATUS_NO_TRANSACTION; - nested throwable: (org.hibernate.HibernateException: identifier of an instance of org.person.ejb.Login was altered from 1 to 0)
org.person.web.LoginActionServlet.doit(LoginActionServlet.java:92)
org.person.web.LoginActionServlet.doPost(LoginActionServlet.java:55)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)

root cause

java.lang.RuntimeException: org.jboss.tm.JBossRollbackException: Unable to commit, tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=Ursus/34, BranchQual=, localId=34] status=STATUS_NO_TRANSACTION; - nested throwable: (org.hibernate.HibernateException: identifier of an instance of org.person.ejb.Login was altered from 1 to 0)
org.jboss.aspects.tx.TxPolicy.handleEndTransactionException(TxPolicy.java:198)
org.jboss.aspects.tx.TxPolicy.endTransaction(TxPolicy.java:180)
org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:87)
org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:192)
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98)
org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:76)
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98)
org.jboss.ejb3.stateful.StatefulInstanceInterceptor.invoke(StatefulInstanceInterceptor.java:81)
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98)
org.jboss.aspects.security.AuthenticationInterceptor.invoke(AuthenticationInterceptor.java:78)
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98)
org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:47)
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98)
org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(AsynchronousInterceptor.java:106)
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98)
org.jboss.ejb3.stateful.StatefulContainer.dynamicInvoke(StatefulContainer.java:294)
org.jboss.ejb3.remoting.IsLocalInterceptor.invoke(IsLocalInterceptor.java:55)
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98)
org.jboss.ejb3.stateful.StatefulRemoteProxy.invoke(StatefulRemoteProxy.java:133)
$Proxy462.login(Unknown Source)
org.person.web.LoginActionServlet.doit(LoginActionServlet.java:83)
org.person.web.LoginActionServlet.doPost(LoginActionServlet.java:55)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
Top
 Profile  
 
urswag
 Post subject: Who can explain me this log
PostPosted: Mon Jun 12, 2006 6:30 pm 
Newbie

Joined: Wed Apr 05, 2006 9:08 am
Posts: 6
Quote:
2006-06-13 00:17:41,312 DEBUG [org.hibernate.hql.ast.QueryTranslatorImpl] parse() - HQL: from org.person.ejb.Login l where l.userName = :userName and l.passWord = :passWord
2006-06-13 00:17:41,328 DEBUG [org.hibernate.hql.ast.AST] --- HQL AST ---
\-[QUERY] 'query'
+-[SELECT_FROM] 'SELECT_FROM'
| \-[FROM] 'from'
| \-[RANGE] 'RANGE'
| +-[DOT] '.'
| | +-[DOT] '.'
| | | +-[DOT] '.'
| | | | +-[IDENT] 'org'
| | | | \-[IDENT] 'person'
| | | \-[IDENT] 'ejb'
| | \-[IDENT] 'Login'
| \-[ALIAS] 'l'
\-[WHERE] 'where'
\-[AND] 'and'
+-[EQ] '='
| +-[DOT] '.'
| | +-[IDENT] 'l'
| | \-[IDENT] 'userName'
| \-[COLON] ':'
| \-[IDENT] 'userName'
\-[EQ] '='
+-[DOT] '.'
| +-[IDENT] 'l'
| \-[IDENT] 'passWord'
\-[COLON] ':'
\-[IDENT] 'passWord'

2006-06-13 00:17:41,328 DEBUG [org.hibernate.hql.ast.ErrorCounter] throwQueryException() : no errors
2006-06-13 00:17:41,421 DEBUG [org.hibernate.hql.antlr.HqlSqlBaseWalker] select << begin [level=1, statement=select]
2006-06-13 00:17:41,468 DEBUG [org.hibernate.hql.ast.tree.FromElement] FromClause{level=1} : org.person.ejb.Login (l) -> login0_
2006-06-13 00:17:41,484 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : l -> login0_.loginid
2006-06-13 00:17:41,484 DEBUG [org.hibernate.hql.ast.tree.DotNode] getDataType() : userName -> org.hibernate.type.StringType@dea091
2006-06-13 00:17:41,484 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : l.userName -> login0_.username
2006-06-13 00:17:41,484 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : l -> login0_.loginid
2006-06-13 00:17:41,484 DEBUG [org.hibernate.hql.ast.tree.DotNode] getDataType() : passWord -> org.hibernate.type.StringType@dea091
2006-06-13 00:17:41,484 DEBUG [org.hibernate.hql.ast.tree.FromReferenceNode] Resolved : l.passWord -> login0_.password
2006-06-13 00:17:41,484 DEBUG [org.hibernate.hql.antlr.HqlSqlBaseWalker] select : finishing up [level=1, statement=select]
2006-06-13 00:17:41,484 DEBUG [org.hibernate.hql.ast.HqlSqlWalker] processQuery() : ( SELECT ( FromClause{level=1} login login0_ ) ( where ( and ( = ( login0_.username login0_.loginid userName ) ? ) ( = ( login0_.password login0_.loginid passWord ) ? ) ) ) )
2006-06-13 00:17:41,515 DEBUG [org.hibernate.hql.ast.HqlSqlWalker] Derived SELECT clause created.
2006-06-13 00:17:41,515 DEBUG [org.hibernate.hql.ast.util.JoinProcessor] Using FROM fragment [login login0_]
2006-06-13 00:17:41,515 DEBUG [org.hibernate.hql.antlr.HqlSqlBaseWalker] select >> end [level=1, statement=select]
2006-06-13 00:17:41,562 DEBUG [org.hibernate.hql.ast.AST] --- SQL AST ---
\-[SELECT] QueryNode: 'SELECT' querySpaces (login)
+-[SELECT_CLAUSE] SelectClause: '{derived select clause}'
| +-[SELECT_EXPR] SelectExpressionImpl: 'login0_.loginid as loginid12_' {FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=l,role=null,tableName=login,tableAlias=login0_,origin=null,colums={,className=org.person.ejb.Login}}}
| \-[SQL_TOKEN] SqlFragment: 'login0_.username as username12_, login0_.password as password12_'
+-[FROM] FromClause: 'from' FromClause{level=1, fromElementCounter=1, fromElements=1, fromElementByClassAlias=[l], fromElementByTableAlias=[login0_], fromElementsByPath=[], collectionJoinFromElementsByPath=[], impliedElements=[]}
| \-[FROM_FRAGMENT] FromElement: 'login login0_' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=l,role=null,tableName=login,tableAlias=login0_,origin=null,colums={,className=org.person.ejb.Login}}
\-[WHERE] SqlNode: 'where'
\-[AND] SqlNode: 'and'
+-[EQ] BinaryLogicOperatorNode: '='
| +-[DOT] DotNode: 'login0_.username' {propertyName=userName,dereferenceType=4,propertyPath=userName,path=l.userName,tableAlias=login0_,className=org.person.ejb.Login,classAlias=l}
| | +-[ALIAS_REF] IdentNode: 'login0_.loginid' {alias=l, className=org.person.ejb.Login, tableAlias=login0_}
| | \-[IDENT] IdentNode: 'userName' {originalText=userName}
| \-[NAMED_PARAM] ParameterNode: '?' {name=userName, expectedType=org.hibernate.type.StringType@dea091}
\-[EQ] BinaryLogicOperatorNode: '='
+-[DOT] DotNode: 'login0_.password' {propertyName=passWord,dereferenceType=4,propertyPath=passWord,path=l.passWord,tableAlias=login0_,className=org.person.ejb.Login,classAlias=l}
| +-[ALIAS_REF] IdentNode: 'login0_.loginid' {alias=l, className=org.person.ejb.Login, tableAlias=login0_}
| \-[IDENT] IdentNode: 'passWord' {originalText=passWord}
\-[NAMED_PARAM] ParameterNode: '?' {name=passWord, expectedType=org.hibernate.type.StringType@dea091}

2006-06-13 00:17:41,562 DEBUG [org.hibernate.hql.ast.ErrorCounter] throwQueryException() : no errors
2006-06-13 00:17:41,578 DEBUG [org.hibernate.hql.ast.QueryTranslatorImpl] HQL: from org.person.ejb.Login l where l.userName = :userName and l.passWord = :passWord
2006-06-13 00:17:41,578 DEBUG [org.hibernate.hql.ast.QueryTranslatorImpl] SQL: select login0_.loginid as loginid12_, login0_.username as username12_, login0_.password as password12_ from login login0_ where login0_.username=? and login0_.password=?
2006-06-13 00:17:41,578 DEBUG [org.hibernate.hql.ast.ErrorCounter] throwQueryException() : no errors
2006-06-13 00:17:41,609 DEBUG [org.jboss.mx.loading.UnifiedClassLoader] New jmx UCL with url null
2006-06-13 00:17:41,609 DEBUG [org.jboss.mx.loading.RepositoryClassLoader] setRepository, repository=org.jboss.mx.loading.HeirarchicalLoaderRepository3@1dbad5b, cl=org.jboss.mx.loading.HeirarchicalLoaderRepository3$CacheClassLoader@fa0f67{ url=null ,addedOrder=0}
2006-06-13 00:17:41,609 DEBUG [org.jboss.mx.loading.UnifiedClassLoader] New jmx UCL with url null
2006-06-13 00:17:41,609 DEBUG [org.jboss.mx.loading.RepositoryClassLoader] setRepository, repository=org.jboss.mx.loading.HeirarchicalLoaderRepository3@1dbad5b, cl=org.jboss.mx.loading.UnifiedClassLoader3@10937cb{ url=null ,addedOrder=0}
2006-06-13 00:17:41,625 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2006-06-13 00:17:41,625 DEBUG [org.hibernate.jdbc.ConnectionManager] opening JDBC connection
2006-06-13 00:17:41,625 DEBUG [org.hibernate.SQL] select login0_.loginid as loginid12_, login0_.username as username12_, login0_.password as password12_ from login login0_ where login0_.username=? and login0_.password=?
2006-06-13 00:17:41,640 DEBUG [org.hibernate.loader.hql.QueryLoader] bindNamedParameters() urswag -> userName [1]
2006-06-13 00:17:41,640 DEBUG [org.hibernate.loader.hql.QueryLoader] bindNamedParameters() urs-1wag -> passWord [2]
2006-06-13 00:17:41,640 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to open ResultSet (open ResultSets: 0, globally: 0)
2006-06-13 00:17:41,640 DEBUG [org.hibernate.loader.Loader] result row: EntityKey[org.person.ejb.Login#1]
2006-06-13 00:17:41,656 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to close ResultSet (open ResultSets: 1, globally: 1)
2006-06-13 00:17:41,656 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
2006-06-13 00:17:41,656 DEBUG [org.hibernate.jdbc.ConnectionManager] aggressively releasing JDBC connection
2006-06-13 00:17:41,656 DEBUG [org.hibernate.jdbc.ConnectionManager] releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
2006-06-13 00:17:41,656 DEBUG [org.hibernate.engine.TwoPhaseLoad] resolving associations for [org.person.ejb.Login#1]
2006-06-13 00:17:41,671 DEBUG [org.hibernate.engine.TwoPhaseLoad] done materializing entity [org.person.ejb.Login#1]
2006-06-13 00:17:41,671 DEBUG [org.hibernate.engine.StatefulPersistenceContext] initializing non-lazy collections
2006-06-13 00:17:41,671 DEBUG [org.jboss.mx.loading.UnifiedClassLoader] New jmx UCL with url null
2006-06-13 00:17:41,671 DEBUG [org.jboss.mx.loading.RepositoryClassLoader] setRepository, repository=org.jboss.mx.loading.HeirarchicalLoaderRepository3@1dbad5b, cl=org.jboss.mx.loading.HeirarchicalLoaderRepository3$CacheClassLoader@c12bfd{ url=null ,addedOrder=0}
2006-06-13 00:17:41,671 DEBUG [org.jboss.mx.loading.UnifiedClassLoader] New jmx UCL with url null
2006-06-13 00:17:41,671 DEBUG [org.jboss.mx.loading.RepositoryClassLoader] setRepository, repository=org.jboss.mx.loading.HeirarchicalLoaderRepository3@1dbad5b, cl=org.jboss.mx.loading.UnifiedClassLoader3@2ef8a9{ url=null ,addedOrder=0}
2006-06-13 00:17:41,671 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] processing flush-time cascades
2006-06-13 00:17:41,671 DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] dirty checking collections
2006-06-13 00:17:41,687 DEBUG [org.jboss.ejb3.entity.ManagedEntityManagerFactory] ************** closing entity managersession **************
Top
 Profile  
 
urswag
 Post subject:
PostPosted: Fri Jun 23, 2006 8:44 am 
Newbie

Joined: Wed Apr 05, 2006 9:08 am
Posts: 6
I do not exactly know what the problem is. I have changed the bean name to Vistit and the table to visit, this does work.
When MySQL generates an error You get such a kind of error because the transcation is roll backed.
Perhaps MySQL does not return an exact error message like in error cases. Or Hibernate suppress the MySQL error. ....
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
  [ 3 posts ] 

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.