Hi all,
I am trying to retreive information based on certain condition.
It is working fine if i use SELECT query excluding the WHERE part,But when i include WHERE part i am getting the following error. I am also enclosing my code after the errors. One more strange thing is that it is working for condition Gpa>=gpa but if i use other two conditions i.e degree and major. It is giving the following error.
Note: Gpa is text box in html file
where as degree is inputbox and major is combo.
Well does this matter by any chance.
Root cause:
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2.
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 _0002fsimpleSearch_0002ejspsimpleSearch_jsp_8._jspService(_0002fsimpleSearch_0002ejspsimpleSearch_jsp_8.java:92)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServlet$JspCountedServlet.service(JspServlet.java:130)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:282)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:429)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:500)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405)
at org.apache.tomcat.core.Handler.service(Handler.java:287)
at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:812)
at org.apache.tomcat.core.ContextManager.service(ContextManager.java:758)
at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:213)
at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501)
at java.lang.Thread.run(Thread.java:484)
-----------------------------------------------------------------<HTML>
<HEAD><TITLE>SIMPLE SEARCH PAGE</TITLE></HEAD>
<BODY>
<%@ page session="true"%>
<%@ page import="java.sql.*" %>
<%@ page import="java.util.*" %>
<%@ page import="java.io.*" %>
<%@ page import="java.lang.String" %>
<%
String degree=request.getParameter("degree");
String major=request.getParameter("major");
String gpa=request.getParameter("gpa");
String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
String url = "jdbc
dbc:Resume";
Class.forName(driver);
Connection con=null;
try{
con=DriverManager.getConnection(url);
String query="SELECT LastName, FirstName, Degree, Major1, Gpa FROM Profile WHERE Degree="+degree+" AND Gpa >="+gpa+" AND (Major1="+major+" OR Major2="+major+")";
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery(query);
%>
<table>
<tr>
<th>Last Name</th><th>First Name</th><th>Degree</th><th>Major</th><th>Gpa</th></tr>
<%
while(rs.next()){
String lastname=rs.getString(1);
String firstname=rs.getString(2);
String degree1=rs.getString(3);
String major1=rs.getString(4);
String gpa1=rs.getString(5);
%>
<tr>
<td><%=lastname%></td><td><%=firstname%></td><td><%=degree1%></td><td><%=major1%></td><td><%=gpa1%& gt;</td><td>View Resume</td>
</tr>
<%
}
rs.close();
rs=null;
stmt.close();
stmt=null;
}
finally{
if(con!=null){
con.close();}
}
%>
</table>
</BODY></HTML>
[This message has been edited by vikram nalagampalli (edited November 10, 2001).]
[This message has been edited by vikram nalagampalli (edited November 10, 2001).]