Sunday, September 30th, 2007
public static synchronized Connection getConnection(String url); public static synchronized Connection getConnection(String url, java.util.Properties info); The third method listed here is by far the most elegant way of connecting to any JDBC driver. An intelligent Java application/applet will use Driver.getPropertyInfo (which will not be covered here) to get a list of all of the required and optional properties for the driver. The Java program can then prompt the user for this information, and then create a java.util.Properties object that contains an element for each of the driver properties to be used for the JDBC connection. The following code shows how to setup the java.util.Properties object: // Create the Properties object. java.util.Properties prop = new java.util.Properties(); // Populate the Properties object with each property to be passed to the // JDBC driver. prop.put(”UID”, “dept12″); prop.put(”PWD”, “Julie”); Connection con = DriverManager.getConnection(”jdbc:odbc:Accounting”, prop); JDBC To ODBC Calls: A Roadmap For all of you ODBC junkies, Tables 5.1 through 5.8 show each JDBC method and the corresponding ODBC call (only JDBC methods that actually make an ODBC call are included). I can hear you now: But isn t this a closely guarded national secret? What if someone takes this information to write another Bridge? First of all, the information provided here can be easily gathered by turning on the JDBC logging facility (DriverManager.setLogStream). The Bridge is nice enough to log every ODBC call as it is made, providing a log stream has been set via the DriverManager (all good JDBC drivers should provide adequate logging to aid in debugging). And second, the Bridge is provided for free. No one could possibly take this information to create a better Bridge at a lower price. It simply can t be done. I provide this information in an effort to help you better understand how the Bridge operates, and, if you are well versed in ODBC, to give you the direct correlation between the Bridge and ODBC. This should enable you to write advanced JDBC applications right off the starting line. Table 5.1 Driver ODBC calls. JDBC Interface Method ODBC Call Comments connect SQLDriverConnect The Bridge creates a connection string using the java.util. Properties
Please check java servlet web hosting services, here you will find professional-grade java servlet web hosting with the best prices.