alfresco portlet + postgreSQL

[vincent]

Hello,

I have installed liferay portal (liferay-portal-tomcat-jdk5-4.2.1.zip) and the Alfresco portlet (liferay-portal-alfresco-4.2.1.war) both download on the liferay website. My OS is Windows XP and my application server is tomcat. The alfresco portlet works fine but it uses HSQL db and I would like that it uses postgreSQL db. I modified the following properties files
but that didn't works :


WEB-INF/classes/alfresco/extension/custom-db-connection.properties

db.username=alfresco
db.password=alfresco
db.driver=org.postgresql.Driver
db.url=jdbcostgresql://localhost/alfresco

WEB-INF/classes/alfresco/extension/custom-hibernate-dialect.properties

hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect


In WEB-INF/classes/alfresco/repository.properties

db.driver=org.postgresql.Driver
db.url=jdbcostgresql://localhost/alfresco
db.username=alfresco
db.password=alfresco

I created the database and the user in postgeSQL before

postgres=# \l
        List of databases
   Name    |  Owner   | Encoding
———–+———-+———–
alfresco  | alfresco | UTF8
lportal   | root     | UTF8
postgres  | alfresco | SQL_ASCII
template0 | root     | SQL_ASCII
template1 | root     | SQL_ASCII
(5 rows)

Does somebody know what I forgot to do?

Thanks

for information this is the tomcat log :

Deploying alfresco.war
  Expanding: \home\liferay\deploy\alfresco.war into C:\Liferay\temp\20070223090135863
  Adding Geronimo C:\Liferay\temp\20070223090135863\WEB-INF\geronimo-web.xml
  Modifying Servlet 2.3 C:\Liferay\temp\20070223090135863\WEB-INF\web.xml
  Warning: META-INF\MANIFEST.MF modified in the future.
  Warning: WEB-INF\classes\alfresco\extension\custom-db-connection.properties modified in the future
.
  Warning: WEB-INF\classes\alfresco\repository.properties modified in the future.
  Warning: META-INF modified in the future.
  Copying 5 files to C:\Liferay\bin\..\webapps\alfresco
  Copying 1 file to C:\Liferay\bin\..\webapps\alfresco
  Deleting directory C:\Liferay\temp\20070223090135863
09:01:43,137 INFO  [AutoDeployPortletListener:88] Portlets for \home\liferay\deploy\alfresco.war cop
ied successfully
23 f├®vr. 2007 09:01:44 org.apache.catalina.startup.HostConfig checkResources
INFO: Reloading context [/alfresco]
23 f├®vr. 2007 09:01:44 org.apache.catalina.core.StandardContext stop
INFO: Le conteneur org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/alfresco] n'a pas
├®t├® d├®marr├®
09:01:46,431 INFO  [HotDeployPortletListener:129] Registering portlets for alfresco
09:01:46,525 INFO  [HotDeployPortletListener:342] Portlets for alfresco registered successfully
09:01:54,392 ERROR [transform.magick.AbstractImageMagickContentTransformer] ImageMagickContentTransf
ormer not available: Failed to execute command: imconvert "C:\Liferay\temp\Alfresco\ImageMagickConte
ntTransformer_init_source_41565.gif"  "C:\Liferay\temp\Alfresco\ImageMagickContentTransformer_init_t
arget_41566.png"
09:01:55,454 ERROR [repo.transaction.TransactionUtil] Error rolling back transaction
java.lang.IllegalStateException: No user transaction is active
        at org.alfresco.util.transaction.SpringAwareUserTransaction.rollback(SpringAwareUserTransact
ion.java:450)
        at org.alfresco.repo.transaction.TransactionUtil.executeInTransaction(TransactionUtil.java:1
93)
        at org.alfresco.repo.transaction.TransactionUtil.executeInUserTransaction(TransactionUtil.ja
va:74)
        at org.alfresco.repo.dictionary.DictionaryRepositoryBootstrap.bootstrap(DictionaryRepository
Bootstrap.java:126)
        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:585)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustom
InitMethod(AbstractAutowireCapableBeanFactory.java:1093)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMe
thods(AbstractAutowireCapableBeanFactory.java:1063)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(A
bstractAutowireCapableBeanFactory.java:363)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory
.java:226)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory
.java:147)
        at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingle
tons(DefaultListableBeanFactory.java:275)
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicatio
nContext.java:320)
        at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(
AbstractRefreshableWebApplicationContext.java:134)
        at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.j
ava:246)
        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.jav
a:184)
        at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderLis
tener.java:49)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3729)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4187)
        at org.apache.catalina.startup.HostConfig.checkResources(HostConfig.java:1089)
        at org.apache.catalina.startup.HostConfig.check(HostConfig.java:1187)
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:292)
        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
        at org.apache.catalina.core.ContainerBase.backgroundProcess(ContainerBase.java:1305)
        at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processChildren(Conta
inerBase.java:1569)
        at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processChildren(Conta
inerBase.java:1578)
        at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.run(ContainerBase.jav
a:1558)
        at java.lang.Thread.run(Thread.java:595)
09:01:55,469 ERROR [web.context.ContextLoader] Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dictionaryRe
positoryBootstrap' defined in class path resource [alfresco/core-services-context.xml]: Initializati
on of bean failed; nested exception is org.springframework.transaction.CannotCreateTransactionExcept
ion: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.G
enericJDBCException: Cannot open connection
org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session f
or transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connec
tion
org.hibernate.exception.GenericJDBCException: Cannot open connection
        at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.j
ava:103)
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
        at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:420)
        at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
        at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:129)
        at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57)
        at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1290)
        at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransacti
onManager.java:520)
        at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction
(AbstractPlatformTransactionManager.java:282)
        at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfN
ecessary(TransactionAspectSupport.java:225)
        at org.alfresco.util.transaction.SpringAwareUserTransaction.begin(SpringAwareUserTransaction
.java:348)
        at org.alfresco.repo.transaction.TransactionUtil.executeInTransaction(TransactionUtil.java:1
67)
        at org.alfresco.repo.transaction.TransactionUtil.executeInUserTransaction(TransactionUtil.ja
va:74)
        at org.alfresco.repo.dictionary.DictionaryRepositoryBootstrap.bootstrap(DictionaryRepository
Bootstrap.java:126)
        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:585)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustom
InitMethod(AbstractAutowireCapableBeanFactory.java:1093)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMe
thods(AbstractAutowireCapableBeanFactory.java:1063)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(A
bstractAutowireCapableBeanFactory.java:363)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory
.java:226)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory
.java:147)
        at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingle
tons(DefaultListableBeanFactory.java:275)
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicatio
nContext.java:320)
        at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(
AbstractRefreshableWebApplicationContext.java:134)
        at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.j
ava:246)
        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.jav
a:184)
        at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderLis
tener.java:49)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3729)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4187)
        at org.apache.catalina.startup.HostConfig.checkResources(HostConfig.java:1089)
        at org.apache.catalina.startup.HostConfig.check(HostConfig.java:1187)
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:292)
        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
        at org.apache.catalina.core.ContainerBase.backgroundProcess(ContainerBase.java:1305)
        at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processChildren(Conta
inerBase.java:1569)
        at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processChildren(Conta
inerBase.java:1578)
        at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.run(ContainerBase.jav
a:1558)
        at java.lang.Thread.run(Thread.java:595)
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (FATA
L: database "alfresco;" does not exist)
        at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:855)
        at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
        at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalD
ataSourceConnectionProvider.java:80)
        at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:417)
        … 37 more
Caused by: org.postgresql.util.PSQLException: FATAL: database "alfresco;" does not exist
        at org.postgresql.core.v3.ConnectionFactoryImpl.readStartupMessages(ConnectionFactoryImpl.ja
va:443)
        at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.jav
a:98)
        at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)
        at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:125)
        at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
        at org.postgresql.jdbc3.Jdbc3Connection.<init>(Jdbc3Connection.java:24)
        at org.postgresql.Driver.makeConnection(Driver.java:382)
        at org.postgresql.Driver.connect(Driver.java:260)
        at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.
java:37)
        at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.ja
va:290)
        at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:87
7)
        at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:851)
        … 40 more
09:01:55,469 ERROR [[Catalina].[localhost].[/alfresco]] Exception lors de l'envoi de l'├®v├¿nement c
ontexte initialis├® (context initialized) ├á l'instance de classe d'├®coute (listener) org.springfra
mework.web.context.ContextLoaderListener
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dictionaryRe
positoryBootstrap' defined in class path resource [alfresco/core-services-context.xml]: Initializati
on of bean failed; nested exception is org.springframework.transaction.CannotCreateTransactionExcept
ion: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.G
enericJDBCException: Cannot open connection
org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session f
or transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connec
tion
org.hibernate.exception.GenericJDBCException: Cannot open connection
        at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.j
ava:103)
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
        at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:420)
        at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
        at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:129)
        at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57)
        at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1290)
        at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransacti
onManager.java:520)
        at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction
(AbstractPlatformTransactionManager.java:282)
        at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfN
ecessary(TransactionAspectSupport.java:225)
        at org.alfresco.util.transaction.SpringAwareUserTransaction.begin(SpringAwareUserTransaction
.java:348)
        at org.alfresco.repo.transaction.TransactionUtil.executeInTransaction(TransactionUtil.java:1
67)
        at org.alfresco.repo.transaction.TransactionUtil.executeInUserTransaction(TransactionUtil.ja
va:74)
        at org.alfresco.repo.dictionary.DictionaryRepositoryBootstrap.bootstrap(DictionaryRepository
Bootstrap.java:126)
        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:585)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustom
InitMethod(AbstractAutowireCapableBeanFactory.java:1093)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMe
thods(AbstractAutowireCapableBeanFactory.java:1063)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(A
bstractAutowireCapableBeanFactory.java:363)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory
.java:226)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory
.java:147)
        at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingle
tons(DefaultListableBeanFactory.java:275)
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicatio
nContext.java:320)
        at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(
AbstractRefreshableWebApplicationContext.java:134)
        at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.j
ava:246)
        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.jav
a:184)
        at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderLis
tener.java:49)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3729)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4187)
        at org.apache.catalina.startup.HostConfig.checkResources(HostConfig.java:1089)
        at org.apache.catalina.startup.HostConfig.check(HostConfig.java:1187)
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:292)
        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
        at org.apache.catalina.core.ContainerBase.backgroundProcess(ContainerBase.java:1305)
        at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processChildren(Conta
inerBase.java:1569)
        at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processChildren(Conta
inerBase.java:1578)
        at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.run(ContainerBase.jav
a:1558)
        at java.lang.Thread.run(Thread.java:595)
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (FATA
L: database "alfresco;" does not exist)
        at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:855)
        at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
        at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalD
ataSourceConnectionProvider.java:80)
        at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:417)
        … 37 more
Caused by: org.postgresql.util.PSQLException: FATAL: database "alfresco;" does not exist
        at org.postgresql.core.v3.ConnectionFactoryImpl.readStartupMessages(ConnectionFactoryImpl.ja
va:443)
        at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.jav
a:98)
        at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)
        at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:125)
        at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
        at org.postgresql.jdbc3.Jdbc3Connection.<init>(Jdbc3Connection.java:24)
        at org.postgresql.Driver.makeConnection(Driver.java:382)
        at org.postgresql.Driver.connect(Driver.java:260)
        at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.
java:37)
        at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.ja
va:290)
        at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:87
7)
        at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:851)
        … 40 more
09:01:55,469 ERROR [[Catalina].[localhost].[/alfresco]] Exception lors de l'envoi de l'├®v├¿nement c
ontexte initialis├® (context initialized) ├á l'instance de classe d'├®coute (listener) org.alfresco.
web.app.ContextListener
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dictionaryRe
positoryBootstrap' defined in class path resource [alfresco/core-services-context.xml]: Initializati
on of bean failed; nested exception is org.springframework.transaction.CannotCreateTransactionExcept
ion: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.G
enericJDBCException: Cannot open connection
org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session f
or transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connec
tion
org.hibernate.exception.GenericJDBCException: Cannot open connection
        at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.j
ava:103)
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
        at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:420)
        at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
        at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:129)
        at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57)
        at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1290)
        at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransacti
onManager.java:520)
        at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction
(AbstractPlatformTransactionManager.java:282)
        at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfN
ecessary(TransactionAspectSupport.java:225)
        at org.alfresco.util.transaction.SpringAwareUserTransaction.begin(SpringAwareUserTransaction
.java:348)
        at org.alfresco.repo.transaction.TransactionUtil.executeInTransaction(TransactionUtil.java:1
67)
        at org.alfresco.repo.transaction.TransactionUtil.executeInUserTransaction(TransactionUtil.ja
va:74)
        at org.alfresco.repo.dictionary.DictionaryRepositoryBootstrap.bootstrap(DictionaryRepository
Bootstrap.java:126)
        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:585)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustom
InitMethod(AbstractAutowireCapableBeanFactory.java:1093)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMe
thods(AbstractAutowireCapableBeanFactory.java:1063)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(A
bstractAutowireCapableBeanFactory.java:363)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory
.java:226)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory
.java:147)
        at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingle
tons(DefaultListableBeanFactory.java:275)
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicatio
nContext.java:320)
        at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(
AbstractRefreshableWebApplicationContext.java:134)
        at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.j
ava:246)
        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.jav
a:184)
        at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderLis
tener.java:49)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3729)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4187)
        at org.apache.catalina.startup.HostConfig.checkResources(HostConfig.java:1089)
        at org.apache.catalina.startup.HostConfig.check(HostConfig.java:1187)
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:292)
        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
        at org.apache.catalina.core.ContainerBase.backgroundProcess(ContainerBase.java:1305)
        at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processChildren(Conta
inerBase.java:1569)
        at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processChildren(Conta
inerBase.java:1578)
        at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.run(ContainerBase.jav
a:1558)
        at java.lang.Thread.run(Thread.java:595)
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (FATA
L: database "alfresco;" does not exist)
        at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:855)
        at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
        at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalD
ataSourceConnectionProvider.java:80)
        at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:417)
        … 37 more
Caused by: org.postgresql.util.PSQLException: FATAL: database "alfresco;" does not exist
        at org.postgresql.core.v3.ConnectionFactoryImpl.readStartupMessages(ConnectionFactoryImpl.ja
va:443)
        at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.jav
a:98)
        at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)
        at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:125)
        at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
        at org.postgresql.jdbc3.Jdbc3Connection.<init>(Jdbc3Connection.java:24)
        at org.postgresql.Driver.makeConnection(Driver.java:382)
        at org.postgresql.Driver.connect(Driver.java:260)
        at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.
java:37)
        at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.ja
va:290)
        at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:87
7)
        at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:851)
        … 40 more
23 f├®vr. 2007 09:01:55 org.apache.catalina.core.StandardContext start
SEVERE: Error listenerStart
23 f├®vr. 2007 09:01:55 org.apache.catalina.core.StandardContext start
SEVERE: Erreur de d├®marrage du contexte [/alfresco] suite aux erreurs pr├®c├®dentes
09:01:55,469 INFO  [HotDeployPortletListener:379] Unregistering portlets for alfresco
09:01:55,485 INFO  [HotDeployPortletListener:412] Portlets for alfresco unregistered successfully

[jmliege]

Hello,

Maybe the problem is that db tables are not created.

In order to deploy again with no problem (as you started first with HSQL),
you should delete all the alf_data folder.

Secondly, you modify one parameter of the db in your custom-db-connection.properties as follow:

db.schema.update=true

you can remove it later.

[vincent]

Hello,

Thank you very much for your reply JMLiege.

I will try your solution today, and I will post the result.

[vincent]

I found the solution to install the alfresco portlet on postgres.
We have to :

unpack the liferay-portal-alfresco-4.2.1.war:

delete the 3 files :

alfresco\WEB-INF\classes\alfresco\extension :

- custom-db-and-data-context.xml
- custom-db-connection.properties
- custom-hibernate-dialect.properties

and modify the file :

alfresco\WEB-INF\classes\alfresco\repository.properties

and put in the following values :

db.schema.update=true
db.driver=org.postgresql.Driver
db.name=alfresco
db.url=jdbcostgresql://localhost/alfresco
db.username=alfresco
db.password=alfresco
db.pool.initial=10
db.pool.max=20

Repack the all files in alfresco.war and deploy this archive with the autodeploy tool of liferay.

(if you installed the portlet before you have to remove the alf_data directory)

[jmliege]

In fact, you should keep those files and modify them in order to do the same, as it is recommended to avoid changes in the alfresco config files.
That's the main goal of such extension file.

Happy to see that the 'db.schema.update=true' helped you.

Best regards,
JM