I have used this combination in some testing recently. Other
than a bug with columns marked 'REAL NOT NULL' not working corectly, I had no other problems. To get REAL columns working right, remove the NOT NULL.
My tests were VERY 'select' specific as I was porting an existing CF app over. YMMV
We use JBoss 3.0.0 and SQLServer 2000 via Opta 2000 JDBC driver (www.inetsoftware.de). It works great. Very fast and complete implemenation. Unfortunatly very expensive ($795). The MS Driver seems to work as well but we already had Opta 2000.
We use it on 2.4.7 and 3.0
We use the Microsoft JDBC drivers.
Everything seems to work fine.