preparedStatement

Hi there
I'm using connector J 5.0.4. Lets say I have a preparedStatement with 4 parameters for an insert command. I wish I could do the following: 
1) set all the 4 parameters to null with preparedStatement.setNull(pos, type) 
2) set some of them (say 1 and 2) to a non null value.

When I call preparedStatement.executeUpate() I have an SQLException saying parameter 3 is not set. what's the problem here ?

Thanks for any advice

François 

-- 
MySQL Java Mailing List
For list archives: http://lists.mysql.com/java
To unsubscribe:    http://lists.mysql.com/[email protected]