我的Struts-config.xml文件如下:
<struts-config>
<data-sources>
<data-source>
<set-property property="driverClass" value="com.microsoft.jdbc.sqlserver.SQLServerDriver"/>
<set-property property="url" value="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Northwind"/>
<set-property property="user" value="sa"/>
<set-property property="password" value="sa"/>
</data-source>
</data-sources> <action-mappings>
<action path="/goPage2" forward="/page2.jsp"/>
</action-mappings>
</struts-config>运行是报 The requested resource (Servlet ActionServlet is not available) is not available.
而去掉 <data-sources> 又正常运行
请问 这是怎么回事???WEB-INFO/lib 文件下有:msbase.jar mssqlserver.jar msutil.jar
<struts-config>
<data-sources>
<data-source>
<set-property property="driverClass" value="com.microsoft.jdbc.sqlserver.SQLServerDriver"/>
<set-property property="url" value="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Northwind"/>
<set-property property="user" value="sa"/>
<set-property property="password" value="sa"/>
</data-source>
</data-sources> <action-mappings>
<action path="/goPage2" forward="/page2.jsp"/>
</action-mappings>
</struts-config>运行是报 The requested resource (Servlet ActionServlet is not available) is not available.
而去掉 <data-sources> 又正常运行
请问 这是怎么回事???WEB-INFO/lib 文件下有:msbase.jar mssqlserver.jar msutil.jar
解决方案 »
- Exception in thread "main" java.lang.UnsupportedOperationException: The user must supply a JDBC conn
- 求J2EE面试题,3Q3Q~~在线等~~~~
- javamail1.4 编写发送邮件失败! 在线等!!!
- 怎么样从extjs grid导出excel file (在后台导出, 用Spring, POI, Extjs等)
- 调试出现下载情况
- java拼串有空格怎么拼
- 为什么精华区的文章都打不开!!
- 下面的jsp程序哪里错了啊?
- 大虾指教
- bodytag的问题,困扰许久请援手!<jsp>
- 关于毕业设计的困惑,请有经验的朋友指点一下(50)
- 100分求 JSP/Servlet/JavaBean +TOMCAT+数据库 实例源代码(入门级的)
如果你用的是apache提供的DBCP数据源则要改为(必须要有相应的jar包):<struts-config>
<data-sources>
<data-source type="org.apache.commons.dbcp.BasicDataSource">
<set-property property="driverClass" value="com.microsoft.jdbc.sqlserver.SQLServerDriver"/>
<set-property property="url" value="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Northwind"/>
<set-property property="user" value="sa"/>
<set-property property="password" value="sa"/>
</data-source>
</data-sources> <action-mappings>
<action path="/goPage2" forward="/page2.jsp"/>
</action-mappings>
</struts-config>一般有以下四种数据源可选:
Poolman(http://sourceforge.net/projects/poolman)
Expresso(http://www.jcorporate.com)
JDBC Pool(www.bitmechanic.com/projects/jdbcpool)
DBCP(jakarta.apache.org/commons/index.html)
<struts-config>
<data-sources>
<data-source type="org.apache.commons.dbcp.BasicDataSource">
<set-property property="driverClass" value="com.microsoft.jdbc.sqlserver.SQLServerDriver"/>
<set-property property="url" value="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Northwind"/>
<set-property property="user" value="sa"/>
<set-property property="password" value="sa"/>
</data-source>
</data-sources>
<action-mappings>
<action path="/goPage2" forward="/page2.jsp"/>
</action-mappings>
</struts-config>%Tomcat_Home%/common/lib有如下包:
commons-dbcp.jar
commons-dbcp-1.2.1.jar
commons-pool.jar
commons-pool-1.2.jar
msbase.jar
mssqlserver.jar
msutil.jar
struts.jar
...
<struts-config>
<data-sources>
<data-source type="org.apache.commons.dbcp.BasicDataSource">
<set-property property="driverClass" value="com.microsoft.jdbc.sqlserver.SQLServerDriver"/>
<set-property property="url" value="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Northwind"/>
<set-property property="user" value="sa"/>
<set-property property="password" value="sa"/>
</data-source>
</data-sources>
<action-mappings>
<action path="/goPage2" forward="/page2.jsp"/>
</action-mappings>
</struts-config>%Tomcat_Home%/common/lib有如下包:
commons-dbcp.jar
commons-dbcp-1.2.1.jar
commons-pool.jar
commons-pool-1.2.jar
msbase.jar
mssqlserver.jar
msutil.jar
struts.jar
______________________________________________________________
如果这样还不行,你最好检查一下你的控制类写的有没有问题
把 driverClass 改为 driverClassName
把 user改为 username
SQL Server可以PASS但是 MySQL又不行了
<data-sources>
<data-source key="mysqlDB1" type="org.apache.commons.dbcp.BasicDataSource">
<set-property property="driverClassName" value="org.gjt.mm.mysql.Driver" />
<set-property property="url" value="jdbc:mysql://localhost:3306/mysql" />
<set-property property="username" value="root"/>
<set-property property="password" value=""/>
</data-source>
</data-sources>郁闷!!!%Tomcat_Home%/common/lib有如下包:
commons-dbcp.jar
commons-dbcp-1.2.1.jar
commons-pool.jar
commons-pool-1.2.jar
msbase.jar
mssqlserver.jar
msutil.jar
mysqldriver.jar
mm.mysql-2.0.14-bin.jar
struts.jarstruts为1.2版本的