How to Generate a List of Supported Connection Properties

You can use connection properties in order to control the behavior of a SAS driver. To determine which connection properties are supported by a specific SAS driver for JDBC, you write code that iterates through the DriverPropertyInfo that is returned from the Driver.getPropertyInfo method. The following sample code shows how this task is done.

String url = "jdbc:subprotocol://hostName:port"; 
Driver driver = null;
DriverPropertyInfo [] driverProperties;
driver = DriverManager.getDriver(url);
driverProperties = driver.getPropertyInfo(url, new Properties());
for (i = 0; i < driverProperties.length; i++) {
  System.out.println(driverProperties[i].name);
}