|
|
| |
Installing WebLogic jDriver for Microsoft SQL Server
This document tells you how to install WebLogic jDriver for Microsoft SQL Server, BEA's pure-Java Type 4 JDBC driver for Microsoft SQL Server, and provides information about the following topics:
Overview
WebLogic jDriver for Microsoft SQL Server is a 100% pure Java implementation of the Java Database Connectivity (JDBC) API, the industry standard for relational database access from Java clients.It provides Java clients with direct access to Microsoft SQL Server. The driver is available in two versions: one for SQL Server versions 6.5 and 7.0, and another for SQL Server 7.0 only. Both versions function identically, except as noted in the following section, Before You Begin.
Like all Type 4 JDBC drivers, WebLogic jDriver for Microsoft SQL Server is pure Java; it requires no vendor-supported client libraries. WebLogic jDriver for Microsoft SQL Server communicates directly with SQL Server through a TCP/IP network, using the SQL Server Tabular Data Stream protocol, so DB-Library does not have to be installed on a client computer.
Before You Begin
This section describes the differences between two versions of WebLogic jDriver for Microsoft SQL Server.
Which Version Should I Use?
BEA offers two versions of the WebLogic jDriver for Microsoft SQL Server drivers. One version supports Microsoft SQL Server versions 6.5 and 7.0, and the other version supports Microsoft SQL Server version 7.0 and 2000.
WebLogic jDriver for Microsoft SQL Server Versions 6.5 and 7.0
WebLogic jDriver for Microsoft SQL Server Version 7.0 and 2000
Evaluation Licenses
The Microsoft SQL Server licensing functionality is included in the license file located in the BEA home directory where you installed WebLogic Server. For example:
c:\bea\license.bea
Installation Procedure
The Microsoft SQL Server WebLogic jDriver is bundled with your WebLogic Server distribution. For Version 7.0 and 2000, the weblogic.jar file includes the Micrososft SQL Server jDriver classes needed. However, if you are using Version 6.5, you must pre-pend the mssqlserver4v65.jar file in the classpath as follows:
$ set CLASSPATH=%CLASSPATH%;%WL_HOME%/lib/mssqlserver4v65.JAR;%WL_HOME%/lib/weblogic.jar.
WebLogic jDriver for SQL Server Connection Properties
Using Connection Pools
If you are using WebLogic jDriver for Microsoft SQL Server with either WebLogic Server or WebLogic Express, you can set up a pool of connections to your SQL Server DBMS that will be established when WebLogic Server is started. Because the connections are shared among users, these connection pools eliminate the overhead of opening a new database connection for each user.
Your application then uses a multitier, or Type 3, JDBC driver, such as the WebLogic Pool, JTS or RMI driver to connect to WebLogic Server. WebLogic Server then uses WebLogic jDriver for Microsoft SQL Server and one of the existing connections from the pool to connect to the SQL Server database on behalf of your application.
Configuring a Connection Pool with WebLogic Server
Using the Connection Pool in Your Application
To use a connection pool, you must first establish a database connection. How you establish that connection depends on whether the application in which you want to use the connection pool as a client-side or a server-side application.
Client-Side Applications
To use a connection pool in a client-side application, establish the database connection by using the WebLogic RMI driver. For more information, see "Using WebLogic Multitier JDBC Drivers" in Programming WebLogic JDBC.
Server-Side Applications
To use a connection pool in a server-side application (such as a servlet), establish your database connection by using the WebLogic pool or jts drivers. For more information, see:
Verifying Your SQL Server Installation
Note: Verify that you are using version 6.5 or 7.0 of Microsoft SQL Server. Older versions of SQL Server do not properly support JDBC metadata functions and have limited data type support.
To connect to SQL Server, you need the following information:
For Microsoft SQL Server, the default port number is 1433. Servers, however, can be configured to listen on any port number. Verify the port number from your configuration files. If you need help setting the port number, see the following section, "Setting a Port for SQL Server Connections."
Setting a Port for SQL Server Connections
You set the host name and port for SQL Server connections by creating an entry in the SQL Server configuration files. In the configuration files, a logical server name is associated with a server machine name and port number. WebLogic jDriver for Microsoft SQL Server does not use a logical server name; it uses only the host name and the port number.
You must have administrator privileges to change your SQL Server settings. To set the port:
Once you have set the port, you can verify, by using telnet, that the server is listening on that port. Enter the following command:
$ telnet hostname_or_IP_address port
For example, to check whether the SQL Server is listening on port 1433 of a computer named myhost, type:
$ telnet myhost 1433
If the server is not listening on the port, telnet displays an error message. If the server is listening on the port, telnet displays nothing; eventually, the host drops the connection.
You can test your login information by entering the following command:
$ isql -Uusername -Ppassword -Sserver
Verifying the JDBC Driver With dbping
You can use dbping, a WebLogic Java application, to verify that WebLogic jDriver for Microsoft SQL Server can connect to your SQL Server. To use dbping, make sure that the classes for WebLogic jDriver for Microsoft SQL Server are included in your CLASSPATH, as described in Installation Procedure earlier in this document. Then type the following command:
$ java utils.dbping MSSQLSERVER4 username password [database@]host[:port]
The arguments in this command line are defined as follows:
For example, the following command pings an SQL Server database called pubs on a computer named myhost, using the default TCP/IP port, the sa login, and a null password:
$ java utils.dbping MSSQLSERVER4 sa "" pubs@myhost
The output from the command includes code that you can use to connect to the database in a Java program.
For More Information
This section provides references to documents and code examples that maybe helpful to you.
Documentation
For more information about using JDBC and jDrivers with WebLogic Server, see Programming WebLogic JDBC.
Code Examples
WebLogic Server provides several code examples to help you get started. Code examples are located in samples/examples/jdbc/mssqlserver4 directory of your WebLogic Server installation.
|
Copyright © 2001 BEA Systems, Inc. All rights reserved.
|