7 Replies Latest reply on Apr 6, 2006 11:34 AM by yxyang

    Error creating new directory on CMS

    masternet

      I'm creating new directory on CMS (in root folder, call 'new') and error ocurs:

      08:20:42,133 WARN [JDBCExceptionReporter] SQL Error: 0, SQLState: 23505
      08:20:42,133 ERROR [JDBCExceptionReporter] ERROR: duplicate key violates unique constraint "jbp_cms_wsp_prop_pkey"
      08:20:42,133 ERROR [AbstractFlushingEventListener] Could not synchronize database state with session
      org.hibernate.exception.ConstraintViolationException: could not insert: [org.jboss.portal.cms.hibernate.state.WSPProp]
       at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:69)
       at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
       at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2078)
       at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2427)
       at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:51)
       at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:243)
       at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:227)
      
      <...>
      
      08:20:42,243 ERROR [STDERR] javax.jcr.PathNotFoundException: /new
      08:20:42,243 ERROR [STDERR] at org.apache.jackrabbit.core.HierarchyManagerImpl.resolvePath(HierarchyManagerImpl.java:263)
      08:20:42,243 ERROR [STDERR] at org.apache.jackrabbit.core.CachingHierarchyManager.resolvePath(CachingHierarchyManager.java:127)
      08:20:42,243 ERROR [STDERR] at org.apache.jackrabbit.core.HierarchyManagerImpl.resolvePath(HierarchyManagerImpl.java:202)
      
      

      ---

      Help me :\

        • 1. Re: Error creating new directory on CMS
          theute

          Which version of JBoss Portal ?

          • 2. Re: Error creating new directory on CMS
            masternet

            JBoss Portal 2.2

            on

            jboss-4.0.4RC1

            with

            possgress 8.1 (using admin count)

            Thanks

            • 3. Re: Error creating new directory on CMS
              sitongia

              Same is happening to me, with PostgresQL 8.0 and Portal 2.4 (CVS).

              I've been playing with different types of generator classes in the HBM file WSPProp.hbm.xml, to no avail. I'm guessing that the tables in the database are generated from the HBM, but the changes I make in the HBM don't make a difference. I'm dropping the entire database in PostgresQL each time I test this.

              ==Leonard

              • 4. Re: Error creating new directory on CMS

                 

                "sitongia" wrote:
                Same is happening to me, with PostgresQL 8.0 and Portal 2.4 (CVS).

                I've been playing with different types of generator classes in the HBM file WSPProp.hbm.xml, to no avail. I'm guessing that the tables in the database are generated from the HBM, but the changes I make in the HBM don't make a difference. I'm dropping the entire database in PostgresQL each time I test this.

                ==Leonard


                Hi Leonard
                You mentioned tables in the database.I want these tables to be created in my remote database that is on the server. Where do I configure this? In fact I am baffled because I never created a database on my local machine nor do I remember having configured the PORTAL to work with my remote database.
                I am a little new to all this, so please bear with me. Thanks.

                How do I specify the remote datasource so that the tables are created in the database on the remote machine. Well, the thing is, I created a database on my local machine. I should be able to create the tables on that database atleast

                Thanks in advance


                • 5. Re: Error creating new directory on CMS
                  sitongia

                  The portal defaults to creating tables using an embedded Hypersonic database.

                  You can switch to another database using the instructions in the documentation:
                  http://docs.jboss.com/jbportal/v2.2/user-guide/en/html/installation.html#d0e558

                  There are other places in the documentation that databases are described.

                  ==Leonard

                  • 6. Re: Error creating new directory on CMS

                    hi Leonard
                    thanks. I will try that.

                    • 7. Re: Error creating new directory on CMS

                      i encount similar problem. postgresql 8.1.3 + jbp2.2.1.rc3 and jboss 4.0.3sp1.

                      when i try to use cms admin to add one new file, this error happened. It is really big problem to drop the whole database because of so many data already there.

                      pls help

                      yang