Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server 2005 vs Oracle 9i for JAVA Application Expand / Collapse
Author
Message
Posted Wednesday, October 7, 2009 7:33 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 2:10 AM
Points: 1,093, Visits: 1,221
Hi All,

We are group of 8 peoples which consists FE developers, BE developers and Business Analyst. We have plan for developing one HMS - Hospital Management System application.

Now the main debate is going on which platform to be used, as we have JAVA developers and SQL Server developers with us. For DB we have two options, 1. SQL Server 2005, 2. Oracle 9i

We have DB team which is well versed with SQL Server 2000/2005 and aware with Oracle 9i. We have come to a conclusion for using SQL Server 2005 as BE. Now for the FE we have only one option and that is JAVA.

So I wanted to know how SQL Server 2005 is suitable with JAVA or vice-versa? Which things to be taken care of while working on such platform?


Thanks in advance,

Mahesh


MH-09-AM-8694
Post #799153
Posted Thursday, October 8, 2009 1:19 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 2:44 AM
Points: 5,018, Visits: 10,532
SQL Server works great with Java. You just have to pick the right JDBC driver.
I have used JTDS and MSJDBC and they both perform well. Unfortunately they don't behave identically, but it'a a minor issue if you choose which one to use from the start.

Hope this helps
Gianluca


--
Gianluca Sartori

Get your two-cent-answer quickly
spaghettidba.com
@spaghettidba
Post #799739
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse