i am populating my JMenuBar with data coming from a database source
when i execute my prepared statement wherein a parameter does not
exist i get an error.

the code is below:

try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection
("jdbc:odbc:test");
Statement state=con.createStatement();
ResultSet result1=state.executeQuery("Select * from
Project");
PreparedStatement stat1=con.prepareStatement("select
* from Well where Pid=?");


while(result1.next())
{

String s=result1.getString(2);
submenu = new JMenu(s);
menu.add(submenu);
stat1.setString(1,result1.getString(1));
ResultSet result2=stat1.executeQuery();

while(result2.next())
{
String ss=result2.getString(1);
menuitem = new JMenuItem(ss);
submenu.add(menuitem);
}
}

}
catch(Exception e)
{
System.out.println("error" + e);
}