"blob" does not exist
ebross Apr 1, 2010 7:42 PMHello 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?