numeric overflow error

[patel_dil]

statement.setString(3, userContext.getUser().getUserName());
statement.registerOutParameter(4, Types.INTEGER); //this gives numeric overflow

How about changing that to Types.BIGINT. Did you try that?