Skip to Content.
Sympa Menu

freetds - Re: Driver Properties

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Curt Hagenlocher" <curt AT hagenlocher.org>
  • To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
  • Subject: Re: Driver Properties
  • Date: Thu, 5 Apr 2001 08:49:51 -0700


> 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




Archive powered by MHonArc 2.6.24.

Top of Page