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#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...