The documentation for java.sql.DriverManager (1.3) says that the getConnection() method has a signature that takes Properties. What I haven't found yet is any documentation that says what could be contained in that Properties set. (It lists it as an 'arbitrary set of string/value pairs.) Should I assume that that should be part of my driver's documentation? I'm looking for it for the MS SQL Server 2000 JDBC driver, but haven't yet found it.
I did end up finding my answer. . . Essentially, I had run across something that suggested I needed to pass in a property other than username or password (property was SelectMode for the SQL Server 2000 database), but I was having difficulty finding documentation for that property. I'm using a connection pooling mechanism provided by some in-house libraries, so haven't had to deal with things in as-detailed a manner as I might have had to otherwise. Under the covers, the connections added to the connection pool are created by setting the username and password as part of the Properties parameter. I ended up passing in my SelectMode property as part of the URL string for the connection. (Documentation for that property did exist in a different MS JDBC 2000 document - I just was looking in the wrong place.) Thanks! Tina