Hi there
When I try to connect my JSP to my database thru a bean and fetch data from Result set I am getting exception..

My JSP code is like this..
<%@ page import ="tryBean" %>

<%
String eid=request.getParameter("param1");
tb.setConnection();
ResultSet rs1 = tb.getResultSet(eid);
String lname= rs1.getString("lastname");
String fname= rs1.getString("firstname");
String ext = rs1.getString("extension");
String city= rs1.getString("cityofresidence");
String dept= rs1.getString("dept");
%>

-----


and in my bean I try to connect to Database to get the required data...
tryBean.java

public void setConnection () {
try {
dbPool = DBPool.getPool("test_db");
con = dbPool.getConnection();
stmt = con.createStatement();
}catch(SQLException e) {
e.getMessage(); }
}

public ResultSet getResultSet(String id) throws Exception {
rs = stmt.executeQuery("SELECT * FROM emp where empid
='"+id+"' " );
return rs;
}

-------
But When I run my JSP I get the following error..
java.sql.SQLException: Before start of result set
at org.gjt.mm.mysql.ResultSet.checkRowPos
(ResultSet.java:1336)
at org.gjt.mm.mysql.ResultSet.getString
(ResultSet.java:220)
at org.gjt.mm.mysql.ResultSet.getString
(ResultSet.java:889)
at _jsp._custModify__jsp._jspService(/custModify.jsp:22)
at com.caucho.jsp.JavaPage.service(JavaPage.java:87)
at com.caucho.jsp.JavaPage.subservice(JavaPage.java:81)
at com.caucho.jsp.Page.service(Page.java:407)
at com.caucho.server.http.FilterChainPage.doFilter (FilterChainPage.java:136)
at com.caucho.server.http.Invocation.service (Invocation.java:268)
at com.caucho.server.http.CacheInvocation.service (CacheInvocation.java:128)
at com.caucho.server.http.HttpRequest.handleRequest (HttpRequest.java:238)
at com.caucho.server.http.HttpRequest.handleConnection (HttpRequest.java:157)
at com.caucho.server.TcpConnection.run
(TcpConnection.java:140)
at java.lang.Thread.run(Thread.java:484)

This exception is very new to me ...So please help me..
What is the problem in my code..
Thanks
ScottDecosta    <<Less