FreeTDS Development Group

["Curt Hagenlocher" <curt AT hagenlocher.org>]

> 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.

As someone else has pointed out, this should theoretically be a
simple matter of executing the text "set ansi_nulls on" and
"set ansi_warnings on".  Unfortunately, because of the way the
JDBC driver works, you may be getting a new connection to the
SQL Server without knowing it.  As a result, you would have to
make these calls nearly every time you wanted to execute a command
that could be affected by them.

One alternative is to have a private build of the jdbc library,
and replace the function Connection_base::sqlStatementToInitialize
with the additional statements.  The text returned by this function
is exectuted every time a new connection is made.

--
Curt Hagenlocher
curt AT hagenlocher.org