Salve ragazzi,
ho appena cominciato la mia avventura con Struts.
Premetto che come ambiente uso Eclipse ed Exadel, col Tomcat incorporato.
Devo far funzionare un'applicazione già pronta ma ho questo errore in fase di login, qualsiasi parametro inserisco.
La console mi dice questo
GRAVE: Initializing application data source BacteriaClassifier
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'bacteria'@'localhost' (using password: YES))
at org.apache.commons.dbcp.BasicDataSource.createData Source(BasicDataSource.java:855)
at org.apache.commons.dbcp.BasicDataSource.setLogWrit er(BasicDataSource.java:598)
at org.apache.struts.action.ActionServlet.initModuleD ataSources(ActionServlet.java:1087)
at org.apache.struts.action.ActionServlet.init(Action Servlet.java:472)
at javax.servlet.GenericServlet.init(GenericServlet.j ava:211)
at org.apache.catalina.core.StandardWrapper.loadServl et(StandardWrapper.java:1029)
at org.apache.catalina.core.StandardWrapper.load(Stan dardWrapper.java:862)
at org.apache.catalina.core.StandardContext.loadOnSta rtup(StandardContext.java:4013)
at org.apache.catalina.core.StandardContext.start(Sta ndardContext.java:4357)
at org.apache.catalina.core.ContainerBase.start(Conta inerBase.java:1083)
at org.apache.catalina.core.StandardHost.start(Standa rdHost.java:789)
at org.apache.catalina.core.ContainerBase.start(Conta inerBase.java:1083)
at org.apache.catalina.core.StandardEngine.start(Stan dardEngine.java:478)
at org.apache.catalina.core.StandardService.start(Sta ndardService.java:480)
at org.apache.catalina.core.StandardServer.start(Stan dardServer.java:2313)
at org.apache.catalina.startup.Catalina.start(Catalin a.java:556)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknow n Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Un known Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.catalina.startup.Bootstrap.start(Bootst rap.java:287)
at org.apache.catalina.startup.Bootstrap.main(Bootstr ap.java:425)
Caused by: java.sql.SQLException: Access denied for user 'bacteria'@'localhost' (using password: YES)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:2926)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:771)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java: 3647)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:11 76)
at com.mysql.jdbc.Connection.createNewIO(Connection.j ava:2544)
at com.mysql.jdbc.Connection.<init>(Connection.java:1 474)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonReg isteringDriver.java:266)
at org.apache.commons.dbcp.DriverConnectionFactory.cr eateConnection(DriverConnectionFactory.java:37)
at org.apache.commons.dbcp.PoolableConnectionFactory. makeObject(PoolableConnectionFactory.java:290)
at org.apache.commons.dbcp.BasicDataSource.validateCo nnectionFactory(BasicDataSource.java:877)
at org.apache.commons.dbcp.BasicDataSource.createData Source(BasicDataSource.java:851)
... 21 more
4-mag-2006 17.52.05 org.apache.catalina.core.StandardHost getDeployer
INFO: Create Host deployer for direct deployment ( non-jmx )
4-mag-2006 17.52.05 org.apache.catalina.core.StandardHostDeployer install
INFO: Installing web application at context path from URL file:C:\workspace\.metadata\.plugins\org.eclipse.w st.server.core\tmp0\webapps\ROOT
4-mag-2006 17.52.06 org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
4-mag-2006 17.52.06 org.apache.jk.common.ChannelSocket init
INFO: JK2: ajp13 listening on /0.0.0.0:8009
4-mag-2006 17.52.06 org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/120 config=null
4-mag-2006 17.52.06 org.apache.catalina.startup.Catalina start
INFO: Server startup in 3275 ms
Vi posto il web.xml
<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE web-app PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
"http://java.sun.com/dtd/web-app_2_3.dtd">
<web-app>
<display-name>BacteriaClassifier4</display-name>
<servlet>
<servlet-name>action</servlet-name>
<servlet-class>org.apache.struts.action.ActionServlet</servlet-class>
<init-param>
<param-name>config</param-name>
<param-value>/WEB-INF/struts-config.xml</param-value>
</init-param>
<load-on-startup>1</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>action</servlet-name>
<url-pattern>*.do</url-pattern>
</servlet-mapping>
<welcome-file-list>
<welcome-file>login.jsp</welcome-file>
</welcome-file-list>
<taglib>
<taglib-uri>/WEB-INF/struts-bean</taglib-uri>
<taglib-location>/WEB-INF/struts-bean.tld</taglib-location>
</taglib>
<taglib>
<taglib-uri>/WEB-INF/struts-logic</taglib-uri>
<taglib-location>/WEB-INF/struts-logic.tld</taglib-location>
</taglib>
<taglib>
<taglib-uri>/WEB-INF/struts-html</taglib-uri>
<taglib-location>/WEB-INF/struts-html.tld</taglib-location>
</taglib>
<taglib>
<taglib-uri>/WEB-INF/sql</taglib-uri>
<taglib-location>/WEB-INF/sql.tld</taglib-location>
</taglib>
<taglib>
<taglib-uri>/WEB-INF/fmt</taglib-uri>
<taglib-location>/WEB-INF/fmt.tld</taglib-location>
</taglib>
<taglib>
<taglib-uri>/WEB-INF/c</taglib-uri>
<taglib-location>/WEB-INF/c.tld</taglib-location>
</taglib>
<taglib>
<taglib-uri>/WEB-INF/struts-nested</taglib-uri>
<taglib-location>/WEB-INF/struts-nested.tld</taglib-location>
</taglib>
<taglib>
<taglib-uri>/WEB-INF/struts-tiles</taglib-uri>
<taglib-location>/WEB-INF/struts-tiles.tld</taglib-location>
</taglib>
<taglib>
<taglib-uri>/WEB-INF/x</taglib-uri>
<taglib-location>/WEB-INF/x.tld</taglib-location>
</taglib>
</web-app>
Vi prego aiutatemi e considerate che sono alle prime armi, anche per eventuali spiegazioni.
Grazie
Rispondi quotando
