topic Re: Install 2.1 - Tomcat - HSQLDB in Alfresco Archive

Install 2.1 - Tomcat - HSQLDB

fif — Mon, 06 Aug 2007 10:07:09 GMT

HelloI'm trying to install Alfresco 2.1 Tomcat Bundled Installation: I want to use the embedded HSQLDB databaseSo I extract in c:\ the alfresco folder.The JAVA_HOME is configure to my JDK : E:\Program Files\Java\jdk1.6.0If I start 'alf_start.bat' a console open. It's seems to start tomcat but after

Re: Install 2.1 - Tomcat - HSQLDB

fif — Mon, 06 Aug 2007 13:59:25 GMT

ok after few hours ….
Actully, I was using a JDK 64bit.
I change my JAVA_HOME to a 32bits JDK, and now :
everything is OK.

Thanks

Re: Install 2.1 - Tomcat - HSQLDB

binlah — Wed, 15 Aug 2007 08:23:34 GMT

I'm trying to install Alfresco 2.1 .war package with Tomcat 5.5, MySQL, JDK 5.0 on Window XP and getting the same problem to you.

but I already set JAVA_HOME to correct location :C:\Java\jdk1.5.0_11
this is 32bit JDK.

can somebody help me?

thank you.

2007-08-15 15:11:14,203 INFO [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/alfresco]] - Loading Spring root WebApplicationContext
2007-08-15 15:11:20,109 ERROR [org.hibernate.util.JDBCExceptionReporter] - Cannot create PoolableConnectionFactory (Access denied for user 'alfresco'@'localhost' (using password: YES))
2007-08-15 15:11:28,984 ERROR [org.hibernate.util.JDBCExceptionReporter] - Cannot create PoolableConnectionFactory (Access denied for user 'alfresco'@'localhost' (using password: YES))
2007-08-15 15:11:28,984 ERROR [org.hibernate.util.JDBCExceptionReporter] - Cannot create PoolableConnectionFactory (Access denied for user 'alfresco'@'localhost' (using password: YES))
2007-08-15 15:11:29,031 ERROR [org.springframework.web.context.ContextLoader] - Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dictionaryRepositoryBootstrap' defined in class path resource [alfresco/core-services-context.xml]: Invocation of init method failed; nested exception is org.alfresco.error.AlfrescoRuntimeException: Failure during rollback: org.alfresco.repo.dictionary.DictionaryRepositoryBootstrap$1@1822112
Caused by:
org.alfresco.error.AlfrescoRuntimeException: Failure during rollback: org.alfresco.repo.dictionary.DictionaryRepositoryBootstrap$1@1822112
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:281)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:155)
   at org.alfresco.repo.dictionary.DictionaryRepositoryBootstrap.bootstrap(DictionaryRepositoryBootstrap.java:134)
   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.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1160)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1122)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1085)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:429)
   at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:250)
   at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141)
   at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:247)
   at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:161)
   at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:273)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:346)
   at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:156)
   at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)
   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184)
   at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
   at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3763)
   at org.apache.catalina.core.StandardContext.start(StandardContext.java:4211)
   at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
   at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
   at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
   at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:809)
   at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:698)
   at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:472)
   at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1122)
   at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310)
   at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1021)
   at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1013)
   at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)
   at org.apache.catalina.core.StandardService.start(StandardService.java:450)
   at org.apache.catalina.core.StandardServer.start(StandardServer.java:709)
   at org.apache.catalina.startup.Catalina.start(Catalina.java:551)
   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.apache.catalina.startup.Bootstrap.start(Bootstrap.java:294)
   at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:432)
Caused by: java.lang.IllegalStateException: No user transaction is active
   at org.alfresco.util.transaction.SpringAwareUserTransaction.rollback(SpringAwareUserTransaction.java:479)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:276)
   … 44 more

Re: Install 2.1 - Tomcat - HSQLDB

marinew — Fri, 17 Aug 2007 12:39:14 GMT

Hello,

I have the same error too.
Config : Alfresco 2.1.0 + Tomcat bundle, JDK 1.5.0_08, Debian Etch 4.0, default HSQL database.
Alfresco seems to work correctly. But when I want to stop and start again Tomcat, I have the error. I have to reboot in order to be able to start successfully Tomcat.

The error :

12:17:35,089 ERROR [[Catalina].[localhost].[/alfresco]] Exception lors de l'envoi de l'ÃƒÂ©vÃƒÂ¨nement contexte 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 'dictionaryRepositoryBootstrap' defined in class path resource [alfresco/core-services-context.xml]: Invocation of init method failed; nested exception is org.alfresco.error.AlfrescoRuntimeException: Failure during rollback: org.alfresco.repo.dictionary.DictionaryRepositoryBootstrap$1@1cbc5cb
Caused by:
org.alfresco.error.AlfrescoRuntimeException: Failure during rollback: org.alfresco.repo.dictionary.DictionaryRepositoryBootstrap$1@1cbc5cb
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:281)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:155)
        at org.alfresco.repo.dictionary.DictionaryRepositoryBootstrap.bootstrap(DictionaryRepositoryBootstrap.java:134)
        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.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1160)
(…)
Caused by: java.lang.IllegalStateException: No user transaction is active
        at org.alfresco.util.transaction.SpringAwareUserTransaction.rollback(SpringAwareUserTransaction.java:479)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:276)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Any idea about this problem ?

Thanks.

Re: Install 2.1 - Tomcat - HSQLDB

dominique — Thu, 30 Aug 2007 11:29:16 GMT

I got this problem too.

I think solved it by cleaning my MySQL DB, by issuing the

extras/databases/mysql/db_remove.bat

and the

extras/databases/mysql/db_setup.bat tools.

Next, I also removed the "alfresco" folder in "tomcat/webapps", the alf_data folder and the "tomcat/work/Catalina/localhost/alfresco" folder.

Hope this helps,

Dominique

Re: Install 2.1 - Tomcat - HSQLDB

dominique — Thu, 30 Aug 2007 19:56:00 GMT

OK, now I got the problem too for the HSQL database.
If you use that, YOU CAN NOT DELETE THE alf_data folder !

alf_data/hsql_data

It needs to be kept in place (see the original tomcat-alfresco zip).

For cleaning DB, only delete the other subfolders inside alf_data

To resume, if you got an error like that, you're DB is not set up correctly !

Re: Install 2.1 - Tomcat - HSQLDB

marinew — Thu, 30 Aug 2007 20:48:04 GMT

Thanks for your tip.
Does that means that you loose all your data, if you already started working with Alfresco ?

I finally migrated to Mysql instead of HSQL, and it worked. At this time, I don't have the problem anymore…