Java with MS SQL Server
We are considering using Java with MS SQL server instead of Oracle to save money. Does using MS SQL server pose any problems ? I have worked on enough Java projects to know that any JDBC datasource will work. But I was wondering if there are any other issues we should consider ?
We plan on using Spring quite heavily, JSP/JSF, and may be YUI. We may use Hibernate too.
jTDS or MS Sql Server will have database drivers available for Java applications down the road, right ?
We might need reporting capabilities from the database in future. If we have to allow users to generate reports, then i guess it makes sense to go with C#.net instead of Java, right ?
I have already proposed MySQL but the admin group does not support it.