AnsweredAssumed Answered

Alfresco and SQL Server configuration

Question asked by mail2vijaysri on Jul 17, 2009
Hi,

Am configuring Alfresco Enterprise 3.1 Release with SQL Server. Getting error as org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Incorrect syntax near 'SNAPSHOT'.). Modified custom-repository.props as below

db.driver=net.sourceforge.jtds.jdbc.Driver
db.url=jdbc:jtds:sqlserver://localhost:1433/alfresco
db.txn.isolation=4096.

changed custom-hibernate-dialect.properties as -

hibernate.dialect=org.alfresco.repo.domain.hibernate.dialect.AlfrescoSQLServerDialect


Any pointer will be helpful.

regds,
Vijay

Outcomes