NullPointerException inside ResultSet.next()

Hi all,

I have a query which returns multiple rows like so:

ResultSet ingredients = st.executeQuery("SELECT * FROM ingredientslookup
WHERE (recipeindex = " + recipes.getInt("recipe_index") + ")");

while (ingredients.next()) {
// do stuff
}

When I run this query, it iterates through the while loop exactly once,
but then bombs out on the second attempt to evaluate
"ingedients.next()".

java.lang.NullPointerException
at org.postgresql.jdbc2.ResultSet.next(ResultSet.java:113)

My question is: Should it be possible for this exception to occur inside
this code at all?

Am I making a mistake somewhere, or is this a bug in the jdbc driver?

I have tried both the driver that came with v7.1.3, and the latest v7.2
driver from jdbc.postgresql.org.

Regards,
Graham
--
-----------------------------------------
minfrin(at)sharp(dot)fm "There's a moon
over Bourbon Street
tonight..."