some problem config Alfresco to run with Microsoft SQL Serve

[sail]

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.SQLServerDriver
db.name=alfresco
db.url=jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=${db.name}
db.username=sa
db.password=sa‍‍‍‍‍‍

then, i modify the file "WEB-INF/classes/alfresco/domain/hibernate-cfg.properties", change the "hibernate.dialect":

hibernate.dialect=org.hibernate.dialect.SQLServerDialect‍‍

I create a database named "alfresco".

When I start my tomcat the first time, Alfresco startup successful. But when I start my tomcat the scond  time, Alfresco can not startup.

what's wrong?

thanks in adv.

[gavinc]

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

[sail]

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.

[steve]

Hi,

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

Thanks,

Steve

[sail]

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!

[steve]

Hi,

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

Steve