-
1. Re: Oracle 10g configuration
jon_french May 15, 2006 9:00 AM (in response to d.venturini)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 May 15, 2006 9:18 AM (in response to 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 May 15, 2006 9:34 AM (in response to d.venturini)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 May 15, 2006 10:10 AM (in response to 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
roy.russo May 16, 2006 11:38 AM (in response to d.venturini)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
roy.russo May 16, 2006 4:17 PM (in response to d.venturini)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 May 17, 2006 3:11 AM (in response to 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!