HULFT Technical Support & FAQ

  • Font Size
  • S
  • M
  • L

My Page

Search via FAQ No.

Enter the FAQ record number and click "Browse."

  • No : 30641
  • Open Date : 2019/09/02 12:01
  • Print
NEW

[DataSpider Servista] Is there a way to connect to different versions of the same database product?

In the same environment, different versions of the same database product are mixed. In order to use the JDBC adapter to connect to different versions of the same database product, I placed multiple JDBC drivers in the library installation location of the JDBC adapter, but only one of them is recognized, an error occurs in the other.
Is there a way to connect to different versions of the same database product?
 
Category : 

Answer

■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]
 

Top