在strtus中配置DataSource时的问题

[codeName_Armor]

该加的包都加了,但是一启动tomcat就报错,我把错误信息和配置文件都贴出来,请老大们指教下哈
数据源配置文件
<data-sources >
<data-source key="sql2000" type="org.apache.commons.dbcp.BasicDataSource">
<set-property property="password" value="sundiaya" />
<set-property property="minCount" value="" />
<set-property property="maxCount" value="" />
<set-property property="user" value="sa" />
<set-property property="driverClassName" value="com.microsoft.jdbc.sqlserver.SQLServerDriver" />
<set-property property="description" value="" />
<set-property property="url" value="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=test" />
<set-property property="readOnly" value="false" />
<set-property property="autoCommit" value="false" />
<set-property property="loginTimeout" value="" />
</data-source>

</data-sources>
tomcat错误信息:
信息: The listener "listeners.SessionListener" is already configured for this co
ntext. The duplicate definition has been ignored.
2008-11-17 1:07:39 org.apache.struts.action.ActionServlet initModuleDataSources
严重: Initializing application data source sql2000
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
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:212)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.
java:1161)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:98
1)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContex
t.java:4058)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4
364)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase
.java:791)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:77
1)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)

at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.jav
a:924)
at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.j
ava:887)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492
)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1147)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java
:311)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(Lifecycl
eSupport.java:117)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)

at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)

at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443
)
at org.apache.catalina.core.StandardService.start(StandardService.java:5
16)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710
)
at org.apache.catalina.startup.Catalina.start(Catalina.java:578)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver
of class 'com.microsoft.jdbc.sqlserver.SQLServerDriver' for connect URL 'null' at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSou
rce.java:780)
at org.apache.commons.dbcp.BasicDataSource.setLoginTimeout(BasicDataSour
ce.java:586)
... 40 more
Caused by: java.lang.NullPointerException
at sun.jdbc.odbc.JdbcOdbcDriver.getProtocol(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcDriver.knownURL(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcDriver.acceptsURL(Unknown Source)
at java.sql.DriverManager.getDriver(Unknown Source)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSou
rce.java:773)
... 41 more
2008-11-17 1:07:40 org.apache.coyote.http11.Http11Protocol start
信息: Starting Coyote HTTP/1.1 on http-8080
2008-11-17 1:07:40 org.apache.jk.common.ChannelSocket init
信息: JK: ajp13 listening on /0.0.0.0:8009
2008-11-17 1:07:40 org.apache.jk.server.JkMain start
信息: Jk running ID=0 time=0/31 config=null
2008-11-17 1:07:40 org.apache.catalina.startup.Catalina start
信息: Server startup in 3508 ms

[老廉颇尚能饭否]

1.楼主打sqlserver sp3的补丁没？
2.数据库URL是否正确
3.确认struts的版本，有的是<set-property property="driverClassName" 有的是driverClass

[haobaofufob]

要打上sp3补丁，最好把sp4补丁也打上

[arg]

数据库确认打了sp3，最好打sp4

然后把那几个驱动包 扔到tomcat的lib 目录下，看看行不行

[bruni]

connection url有问题:
jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=test
改成
jdbc:sqlserver://localhost:1433;DatabaseName=test

[xian_hf]

用的是2000麽？加那3个驱动没？

[kokobox]

Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver
of class 'com.microsoft.jdbc.sqlserver.SQLServerDriver' for connect URL 'null'

驱动没有加对，感觉还是你改加的驱动包没有加，再仔细检查一下吧

如果有驱动包打开一下看看驱动类路径对不对

[dami01]

路过，学习

[codeName_Armor]

msbase.jar
commons-pool-1.2.jar
mssqlserver.jar
commons-dbcp-1.2.1.jar
msutil.jar
已经导入了3个jdbc驱动包,和dbcp和pool包了
麻烦老大们在给我诊断下哈

[hcr526]

bu zhidao ,,我用MySql

[lemonflowers]

学习了，嘿嘿嘿