[jboss-user] [JBoss Portal] - Re: Admin Portlet: Strange Behavior with Oracle-DB

[ssolfaroli]

Same problem here.
Trying to add a property to a page i get nothing on first time, if I retry I get this error:

  | 2008-04-10 10:44:38,300 WARN  [org.hibernate.util.JDBCExceptionReporter] SQL Error: 1, SQLState: 23000
  | 2008-04-10 10:44:38,300 ERROR [org.hibernate.util.JDBCExceptionReporter] ORA-00001: unique constraint (JBPORTAL.SYS_C0016340) violated
  | 
  | 2008-04-10 10:44:38,300 WARN  [org.hibernate.util.JDBCExceptionReporter] SQL Error: 1, SQLState: 23000
  | 2008-04-10 10:44:38,300 ERROR [org.hibernate.util.JDBCExceptionReporter] ORA-00001: unique constraint (JBPORTAL.SYS_C0016340) violated
  | 
  | 2008-04-10 10:44:38,300 ERROR [org.hibernate.event.def.AbstractFlushingEventListener] Could not synchronize database state with session
  | org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
  | 

My environment:
* Version: jboss-portal-2.6.4
* Download Version
* JBoss AS Version: 4.2.2.GA 
* Database: Oracle Database 10g Release 2
* JDBC Connector and Version: ojdb14.jar shipped with database
* OS Platform: Red Hat Enterprise Linux AS release 4 
* Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_05-b05)

Searching in Hibernate FAQ i tried to disable batch update
<property name="hibernate.jdbc.batch_versioned_data">false</property>
  | <property name="hibernate.jdbc.batch_size">0</property>
  | , nothing has changed.

Tried specifing hibernate dialect also, with:

  | <property name="dialect">org.hibernate.dialect.Oracle10gDialect</property>
  | 

Someone has an idea of what is happening?
Please help me.

Thanks


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

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