Configure the Microsoft sqlserverdriver 7.2 driver in WebLogic 2000

Note:

Part 1: how to configure the Microsoft sqlserverdriver 2000 driver in weblogic7.0 without using the built-in sqlserver2000. I used RS in the program. before () appears: Java. SQL. sqlexception: This JDBC 2.0 method is not implemented, so the MS driver is used. But I don't know why the MS driver occupies a lot of database connections on weblogic7.0.

Part 2: sybase1x and sqlserver2000 use the configuration parameters of the Weblogic built-in driver

?

If you use weblogic8.0 or a later version, it may be simpler.

1. Set msjdbc driver to WebLogic
2. Create a pool
3. Apply the pool to the server
4. Create DS
5. Apply ds to server
   //~ End

1. Set the msjdbc driver to WebLogic

Copy the Microsoft sqlserverdriver 2000 driver to X:/BEA/weblogic705/Server/lib

Open X:/BEA/weblogic705/Server/bin/startwls. cmd. This file is the Weblogic Startup File.

Find:
Set classpath = % java_home %/lib/tools. Jar ....................

The path of the three files after this sentence. The result is as follows:

Set classpath = % java_home %/lib/tools. jar; % wl_home %/Server/lib/weblogic_sp.jar; % wl_home %/Server/lib/weblogic. jar; % wl_home %/Server/lib/msbase. jar; % wl_home %/Server/lib/msutil. jar; % wl_home %/Server/lib/MSSQLServer. jar; % classpath %

Save and exit. Restart WebLogic to take effect.

2. Create a pool

1. Start WebLogic,

2. log on to http: // xxxxxx/console

3. Enter your own domain .....

Click Configure a new JDBC connection pool... and configure as follows:

?

Name:
Mypool
URL :?
JDBC: Microsoft: sqlserver: // 76.48.17.170: 1433
Driver classname :??
Com. Microsoft. JDBC. sqlserver. sqlserverdriver
Properties: // Database Name and database logon Username
DB = TICs
User = TICs
Aclname ://?? Not Required
Password: // database logon Password
******
Open string password:
******

Click "CREATE.

3. Apply the pool to the server

Add your servers as available. "Apply" Completes pool Configuration

4. Create DS

Go to the DS configuration page

The poolname here is the name of the pool just configured.
Start with JNDI and use it in the program.

??Configuration??

?? Targets ??

?? Notes ??

5. Apply ds to server

O. K.

Part 2: sybase1x and sqlserver2000 use the configuration parameters of the Weblogic built-in driver

The following describes how to configure Sybase with the Weblogic driver.

Environment WebLogic 7.0 SP5 ctais sybase12

URL:
JDBC: Sybase: TDS: 76.48.16.10: 4100 // ctais? Charset = eucgb
Driver classname:
Com. Sybase. jdbc2.jdbc. sybdriver
Properties
(Key = value ):
User = ctais_htcx

You only need to use the above attributes. I have not done any step on the Internet to copy the driver.

Other attributes: (from the Network)
User = test
Password = 000000
Jconnect_version = 0
Portnumber = 5000
Databasename = test
Servername = 127.0.0.1
Charset = eucgb

-------------------------------
The following describes how to configure sqlserver with the Weblogic driver.

URL:
JDBC: WebLogic: mssqlserver4
Driver classname:
Weblogic. JDBC. mssqlserver4.driver
Properties
(Key = value ):
User = TICs
DB = TICs
Server = 76.48.17.170