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
~ 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!!"
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.