TAG:
WebLogic中SQL Server2000的JDBC Pool配置 <br/> 一、 采用Microsoft的JDBC Driver<br/><br/>1 <img align=absmiddle src=/sys_images/FileIcon/url.gif border='0'><a TARGET='_blank' href=http://www.microsoft.com>www.microsoft.com</a>上下载"Microsoft SQL Server 2000 Driver for JDBC"并安装<br/><br/>2 安装后,在安装的目录中有三个jar文件包<br/>.\\lib\\msbase.jar<br/>.\\lib\\msutil.jar <br/>.\\lib\\mssqlserver.jar<br/><br/>建议将其拷贝出来放置到%WL_HOME%目录中<br/><br/><A HREF='/Files/UpFiles/dev2/java/0010399000_200398_143112_60767.jpg' TARGET='_blank'><IMG SRC='/Files/UpFiles/dev2/java/0010399000_200398_143112_60767.jpg' border='0' alt='新窗口浏览' onload="javascript:if(this.width>screen.width-333)this.width=screen.width-333"></A><br/><br/>3 将3个jar包加入到classpath中,改startWLS.cmd,"set CLASSPATH="后加上%WL_HOME%\\server\\lib\\msbase.jar;%WL_HOME%\\server\\lib\\msutil.jar;%WL_HOME%\\server\\lib\\mssqlserver.jar; <br/><br/><A HREF='/Files/UpFiles/dev2/java/0010399000_200398_143139_29265.jpg' TARGET='_blank'><IMG SRC='/Files/UpFiles/dev2/java/0010399000_200398_143139_29265.jpg' border='0' alt='新窗口浏览' onload="javascript:if(this.width>screen.width-333)this.width=screen.width-333"></A><br/><br/>4 确认MSSQLServer的端口号(这点比较重要)<br/><br/><A HREF='/Files/UpFiles/dev2/java/0010399000_200398_14327_40618.jpg' TARGET='_blank'><IMG SRC='/Files/UpFiles/dev2/java/0010399000_200398_14327_40618.jpg' border='0' alt='新窗口浏览' onload="javascript:if(this.width>screen.width-333)this.width=screen.width-333"></A><br/><br/>5 启动WebLogic <br/><br/>6 打开IE,在地址栏中输入:<img align=absmiddle src=/sys_images/FileIcon/url.gif border='0'><a TARGET='_blank' href=http://localhost:7001/console>http://localhost:7001/console</a> <br/><br/>7 输入用户名和密码 <br/><br/>8 在左边的目录树中选中Services->JDBC->Connection Pools,单击右侧的Configure a new JDBC Connection Pool.,输入以下信息: <br/>Configuration->General页: <br/>Name = MSSQLServerConnectionPool <br/>URL = jdbc:microsoft:sqlserver://localhost:2040 (注意端口号填第5步中看到的port)<br/>Driver classname =com.microsoft.jdbc.sqlserver.SQLServerDriver <br/>Properties : <br/>databasename= northwind<br/>user = sa <br/>password = <- sa的密码 <br/>单击Create建立连接池。<br/><br/><A HREF='/Files/UpFiles/dev2/java/0010399000_200398_143239_23034.jpg' TARGET='_blank'><IMG SRC='/Files/UpFiles/dev2/java/0010399000_200398_143239_23034.jpg' border='0' alt='新窗口浏览' onload="javascript:if(this.width>screen.width-333)this.width=screen.width-333"></A><br/><br/>9 Connection属性设置<br/>Configuration->Connections页:<br/>将Initial Capacity由1置为10 (视需求)<br/>将Maximum Capacity由1置为10(视需求)<br/><br/><A HREF='/Files/UpFiles/dev2/java/0010399000_200398_14334_45063.jpg' TARGET='_blank'><IMG SRC='/Files/UpFiles/dev2/java/0010399000_200398_14334_45063.jpg' border='0' alt='新窗口浏览' onload="javascript:if(this.width>screen.width-333)this.width=screen.width-333"></A><br/><br/>10 Targets->Server页: <br/>将myserver(服务器名称)移至右侧的列表中,但击单击Apply <br/><br/><A HREF='/Files/UpFiles/dev2/java/0010399000_200398_143334_61462.jpg' TARGET='_blank'><IMG SRC='/Files/UpFiles/dev2/java/0010399000_200398_143334_61462.jpg' border='0' alt='新窗口浏览' onload="javascript:if(this.width>screen.width-333)this.width=screen.width-333"></A><br/><br/>11 配置数据源<br/>. 在左边的目录树中选中Services->JDBC->Data Sources(或者TXData Sources),单击右侧的Configure a new JDBC Connection Pool.,输入以下信息: <br/>Configuration->General页: <br/>Name = SQLServer Tx Data Source <br/>JNDI Name = SQLServer <br/>Pool Name = MSSQLServerConnectionPool <br/>选中Emulate Two-Phase Commit for non-XA Driver和Row Prefetch Enabled <br/>单击Create建立数据源。<br/><br/><A HREF='/Files/UpFiles/dev2/java/0010399000_200398_155230_45973.jpg' TARGET='_blank'><IMG SRC='/Files/UpFiles/dev2/java/0010399000_200398_155230_45973.jpg' border='0' alt='新窗口浏览' onload="javascript:if(this.width>screen.width-333)this.width=screen.width-333"></A><br/><br/>12 Targets->Server页: <br/>将myserver(服务器名称)移至右侧的列表中,但击单击Apply,配置完毕。<br/><br/><A HREF='/Files/UpFiles/dev2/java/0010399000_200398_15532_22631.jpg' TARGET='_blank'><IMG SRC='/Files/UpFiles/dev2/java/0010399000_200398_15532_22631.jpg' border='0' alt='新窗口浏览' onload="javascript:if(this.width>screen.width-333)this.width=screen.width-333"></A><br/><br/>13 reboot server<br/><br/>二、采用WebLogic的JDBC Driver for SQL Server<br/><br/>1确认MSSQLServer的端口号(这点比较重要)<br/><br/><A HREF='/Files/UpFiles/dev2/java/0010399000_200398_155330_24185.jpg' TARGET='_blank'><IMG SRC='/Files/UpFiles/dev2/java/0010399000_200398_155330_24185.jpg' border='0' alt='新窗口浏览' onload="javascript:if(this.width>screen.width-333)this.width=screen.width-333"></A><br/><br/>3 打开IE,在地址栏中输入:<img align=absmiddle src=/sys_images/FileIcon/url.gif border='0'><a TARGET='_blank' href=http://localhost:7001/console>http://localhost:7001/console</a> <br/><br/>4 输入用户名和密码 <br/><br/>5 在左边的目录树中选中Services->JDBC->Connection Pools,单击右侧的Configure a new JDBC Connection Pool.,输入以下信息: <br/>Configuration->General页: <br/>Name = SQLServerPool<br/>URL = jdbc:weblogic:mssqlserver4:northwind@localhost:2040 <br/>(northwind是你的数据库名)<br/>Driver classname = weblogic.jdbc.mssqlserver4.Driver <br/>(这时BEA自带的SQL Server驱动)<br/>Properties : <br/>user = sa <br/>password = <- sa的密码 <br/>单击Create建立连接池。 <br/><br/><A HREF='/Files/UpFiles/dev2/java/0010399000_200398_155358_76811.jpg' TARGET='_blank'><IMG SRC='/Files/UpFiles/dev2/java/0010399000_200398_155358_76811.jpg' border='0' alt='新窗口浏览' onload="javascript:if(this.width>screen.width-333)this.width=screen.width-333"></A><br/><br/>6 Connection属性设置<br/>Configuration->Connections页:<br/>将Initial Capacity由1置为10 (视需求)<br/>将Maximum Capacity由1置为10(视需求)<br/><br/><A HREF='/Files/UpFiles/dev2/java/0010399000_200398_155428_78066.jpg' TARGET='_blank'><IMG SRC='/Files/UpFiles/dev2/java/0010399000_200398_155428_78066.jpg' border='0' alt='新窗口浏览' onload="javascript:if(this.width>screen.width-333)this.width=screen.width-333"></A><br/><br/>7 Targets->Server页: <br/>将myserver(服务器名称)移至右侧的列表中,但击单击Apply <br/><br/><A HREF='/Files/UpFiles/dev2/java/0010399000_200398_155450_25406.jpg' TARGET='_blank'><IMG SRC='/Files/UpFiles/dev2/java/0010399000_200398_155450_25406.jpg' border='0' alt='新窗口浏览' onload="javascript:if(this.width>screen.width-333)this.width=screen.width-333"></A><br/><br/>8 配置数据源<br/>. 在左边的目录树中选中Services->JDBC->Data Sources(或者TXData Sources),单击右侧的Configure a new JDBC Connection Pool.,输入以下信息: <br/>Configuration->General页: <br/>Name = SQLServerTxDSource<br/>JNDI Name = examples-dataSource-demoPool <br/>Pool Name = SQLServerPool <br/>选中Emulate Two-Phase Commit for non-XA Driver和Row Prefetch Enabled <br/><br/>单击Create建立数据源。 <br/><br/><A HREF='/Files/UpFiles/dev2/java/0010399000_200398_155514_12251.jpg' TARGET='_blank'><IMG SRC='/Files/UpFiles/dev2/java/0010399000_200398_155514_12251.jpg' border='0' alt='新窗口浏览' onload="javascript:if(this.width>screen.width-333)this.width=screen.width-333"></A><br/><br/>9 Targets->Server页: <br/>将myserver(服务器名称)移至右侧的列表中,但击单击Apply,配置完毕。<br/><br/><A HREF='/Files/UpFiles/dev2/java/0010399000_200398_155542_31885.jpg' TARGET='_blank'><IMG SRC='/Files/UpFiles/dev2/java/0010399000_200398_155542_31885.jpg' border='0' alt='新窗口浏览' onload="javascript:if(this.width>screen.width-333)this.width=screen.width-333"></A><br/><br/>10 reboot server <br/> (iwgh) |