I am calling a Stored procedure on sql server through a jdbc connection and get the followong exception
java.sql.SQLException: [LDNDCM05400V05A\CHM_MAIN1_LIVE]Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection. This ensures consistent query semantics. Enable these options and then reissue your query.
If i call the stored procedure directly on sql server it works fine but if i call it through my java process i get the exception.
Note: the folowing HAVE been set on the stored proc.
SET ANSI_NULLS ON
SET ANSI_WARNINGS ON
Can anyone help?