topic some problem config Alfresco to run with Microsoft SQL Serve in Alfresco Archive

some problem config Alfresco to run with Microsoft SQL Serve

sail — Mon, 06 Mar 2006 03:49:10 GMT

I want to config Alfresco1.2.0RC2 to run with Microsoft SQL Serve 2000.After getting some information from the wiki, I modify the file "WEB-INF/classes/alfresco/repository.properties", change the Database configuration as below:db.driver=com.microsoft.jdbc.sqlserver.SQLServerDriverdb.name=alfrescodb

Re: some problem config Alfresco to run with Microsoft SQL Serve

gavinc — Mon, 06 Mar 2006 10:57:49 GMT

After you made the changes did you re-deploy the Alfresco WAR file?

If you did, then the webapp will get re-deployed and overwrite all your changes.

As from 1.2RC2 we do not recommend changing any of the Alfresco configuration files, there is now a mechanism in place for supplying overridden configuration, see this wiki page for more details: http://www.alfresco.org/mediawiki/index.php/Repository_Configuration

Re: some problem config Alfresco to run with Microsoft SQL Serve

sail — Tue, 07 Mar 2006 03:05:47 GMT

I am sure that I have re-deployed the Alfresco WAR file.

After doing these changes,I start tomcat and Alfresco runs well. The folder "alf_data" was created automaticly by Alfresco, and all the tables needed was created in the database. There is nothing wrong.

But when I restart my tomcat, Alfresco can not startup, and throws some Exceptions about Hibernate and JDBC.

Is this a bug? or is there something wrong with my configuration?

thanks in adv.

Re: some problem config Alfresco to run with Microsoft SQL Serve

steve — Tue, 07 Mar 2006 08:26:48 GMT

Hi,

Can you post the errors you get when you restart Tomcat please?

Thanks,

Steve

Re: some problem config Alfresco to run with Microsoft SQL Serve

sail — Wed, 08 Mar 2006 01:00:03 GMT

I have got the reason of this problem.

It is that the Microsoft JDBC for SQLServer 2000 has some bugs.
http://support.microsoft.com/kb/824106

I change the JDBC, now using JTDS.
http://jtds.sourceforge.net/
http://sourceforge.net/projects/jtds/

Everything goes well now.

Thank you!

Re: some problem config Alfresco to run with Microsoft SQL Serve

steve — Wed, 08 Mar 2006 10:47:20 GMT

Hi,

Thanks for the update, and letting us know what you did to resolve the issue.

Steve