weblogic9.2配置数据源

Question

没能够加载驱动
1.把Sql Server的驱动放到bea\wlserver_9.2\server\lib下
2.修改你的domain的bin目录下startWeblogic.cmd
if NOT "%WLS_PW%"=="" (
set JAVA_OPTIONS=%JAVA_OPTIONS% -Dweblogic.management.password=%WLS_PW%
)set CLASSPATH=%CLASSPATH%;%MEDREC_WEBLOGIC_CLASSPATH%;%WL_HOME%\server\lib\sqljdbc.jar --->在这里加载sql server的驱动

Answer 1

按一楼的去做的话，就有如下错误提示：
连接测试失败。  
  到主机 的 TCP/IP 连接失败。 java.net.ConnectException: Connection refused: connect
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Lcom.microsoft.sqlserver.jdbc.SQLServerConnection;Ljava.lang.Object;Ljava.lang.String;Ljava.lang.String;Z)V(Unknown Source)
com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(Ljava.lang.String;III)V(Unknown Source)
com.microsoft.sqlserver.jdbc.SQLServerConnection.loginWithoutFailover(Ljava.lang.String;Ljava.lang.String;IIJ)V(Unknown Source)
com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Ljava.util.Properties;Lcom.microsoft.sqlserver.jdbc.SQLServerPooledConnection;)Ljava.sql.Connection;(Unknown Source)
com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Ljava.lang.String;Ljava.util.Properties;)Ljava.sql.Connection;(Unknown Source)
com.bea.console.utils.jdbc.JDBCUtils.testConnection(JDBCUtils.java:504)
com.bea.console.actions.jdbc.datasources.createjdbcdatasource.CreateJDBCDataSource.testConnectionConfiguration(CreateJDBCDataSource.java:369)
jrockit.reflect.VirtualNativeMethodInvoker.invoke(Ljava.lang.Object;[Ljava.lang.Object;)Ljava.lang.Object;(Unknown Source)
java.lang.reflect.Method.invoke(Ljava.lang.Object;[Ljava.lang.Object;I)Ljava.lang.Object;(Unknown Source)
org.apache.beehive.netui.pageflow.FlowController.invokeActionMethod(FlowController.java:869)
org.apache.beehive.netui.pageflow.FlowController.getActionMethodForward(FlowController.java:808)
org.apache.beehive.netui.pageflow.FlowController.internalExecute(FlowController.java:477)
org.apache.beehive.netui.pageflow.PageFlowController.internalExecute(PageFlowController.java:305)
org.apache.beehive.netui.pageflow.FlowController.execute(FlowController.java:335)
org.apache.beehive.netui.pageflow.internal.FlowControllerAction.execute(FlowControllerAction.java:51)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
org.apache.beehive.netui.pageflow.PageFlowRequestProcessor.access$201(PageFlowRequestProcessor.java:95)
org.apache.beehive.netui.pageflow.PageFlowRequestProcessor$ActionRunner.execute(PageFlowRequestProcessor.java:2042)
org.apache.beehive.netui.pageflow.interceptor.action.internal.ActionInterceptors$WrapActionInterceptorChain.continueChain(ActionInterceptors.java:63)
org.apache.beehive.netui.pageflow.interceptor.action.ActionInterceptor.wrapAction(ActionInterceptor.java:167)
...