1 Reply Latest reply on Apr 2, 2010 4:23 AM by Benjamin Seyinbour

    "blob" does not exist

    Benjamin Seyinbour Expert

      Hello All,

       

      I don't know how many of you are using PostgreSQL with GateIn. I have “blob does not exist” error. Okay, I have edited both the configuration.properties file and the repository-configuration.xml for the  following:

       

      02portal.war
      gatein-sample-portal.ear/sample-portal.war
      gatein-sample-extension.ear/sample-ext.war

       

      I have added
      <property name="jbosscache-cl-cache.jdbc.node.type" value="bytea" />  /* 'bytea' in place of 'blob' */
      to each  repository-configuration.xml.

       

      But despite all these changes, I am still having the exception below:

       

      23:06:00,514 INFO  [TRAXTemplatesServiceImpl] XSLT schema found by relative path: xslt/get-method.xsl
      23:06:00,763 ERROR [RootContainer] Cannot create the portal container 'portal' . ServletContext: org.apache.catalina.core.ApplicationContextFacade@19852b0
      org.picocontainer.PicoIntrospectionException: Failed when calling start on org.exoplatform.services.jcr.impl.config.RepositoryServiceConfigurationImpl@14f4ed9
      at org.picocontainer.defaults.LifecycleVisitor.traverse(LifecycleVisitor.java:81)
      at org.picocontainer.defaults.LifecycleVisitor.start(LifecycleVisitor.java:113)
      at org.picocontainer.defaults.DefaultPicoContainer.start(DefaultPicoContainer.java:369)
      at org.exoplatform.container.PortalContainer.start(PortalContainer.java:568)
      at org.exoplatform.container.RootContainer.createPortalContainer(RootContainer.java:332)


      Caused by: java.lang.RuntimeException: org.exoplatform.services.jcr.config.RepositoryConfigurationException: Fail to init from xml! Reason: javax.jcr.RepositoryException: Database exception. org.postgresql.util.PSQLException: ERROR: type "blob" does not exist
      Position: 60. SQL: CREATE TABLE JCR_CONFIG (NAME VARCHAR(64) NOT NULL, CONFIG BLOB NOT NULL, CONSTRAINT JCR_CONFIG_PK PRIMARY KEY(NAME)): Database exception. org.postgresql.util.PSQLException: ERROR: type "blob" does not exist
      Position: 60. SQL: CREATE TABLE JCR_CONFIG (NAME VARCHAR(64) NOT NULL, CONFIG BLOB NOT NULL, CONSTRAINT JCR_CONFIG_PK PRIMARY KEY(NAME))
      at org.exoplatform.services.jcr.impl.config.RepositoryServiceConfigurationImpl.start(RepositoryServiceConfigurationImpl.java:288)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:597)
      at org.picocontainer.defaults.LifecycleVisitor.traverse(LifecycleVisitor.java:75)
      ... 75 more
      Caused by: org.exoplatform.services.jcr.config.RepositoryConfigurationException: Fail to init from xml! Reason: javax.jcr.RepositoryException: Database exception. org.postgresql.util.PSQLException: ERROR: type "blob" does not exist
      Position: 60. SQL: CREATE TABLE JCR_CONFIG (NAME VARCHAR(64) NOT NULL, CONFIG BLOB NOT NULL, CONSTRAINT JCR_CONFIG_PK PRIMARY KEY(NAME)): Database exception. org.postgresql.util.PSQLException: ERROR: type "blob" does not exist
      Position: 60. SQL: CREATE TABLE JCR_CONFIG (NAME VARCHAR(64) NOT NULL, CONFIG BLOB NOT NULL, CONSTRAINT JCR_CONFIG_PK PRIMARY KEY(NAME))
      ... 81 more
      Caused by: javax.jcr.RepositoryException: Database exception. org.postgresql.util.PSQLException: ERROR: type "blob" does not exist
      Position: 60. SQL: CREATE TABLE JCR_CONFIG (NAME VARCHAR(64) NOT NULL, CONFIG BLOB NOT NULL, CONSTRAINT JCR_CONFIG_PK PRIMARY KEY(NAME)): Database exception. org.postgresql.util.PSQLException: ERROR: type "blob" does not exist
      Position: 60. SQL: CREATE TABLE JCR_CONFIG (NAME VARCHAR(64) NOT NULL, CONFIG BLOB NOT NULL, CONSTRAINT JCR_CONFIG_PK PRIMARY KEY(NAME))
      at org.exoplatform.services.jcr.impl.config.RepositoryServiceConfigurationImpl.retain(RepositoryServiceConfigurationImpl.java:207)
      at org.exoplatform.services.jcr.impl.config.RepositoryServiceConfigurationImpl.start(RepositoryServiceConfigurationImpl.java:278)
      ... 80 more
      Caused by: org.exoplatform.services.jcr.config.RepositoryConfigurationException: Database exception. org.postgresql.util.PSQLException: ERROR: type "blob" does not exist
      Position: 60. SQL: CREATE TABLE JCR_CONFIG (NAME VARCHAR(64) NOT NULL, CONFIG BLOB NOT NULL, CONSTRAINT JCR_CONFIG_PK PRIMARY KEY(NAME))
      at org.exoplatform.services.jcr.impl.config.JDBCConfigurationPersister.write(JDBCConfigurationPersister.java:385)


      Any suggestions?

       



        • 1. Re: "blob" does not exist
          Benjamin Seyinbour Expert

          Problem is sorted!

           

          In my configuration.properties file, I made the following changes:

           

          # JCR

          .

          .

          .

          gatein.jcr.datasource.type=bytea
          gatein.jcr.datasource.dialect=pgsql

          gatein.jcr.datasource.driver=org.postgresql.Driver

           

           

          # IDM

          .

          .

          .

          gatein.idm.datasource.type=bytea
          gatein.idm.datasource.dialect=pgsql

          gatein.idm.datasource.driver=org.postgresql.Driver

           

           

           

          Gosh! GateIn then took 42m:42s:404ms to start up. Anyway, I am happy -- hope I haven't spoken too soon.

           

           

           

           

           

          B