4 Replies Latest reply on Apr 15, 2008 5:49 AM by Stefano Solfaroli

    Admin Portlet: Strange Behavior with Oracle-DB

    Stephan Eisermann Newbie

      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!

        • 1. Re: Admin Portlet: Strange Behavior with Oracle-DB
          Peter Johnson Master

          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).

          • 2. Re: Admin Portlet: Strange Behavior with Oracle-DB
            Stephan Eisermann Newbie

            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!


            • 3. Re: Admin Portlet: Strange Behavior with Oracle-DB
              Stefano Solfaroli Newbie

              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


              • 4. Re: Admin Portlet: Strange Behavior with Oracle-DB
                Stefano Solfaroli Newbie

                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