1 Reply Latest reply on Nov 4, 2008 10:06 AM by Alessio Papi

    Problems with Identity portlet and user portlet

    Alessio Papi Newbie

      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 ?