1 Reply Latest reply on Jul 7, 2005 9:58 AM by Dion Dodgen

    Permission denied error using PostgresRDBMSAdapter for J2EES

    Dion Dodgen Newbie

      Hi,
      I'm using
      org.apache.slide.store.impl.rdbms.PostgresRDBMSAdapter
      to run the
      org.apache.slide.store.impl.rdbms.J2EEStore

      I'm getting this error:
      14:43:48,759 ERROR [PostgresRDBMSAdapter] SQL error 0 on /: ERROR: permission denied for relation uri

      14:43:48,761 INFO [STDOUT] org.apache.slide.common.ServiceAccessException: Service org.apache.slide.store.impl.rdbms.J2EEStore@92de02 access error : ERROR: permission denied for relation uri

      Any advice appretiated,
      Dion

        • 1. Re: Permission denied error using PostgresRDBMSAdapter for J
          Dion Dodgen Newbie

          Hi,

          This has been run using Postgres8.0.3 and Postgres7.4 on Suse9.1 and Suse9.3
          The scriptCreatePostgresSchema.sql has been used.

          I should have included this as part of the stack trace above previous:-

          15:43:06,450 INFO [Domain] Initializing namespace : slide
          15:43:06,637 INFO [Namespace] Loading namespace slide parameters
          15:43:06,715 INFO [Namespace] Loading namespace definition
          15:43:06,859 INFO [Namespace] nodestore: org.apache.slide.store.impl.rdbms.J2EEStore
          15:43:06,994 INFO [J2EEStore] Retrieving datasource 'PortalDS'
          15:43:06,996 INFO [Namespace] securitystore references nodestore
          15:43:06,997 INFO [Namespace] lockstore references nodestore
          15:43:06,997 INFO [Namespace] revisiondescriptorsstore references nodestore
          15:43:06,997 INFO [Namespace] revisiondescriptorstore references nodestore
          15:43:06,997 INFO [Namespace] contentstore references nodestore
          15:43:07,015 INFO [logger] Setting TLock timeout for store j2ee to 20 seconds
          15:43:07,015 INFO [logger] Setting object cache size for store j2ee to 10000
          15:43:07,016 INFO [ExtendedStore] Setting permission cache size for store j2ee to 10000
          15:43:07,016 INFO [ExtendedStore] Setting lock cache size for store j2ee to 100
          15:43:07,016 INFO [ExtendedStore] Setting descriptors cache size for store j2ee to 10000
          15:43:07,016 INFO [ExtendedStore] Setting descriptor cache size for store j2ee to 10000
          15:43:07,016 INFO [ExtendedStore] Setting content caching for store j2ee to false
          15:43:07,016 INFO [ExtendedStore] Setting content cache size for store j2ee to 10000
          15:43:07,017 INFO [ExtendedStore] Setting content cache byte size for store j2ee to 10000000
          15:43:07,017 INFO [ExtendedStore] Setting transaction content cache size for store j2ee to 1000
          15:43:07,017 INFO [ExtendedStore] Setting transaction content cache byte size for store j2ee to 1000000
          15:43:07,017 INFO [ExtendedStore] Setting maximum byte size for content cache entry for store j2ee to 50000
          15:43:07,017 INFO [ExtendedStore] Enabling full caching causing low isolation
          15:43:07,164 INFO [Namespace] Registering Store j2ee (class org.apache.slide.store.ExtendedStore) with parameters {} on scope /
          15:43:07,197 INFO [Namespace] Initializing Store j2ee(org.apache.slide.store.ExtendedStore)
          15:43:07,619 INFO [Namespace] Loading namespace slide base data
          15:43:08,067 ERROR [PostgresRDBMSAdapter] SQL error 0 on /: ERROR: permission denied for relation uri
          15:43:08,071 INFO [STDOUT] org.apache.slide.common.ServiceAccessException: Service org.apache.slide.store.impl.rdbms.J2EEStore@1edc290 access error : ERROR: permission denied for relation uri
          15:43:08,073 INFO [STDOUT] at org.apache.slide.store.impl.rdbms.PostgresRDBMSAdapter.createException(PostgresRDBMSAdapter.java:341)


          Again any advice.....
          Thanks
          Dion