skip to main content
Quick Start: Accessing REST data sources using no authentication : Using connection properties
  

Try DataDirect Drivers Now

Using connection properties

You can use connection properties to customize the driver for your environment. You can use these connection properties with either the JDBC Driver Manager or a JDBC data source. For a Driver Manager connection, a property is expressed as a key value pair and takes the form property=value. For a data source connection, a property is expressed as a JDBC method and takes the form setProperty(value). For a complete list of supported properties, refer to "Connection property descriptions" in the Progress DataDirect Autonomous REST Connector for JDBC User's Guide.
The following table summarizes the essential connection properties used to configure the driver to access data sources that do not require authentication.
Note: All connection property names are case-insensitive. For example, Password is the same as password. Required properties are noted as such.
Note: The data type listed for each connection property is the Java data type used for the property value in a JDBC data source.
Table 3. Essential Connection Properties for Sessions Without Authentication
Property
Characteristic
Required Properties
Config
Specifies the name and location of the input REST file that contains the list of endpoints to sample and paging configuration information. For example, C:/path/to/mysite.rest.
For more information on information on the REST file, see "Creating a REST File for Multiple End Points."
Note: The Config property determines whether the driver uses an input REST file for the session. If no value is provided, an endpoint must be provided using the Sample property.
Sample
Specifies the endpoint to connect to and sample.
Note: This option is required when not using an input REST file.
Optional Properties
CreateMap
Determines whether the driver creates the internal files required for a relational map of the native data when establishing a connection.
If set session, the driver uses memory to store the internal configuration information and relational map of native data. After the session, the relational map is discarded.
If set to forceNew, the driver deletes the current internal configuration files and relational map specified by the SchemaMap property and creates a new set at the same location.
If set to notExist, the driver uses the current internal files and relational map specified by the SchemaMap property. If the files do not exist, the driver creates them.
Default: Session
SchemaMap
Specifies the directory where internal files and the relational map of native data data are written. The driver looks for this location when connecting to an endpoint. If these files do not exist, the driver creates them.
Windows default:
application_data_folder\Local\Progress\DataDirect\AutoREST_Schema\
UNIX/Linux default:
~/progress/datadirect/AutoREST_Schema/
ServerName
Specifies the host name portion of the HTTP endpoint to which you send requests. Specify this value if you want to define endpoints without storing the host name component in the REST file.