■Description
The usage restrictions of the JDBC adapter are as follows:
*You can check the following from the "Reference information" link from the help of DataSpider Servista.
---
When connecting to multiple types of a data source, deploy all the necessary JDBC drivers for each.
Although you can connect to multiple types of a database, you cannot load classes with the same names from multiple deployed JDBC drivers. For this reason, you cannot deploy multiple JDBC drivers of different versions.
---
Therefore, you cannot connect to different versions of the same database if the JDBC driver class names are the same. If you need to connect to different versions of the same database, consider using a dedicated adapter.
For more information on the difference between a general-purpose adapter and a dedicated adapter, please refer to the following.
▼General purpose adapter
For the JDBC adapter and the ODBC adapter, you cannot manage each version because the connection destination RDBMS is not limited. For this reason, a driver that can be installed will be only one type. As a result, the connection destination is RDBMS that is supported by that driver.
▼Dedicated adapter
Dedicated adapters can be connected to the version that is supported by the adapter. Basically, you can connect to multiple versions to install the driver for each version.
Reference information
- [JDBC]-[Restrictions]-[Common to all processes]