0 Replies Latest reply on Jan 4, 2006 2:35 PM by Ram Alluri

    portal-oracle-ds file

    Ram Alluri Newbie

      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)