AnsweredAssumed Answered

Problems installing on Suse 10, Java 1.6, Sun App Server

Question asked by neobyte on May 16, 2007
Latest reply on May 16, 2007 by neobyte
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.  I have created the local mysql database as per the script provided.  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:

[#|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
on.TransactionUtil] Error rolling back transaction
java.lang.IllegalStateException: No user transaction is active

[#|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
ntextLoader] Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dictionaryRepositoryBootstrap' defined in class path resource [alfres
co/core-services-context.xml]: Initialization of bean failed; nested exception is org.springframework.transaction.CannotCreateTransactionException: Could not
open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection
org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.excepti
on.GenericJDBCException: Cannot open connection
org.hibernate.exception.GenericJDBCException: Cannot open connection

[#|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-
b7d4-cbec70947b1a;|WebModule[/alfresco]Exception sending context initialized event to listener instance of class org.springframework.web.context.ContextLoade
rListener
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dictionaryRepositoryBootstrap' defined in class path resource [alfres
co/core-services-context.xml]: Initialization of bean failed; nested exception is org.springframework.transaction.CannotCreateTransactionException: Could not
open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection
org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.excepti
on.GenericJDBCException: Cannot open connection
org.hibernate.exception.GenericJDBCException: Cannot open connection

[#|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-
b7d4-cbec70947b1a;|WebModule[/alfresco]Exception sending context initialized event to listener instance of class org.alfresco.web.app.ContextListener
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dictionaryRepositoryBootstrap' defined in class path resource [alfres
co/core-services-context.xml]: Initialization of bean failed; nested exception is org.springframework.transaction.CannotCreateTransactionException: Could not
open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection
org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.excepti
on.GenericJDBCException: Cannot open connection
org.hibernate.exception.GenericJDBCException: Cannot open connection

As you can see, basically JDBC errors.  Is there something special I need to set up?  Sun App Server supports mysql connections by default.  I will freely admit I am not an expert in configuring Java apps.  I am also not familiar with Hibernate.

I have checked the database "alfresco" and it is still empty of tables, so it hasn't got as far as initializing yet.

Many thanks in advance for your input.

Cheers
Rich

Outcomes