STRUTS.配置数据源,出现登录拒绝的问题,麻烦各位帮忙解答一下。
这是应用启动时出现的错误:
严重: Initializing application data source testSource
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFact
ory (ORA-01017: invalid username/password; logon denied
)
这是我的STRUS-CONFIG.XML文件的设置;
<set-property property="driverClassName" value="oracle.jdbc.driver.OracleDriver"/>
<set-property property="url" value="jdbc:oracle:thin:@127.0.0.1:1521:rsma"/>
<set-property property="maxActive" value="100"/>
<set-property property="maxIdle" value="50"/>
<set-property property="username" value="DBO"/>
<set-property property="password" value="DBO"/>
我用这个用户在PL SQL DEVELOPER 能够登录,不知道他为什么会报这个错误?
麻烦大大们给点建议
这是web.xml
<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE web-app
PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.2//EN"
"http://java.sun.com/j2ee/dtds/web-app_2_2.dtd">
<web-app>
<!-- Standard Action Servlet Configuration (with debugging) -->
<servlet>
<servlet-name>action</servlet-name>
<servlet-class>ier.house.struts.RsmaActionServlet</servlet-class>
<init-param>
<param-name>config</param-name>
<param-value>/WEB-INF/struts-config.xml</param-value>
</init-param>
<init-param>
<param-name>debug</param-name>
<param-value>0</param-value>
</init-param>
<init-param>
<param-name>detail</param-name>
<param-value>1</param-value>
</init-param>
<init-param>
<param-name>log4j</param-name>
<param-value>rsma.properties</param-value>
</init-param>
<init-param>
<param-name>SeriolNo</param-name>
<param-value>297E1-1B2FE-D30EA-5FED3-0EA55</param-value>
</init-param>
<load-on-startup>2</load-on-startup>
</servlet>
<!-- Standard Action Servlet Mapping -->
<servlet-mapping>
<servlet-name>action</servlet-name>
<url-pattern>*.do</url-pattern>
</servlet-mapping>
<!-- The Usual Welcome File List -->
<welcome-file-list>
<welcome-file>index.jsp</welcome-file>
</welcome-file-list>
<!-- <error-page>
<exception-type>javax.servlet.ServletException</exception-type>
<location>/pages/include/errpage.jsp</location>
</error-page> -->
<!-- Struts Tag Library Descriptors -->
<taglib>
<taglib-uri>/tags/struts-bean</taglib-uri>
<taglib-location>/WEB-INF/struts-bean.tld</taglib-location>
</taglib>
<taglib>
<taglib-uri>/tags/struts-html</taglib-uri>
<taglib-location>/WEB-INF/struts-html.tld</taglib-location>
</taglib>
<taglib>
<taglib-uri>/tags/struts-logic</taglib-uri>
<taglib-location>/WEB-INF/struts-logic.tld</taglib-location>
</taglib>
</web-app>
这是struts配置文件的头部。
<data-sources>
<data-source key="testSource" type="org.apache.commons.dbcp.BasicDataSource">
<set-property property="driverClassName" value="oracle.jdbc.driver.OracleDriver"/>
<set-property property="url" value="jdbc:oracle:thin:@127.0.0.1:1521:rsma"/>
<set-property property="maxActive" value="100"/>
<set-property property="maxIdle" value="50"/>
<set-property property="username" value="DBO"/>
<set-property property="password" value="DBO"/>
<!--set-property property="removeAbandoned" value="true"/-->
<!--set-property property="removeAbandonedTimeout" value="10"/-->
<set-property property="maxWait" value="10000"/>
</data-source>
</data-sources>