[jboss-user] [JBoss Portal] - Problems with Identity portlet and user portlet

[alessio.papi]

Hi,

I have a problem with identity portlet and user portlet, when users add a new properties to their profile and confirm changes both portlets throw an exception :


  | javax.servlet.ServletException: java.sql.BatchUpdateException: ORA-00001: unique constraint (JBOSSPORTAL.SYS_C0093012) violated
  | 	org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:276)
  | 	javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
  | 	org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
  | 
  | root cause
  | 
  | java.sql.BatchUpdateException: ORA-00001: unique constraint (JBOSSPORTAL.SYS_C0093012) violated
  | 
  | 	oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
  | 	oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10768)
  | 	org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:774)
  | 	org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
  | 	org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)
  | 	org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:237)
  | ....
  | 

The constraint violated is the follow :


  | ALTER TABLE jbp_user_prop
  |   ADD PRIMARY KEY (
  |     jbp_uid,
  |     jbp_name
  |   )
  | 

This is a strange behavior because if users change properties already stored like given name and family name the operation doesn't throw an exception.

My environment is this :
- JBoss 4.2.3
- JBoss Portal 2.6.6
- Oracle 9i (with jdbc driver provided by version 10g)

Someone has the same problem ?


View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4184400#4184400

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4184400