7 Replies Latest reply on May 17, 2006 3:11 AM by d.venturini

    Oracle 10g configuration

    d.venturini

      Hi,
      I have observed that the configuration of database the Oracle 10g doesn't work correctly. I'm following this steps:

      1. I have copied classes12.jar under folder <JBOSS_HOME>\server\default\lib
      2. I have created a file portal-oracle-ds.xml under folder <JBOSS_HOME>\server\default\deploy
      3. I have changed configuration in any folder contained in <JBOSS_HOME>\server\default\deploy\jboss-portal.sar\conf\hibernate
      named hibernate.cfg.xml with the following uncomment:
      <!-- Force the dialect instead of using autodetection -->
      org.hibernate.dialect.Oracle9Dialect

      I've lunched Jboss and the following error was showed:


      --- MBeans waiting for other MBeans ---
      ObjectName: portal:service=CMS
      State: FAILED
      Reason: org.hibernate.TransactionException: Transaction not successfully start
      ed
      I Depend On:
      jboss.jca:service=DataSourceBinding,name=PortalDS
      portal:service=JAASLoginModule
      Depends On Me:
      portal:mapper=CMSObject

      --- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---
      ObjectName: portal:service=CMS
      State: FAILED
      Reason: org.hibernate.TransactionException: Transaction not successfully start
      ed
      I Depend On:
      jboss.jca:service=DataSourceBinding,name=PortalDS
      portal:service=JAASLoginModule
      Depends On Me:
      portal:mapper=CMSObject

      08:39:39,984 INFO [Http11BaseProtocol] Starting Coyote HTTP/1.1 on http-0.0.0.0
      -8080
      08:39:40,109 INFO [ChannelSocket] JK: ajp13 listening on /0.0.0.0:8009
      08:39:40,109 INFO [JkMain] Jk running ID=0 time=0/78 config=null


      But if I erased the CMS directories (portal-cms.*) under jboss-portal.sar folder Jboss work correctly... off course without CMS content manager portlet application.

      I have not understood if the file hsqldb-ds.xml (under folder <JBOSS_HOME>\server\default\deploy) must be changed with new file of configuration oracledb-ds.xml...


      Thank you very much for any suggestions.

      Best Regards,
      Davide.

        • 1. Re: Oracle 10g configuration
          jon_french

          There is at least one outstanding Oracle issue is JBoss Portal JIRA:

          http://jira.jboss.com/jira/browse/JBPORTAL-816

          It appears different than what you are describing, but I wonder if you see this error also.

          • 2. Re: Oracle 10g configuration
            d.venturini

            Off course... the first time is very wonderful.... I'm maked a new oracle user and Jboss Portal by hibernate recreate all tables correctly and the portal works very done.
            But when I stop the service and restart it... I can see the same error:

            --- MBeans waiting for other MBeans ---
            ObjectName: portal:service=CMS
            State: FAILED
            Reason: org.hibernate.TransactionException: Transaction not successfully start
            ed
            I Depend On:
            jboss.jca:service=DataSourceBinding,name=PortalDS
            portal:service=JAASLoginModule
            Depends On Me:
            portal:mapper=CMSObject

            --- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---
            ObjectName: portal:service=CMS
            State: FAILED
            Reason: org.hibernate.TransactionException: Transaction not successfully start
            ed
            I Depend On:
            jboss.jca:service=DataSourceBinding,name=PortalDS
            portal:service=JAASLoginModule
            Depends On Me:
            portal:mapper=CMSObject

            Actually I'm using jboss-portal-2.2.1-bundled with Oracle10g XE ed.

            Thank you very much.

            Davide.

            • 3. Re: Oracle 10g configuration
              jon_french

              From the JIRA post:

              In looking at the table JBP_CMS_REPOSITORYENTRY, the row with FSENTRY_NAME=custom_nodetypes.xml has a null value for FSENTRY_DATA but a value of FSENTRY_LENGTH of 2270.


              Do you see this too?

              • 4. Re: Oracle 10g configuration
                d.venturini

                In looking at the table JBP_CMS_REPOSITORYENTRY, the row with FSENTRY_NAME=custom_nodetypes.xml has an xml document into the blob for FSENTRY_DATA and value of FSENTRY_LENGTH of 1659.

                Davide.

                • 5. Re: Oracle 10g configuration

                  I will take a look at it this week.

                  We have a planned 2.2.1SP1 going out soon, and I'll try to squeexe it in there.

                  • 6. Re: Oracle 10g configuration

                    I am not able to reproduce this bug.

                    Please look at http://jira.jboss.com/jira/browse/JBPORTAL-816 and tell me whats different from your environment.

                    Perhaps the driver version?

                    • 7. Re: Oracle 10g configuration
                      d.venturini

                      This is the my environment:

                      1. jdk1.5.0_04
                      2. Oracle 10g XE ed. Release 10.2.0.1.0 - Production
                      3. JBoss [Zion] 4.0.4.CR2 (jboss-portal-2.2.1-bundled)
                      4. JDBC driver version: 9.2.0.1.0
                      5. Hibernate dialect: org.hibernate.dialect.OracleDialect

                      This is a part of jboss startup:

                      08:49:19,375 INFO [SettingsFactory] RDBMS: Oracle, version: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
                      08:49:19,375 INFO [SettingsFactory] JDBC driver: Oracle JDBC driver, version: version: 9.2.0.1.0
                      ...
                      [org.hibernate.dialect.Dialect] Using dialect: org.hibernate.dialect.OracleDialect
                      ...
                      08:54:18,265 INFO [SettingsFactory] JDBC batch size: 15
                      08:54:18,265 INFO [SettingsFactory] JDBC batch updates for versioned data: disa
                      bled
                      08:54:18,265 INFO [SettingsFactory] Scrollable result sets: enabled
                      08:54:18,265 INFO [SettingsFactory] JDBC3 getGeneratedKeys(): disabled
                      08:54:18,265 INFO [SettingsFactory] Connection release mode: auto
                      08:54:18,265 INFO [SettingsFactory] Default batch fetch size: 1
                      08:54:18,265 INFO [SettingsFactory] Generate SQL with comments: disabled
                      08:54:18,265 INFO [SettingsFactory] Order SQL updates by primary key: disabled
                      08:54:18,265 INFO [SettingsFactory] Query translator: org.hibernate.hql.ast.AST
                      QueryTranslatorFactory
                      ...

                      That's all...

                      Thank you very much for your time!