Skip to main content

Java with MS SQL Server

1 reply [Last post]
tkkishore2000
Offline
Joined: 2009-06-08
Points: 0

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.

Reply viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.
peter__lawrey
Offline
Joined: 2005-11-01
Points: 0

MS-SQL works with JDBC and has done for years.

I don't know why you would chose C# over Java for connectivity/reports, I am not sure what difference you expect this to make. MS SQL supports SQL which is neither C# nor Java but a language in itself. The core query will be in SQL so it make no difference in my mind.