JDBC Driver for SQL Server

Build 20.0.7587

Connection Properties

The available connection properties can be retrieved with the getPropertyInfo method of the Driver class. This method returns an array with elements of type DriverPropertyInfo.

String connectionString = "jdbc:sql:";

Driver driver = DriverManager.getDriver(connectionString);
Properties info = new Properties();
DriverPropertyInfo[] attr = driver.getPropertyInfo(connectionString,info);
for(int i=0;i<attr.length;i++){
  System.out.println(attr[i].name);
  System.out.println(attr[i].description);
  System.out.println(attr[i].required);
  System.out.println(attr[i].value);
  String[] c = attr[i].choices;
  if(c != null) {
    for(String s: c)
      System.out.println(s);
  }
}

The DriverPropertyInfo class has the following properties:

Property NameData TypeDescription
NameStringThe name of the connection property.
DescriptionStringThe description for the connection property.
RequiredbooleanWhether the connection property must be set to connect to SQL Server.
ChoicesString[]An array of the allowed values for the connection property.
ValueStringThe current value of the connection property or the default value if one is not set by the user.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587