connectivity problem using mysql
Iam using eclipse 3.2 IDE and Tomcat 5.x
I am trying to connect to the database and get the access denied error. Any idea what I might be missing here.
****************************************************************************
ERROR MESSAGE
****************************************************************************
Jun 16, 2007 1:49:56 AM org.apache.struts.chain.ComposableRequestProcessor init
INFO: Initializing composable request processor for module prefix ''
Jun 16, 2007 1:49:56 AM org.apache.struts.chain.commands.servlet.CreateAction createAction
INFO: Initialize action of type: dummies.struts.LoginAction
java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: NO)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2934)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:870)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3333)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1232)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2749)
at com.mysql.jdbc.Connection.<init>(Connection.java:1553)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at dummies.struts.LoginBean.validateUser(LoginBean.java:47)
at dummies.struts.LoginAction.execute(LoginAction.java:38)
at org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteAction.java:58)
at org.apache.struts.chain.commands.AbstractExecuteAction.execute(AbstractExecuteAction.java:67)
at org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51)
at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
at org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:304)
at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
at org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:534)
Jun 16, 2007 1:49:57 AM org.apache.struts.util.PropertyMessageResources loadLocale
WARNING: Resource ApplicationResources_en_US.properties Not Found.
Jun 16, 2007 1:49:57 AM org.apache.struts.util.PropertyMessageResources loadLocale
WARNING: Resource ApplicationResources_en.properties Not Found.
****************************************************************************
JAVA CODE
****************************************************************************
The java code used for database is given below
boolean valid = false;
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
String dbUrl = "jdbc:mysql://localhost:3306/Login";
String dbRootUserName = "root";
String dbRootPassWord = "raju123";
try {
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection( dbUrl, dbRootUserName, dbRootPassWord );
stmt = con.createStatement();
rs = stmt.executeQuery(
"SELECT * FROM users " +
"WHERE username = '" + userName + "' " +
"AND password = '" + password + "'");
if( rs.next() )
valid = true;
}
catch( ClassNotFoundException e ) {
e.printStackTrace();
}
catch( SQLException e ) {
e.printStackTrace();
}
finally {
try{ if( rs != null ) rs.close(); } catch( SQLException e ) {};
try{ if( stmt != null ) stmt.close(); } catch( SQLException e ) {};
try{ if( con != null ) con.close(); } catch( SQLException e ) {};
}
return valid;
****************************************************************************
