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 _______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
