Prepared Statement Problem

[Ross Howard Miller]

I'm getting a SQLException invalid column index.

		    String callNumber = "Boyd JK468.P64 O33 2008";
		    String getRowNumber = "SELECT row_number FROM call_no_browse WHERE call_no_display = ' ? ';";
		    PreparedStatement stm = connection.prepareStatement(getRowNumber);
		    
		    
		    stm.setString(1, callNumber);
		    ResultSet set = stm.executeQuery();
		    String rowNumber = null;
		    
			while (set.next()) {
				rowNumber = set.getString("ROW_NUMBER");
			}
		    
			System.out.println(rowNumber);

[James Boswell]

Hi Ross

On what line is this exception being thrown?

[Paul Clapham]

Why do you have those quotes around the parameter marker in the SQL?

[Michael Dirks]

You're putting quotes around your parameter which means that instead of the query trying to find the row number where call_no_display = callNumber, it's trying to find a case where call_display equals a string that has a question mark in it.

try this instead:
String getRowNumber = "SELECT row_number FROM call_no_browse WHERE call_no_display = ? ";

[sarath j nair]

You Should get this Error " getting a SQLException invalid column index. " because Its not a proper Query


sql="insert into OTEMPLOYEE(ADMIN) values(?)";
PreparedStatement ps=null;
ps=con.prepareStatement(sql);
ps.setInt(1, admin);
ps.close();