JDBC Driver for IBM Cloud SQL Query

Build 22.0.8462

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:Api Key=MyAPIKey;:";

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 IBM Cloud SQL Query.
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) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462