<data-sources>
<data-source>
<set-property property="password" value="lcwse" />
<set-property property="minCount" value="1" />
<set-property property="maxCount" value="5" />
<set-property property="user" value="se" />
<set-property property="driverClass" value="oracle.jdbc.driver.OracleDriver" />
<set-property property="description" value="" />
<set-property property="url" value="jdbc:oracle:thin:@LCWJNSESERV:1521:SE" />
<set-property property="readOnly" value="false" />
<set-property property="autoCommit" value="true" />
<set-property property="loginTimeout" value="" />
</data-source>
</data-sources>
是oracle的,你可以参考一下。
<data-source>
<set-property property="password" value="lcwse" />
<set-property property="minCount" value="1" />
<set-property property="maxCount" value="5" />
<set-property property="user" value="se" />
<set-property property="driverClass" value="oracle.jdbc.driver.OracleDriver" />
<set-property property="description" value="" />
<set-property property="url" value="jdbc:oracle:thin:@LCWJNSESERV:1521:SE" />
<set-property property="readOnly" value="false" />
<set-property property="autoCommit" value="true" />
<set-property property="loginTimeout" value="" />
</data-source>
</data-sources>
是oracle的,你可以参考一下。
解决方案 »
- Spring 里面XML配置AOP时 报错
- Struts2实现ajax返回数据失败
- Jsf中页面转向
- Struts+Hibernate+Spring 整合中的监听器的问题
- hibernate怎么执行SQL语句啊?
- 初学struts 对struts 有两个不明白的问题望指点!
- getClass和getClassLoader
- tomcat 下的项目不能通过ie访问,且tomcat启动时发出如下警告的问题
- 急问,一些远行JAVA程序出现的错误提示,老大们帮忙看看。谢谢!
- 请问如何在jboss里不同的application下共享色session?
- jdbc数据库的问题
- jsp(j2sdk1.4.2+tomcat5.0)链接mysql出错:package news does not exist。
我查找了我用的struts.jar文件,结果没有发现org.apach.struts.GenericDataSource这个类
我看了看struts的api(1.2.1),也没有发现对这个类的介绍。是不是这个类在1.2中不存在了??
我现在用的struts库应该是哪个版本的??怎样看得出来??
我又换了另一个类:org.apache.commons.dbcp.BasicDataSource
并将它所在的jar文件:c:\tomcat5.0\commons\lib\commons-dbcp.jar的路经加入到了classpath中,结果还是不行。我现在的配置如下:<data-sources>
<data-source key="DATA_SOURCE" type="org.apache.commons.dbcp.BasicDataSource">
<set-property property="password" value="123" />
<set-property property="minCount" value="7" />
<set-property property="maxCount" value="14" />
<set-property property="user" value="haofeng" />
<set-property property="driverClass" value="com.microsoft.jdbc.sqlserver.SQLServerDriver" />
<set-property property="description" value="" />
<set-property property="url" value="jdbc:microsoft:sqlserver://localhost:1433;databaseName=forum" />
<set-property property="readOnly" value="false" />
<set-property property="autoCommit" value="false" />
<set-property property="loginTimeout" value="" />
</data-source>
</data-sources>
log信息如下:
2004-11-22 22:45:12 createObjectName with StandardEngine[Catalina].StandardHost[localhost]
2004-11-22 22:45:12 preRegister with Catalina:type=Logger,host=localhost
2004-11-22 22:45:15 Marking servlet action as unavailable
2004-11-22 22:45:15 Servlet /haofengforum threw load() exception
javax.servlet.UnavailableException: Initializing application data source DATA_SOURCE
at org.apache.struts.action.ActionServlet.initModuleDataSources(ActionServlet.java:782)
at org.apache.struts.action.ActionServlet.init(ActionServlet.java:331)
at javax.servlet.GenericServlet.init(GenericServlet.java:256)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1044)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:887)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3820)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4108)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1125)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:792)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1125)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:502)
at org.apache.catalina.core.StandardService.start(StandardService.java:519)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:2343)
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:295)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:392)2004-11-22 22:45:21 ContextListener: contextInitialized()
2004-11-22 22:45:21 SessionListener: contextInitialized()
2004-11-22 22:45:22 ContextListener: contextInitialized()
2004-11-22 22:45:22 SessionListener: contextInitialized()
2004-11-22 22:45:23 userdatabase: Initializing database servlet
2004-11-22 22:45:23 userdatabase: Loading database from '/WEB-INF/userdatabase.xml'
请再帮我看看是什么原因好吗??万分感谢!!!!!!
2、确认SQLServer的jdbc驱动在classpath中。
=======================================
<Context path="/bzw" reloadable="true" docBase="D:\projects\bzw\bzwApp" workDir="D:\projects\bzw\work\org\apache\jsp" >
<Logger className="org.apache.catalina.logger.SystemOutLogger" verbosity="4" timestamp="true"/>
<Resource name="jdbc/bzworacle" auth="Container"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/bzworacle">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:oracle:thin:@littlepig:1521:bzw</value>
</parameter>
<parameter>
<name>poolPreparedStatements</name>
<value>true</value>
</parameter>
<parameter>
<name>username</name>
<value>bzw</value>
</parameter>
<parameter>
<name>password</name>
<value>bzw</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>2</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>2</value>
</parameter>
<parameter>
<name>minIdle</name>
<value>0</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>1000</value>
</parameter>
<parameter>
<name>removeAbandoned</name>
<value>true</value>
</parameter>
<parameter>
<name>removeAbandonedTimeout</name>
<value>30</value>
</parameter>
<parameter>
<name>logAbandoned</name>
<value>true</value>
</parameter>
</ResourceParams>
</Context>
web.xml的相关片断
===================
<resource-ref>
<description>BZW Oracle Datasource</description>
<res-ref-name>jdbc/bzworacle</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
按你说的还是不行,难道easystruts下不能使用这个数据源类??