Sap Sum Jdbc Driver Not Supported For Oracle Database

Posted on by

Write SQL, get SAP ERP data. Access SAP through standard Java Database Connectivity. Codeless integration with popular BI, Reporting, & ETL Tools. The SAP ERP JDBC Driver is a powerful tool that allows you to easily connect-to live SAP ERP data through any JDBC capable application or tool! JDBC is the most widely supported interface for. Do Oracle's JDBC drivers support PL/SQL tables/result sets/records/booleans? It is not feasible for Oracle JDBC drivers to support calling arguments or return values of the PL/SQL types TABLE (now known as indexed-by tables), RESULT SET, RECORD, or BOOLEAN. There are currently no plans to change this.

  1. JDBC driver not supported for MS_SQL_SERVER database HI, After deployed JDBC driver in NWA, i created SQL Server 2000 JDBC system in portal.when i try test connection i am getting this exception in log system database.
  2. There are several different types of Oracle JDBC drivers. Of these different types, SAP supports the so-called Oracle Thin JDBC driver only. This driver is a self-contained pure Java driver, i.e. It does not need any additional binary library.
Skip to end of metadataGo to start of metadata

Purpose

This article will show you how to check which Oracle JDBC driver version is compatible with your SAP Product Release.

Overview

You want to check which Oracle JDBC driver version is compatible with the SAP Product Release. Example, during system upgrade from SAP NETWEAVER 7.0 to SAP NETWEAVER 7.2, you want to check if the existing Oracle JDBC driver is compatible with the SAP NETWEAVER 7.2.

Method

1. Please refer to SAP Note 867176 point 3 and 4 for more information.

Example: SAP NETWEAVER 7.0

As per SAP Note 867176 point 3 and 4, SAP release 7.0X is compatible with Java version 1.4. The ojdbc14.jar with Oracle JDBC Driver Version 10.2 is required.

Not


Example: SAP NETWEAVER 7.2

As per SAP Note 867176 point 3 and 4, SAP release >=7.2x is compatible with Java version 6. The ojdbc6.jar with Oracle JDBC Driver Version 11.2 or 12.1 (depend on the Oracle Client Version installed) is required.


  • To check which Oracle JDBC driver version has installed in the system.

Follow the SAP note 867176, point 8 for more details.

Command:

Windows

java -classpath <path to driver>/<driver filename>;. JdbcCheckup

UNIX/Linux

java -classpath <path to driver>/<driver filename>:. JdbcCheckup

Jdbc Driver Not Found

Java

Example:

        • To check which Oracle driver file name used in the system.

The Oracle driver file name is set under the property rdbms.driverLocation in the config.properties file for the J2EE instance, usually under the following directory:

UNIX:

/usr/sap/<SID>/JC<XX>|DVEBMGS<XX>/j2ee/configtool
WINDOWS:

<D>:usrsap<SID>JC<XX>|DVEBMGS<XX>exe ('DIR_EXECUTABLE')

Example:


        • To check which Java version used in your system

Command:

Java –version

        • To check which Oracle client is installed in the system

Command:

Driver

genezi -v

Check this link for more information.


867176 - FAQ: Oracle JDBC

915079 - J2EE on Oracle: Updating the JDBC drivers

Jdbc Driver Not Found Java

819829 - Oracle Instant Client Installation and Configuration on Unix

Sap Sum Jdbc Driver Not Supported For Oracle Database Windows 10

998004 - Update the Oracle Instant Client on Windows