Hi I am trying to insert a null into a column of type int, via JDBC.
I am using Microsoft SQL Server 2000 Driver for JDBC, and the code I use is:

if ( serviceConfigId != -1) {
pstmt.setInt( 2, serviceConfigId);
} else {
log_.debug("No service configuration attached");
pstmt.setNull( 2, Types.NULL);

This compiles fine, but when I try to run it I get an exception:

SQLException in updateKeyword: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]The specified SQL type is not supported by this driver.

My question is, how can it be done using the Microsoft driver ?
I need to explicitly insert a null, because there will be cases when the column already has a value, but I wish to set it back to null.
I know I can solve the problem by using a stored procedure, but I would prefer not to.