1 Reply Latest reply on Feb 27, 2011 10:57 AM by anand9722

    Need help running Jboss portal 2.7.2 with oracle XE

    anand9722 Newbie

      Hi,

       

      I downloaded and installed Jboss portal 2.7.2, created a database user with appropriate permission.

      Changed the hibernate dialect to oracle 10g and database driver to oracle.jdbc.OracleDriver.

       

      However I am getting the below exception when starting jboss:

       

      13:11:42,171 ERROR [MainDeployer] Could not initialise deployment: file:/D:/jboss-portal-2.7.2/server/default/deploy/jboss-portal.sar/portal-wsrp.sar/default-wsrp.xml

      org.jboss.deployment.DeploymentException: Failed to parse source: Couldn't create Consumer 'self'; - nested throwable: (org.jboss.xb.binding.JBossXBException: Failed to parse source: Couldn't create C

      onsumer 'self')

              at org.jboss.portal.wsrp.deployment.WSRPDeployer.init(WSRPDeployer.java:111)

              at org.jboss.deployment.MainDeployer.init(MainDeployer.java:872)

              at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:809)

              at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)

      ..............

      Caused by: org.hibernate.exception.SQLGrammarException: could not get next sequence value

              at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)

              at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)

              at org.hibernate.id.SequenceGenerator.generate(SequenceGenerator.java:96)

              at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:99)

              at org.hibernate.event.def.DefaultPersistEventListener.entityIsTransient(DefaultPersistEventListener.java:131)

              at org.hibernate.event.def.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:87)

              at org.hibernate.event.def.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:38)

              at org.hibernate.impl.SessionImpl.firePersist(SessionImpl.java:618)

              at org.hibernate.impl.SessionImpl.persist(SessionImpl.java:592)

              at org.hibernate.impl.SessionImpl.persist(SessionImpl.java:596)

              at org.jboss.portal.wsrp.consumer.ConsumerRegistryService.org$jboss$portal$wsrp$consumer$ConsumerRegistryService$createConsumer$aop(ConsumerRegistryService.java:95)

              ... 168 more

      Caused by: java.sql.SQLSyntaxErrorException: ORA-02289: sequence does not exist

       

       

      I tried to create the sequences manuall using the below command but it was no good:

      create sequence hibernate_sequence;

      create sequence portal_seq;

      create sequence sec_seq;

      create sequence instance_seq;

      create sequence portlet_seq;

      create sequence user_seq;

       

       

      Below is the portal-oracle-ds.xml entries

      <datasources>

        <local-tx-datasource>

          <jndi-name>PortalDS</jndi-name>

          <connection-url>jdbc:oracle:thin:jbossportal/jbossportal@localhost:1521/XE</connection-url>

          <driver-class>oracle.jdbc.OracleDriver</driver-class>

          <user-name>jbossportal</user-name>

          <password>jbossportal</password>

        </local-tx-datasource>

      </datasources>

       

      and these are the SQL statements I used to create the user for Jboss portal:

      create user jbossportal identified by jbossportal;

       

      create temporary tablespace jboss_portal_temp tempfile 'C:\oraclexe\oradata\XE\jboss_portal_temp.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED;

       

      create tablespace jboss_portal_sys datafile 'C:\oraclexe\oradata\XE\jboss_portal_sys.dbf' size 200M reuse autoextend on next 5120k maxsize unlimited;

       

      ALTER USER jbossportal temporary tablespace jboss_portal_temp default tablespace jboss_portal_sys quota unlimited on jboss_portal_sys;

       

      GRANT CREATE SESSION TO jbossportal;

      GRANT ALTER ANY TABLE to jbossportal;

      GRANT SELECT ANY TABLE to jbossportal;

      GRANT UPDATE ANY TABLE to jbossportal;

      GRANT DROP ANY TABLE to jbossportal;

       

       

      GRANT CREATE ANY SEQUENCE to jbossportal;

      GRANT ALTER ANY SEQUENCE to jbossportal;

      GRANT DROP ANY SEQUENCE to jbossportal;

      GRANT SELECT ANY SEQUENCE to jbossportal;

       

      and I have placed ojdbc6.jar in JBOSS_HOME\server\default\lib folder....

       

       

      Any idea where I am going wrong ? Any help would greatly be appreciated,

        • 1. Need help running Jboss portal 2.7.2 with oracle XE
          anand9722 Newbie

          Found the solution to this problem, although its a temporary fix :

           

          It was something to do with the database permissions added the

          permission :

           

          grant DBA to jbossportal;

           

          And everything seems to work fine.

           

          The permissions for the portal DB credentials is not documented anywhere.

           

          Don't know why Jboss always makes great products with pathetic

          documentation. 

          1 of 1 people found this helpful