java mssql jdbc_一个简单的Struts JDBC连接池(mssql)

tomcat 的错误信息：

————————————————————————————————————————————————————————————

2006-9-14 16:43:36 org.apache.struts.action.ActionServlet initModuleDataSources

严重: Initializing application data source MssqlDB1

java.lang.reflect.InvocationTargetException

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.

java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces

sorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:585)

at org.apache.commons.beanutils.PropertyUtilsBean.invokeMethod(PropertyU

tilsBean.java:1773)

at org.apache.commons.beanutils.PropertyUtilsBean.setSimpleProperty(Prop

ertyUtilsBean.java:1759)

at org.apache.commons.beanutils.PropertyUtilsBean.setNestedProperty(Prop

ertyUtilsBean.java:1648)

at org.apache.commons.beanutils.PropertyUtilsBean.setProperty(PropertyUt

ilsBean.java:1677)

at org.apache.commons.beanutils.BeanUtilsBean.setProperty(BeanUtilsBean.

java:1022)

at org.apache.commons.beanutils.BeanUtilsBean.populate(BeanUtilsBean.jav

a:811)

at org.apache.commons.beanutils.BeanUtils.populate(BeanUtils.java:298)

at org.apache.struts.action.ActionServlet.initModuleDataSources(ActionSe

rvlet.java:807)

at org.apache.struts.action.ActionServlet.init(ActionServlet.java:335)

at javax.servlet.GenericServlet.init(GenericServlet.java:211)

at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.

java:1044)

at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:87

6)

at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContex

t.java:4017)

at org.apache.catalina.core.StandardContext.start(StandardContext.java:4

337)

at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase

.java:823)

at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:80

7)

at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:595)

at org.apache.catalina.core.StandardHostDeployer.install(StandardHostDep

loyer.java:277)

at org.apache.catalina.core.StandardHost.install(StandardHost.java:832)

at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.j

ava:701)

at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:432

)

at org.apache.catalina.startup.HostConfig.start(HostConfig.java:983)

at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java

:349)

at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(Lifecycl

eSupport.java:119)

at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1091)

at org.apache.catalina.core.StandardHost.start(StandardHost.java:789)

at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1083)

at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:478

)

at org.apache.catalina.core.StandardService.start(StandardService.java:4

80)

at org.apache.catalina.core.StandardServer.start(StandardServer.java:231

3)

at org.apache.catalina.startup.Catalina.start(Catalina.java:556)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.

java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces

sorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:585)

at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:287)

at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:425)

Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableCon

nectionFactory ([Microsoft][SQLServer 2000 Driver for JDBC]Unable to connect.  I

nvalid URL.)

at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSou

rce.java:855)

at org.apache.commons.dbcp.BasicDataSource.setLoginTimeout(BasicDataSour

ce.java:586)

... 41 more

Caused by: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Una

ble to connect.  Invalid URL.

at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source

)

at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)

at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)

at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(Driv

erConnectionFactory.java:37)

at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(Poolable

ConnectionFactory.java:290)

at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(Bas

icDataSource.java:877)

at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSou

rce.java:851)

... 42 more

————————————————————————————————————————————————————————————————————

struts-config.xml 配置是：

attribute="userForm"

input="/login.jsp"

name="userForm"

path="/login"

scope="request"

type="com.login.struts.action.UserAction">