problem with ResultSet

[Haritha Gorijavolu]

I am using the following code to get data from a database and display it.

String magname="haritha";
String currid="";
try
{
	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	Connection con=DriverManager.getConnection("jdbc:odbc:source","db2admin","db2admin");
	Statement stmt = con.createStatement();
	ResultSet rst=stmt.executeQuery("SELECT * FROM USER.MAGAZINES WHERE UPPER(MAGNAME) LIKE UPPER('%" + magname + "%')");
	while(rst.next())
	{
		out.println("<h4>Magazine info:</h4>");
		out.println("</br>Magazine ID:"+rst.getString(1));
		out.println("</br>Magazine Name:"+rst.getString(2));
		out.println("</br>Publisher:"+rst.getString(3));
		out.println("</br>Frequency:"+rst.getString(5));
		currid=rst.getString(1);
		out.println(rst.getString(1));
	
	}
	rst.close();
	stmt.close();
	con.close();
	
}

catch (Exception e)
{
	e.printStackTrace();
	out.println("EXCEPTION:" + e.getMessage() );
	out.println("</br>");
}

I am getting the following output:

Magazine info:

Magazine ID:1
Magazine Name:haritha
Publisher:xyz
Frequency:weekly EXCEPTION:No data found

When I use currid instead of rst.getString(1) in the out.println() of last line of while loop, the code works fine. Why is it not working for rst.getString(1)? Please help.

[Haritha Gorijavolu]

I m sorry. This script was to be in a JSP. So I choose JSP. However, the problem is with the result set. I should have posted it in JDBC.

[Paul Sturrock]

It looks like you may be using DB2. If so, why are you using the JDBC-ODBC bridge? I would recommend using a type 4 driver instead.