Meaningless Drivel is fun!*
The moose likes JDBC and the fly likes Best JDBC drivers? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Best JDBC drivers?" Watch "Best JDBC drivers?" New topic
Author

Best JDBC drivers?

Fergus Red
Ranch Hand

Joined: Apr 25, 2002
Posts: 42
I'm just wondering what's regarded as the best jdbc driver to use?
What free jdbc drivers are out there also. And which of these are best?
Also if any of you use JRun 3.1 as your application web server then what's best for that also?
Ken Robinson
Ranch Hand

Joined: Jul 25, 2002
Posts: 52
The driver you use will be greatly influenced, if not dictated, by the database you are using.
I would suggest trying to get a driver from the vendor of the DB you are using. If that is not possible, try looking for 3rd party vendors.
David O'Meara
Rancher

Joined: Mar 06, 2001
Posts: 13459

"Whiteemerson",
The Java Ranch has thousands of visitors every week, many with surprisingly similar names. To avoid confusion we have a naming convention, described at http://www.javaranch.com/name.jsp.
We require names to have at least two words, separated by a space, and strongly recommend that you use your full real name. Please edit your profile and select a new name which meets the requirements.
Thanks.
Dave
Piyush Daiya
Ranch Hand

Joined: Jun 13, 2002
Posts: 67
hi,
jdbc drivers will be dependant on the db you are using. You can get list of jdbc drivers available at:-
http://industry.java.sun.com/products/jdbc/drivers

Piyush


"A scientist is not person who gives right answers but a person who asks right questions"
Fergus Red
Ranch Hand

Joined: Apr 25, 2002
Posts: 42
The database is MS SQL Server 2000
Fergus Red
Ranch Hand

Joined: Apr 25, 2002
Posts: 42
jusy going to change my details as suggested for my name display
Piyush Daiya
Ranch Hand

Joined: Jun 13, 2002
Posts: 67
Hi,
You can find the list of jdbc drivers for MS SQL server available on http://industry.java.sun.com/products/jdbc/drivers
or you can download jdbc driver from microsoft
http://msdn.microsoft.com/downloads/default.asp?URL=/downloads/sample.asp?url=/MSDN-FILES/027/001/779/msdncompositedoc.xml
and for sample code
http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q313100&

Hope, this helps out.
Piyush
Fergus Red
Ranch Hand

Joined: Apr 25, 2002
Posts: 42
Do you know if the JDBC drivers come with MS SQL Server 2000 when you install it, or do you have to go and download them afterwards (Don't want to be overwriting drivers if they already exist?
If they have to be donwloaded then I will do so as you suggest.

Cheers for the help by the way.
Fergus Red
Ranch Hand

Joined: Apr 25, 2002
Posts: 42
I just downloaded and installed the jdbc driver.
Cheers for the help all.
 
 
subject: Best JDBC drivers?
 
Similar Threads
Using Eclipse SWT Image, JDBC SQLite and JAVA to insert, store and retrieve Images.
JDBC2 Driver for oracle
JDBC driver with WLS6.1sp3 and Oracle9
Usage of Polymorphism feature in a project
unimplemented or unreasonable request at ps.execute()