Store Procedure in Spring

[rahul karwal]

I am calling a store procedure from Spring(extending MappingSqlQuery)
and that procedure has one of the parameters as optional (eg @iD Integer = null).I am using Sybase and my question is how do you pass null from Java knowing that its an Integer? I tried to do this Integer x =null and pass x as teh param but give me exceptions.can anyone pls help me.
thanks
aziz

[Karthik Guru]

If the DB procedure signature specifies that a parameter is optional and has a default value specified as well, are we required to pass it in when calling fro java?

Did you check java.sql.Types.NULL ?
[ November 30, 2005: Message edited by: Karthik Guru ]

[rahul karwal]

yes we are required to pass in the parameter or spring is complaining.