Selecting JDBC drivers
You might want to change settings for a JDBC driver, for example, to add a custom entry. An example is provided.
About this task
To select JDBC drivers, follow these steps in HCL DevOps Test Integrations and APIs (Test Integrations and APIs):
In this example, a predefined driver for IBM®
Db2® 9.7
is selected and a custom entry is added for Composite.
Procedure
- In the Database (JDBC) section
of Library Manager, select the two providers and click OK to
quit Library Manager.
In the
librarysettings.xmlfile, the list of selected items is a comma-separated list inselectedPathSets.In the following example, MySQL, Oracle (which installed), Db2®, and the custom entry are listed (in that order).
Each provider is listed with its ID.
- Each custom entry is given a unique ID. You
can set this ID manually in the
librarysettings.xmlfile or create it in the graphical Library Manager and copy it.<pathSet base="< Installation Directory>" displayName="Composite" id="user.defined.<Custom Entry ID>" userDefined="true"><pathElement location="<Composite JDBC Provider JAR File Directory>" name="<JAR File Name>"/></pathSet> </provider>Note: If the library file location is on a mapped network drive, you might get errors while running tests in a project. To prevent this, ensure that the files are available on a local drive that can be accessed by Test Integrations and APIs and its Agent.