Integration of Weblogic 7 and JBuilder 9 Development SQL Server Environment

1. Install weblogic7 and jbuilder9

2. Download and install the patch package for SQL Server for Java on the Microsoft website.

3. Set the jbuileder9 environment after jbuilder9 is installed: Set the properties of the project to modify the temporary project file directory and the default program directory (these directories cannot contain spaces ), choose configure libraries from the Tools menu and set a Lib for sqlser. The file is the directory where the patch package is installed, and then open configure Server to set WebLogic Server. The home directory is set to the server directory under the Weblogic installation directory, the Work directory is set to the directory for you to install services, and the BEA directory is set to the root directory for you to install; the JDK directory is generally set to the jsk directory installed by weblogic.

4. Open the startexamplesserver. CMD file in the Weblogic installation service directory.

Set wls_user = zhouj

Sets wls_pw = 12345678

These two parameters are the user name and password you set during installation. This prevents you from entering the user name and password each time you start weblogic.

Add the directory for installing the SQL Server Java package after set classpath =, for example

Set classpath = D:/BEA/jdk1__02/lib/tools. jar; % samples_home %/Server/eval/pointbase/lib/pbserver42ecf172. jar; % samples_home %/Server/eval/pointbase/lib/pbclient42ecf172. jar; % client_classes %; % server_classes %; D:/sqlserverlib/MSSQLServer. jar; D:/sqlserverlib/msbase. jar; D:/sqlserverlib/msutil. jar

5. Open the Database Pilot menu under Tools menu of jbuilder9, select option after opening, open Add under driver, and enter COM. microsoft. JDBC. sqlserver. after the sqlserverdriver is added, enter: Microsoft: sqlserver: // localhost: 1433; databasename = mybase in the sample URL.

6. After the above work is completed, you can start your WebLogic console. After the startup is complete, open http: // zhouj: 7001/console then select connection pool to add a new JDBC setting name: sqlserverjdbc, URL is set to JDBC: Microsoft: sqlserver: // 192.168.1.113: 1433; databasename = highroadinfo, set driver classname to com. microsoft. JDBC. sqlserver. sqlserverdriver. Properties (Key = value): Set the username and password you need to log on to SQL Server. After setting is complete, open the Tx data source to add a new one. Set Name to TX data source; JNDI name to sqlserverdatasource; pool name to sqlserverjdbc.

7. The connection environment for WebLogic to connect to sqlserver has been established.

Is it the default web app setting of the Web application?
Add the following line to welogic. xml:
<Context-root>/</context-root>
You can set the default service for your current web application.

This has changed from 7.0 to 8.1, as mentioned in the release notes of Weblogic8.1.