This class defines features shared by inbound and outbound SQL adapters, of both the ODBC and JDBC varieties
It also can be instantiated to represent a collection of config settings used to connect to a JDBC driver.
It also offers methods allowing an instance to be used as a Connection object on which JDBC gateway calls can be invoked
A set of SQL Connection Attribute options.
For ODBC they are of the form attr:val,attr:val,...
For example, "AutoCommit:1"
For JDBC they are of the form attr=val;attr=val;...
For example, "TransactionIsolationLevel=TRANSACTION_READ_COMMITTED"
Note: if using a named JDBC SQL Gateway Connection as DSN, this value is optional but if present
will override the value specified in the named JDBC SQL Gateway Connection's Properties field.
This Data Source Name specifies the external datasource to connect to.
If this name matches the name of a JDBC or ODBC 'Object/SQL Gateway connection' configured from the System Management Portal,
the parameters from that specification will be used. Otherwise this value may be an ODBC DSN name configured in your OS, or a JDBC URL.
Note: if a JDBC URL, then in addition to Credentials the JDBCDriver and JDBCClasspath settings must also be configured, and ConnectionAttributes will also apply if configured.
property JDBCDriver as %String (MAXLEN = 1000) [ Required ];
JDBC Driver classname - not used for ODBC DSN connections
Note: if using a named SQL Gateway Connection as DSN, this value is optional but if present
will override the value specified in the named JDBC SQL Gateway Connection's set of properties.
Create a new configuration-object instance of this class, loading values from the DB if possible
This new instance may contain values distinct from those defined in the Adapter if loaded indirectly from a %Library.Sys.SQLConnection object in the DB
Decide whether the text of an error returned from the driver represents
a disconnection implying the need to re-connect.
Override this method in a subclass if you encounter other error signatures that ought to be in this list,
Also please contact InterSystems so that we may add the new codes to the base IsTextNetworkError() method.