[jboss-user] [JBoss Portal] - Need help running Jboss portal 2.7.2 with oracle XE

[anand9722]

anand9722 [http://community.jboss.org/people/anand9722] created the discussion

"Need help running Jboss portal 2.7.2 with oracle XE"

To view the discussion, visit: http://community.jboss.org/message/589901#589901

--------------------------------------------------------------
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 at 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,
--------------------------------------------------------------

Reply to this message by going to Community
[http://community.jboss.org/message/589901#589901]

Start a new discussion in JBoss Portal at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2011]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20110227/18e3a9e0/attachment.html