File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Oracle vs SQL Server with J2EE Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Oracle vs SQL Server with J2EE" Watch "Oracle vs SQL Server with J2EE" New topic

Oracle vs SQL Server with J2EE

Sunit Mukherjee

Joined: Dec 28, 2001
Posts: 18
Does anyone know of any reliable comparisons of JDBC performance using Oracle JDBC driver vs SQL Server JDBC driver? We are trying to evaluate reasons for going with Oracle vs SQL Server.
SJ Adnams
Ranch Hand

Joined: Sep 28, 2001
Posts: 925
you can be sure that there will be much busier sites than yours which run both.
The technical abilities of your staff should be a more important factor.
(or security even)?

my $0.02
Ranch Hand

Joined: Nov 22, 2008
Posts: 18944
I wouldn't say there are much differences in the JDBC driver regarding performance (talking about pure JDBC driver). The biggest difference should happen in the DB itself.
For Oracle there exists also an OCI driver (native) which can be called from java. This driver increases performance immens.
The other thing is also which machine are you running your db. Oracle needs a bigger box then MS SQL Server (Hope you really meant this with SQL Server).
[ September 24, 2003: Message edited by: Oliver Refle ]
I agree. Here's the link:
subject: Oracle vs SQL Server with J2EE
It's not a secret anymore!