[jboss-user] [JBoss Portal] - Re: SQL Server 2000 error on startup and for CMS on access

[esmith1]

If you want to switch to the ms jdbc driver, this worked for me 
1- download the latest Microsoft JDBC driver for 2005 server (sqljdbc.jar) and place into the deploy/xyz/lib;
2- grab the jboss-portal-2.6.4\setup\portal-sqlserver-ds.xml, edit it and change <driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class> then add 
	<type-mapping>MS SQLSERVER2000</type-mapping>
		
3- place portal-sqlserver-ds.xml into deploy/xyz/lib
4- no hibernate chgs
5- define the MS database with case insensitive because portal code is inconsistent and hits bugs otherwise


View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4141527#4141527

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4141527