5 Replies Latest reply on Apr 28, 2009 11:51 AM by mazz

    Jopr - Oracle10g database access issue.

    senthurkumaran masilamani Newbie

      Hi All,

      I am in the process of configuring jopr in our organization.
      There are 2 types of database users.
      1. schema_owner
      2. schema_oper

      Shema owner has all access to the oracle schema.
      shema oper has only select,insert, update and delete access to all objects in the db.

      I have used schema owner account to install the jopr. All the schema objects created successfully.
      Now, I want to use oper account in jopr because of our organization policy prevents using owner accounts in applications.
      I have modified "rhq-server.properties" with jon oper account. But i am getting multiple errors when server startup.
      sample trace
      2009-04-24 11:36:41,147 WARN [org.jboss.system.ServiceController] Problem starting service jboss.mq:service=PersistenceManager
      org.jboss.mq.SpyJMSException: Could not resolve uncommited transactions. Message recovery may not be accurate; - nested throwable: (java.sql.SQLException: ORA-00942: table or view does not exist
      )
      at org.jboss.mq.pm.jdbc2.PersistenceManager.resolveAllUncommitedTXs(PersistenceManager.java:495)
      at org.jboss.mq.pm.jdbc2.PersistenceManager.startService(PersistenceManager.java:1809)
      at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
      at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
      at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)



      anybody please let me know how can I prevent these errors while using oper accounts?


      Thanks & Regards
      senthur