First, use Microsoft JDBC Driver 1 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 msbase.jar msutil.jar MSSQLSERVER. JAR It is recommended to copy it into the% WL_HOME% / server / lib directory (in fact, but in addition, in additional classpath) 3 Add 3 JAR packets to classpath, change Startwls.cmd, "SET ClassPath =" Post-insert% WL_HOME% / server / lib / msbase.jar;% wl_home% / server / lib / msutil.jar;% WL_HOME% / server / lib / mssqlserver.jar; 4 confirming the port number of MSSQLSERVER (this is more important) and to find the port number where your instance is running, run the server network utility and select the server instance and select the TCP / IP. When you click the properties button, it will show the port. 5 start WebLogic 6 open IE, in In the address bar: http: // localhost: 7001 / console 7 Enter the username and password 8 Select the Services-> JDBC-> Connection Pools on 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 = mssqlserverConnectionPool URL = JDBC: Microsoft: SQLServer: // localhost: 2040 (note port number) Driver classname = com.microsoft.jdbc.sqlserverververver. SQLSERVERDRIVER Properties: DatabaseName = Northh WIND USER = SA Password = <(SA) 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. 13 reboot server Second, the use WebLogic's JDBC Driver for SQL Server 1 confirm the port number MSSQLServer of (this is important) And to find the port number where your instance is running, run the server network utility and select the server instance and select the TCP / IP. WHEN You Click The Properties Button, IT Will Show The Port. 2 Start WebLogic 3 Open IE, type in the address bar: http: // localhost: 7001 / Console 4 Enter the username and password 5 on the left side of the directory tree selected in the Services-> JDBC-> Connection Pools, click the Configure a new right of JDBC Connection Pool, enter the following information:. Configuration-> General page: Name = WLSQLServerConnectionPool URL = jdbc: weblogic: mssqlserver4: northwind @ localhost: 2040 Driver classname = WebLogic.jdbc.msqlser4.driver property: user = sa password = <- SA password Click Create to establish a connection pool.
6 Connection Properties Settings CONFIGURATION-> Connections Page: Take the initial capacity by 1 (depending on the demand) Put Maximum Capacity by 1 (depending on the demand) 7 Targets-> Server Page: Move myServer to the right In the list of the side, click Apply 8 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 = WLSQLServerConnectionPool Select Emulate TW-PHASE COMMIT for Non-Xa Driver and Row Prefetch Enabled Click Create to create a data source. 9 Targets-> Server Page: Move MyServer (server name) to the list of the right, but click Apply, configure it. 10 Reboot Server Note: If your WebLogic Server and SQL Server2k are not in the same machine, SQL Server2k's secure authentication method is to select SQL Server and Windows but personal suggestions, use the MS SQL Server database system, try not to use WebLogic JDriver Or MS MSSQL Driver. The reasons are as follows: (1) In future releases, WebLogic will no longer support JDriver of MSSQL Server (1) MS MSSQL Driver For Image and Text Types (that is, BLOB and Clob Types) data query, it is not good. So, try to use third-party MS SQL Server Driver.
