java.sql.SQLException: Result set is in an invalid state. May be before the first row or after the

[Kalai Selvi]

I am using JNDI Datasource (running in weblogic8.1) to connect to database. I have inserted 2 rows in the table. Below is the code. I am able to get the resultset. But, I get
"java.sql.SQLException: Result set is in an invalid state. May be before the first row or after the last row". I can understand this is because of not positioning the pointer at the correct place in resultset. I am trying different possibilities. Please let me know what the problem could be?

 	public String ConnectDataSource()
	{
		Connection conn = null;
		Context ctx = null;
		Statement st = null;
		ResultSet rs = null;

	try {
	 Hashtable env= new Hashtable(2);
	 env.put(Context.INITIAL_CONTEXT_FACTORY, "weblogic.jndi.WLInitialContextFactory" );
                 env.put(Context.PROVIDER_URL,"t3://localhost:7001");
	 ctx=new InitialContext(env);
	 DataSource ds=(DataSource) ctx.lookup("data/Musicdata");
	 conn = ds.getConnection();
	 st = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
  	 rs = st.executeQuery("select upc,title,artist,type,price from musictable");
	 ResultSetMetaData rsmd = rs.getMetaData();
	 int numberOfColumns = rsmd.getColumnCount();
	 System.out.println("Number of Columns is "+numberOfColumns);
	 int typeOfRs = rs.getType();
	 System.out.println("Resultset Type is "+typeOfRs);
	 while(rs.next())
				{
					upc = rs.getString(1);
					System.out.println("upc is "+upc);
					title = rs.getString(2);
					artist = rs.getString(3);
					type = rs.getString(4);
					price = rs.getFloat(5);
				}
		} catch (Exception se) {
				System.out.println("Caught you !!! Ha Ha!!");
				se.printStackTrace();
		}
		finally
		{
			try
			{
				if (ctx !=null)		ctx.close();				
				if (conn !=null) 	conn.close();
				if (st !=null) 	st.close();
				if (rs !=null)  rs.close();
			}
			catch(SQLException sqle)
			{
				sqle.printStackTrace();
			}
			catch (NamingException ne)
			{
				ne.printStackTrace();
			}			
		}		
			return upc;
	}