# DriverPropertyInfo array example

Here is some example code:

    import java.sql.*;
    import java.util.Properties;
    // start with the least amount of information
    // to see the full list of choices
    // we could also enter with a URL and Properties
    // provided by a user.
    String url = "jdbc:derby:";
    Properties info = new Properties();
    Driver cDriver = DriverManager.getDriver(url);
    for (;;)
            {
            DriverPropertyInfo[] attributes = cDriver.getPropertyInfo(
                url, info);
             // zero length means a connection attempt can be made
            if (attributes.length == 0)
            break;
            // insert code here to process the array, e.g.,
            // display all options in a GUI and allow the user to
            // pick and then set the attributes in info or URL.
            }
    // try the connection
    Connection conn = DriverManager.getConnection(url, info);

Parent topic: The DriverPropertyInfo Array