Error en acceso a BBDD
Aquí está el error y el jsp en sí:
El error que me aparece en el navegador es:
Error: 500
Localización: /eviajes/validar.jsp
Error interno del Servlet:
javax.servlet.ServletException: [Microsoft][Controlador ODBC Microsoft Access] Error de sintaxis (falta operador) en la expresión de consulta 'clientes.nombreFROM clientesWHERE ((clientes.nombre)=javier)'.
at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:460)
at validar_3._jspService(validar_3.java:84)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119)
at javax.servlet.http.HttpServlet.service(HttpServlet.java)
at org.apache.tomcat.facade.ServletHandler.doService(ServletHandler.java:574)
at org.apache.tomcat.core.Handler.invoke(Handler.java:322)
at org.apache.tomcat.core.Handler.service(Handler.java:235)
at org.apache.tomcat.facade.ServletHandler.service(ServletHandler.java:485)
at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:917)
at org.apache.tomcat.core.ContextManager.service(ContextManager.java:833)
at org.apache.tomcat.modules.server.Http10Interceptor.processConnection(Http10Interceptor.java:176)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:494)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:516)
at java.lang.Thread.run(Thread.java:484)
Causa Raíz:
java.sql.SQLException: [Microsoft][Controlador ODBC Microsoft Access] Error de sintaxis (falta operador) en la expresión de consulta 'clientes.nombreFROM clientesWHERE ((clientes.nombre)=javier)'.
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6031)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:6188)
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java:2494)
at sun.jdbc.odbc.JdbcOdbcStatement.execute(JdbcOdbcStatement.java:334)
at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(JdbcOdbcStatement.java:249)
at validar_3._jspService(validar_3.java:63)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119)
at javax.servlet.http.HttpServlet.service(HttpServlet.java)
at org.apache.tomcat.facade.ServletHandler.doService(ServletHandler.java:574)
at org.apache.tomcat.core.Handler.invoke(Handler.java:322)
at org.apache.tomcat.core.Handler.service(Handler.java:235)
at org.apache.tomcat.facade.ServletHandler.service(ServletHandler.java:485)
at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:917)
at org.apache.tomcat.core.ContextManager.service(ContextManager.java:833)
at org.apache.tomcat.modules.server.Http10Interceptor.processConnection(Http10Interceptor.java:176)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:494)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:516)
at java.lang.Thread.run(Thread.java:484)
El código del jsp es:
<html>
<body>
<br><br>
<%
boolean encontrado= false;
String nombre1= request.getParameter("nombre");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String bd=("jdbc:odbc:basetest");
java.sql.Connection con= java.sql.DriverManager.getConnection(bd);
java.sql.Statement st = con.createStatement();
String qry="SELECT clientes.nombre";
qry+="FROM clientes";
qry+="WHERE ((clientes.nombre)="+nombre1+");";
java.sql.ResultSet rs=st.executeQuery(qry);
while (rs.next())
{
encontrado=true;
}
rs.close();
if(encontrado)
out.println("ok");
else
out.println("Password incorrecta");
%>
</body></html>
El error que me aparece en el navegador es:
Error: 500
Localización: /eviajes/validar.jsp
Error interno del Servlet:
javax.servlet.ServletException: [Microsoft][Controlador ODBC Microsoft Access] Error de sintaxis (falta operador) en la expresión de consulta 'clientes.nombreFROM clientesWHERE ((clientes.nombre)=javier)'.
at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:460)
at validar_3._jspService(validar_3.java:84)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119)
at javax.servlet.http.HttpServlet.service(HttpServlet.java)
at org.apache.tomcat.facade.ServletHandler.doService(ServletHandler.java:574)
at org.apache.tomcat.core.Handler.invoke(Handler.java:322)
at org.apache.tomcat.core.Handler.service(Handler.java:235)
at org.apache.tomcat.facade.ServletHandler.service(ServletHandler.java:485)
at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:917)
at org.apache.tomcat.core.ContextManager.service(ContextManager.java:833)
at org.apache.tomcat.modules.server.Http10Interceptor.processConnection(Http10Interceptor.java:176)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:494)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:516)
at java.lang.Thread.run(Thread.java:484)
Causa Raíz:
java.sql.SQLException: [Microsoft][Controlador ODBC Microsoft Access] Error de sintaxis (falta operador) en la expresión de consulta 'clientes.nombreFROM clientesWHERE ((clientes.nombre)=javier)'.
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6031)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:6188)
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java:2494)
at sun.jdbc.odbc.JdbcOdbcStatement.execute(JdbcOdbcStatement.java:334)
at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(JdbcOdbcStatement.java:249)
at validar_3._jspService(validar_3.java:63)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119)
at javax.servlet.http.HttpServlet.service(HttpServlet.java)
at org.apache.tomcat.facade.ServletHandler.doService(ServletHandler.java:574)
at org.apache.tomcat.core.Handler.invoke(Handler.java:322)
at org.apache.tomcat.core.Handler.service(Handler.java:235)
at org.apache.tomcat.facade.ServletHandler.service(ServletHandler.java:485)
at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:917)
at org.apache.tomcat.core.ContextManager.service(ContextManager.java:833)
at org.apache.tomcat.modules.server.Http10Interceptor.processConnection(Http10Interceptor.java:176)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:494)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:516)
at java.lang.Thread.run(Thread.java:484)
El código del jsp es:
<html>
<body>
<br><br>
<%
boolean encontrado= false;
String nombre1= request.getParameter("nombre");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String bd=("jdbc:odbc:basetest");
java.sql.Connection con= java.sql.DriverManager.getConnection(bd);
java.sql.Statement st = con.createStatement();
String qry="SELECT clientes.nombre";
qry+="FROM clientes";
qry+="WHERE ((clientes.nombre)="+nombre1+");";
java.sql.ResultSet rs=st.executeQuery(qry);
while (rs.next())
{
encontrado=true;
}
rs.close();
if(encontrado)
out.println("ok");
else
out.println("Password incorrecta");
%>
</body></html>