Admin Portlet: Strange Behavior with Oracle-DB

[ironman77]

Hi,

using this setup

* Version: jboss-portal-2.6.1.GA and jboss-portal-2.6.4.GA
* Download Version
* JBoss AS Version: 4.2.1.GA (build: SVNTag=JBoss_4_2_1_GA date=200707131605)] and 4.2.2
* Database: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning and Data Mining options
* JDBC Connector and Version: ojdb14.jar (10.2.0.1.0 and 10.2.0.4.0)
* OS Platform: SUSE Linux Enterprise Server 10 (i586)
* Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_11-b03)

i have a rather strange behavoir when using the admin portlet. Adding a property to a page or modifying a user does not work as expected. The data seems to be written to the oracle database but it is NOT shown in the admin portlet. Using a mysql 5.0.26 database with the same setup does work as expected.

This seems to a strange effect, as it affects 2.6.1 and 2.6.4 without any modification. Is this a known bug (i have found nothing in the jira) or could it be related to the setup of the oracle database?

Oracle seems to be a quite popular database, so i am under the expression that this could be a bug with portal 2.6.1 AND 2.6.4?

Thanks in advance!

[peterj]

This is a long shot, but in the jboss-portal.sar/conf/hibernate/*/hibernate.cfg.xml files, try setting the "dialect" property (currently it is commented out).

[ironman77]

Hi Peter,

i tried

* org.hibernate.dialect.OracleDialect
* org.hibernate.dialect.Oracle9Dialect

but no effect.

An extension to the previous description:
If you try to add a property (e.g. "hidden") first nothing happens (reload). If you try to add the property again you get a:

java.sql.BatchUpdateException: ORA-00001: Unique Constraint (JBOSSPORTAL_2_6.SYS_C0011591)

Exception as the property is already written to the database table!

[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

[ssolfaroli]

I change the question:
there is someone that is using Oracle10g with JBoss portal without having this problem?
If so, I could exclude a bug or an incompatibily with this database...

Thanks