[jboss-user] [JBoss Portal] - Re: Oracle11g

2008-11-27 Thread nvipas
This is now on JBoss Portal Wiki. Search term: Oracle11g Naga View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4192913#4192913 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4192913 ___

[jboss-user] [JBoss Portal] - Oracle11g

2008-11-27 Thread nvipas
To use JBoss Portal with Oracle11g, please refer to this post (if you encounter issues) - http://www.jboss.com/index.html?module=bb&op=viewtopic&t=146341 View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4192890#4192890 Reply to the post : http://www.jboss.com/

[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - Re: Oracle11g

2008-11-27 Thread nvipas
Ok, I am answering my own post, after trying out and finding the best approach to go about. (1) Do *NOT* use oracle.jdbc.driver.OracleDriver for Driver Class. Please *USE* this instead as clearly documented by Oracle Corporation - | oracle.jdbc.OracleDriver | as clearly documented b

[jboss-user] [JBoss Portal] - Re: No such user admin

2008-11-26 Thread nvipas
No changes done to jboss-portal.sar/conf/hibernate/user/setup.txt View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4192633#4192633 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4192633 _

[jboss-user] [JBoss Portal] - Re: No such user admin

2008-11-26 Thread nvipas
Here's the last bit of info ... | SQL> select object_type, count(object_type) | 2 from user_objects | 3 group by object_type; | | OBJECT_TYPE COUNT(OBJECT_TYPE) | --- -- | INDEX 134 | LOB

[jboss-user] [JBoss Portal] - Re: No such user admin

2008-11-26 Thread nvipas
Thanks for info on location of the .cfg.xml files. The issue was in portal-oracle-ds.xml. Having noticed there are two places to provide un/pw, I eliminated the un/pw in the connection-url line. And that somehow triggered the 'No such user admin' issue. Don't know how. Obviously this is som

[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - Oracle11g

2008-11-26 Thread nvipas
Has anyone tried with Oracle11g? What is the one to be used for Hibernate Dialect? Environment: - jdk1.6 - ojdbc6.jar - JVM on one box - Oracle11g on another box View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4192573#4192573 Reply to the post : http://www

[jboss-user] [JBoss Portal] - Re: No such user admin

2008-11-25 Thread nvipas
Third question - 3. In which xml/prop file can I change from Oracle9Dialect to Oracle10gDialect? View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4192311#4192311 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4192311

[jboss-user] [JBoss Portal] - Re: No such user admin

2008-11-25 Thread nvipas
Two questions - 1. Something to do with WARN for Oracle9Dialect? 2. Incremental Oracle Schema update issue? Do I need to drop the orcale user cascade, and rerun, for systematic re-creation of the database objects, including seed data? Thanks View the original post : http://www.jboss.com/i

[jboss-user] [JBoss Portal] - Re: No such user admin

2008-11-25 Thread nvipas
Here's first stack trace from console - | 16:15:08,111 INFO [JBossCachePersistenceManager] -- | --- | 16:15:08,111 INFO [JBossCachePersistenceManager] JBossCachePersistenceManager i | s fully loaded. | 16:15:08,111 INFO [JBossCachePer

[jboss-user] [JBoss Portal] - Re: No such user admin

2008-11-25 Thread nvipas
"PeterJ" wrote : Looking more closely at the error, it appears that the CMS code is having an issue with logging into the portal and loading the default CMS content. It would use a username of admin. | | Go into Oracle and do: select * from jbp_users; | | You should get two rows - one

[jboss-user] [JBoss Portal] - Re: No such user admin

2008-11-25 Thread nvipas
"PeterJ" wrote : anonymous wrote : --- MBeans waiting for other MBeans --- | | ObjectName: jboss.ejb:service=EJBTimerService,persistencePolicy=database | | State: CONFIGURED | | I Depend On: | | jboss.jca:service=DataSourceBinding,name=DefaultDS | | Looks like you also removed

[jboss-user] [JBoss Portal] - Re: No such user admin

2008-11-25 Thread nvipas
"PeterJ" wrote : I assume that you configured a *-ds.xml file to connect to Oracle. What username and password did you provide in that file? Is it a valid Oracle username and password? === Yes, valid username/password created using sqlplus with all necessary permissions - 1. CREAT

[jboss-user] [JBoss Portal] - Re: No such user admin

2008-11-25 Thread nvipas
== Environment is - == - jboss-portal-2.7.0.GA running on a Windows Vista box - Oracle10g running on another box (Windows XP) - jvm is jdk1.6.0_07 - ojdbc6.jar is in server/default/lib - portal-oracle-ds.xml is only *-ds.xml file in server/default/deploy di

[jboss-user] [JBoss Portal] - No such user admin

2008-11-25 Thread nvipas
Just installed JBoss Portal on a box. It uses Oracle10g on another box. server.log shows issues related to 'No such user admin'. Has anyone encountered this before? If yes, may I know how to overcome this issue? Thanks View the original post : http://www.jboss.com/index.html?module=bb&op=v