Note:
The first part: How to configure the Microsoft SQLServerDriver 2000 driver in WebLogic7.0, do not use WebLogic's own SQLServer2000. I used rs.before () in the program: java.sql.sqlexception: this JDBC 2.0 Method is not mailmented, so use MS driver. But I don't know why MS's driver accounts for many database links on WebLogic 7.0.
Part II: Sybase1X, SQLServer2000 Using WebLogic Self-Drive Configuration Parameters
?
If you use WebLogic 8.0 and above, you may be simple.
Set MSJDBC Drive to WebLogic Creating Pool Settings Pool Apply to Server to Build DS Apply DS to Server // ~ End
1. Set the MSJDBC to drive to WebLogicCopy Microsoft SQLServerDriver 2000 driver three files to x: / bea / weblogic705 / server / lib directory
Open x: /bea/weblogic705/server/bin/startwls.cmd, this file is WebLogic startup file found: set classpath =% java_home% / lib / Tools.jar ............. ....... On this sentence, the path of three files on 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 exit, restart WebLogic take effect
2. Establish POLOL
1. Start WebLogic,
2. Log in http: // xxxxxx / console
3. Enter your own Domain .....
Click Configure A New JDBC Connection Pool ...
?
Name: MyPoolURL:? Jdbc: microsoft: sqlserver: //76.48.17.170: 1433Driver Classname: ?? com.microsoft.jdbc.sqlserver.SQLServerDriverProperties: // database name and login user name db = ticsuser = ticsACLName: // ?? Don't fill in the password: // database login password ****** Open string password: *******
Click "CREATE" to do.
3. Apply pool to Server
Add your servers to use it. "Apply" completed the configuration of pool
4. Establish DS
PoolName where you enter the DS configuration page is the pool name just configured. JNDI will start with one, will be used in the program.
?? configuration ????? Targets ???? notes ??