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 Jdbc Odbc Bridge Driver 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 "Jdbc Odbc Bridge Driver" Watch "Jdbc Odbc Bridge Driver" New topic

Jdbc Odbc Bridge Driver

Pratibha Malhotra
Ranch Hand

Joined: Dec 21, 2003
Posts: 199
1> What are the limitations of of using JDBCODBC Bridge Driver ??
One I know about is Memopry leakage. Can any body pls tell me hoew bridge
cause memory leakage.
2> Is Bridge Driver the default driver available in all webservers.
If not all then pls specify in what all web servers provide it as default driver.
and in which folder/subfolder can we find this driver in a webserver
3> We can restict the count of user that can access an application by configuration settings in webserver.
Can any body pls tell me where can we do this setting

~ Pratibha Malhotra<br /> <br />Sun Certified Java Programmer<br />SCEA 1.4 (In Progress)<br />~~~~~~~~~~~~~~~~~~~~~~~~~~~<br />"Many of life's failures are people who did not realize how close they were to success when they gave up!!"
David O'Meara

Joined: Mar 06, 2001
Posts: 13459

I ususally describe the JDBC:ODBC bridge as 'a crappy little hack added for fast integration to MS ODBC'.
Other problems include (but is not limitted to) a lack of thread safety, it isn't network enabled (the database must be local) and it has some programming bugs that won't be fixed beacuse it isn't actually supported. The JDBC FAQ at Sun's Java site may have more information.
It is not 'the default driver', it's a driver for ODBC Data Source, it only works with ODBC databases, and it comes packaged in the standard J2SE API. You 'find' it with all the other standard Java classes.
Question 3 is not a JDBC question. Please ask it in the Servlet forum.
Hope this helps.
Bosun Bello
Ranch Hand

Joined: Nov 06, 2000
Posts: 1510
Here is the FAQ regarding the JDBC-ODBC bridge.

So much trouble in the world -- Bob Marley
I agree. Here's the link:
subject: Jdbc Odbc Bridge Driver
It's not a secret anymore!