---

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

 

---

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