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 ?
