JDBC Driver

Use

You use the MaxDB JDBC drive to execute SQL statements in a MaxDB database instance within a Java application.

Additional properties of the MaxDB JDBC drivers:

?     "100 percent pure Java"

?     Supports JDBC 2.0 Standard Extension API (DataSource, XADataSource, and ConnectionPoolDataSource)

?     Driver of type 4 (the connection to the database instance is established using the MaxDB-specific network protocol)

Prerequisites

?     You have installed a Java platform:

0     Sun Java JRE 1.2 or, for the application development Sun Java JDK 1.2 (for JDBC 2.0)

0     Sun Java 2 Standard Edition 1.4 or 1.5 or, for the application development Sun Java JDK 1.4 or 1.5 (for JDBC 3.0)

?     You have installed the JDBC software component (see Installation Manual, Software Components).

Features

Loading the JDBC Driver

Connecting to the Database Instance

Executing SQL Statements

Troubleshooting (JDBC Driver)

The Java classes of the MaxDB JDBC driver are contained in the <independent_program_path>\runtime\jar\sapdbc.jar file.

C:\Program Files\sdb\programs\runtime\jar\sapdbc.jar

Java Classes of the MaxDB JDBC Drivers

Java Class

Description

com.sap.dbtech.jdbc.DriverSapDB

JDBC driver

com.sap.dbtech.powertoys.jdbc.exception.*

Troubleshooting

com.sap.dbtech.jdbcext.DataSourceSapDB

Classes for the JDBC 2.0 Standard Extension

Example

Example: Executing an SQL Statement