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