INFO: parametercount: 1. Assertion failure

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Luuk
    Recognized Expert Top Contributor
    • Mar 2012
    • 1043

    INFO: parametercount: 1. Assertion failure

    Code:
    		PreparedStatement prep = conn.prepareStatement("select sheetname from sheet where i = ?;");
    		ParameterMetaData p = prep.getParameterMetaData();
    	    logger.info("parametercount: " + p.getParameterCount());
    		prep.setInt(1, 1);
    		prep.addBatch();
    		[B]ResultSet rs = prep.executeQuery();[/B]
    		while (rs.next()) {
    			s = rs.getString("sheetname");
    		}
    		rs.close();
    when I execute this, I get an error on line 6 of above code:
    Code:
    INFO: parametercount: 1
    Exception in thread "main" java.sql.SQLException: assertion failure: param count (1) != value count (2)
    what am I doing wrong... ;)
  • Luuk
    Recognized Expert Top Contributor
    • Mar 2012
    • 1043

    #2
    solved...

    SOLVED!, line 5 should not have been there....

    Comment

    Working...