I try to install jboss portal and i've got a problem. Don't know if i am on the
right place ? Let me know if not.
After a bad installation i've got a pending transaction in jboss. When i deploy
portal, i've got the following logs :
2005-01-21 00:29:33,655 DEBUG [net.sf.hibernate.impl.SessionImpl] saving
[org.jboss.portal.core.impl.user.UserPrefSet#]
2005-01-21 00:29:33,655 DEBUG [net.sf.hibernate.impl.SessionImpl] executing
insertions
2005-01-21 00:29:33,655 DEBUG [net.sf.hibernate.engine.Cascades] processing
cascades for: org.jboss.portal.core.impl.user.UserPrefSet
2005-01-21 00:29:33,655 DEBUG [net.sf.hibernate.engine.Cascades] done
processing cascades for: org.jboss.portal.core.impl.user.UserPrefSet
2005-01-21 00:29:33,660 DEBUG [net.sf.hibernate.impl.WrapVisitor] Wrapped
collection in role: org.jboss.portal.core.impl.user.UserPrefSet.children
2005-01-21 00:29:33,660 DEBUG [net.sf.hibernate.impl.WrapVisitor] Wrapped
collection in role: org.jboss.portal.core.impl.user.UserPrefSet.content
2005-01-21 00:29:33,663 DEBUG [net.sf.hibernate.persister.EntityPersister]
Inserting entity: org.jboss.portal.core.impl.user.UserPrefSet (native id)
2005-01-21 00:29:33,663 DEBUG [net.sf.hibernate.impl.BatcherImpl] about to
open: 0 open PreparedStatements, 0 open ResultSets
2005-01-21 00:29:33,663 DEBUG [net.sf.hibernate.SQL] insert into
jbp_user_pref_set (name, jbp_parent_id) values (?, ?)
2005-01-21 00:29:33,663 DEBUG [net.sf.hibernate.impl.BatcherImpl] preparing
statement
2005-01-21 00:29:33,664 DEBUG [net.sf.hibernate.persister.EntityPersister]
Dehydrating entity: [org.jboss.portal.core.impl.user.UserPrefSet#]
2005-01-21 00:29:33,664 DEBUG [net.sf.hibernate.type.StringType] binding '' to
parameter: 1
2005-01-21 00:29:33,664 DEBUG [net.sf.hibernate.type.IntegerType] binding null
to parameter: 2
2005-01-21 00:29:33,666 DEBUG [net.sf.hibernate.util.JDBCExceptionReporter] SQL
Exception
org.postgresql.util.PSQLException: ERROR: null value in column "jbp_id"
violates not-null constraint
at
org.postgresql.util.PSQLException.parseServerError(PSQLException.java:139)
at org.postgresql.core.QueryExecutor.executeV3(QueryExecutor.java:152)
at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:100)
at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:43)
....
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:534)
2005-01-21 00:29:33,690 DEBUG [net.sf.hibernate.impl.SessionImpl] running
Session.finalize()
2005-01-21 00:29:33,691 DEBUG [net.sf.hibernate.impl.SessionImpl] running
Session.finalize()
2005-01-21 00:29:33,691 WARN [net.sf.hibernate.util.JDBCExceptionReporter] SQL
Error: 0, SQLState: 23502
When i try to update some data (roles, ....), i've got the following logs :
2005-01-21 00:50:05,161 ERROR [net.sf.hibernate.util.JDBCExceptionReporter]
ERROR: current transaction is aborted, commands ignored until end of
transaction block
2005-01-21 00:50:05,161 ERROR [net.sf.hibernate.util.JDBCExceptionReporter]
could not insert: [org.jboss.portal.core.impl.user.UserPrefSet]
org.postgresql.util.PSQLException: ERROR: current transaction is aborted,
commands ignored until end of transaction block
at
org.postgresql.util.PSQLException.parseServerError(PSQLException.java:139)
at org.postgresql.core.QueryExecutor.executeV3(QueryExecutor.java:152)
at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:100)
at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:43)
at
org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:517)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:50)
at
org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc1Statement.java:273)
at
org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:316)
at
net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:528)
at
net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:432)
...
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:534)
2005-01-21 00:50:05,162 WARN [org.jboss.hibernate.session.TransactionSynch]
Error flushing session
2005-01-21 00:50:05,162 DEBUG [net.sf.hibernate.engine.CacheSynchronization]
transaction before completion callback
2005-01-21 00:50:05,163 DEBUG [net.sf.hibernate.impl.SessionImpl] closing
session
2005-01-21 00:50:05,163 DEBUG [net.sf.hibernate.impl.SessionImpl] disconnecting
session
2005-01-21 00:50:05,163 DEBUG [net.sf.hibernate.engine.CacheSynchronization]
transaction after completion callback, status: 3
2005-01-21 00:50:05,163 DEBUG [net.sf.hibernate.impl.SessionImpl] transaction
completion
What can i do ?
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3863004#3863004
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3863004
-------------------------------------------------------
This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting
Tool for open source databases. Create drag-&-drop reports. Save time
by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc.
Download a FREE copy at http://www.intelliview.com/go/osdn_nl
_______________________________________________
JBoss-Development mailing list
JBoss-Development@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jboss-development
