x

You can configure the adapter from either the Web Console or the Data Management Console.

1. From the Web Console menu bar, click Adapters.

   or

   From the Data Management Console, expand the Adapters folder.

   The Adapters folder opens.

2. Expand the Available folder, if it is not already expanded.
3. Expand the appropriate group folder and the specific adapter folder. The group folder is described in the connection attributes reference.
4. Right-click the adapter name and/or version and select Configure.

   The Add Adapter to Configuration pane opens.

5. Enter values for the parameters required by the adapter, as described in the connection attributes reference.
6. Click Configure. The configured adapter is added to the Adapters list in the navigation pane.

x

The Ingres adapter is under the SQL group folder.

The following list describes the connection attributes for which you can supply values. To complete the attribute declaration, click the Configure button.

Connection name

Logical name used to identify this particular set of connection attributes. The default is CON01.

URL

Location URL for the Ingres data source. It uses the following syntax:

jdbc:ingres://lnxx64r6:21071/qatst;TZ=GMT-5;DATE=INGRESDATE

where:

TZ

Specifies the Ingres time zone associated with the client's location. It corresponds to the Ingres environment variable II_TIMEZONE_NAME and is assigned the same value. This property is not used directly by the driver, but is sent to the DBMS and affects the processing of dates.

DATE

Specifies the data type of the columns created using the alias keyword date. Valid values are: ansidate or ingresdate. The default value is ansidate if the send_ingres_dates property is set to false, otherwise it is ingresdate. This value is not used directly by the driver, but is sent to the DBMS and affects the processing of query text.

Driver name

Name for the Ingres JDBC driver.

For example: com.ingres.jdbc.IngresDriver

See Ingres documentation for the specific driver release you are using.

IBI_CLASSPATH

Defines the additional Java Class directories or full-path jar names which will be available for Java Services. Value may be set by editing the communications file or in the Web Console. Using the Web Console, you can enter one reference per line in the input field. When the file is saved, the entries are converted to a single string using colon (:) delimiters for all platforms. OpenVMS platforms must use UNIX-style conventions for values (for example, /mydisk/myhome/myclasses.jar, rather than mydisk:[myhome]myclasses.jar) when setting values. When editing the file manually, you must maintain the colon delimiter.

Security

There are two methods by which a user can be authenticated when connecting to a database server:

• Explicit. The user ID and password are explicitly specified for each connection and passed to the database, at connection time, for authentication.
• Password Passthru. The user ID and password received from the client application are passed to the database, at connection time, for authentication.

User

Primary authorization ID by which you are known to the data source.

Password

Password associated with the primary authorization ID.

x

ENGINE SQLING SET CONNECTION_ATTRIBUTES connection 
'URL'/userid,password            

where:

SQLING

Indicates the adapter. You can omit this value if you previously issued the SET SQLENGINE command.

connection

Is the connection name.

URL

Is the URL to the location of the Ingres data source.

userid

Is the primary authorization ID by which you are known to the target database.

password

Is the password associated with the primary authorization ID.

Top of page

Example: Declaring Connection Attributes

The following SET CONNECTION_ATTRIBUTES command connects to a data source using the Ingres JDBC Driver, with an explicit user ID (MYUSER) and password (PASS). To ensure security, specifying connection attributes from the Web Console or DMS will encrypt the password before adding it to the server profile.

Note: Consult vendor documentation for the exact name, port, and path.

ENGINE SQLING SET CONNECTION_ATTRIBUTES CON1
  'jdbc:ingres://lnxx64r6:21071/qatst;DATE=INGRESDATE;TZ=GMT-5'/uid,pwd

x

ENGINE SQLING SET DEFAULT_CONNECTION connection

where:

SQLING

Indicates the adapter. You can omit this value if you previously issued the SET SQLENGINE command.

connection

Is the connection defined in a previously issued SET CONNECTION_ATTRIBUTES command. If this name was not previously declared, the following message is issued:

FOC1671, Command out of sequence

Note:

• If you use the SET DEFAULT_CONNECTION command more than once, the connection name specified in the last command serves as the default connection.
• The SET DEFAULT_CONNECTION command cannot be issued while an uncommitted transaction (LUW) is pending. In that case, the following message is issued:

  FOC1671, Command out of sequence. 

Top of page

Example: Selecting the Default Connection

The following SET DEFAULT_CONNECTION command selects the database server named SAMPLE as the default database server:

ENGINE SQLING SET DEFAULT_CONNECTION SAMPLE

x x

ENGINE SQLING SET AUTODISCONNECT ON {FIN|COMMIT}

where:

SQLING

Indicates the adapter. You can omit this value if you previously issued the SET SQLENGINE command.

FIN

Disconnects automatically only after the session has been terminated. FIN is the default value.

COMMIT

Disconnects automatically only after COMMIT or ROLLBACK is issued as a native SQL command.