1. Sign in Admin Console
2. Join the JDBC class package to connect to SQL Server 2000:
In the Application Server configuration, enter "JVM Settings", then go to "Path Settings" in "ClassPath SUFFIX"
Add: Msbase.jar, Msutil.jar and MSSQLServer.jar, and include its full path
Increase the "save" save
3. Establish a connection pool:
a. Open "JDBC" -> "Connection Pools", click "New" to enter the creation interface, enter the name of the connection pool, and select the correct resource type = javax.sql.datasource
b. Click "Next" to enter the next interface, enter the correct class name of the data source:
com.microsoft.jdbcx.sqlserver.sqlserverDataSource
c. Click "Next" to enter the next step, enter some parameters of the connection database, such as the server name, database name, port, user, password, etc. should be in the database name:
JDBC: Microsoft: SQLServer: // Sern: 1433; DatabaseName = TESTDB
d. Click "Finish" to complete and save configuration
e. Test: Click "Ping", "ping WAS SUCCESSFUL!" will represent the successful connection of the connection pool.
4. New "JDBC Resources": Open "JDBC" -> "JDBC Resources", click "New" to enter the new interface,
Enter the name, select the corresponding connection pool, click "OK" to determine
The entire JDBC configuration is complete.
