Configuring and Using WebLogic jDriver for Microsoft SQL Server
(Deprecated)

 Previous Next Contents View as PDF  

Installing WebLogic jDriver for Microsoft SQL Server

Overview

Before You Begin

Which Version Should I Use?

WebLogic jDriver for Microsoft SQL Server Version 7.0 and 2000

WebLogic jDriver for Microsoft SQL Server Versions 6.5 and 7.0

Checking Licensing Functionality

Installation Procedure

WebLogic jDriver for SQL Server Connection Properties

Using Connection Pools

Configuring a Connection Pool with WebLogic Server

Using the Connection Pool in Your Application

Client-Side Applications

Server-Side Applications

Verifying Your SQL Server Installation

Setting a Port for SQL Server Connections

Verifying the JDBC Driver With dbping

For More Information

Documentation

Code Examples

Using the SQL Server 2000 Driver for JDBC from Microsoft

Downloading the Driver

Installing the Driver on a Windows System

Installing the Driver on a Unix System

Using WebLogic jDriver for Microsoft SQL Server

What Is the WebLogic jDriver for Microsoft SQL Server?

Connecting to an SQL Server DBMS

Using A Language Other Than English for a Connection

Connecting to a Database Using WebLogic Server in a Two-Tier Configuration

Connection Example

Adding Connection Options

Connecting Using WebLogic Server in a Multi-Tier Configuration

Manipulating Data with JDBC

Making Simple SQL Queries

Inserting, Updating, and Deleting Records

Creating and Using Stored Procedures and Functions

Disconnecting and Closing Objects

Codeset Support

JDBC Extensions

Support for JDBC Extended SQL

Querying Metadata

Sharing a Connection Object in Multithreaded Applications

Execute Keyword with Stored Procedures

JDBC Limitations

cursorName( ) Method Not Supported

java.sql.TimeStamp Limitations

Changing autoCommit Mode

Statement.executeWriteText( ) Methods Not Supported

References

Related Documentation

 

Back to Top Previous Next