topic Problems installing on Suse 10, Java 1.6, Sun App Server in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/problems-installing-on-suse-10-java-1-6-sun-app-server/m-p/104885#M73290 <HTML><HEAD></HEAD><BODY><SPAN>Hello,</SPAN><BR /><BR /><SPAN>I am trying to install Alfresco on our existing Sun Java System Application Server 9, which runs on 1.6 on SUSE 10.</SPAN><BR /><BR /><SPAN>I cannot open the default page and get a lot of errors.&nbsp; I have created the local mysql database as per the script provided.&nbsp; Here are a few of the errors that come up (stack trace removed for readability), in the order they appear in the server logs after startup:</SPAN><BR /><BR /><SPAN>[#|2007-05-16T10:59:41.094+0800|INFO|sun-appserver-pe9.0|javax.enterprise.system.stream.out|_ThreadID=10;_ThreadName=main;|10:59:41,088 ERROR [repo.transacti</SPAN><BR /><SPAN>on.TransactionUtil] Error rolling back transaction</SPAN><BR /><SPAN>java.lang.IllegalStateException: No user transaction is active</SPAN><BR /><BR /><SPAN>[#|2007-05-16T10:59:41.113+0800|INFO|sun-appserver-pe9.0|javax.enterprise.system.stream.out|_ThreadID=10;_ThreadName=main;|10:59:41,109 ERROR [web.context.Co</SPAN><BR /><SPAN>ntextLoader] Context initialization failed</SPAN><BR /><SPAN>org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dictionaryRepositoryBootstrap' defined in class path resource [alfres</SPAN><BR /><SPAN>co/core-services-context.xml]: Initialization of bean failed; nested exception is org.springframework.transaction.CannotCreateTransactionException: Could not</SPAN><BR /><SPAN> open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection</SPAN><BR /><SPAN>org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.excepti</SPAN><BR /><SPAN>on.GenericJDBCException: Cannot open connection</SPAN><BR /><SPAN>org.hibernate.exception.GenericJDBCException: Cannot open connection</SPAN><BR /><BR /><SPAN>[#|2007-05-16T10:59:41.112+0800|SEVERE|sun-appserver-pe9.0|javax.enterprise.system.container.web|_ThreadID=10;_ThreadName=main;_RequestID=043103ec-4ad7-4edf-</SPAN><BR /><SPAN>b7d4-cbec70947b1a;|WebModule[/alfresco]Exception sending context initialized event to listener instance of class org.springframework.web.context.ContextLoade</SPAN><BR /><SPAN>rListener</SPAN><BR /><SPAN>org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dictionaryRepositoryBootstrap' defined in class path resource [alfres</SPAN><BR /><SPAN>co/core-services-context.xml]: Initialization of bean failed; nested exception is org.springframework.transaction.CannotCreateTransactionException: Could not</SPAN><BR /><SPAN> open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection</SPAN><BR /><SPAN>org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.excepti</SPAN><BR /><SPAN>on.GenericJDBCException: Cannot open connection</SPAN><BR /><SPAN>org.hibernate.exception.GenericJDBCException: Cannot open connection</SPAN><BR /><BR /><SPAN>[#|2007-05-16T10:59:41.119+0800|SEVERE|sun-appserver-pe9.0|javax.enterprise.system.container.web|_ThreadID=10;_ThreadName=main;_RequestID=043103ec-4ad7-4edf-</SPAN><BR /><SPAN>b7d4-cbec70947b1a;|WebModule[/alfresco]Exception sending context initialized event to listener instance of class org.alfresco.web.app.ContextListener</SPAN><BR /><SPAN>org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dictionaryRepositoryBootstrap' defined in class path resource [alfres</SPAN><BR /><SPAN>co/core-services-context.xml]: Initialization of bean failed; nested exception is org.springframework.transaction.CannotCreateTransactionException: Could not</SPAN><BR /><SPAN> open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection</SPAN><BR /><SPAN>org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.excepti</SPAN><BR /><SPAN>on.GenericJDBCException: Cannot open connection</SPAN><BR /><SPAN>org.hibernate.exception.GenericJDBCException: Cannot open connection</SPAN><BR /><BR /><SPAN>As you can see, basically JDBC errors.&nbsp; Is there something special I need to set up?&nbsp; Sun App Server supports mysql connections by default.&nbsp; I will freely admit I am not an expert in configuring Java apps.&nbsp; I am also not familiar with Hibernate.</SPAN><BR /><BR /><SPAN>I have checked the database "alfresco" and it is still empty of tables, so it hasn't got as far as initializing yet.</SPAN><BR /><BR /><SPAN>Many thanks in advance for your input.</SPAN><BR /><BR /><SPAN>Cheers</SPAN><BR /><SPAN>Rich</SPAN></BODY></HTML> Wed, 16 May 2007 03:36:26 GMT neobyte 2007-05-16T03:36:26Z Problems installing on Suse 10, Java 1.6, Sun App Server https://connect.hyland.com/t5/alfresco-archive/problems-installing-on-suse-10-java-1-6-sun-app-server/m-p/104885#M73290 Hello,I am trying to install Alfresco on our existing Sun Java System Application Server 9, which runs on 1.6 on SUSE 10.I cannot open the default page and get a lot of errors.&nbsp; I have created the local mysql database as per the script provided.&nbsp; Here are a few of the errors that come up (stack trac Wed, 16 May 2007 03:36:26 GMT https://connect.hyland.com/t5/alfresco-archive/problems-installing-on-suse-10-java-1-6-sun-app-server/m-p/104885#M73290 neobyte 2007-05-16T03:36:26Z Re: Problems installing on Suse 10, Java 1.6, Sun App Server https://connect.hyland.com/t5/alfresco-archive/problems-installing-on-suse-10-java-1-6-sun-app-server/m-p/104886#M73291 <HTML><HEAD></HEAD><BODY><SPAN>My apologies, it appears the mysql connector was incorrectly installed - I'm still getting errors but I will troubleshoot myself for a while.</SPAN></BODY></HTML> Wed, 16 May 2007 06:31:02 GMT https://connect.hyland.com/t5/alfresco-archive/problems-installing-on-suse-10-java-1-6-sun-app-server/m-p/104886#M73291 neobyte 2007-05-16T06:31:02Z