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

[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

[neobyte]

My apologies, it appears the mysql connector was incorrectly installed - I'm still getting errors but I will troubleshoot myself for a while.