SQL Exception

[chetan deol]

I get exception while executing following query

My code runs perfectly If I execute only first query.
I also checked for datatypes matching and table formats.

	Statement statement = connection.createStatement() ;
	Statement agentstatement = connection.createStatement();
	ResultSet agentresultset = null;    
       
    ResultSet resultset =   statement.executeQuery("select * from db_finalreal where cost >=" + minValue + " and cost <= " + maxValue + " and city='"+ city + "'" + " and type='"+ type+"'");
    agentid = 1;    
    agentid = resultset.getInt(12);
	agentresultset=agentstatement.executeQuery("select * from db_finalagents where id="+agentid);

java.sql.SQLException
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
at com.mysql.jdbc.ResultSetImpl.checkRowPos(ResultSetImpl.java:815)
at com.mysql.jdbc.ResultSetImpl.getInt(ResultSetImpl.java:2593)
at org.apache.jsp.jsp.ShowAvailable_jsp._jspService(ShowAvailable_jsp.java:129)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:619)
SQL Error

[Bear Bibeault]

Please take the time to choose the correct forum for your posts. This forum is for questions on JSP.

For more information, please read this.

This post has been moved to a more appropriate forum.

[Jeanne Boyarsky]

You need to call resultSet.next() before calling resultset.getInt(12).

Also, if you only use that one field, why use "select *"? You could write a more specific query.

[Leonardo Carreira]

chetan dhumane wrote:I get exception while executing following query
ResultSet resultset = statement.executeQuery("select * from db_finalreal where cost >=" + minValue + " and cost <= " + maxValue + " and city='"+ city + "'" + " and type='"+ type+"'");
agentid = 1;
agentid = resultset.getInt(12);
agentresultset=agentstatement.executeQuery("select * from db_finalagents where id="+agentid);[/code]

please make sure your SQL statement .

i think your problem is, you put a space after "and cost <= " :
so please use the following ResultSet SQL :
ResultSet rs = statement.executeQuery("select * from db_finalreal where cost >=" + minValue + " and cost <="
+ maxValue + " and city='"+ city + "' and type='"+ type+"'");

and write :
rs.next();

Thank's
Sorry my english isn't too good