[jboss-user] [JBoss Portal] - jboss-portal-2.6-ALPHA1-bundled with Oracle

[olivwalt]

Hello, 

jboss-portal-2.6-ALPHA1-bundled seems not to work with Oracle (9.2.0.5 Windows). 

The application Server starts up, but when i try to execute http://localhost:8080/portal i get the following exception 

  | 2007-01-18 12:13:08,743 DEBUG [org.hibernate.util.JDBCExceptionReporter] could not execute query [select this_.PK as PK56_1_, this_.PATH as PATH56_1_, this_.NAME as NAME56_1_, this_.PARENT_KEY as PARENT4_56_1_, securityco2_.NODE_KEY as NODE3_3_, securityco2_.PK as PK3_, securityco2_.ROLE as ROLE3_, securityco2_.PK as PK65_0_, securityco2_.ROLE as ROLE65_0_, securityco2_.NODE_KEY as NODE3_65_0_, actions3_.PK as PK4_, actions3_.ACTIONS as ACTIONS4_ from JBP_OBJECT_NODE this_ left outer join JBP_OBJECT_NODE_SEC securityco2_ on this_.PK=securityco2_.NODE_KEY left outer join JBP_OBJECT_NODE_SEC_ACTIONS actions3_ on securityco2_.PK=actions3_.PK where (this_.PATH=?)]
  | java.sql.SQLException: ORA-00942: Tabelle oder View nicht vorhanden

In Oracle the table JBP_OBJECT_NODE is missing.

On initial startup the Server.log shows no errors when creating the object

  | 2007-01-18 12:11:51,289 INFO  [org.hibernate.cfg.HbmBinder] Mapping class: org.jboss.portal.core.impl.model.portal.ObjectNode -> JBP_OBJECT_NODE
  | 2007-01-18 12:11:51,289 DEBUG [org.hibernate.cfg.HbmBinder] Mapped property: key -> PK
  | 2007-01-18 12:11:51,289 DEBUG [org.hibernate.cfg.HbmBinder] Mapped property: path -> PATH
  | 2007-01-18 12:11:51,299 DEBUG [org.hibernate.cfg.HbmBinder] Mapped property: name -> NAME
  | 2007-01-18 12:11:51,299 DEBUG [org.hibernate.cfg.HbmBinder] Mapped property: children
  | 2007-01-18 12:11:51,299 DEBUG [org.hibernate.cfg.HbmBinder] Mapped property: parent -> PARENT_KEY
  | 2007-01-18 12:11:51,299 DEBUG [org.hibernate.cfg.HbmBinder] Mapped property: object
  | 2007-01-18 12:11:51,299 DEBUG [org.hibernate.cfg.HbmBinder] Mapped property: securityConstraints

I can not find any errors in alert.log nor any user traces thrown by database.

Regards Oliver

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4003252#4003252

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4003252