I'm trying to setup portal server instance on app server. I have configured
portal-oracle-ds.xml file as below
<local-tx-datasource>
<jndi-name>PortalDS</jndi-name>
<connection-url>jdbc:oracle:thin:@ip-address:1521:dsn</connection-url>
<driver-class>>oracle.jdbc.xa.client.OracleXADataSource</driver-class>
<user-name>user</user-name>
pass
</local-tx-datasource>
Is anything wrong here ? Any help is greatly appreciated.
All I did was moved jboss-portal.sar directory to server/default/deploy and copied the portal-oracle-ds.xml file to deploy directory.
I keep getting the following exceptions..:...
16:37:16,370 INFO DriverManagerConnectionProvider:147 - cleaning up connection pool: jdbc:derby:testDB10.1;create=true
org.hibernate.exception.SQLGrammarException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:59)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.doList(Loader.java:1306)
at org.hibernate.loader.Loader.list(Loader.java:1286)
at org.hibernate.hql.classic.QueryTranslatorImpl.list(QueryTranslatorImpl.java:872)
at org.hibernate.impl.SessionImpl.find(SessionImpl.java:973)
======
Caused by: java.sql.SQLException: ORA-00942: table or view does not exist
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:830)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2391)
