• Font Size
  • S
  • M
  • L
  • Top Category > General Questions > DataSpider Servista > [DataSpider Servista] Please tell me the difference between an adapter such as the JDBC adapter and the ODBC adapter and an adapter that has a product name to it like the Oracle adapter.

Search via FAQ No.


  • No : 30579
  • Open Date : 2019/08/23 17:03
  • Print
NEW

[DataSpider Servista] Please tell me the difference between an adapter such as the JDBC adapter and the ODBC adapter and an adapter that has a product name to it like the Oracle adapter.

Please tell me the difference between an adapter such as the JDBC adapter and the ODBC adapter and an adapter that has a product name to it like the Oracle adapter.
 
Category : 

Answer

■Specification
 
The implementation of internal processing differs between an adapter such as the JDBC adapter and the ODBC adapter and an adapter that has a connecting database name to it like the Oracle adapter.
  • JDBC adapter and ODBC adapter
It is designed to use a generic process so it does not depend on a specific database.
 
For this reason, problems that occur upon using it within the scope of our restrictions regardless of the connecting destination are supported.
 
Also, a user cannot connect to multiple versions of the same connecting database because the adapter's global resources cannot be managed by each version.
  • An adapter with a specific connecting database name
It is designed accordingly to a connecting database.
 
Therefore, problems that occur only on a connecting database that is specified as the adapter connecting destination are also supported.
 
Also, since the global resource of the adapter is managed by each version, it is possible to connect to multiple versions.
 
* Please refer to the help of the reference about specification restrictions of each adapter connected to a database.
 
■Notes on the JDBC adapter and the ODBC adapter
 
The JDBC adapter and the ODBC adapter implement general processing that does not depend on a specific connecting destination, so problems that occur only when connecting to a specific destination are not supported.
(A module cannot be corrected accordingly to the problem that occurred.)
 
Also, an error may occur when it executes a certain function from the JDBC adapter or the ODBC adapter because it requires a change accordingly to a connecting database.
 
In the past cases, it has been reported about the Oracle stored procedure execution that the Oracle adapter can execute without any problem, but an error occurs in the JDBC adapter.
 
In such case, please consider using an adapter with a specific connecting database's name.
 
 
[Reference Information]
  • Restrictions on the Database Adapter
  • Restrictions on the JDBC adapter
  • Restrictions on the ODBC adapter