Nik Petroff wrote:
> Is it possible to set the connection properties so that ANSI_NULLS and
> ANSI_WARNINGS are on? I can't find any java code for this anywhere so an
> example would be great.
Could you just execute this query when you establish a connection?
set ANSI_NULLS on
set ANSI_WARNINGS on
Those settings stay in effect for the session.
HTH.
--jkl