topic 'Connection Refused' while importing an ACP file in Alfresco Archive

'Connection Refused' while importing an ACP file

shea — Wed, 10 Feb 2010 19:18:09 GMT

Hi,I am trying to import an ACP file using command line Import utility.Does anyone know how to resolve the following error:11:45:34,269 INFO [org.alfresco.config.SystemPropertiesFactoryBean] Loading properties file from class path resource [alfresco/domain/hibern11:45:54,202 WARN [org.hibernate.cf

Re: 'Connection Refused' while importing an ACP file

shea — Thu, 11 Feb 2010 15:39:49 GMT

Hello there!

I am using Alfresco version 3.1.
Does anyone know that the connection problem that I have right now is due to lack of the configuration file.
I am able to use Alfresco Explorer to import ACP files, but not through the command line.

In particular, whether the Import Command Line Utility needs the following configuration file?
<extensionRoot>/alfresco/extension/custom-connection-pool-context.xml

Appreciate any help that I can get.

Thanks

Re: 'Connection Refused' while importing an ACP file

shea — Fri, 12 Feb 2010 21:40:15 GMT

All,

I had to add the hibernate.dialect value to the hibernate-cfg.properties file, even though it says in the properties file that it wil be detected automatically.
# The Hibernate Dialect:
#    As of V3.1, the dialect is automatically detected.
#    It is still possible to set the dialect explicitly, for example:
#       hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect
hibernate.dialect=org.alfresco.repo.domain.hibernate.dialect.AlfrescoOracle9Dialect

After restarting Alfresco 3.1 and tried the import command line again, I am getting the following error:

15:30:25,950 INFO [config.xml.XMLConfigService$PropertyConfigurer] Loading properties file from class path resource [alfresco/file-servers.properties]
15:30:49,923 ERROR [transaction.SpringAwareUserTransaction.trace] Detected first UserTransaction which is being garbage collected without a commit() or rollback()
15:30:49,961 ERROR [transaction.SpringAwareUserTransaction.trace] Logging of transaction call stack is now enabled and will affect performance
15:30:49,963 ERROR [transaction.SpringAwareUserTransaction.trace] UserTransaction being garbage collected without a commit() or rollback(). NOTE: Prior .

Does anyone out there know what is missing from the above exception?   Appreciate any help that I can get.

Thanks