FreeTDS Development Group

[Bob Kline <bkline AT rksystems.com>]

On 7 Jun 2000, Stefan Bodewig wrote:

> Hi Bob,
> 
> I'd be interested in your patches and maybe we could work together to
> improve on it. I had offered my help weeks if not months ago and am
> still here waiting to get my hands dirty.
> 

Excellent!  Shall I send them to you directly or post them here (the
context diffs weigh in at about 35K, I believe)?  Do we need Craig to
coordinate modifications to the base code (I've copied him on this
reply, as well as the address on the "Contact" page of the web site for
JDBC code submissions)?

> >>>>> "BK" == Bob Kline <bkline AT rksystems.com> writes:
> 
>  BK> On point #2, I couldn't find any more elegant and unobtrusive way
>  BK> of switching on the 7.0 processing flavor than
>  BK> System.getProperty().  If the "TDSVER" property is set to "70"
>  BK> then the Tds and TdsComm classes know to use that version of TDS.
> 
> I'd prefer to encode it in the JDBC URL, something like
> jdbc:freetds:sqlserver42// and jdbc:freetds:sqlserver70// with
> jdbc:freetds:sqlserver// beeing an alias to sqlserver42.
> 

I thought about something along those lines (I don't necessarily mind
the idea of passing the information in the URL), but I wasn't happy with
the implication in that particular syntax about the version of the DBMS,
which isn't always tied to the version of TDS used/supported (SQL Server
6.x speaks TDS 4.2, for example): might be a bit confusing.  Another
possibility might be to extend the URL syntax out to the right:

    jdbc:freetds:sqlserver//some.org/somedb:tds=70

Or both could be supported.  What do you think?

Bob