Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Jdbc Odbc Bridge Driver

 
Pratibha Malhotra
Ranch Hand
Posts: 199
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
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
 
David O'Meara
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
Dave.
 
Bosun Bello
Ranch Hand
Posts: 1511
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Here is the FAQ regarding the JDBC-ODBC bridge.
http://java.sun.com/products/jdbc/faq.html
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic