JDBC Pool Configuration (reproduced) in SQL Server2000 in WebLogic
First, use Microsoft JDBC Driver1 to www.microsoft.com and download "Microsoft SQL Server 2000 Driver for JDBC" and install 2 installation, there are three JAR files in the installed directory ./lib/msbase.jar./lib /msutil.jar ./lib/msqlserver.jar recommends copying it to the% WL_HOME% of the directory 3 Add 3 JAR packets to classpath, change StartWls.cmd, "set classpath =", add% WL_HOME% /server/lib/msbase.jar;%WL_Home%/server/lib/msutil.jar;%WL_Home%/server/lib/mssqlserver.jar; 4 Confirm the port number of MSSQLServer (this is more important) 5 Start WebLogic 6 Open IE Enter: http: // localhost: 7001 / console 7 Enter the username and password 8 Select Services-> JDBC-> Connection Pools on the directory tree on the left, click the configure a new JDBC Connection Pool on the right side of the CONFIGURE A Enter the following information: configuration-> general page: Name = mssqlserverConnectionPool URL = JDBC: Microsoft: SQLSERVER: // localhost: 2040 (Note port number) Driver classname = com.microsoft.jdbc . SQLServer.sqlserdriver Properties: DatabaseName = Northwinduser = SA Password = <() Click Create to establish a connection pool. 9 Connection Properties Settings CONFIGURATION-> Connections Page: Take the initial capacity by 1 10 (depending on the requirements) Take the Maximum Capacity 10 (depending on the requirements) 10 Targets-> Server Page: Move myServer to the right In the list, click Apply 11 to configure the data source. Select Services-> JDBC-> Data Source (or TXData Sources) in the directory tree on the left, click the Configure a new JDBC Connection Pool on the right. Enter the following information: configuration-> general page: name = SQLSERVER TX DATA SOURCE JNDI Name = SQLServer pool name = MSSQLServerConnectionPool Select Emulate TW-PHASE COMMIT for Non-Xa Driver and Row Prefetch Enabled Click Create to establish a data source. 12 Targets-> Server Page: Move MyServer to the list of the right, but click Apply, the configuration is complete.