How MS implement Positioned cursors on SQL 6.5
Stevenson, Chris (SSABSA)
chris at ssabsa.sa.gov.au
Wed Feb 9 22:07:05 EST 2000
> Stevenson, Chris (SSABSA) writes:
> > > Simply put, most of the 2.0 enhancements can't be
> implemented cleanly
> > > and reliably on a relational database.
> > I disagree with this *very* strongly, and the proof is in
> > the pudding of all the (commercial) implementations.
> Most of the 2.0 drivers (mine included) are just 1.0 drivers where the
> new methods just throw an exception.
The MySql ones are but that's because the MySql protocol
doesn't support cursors, but most commercial dbs *do*
and SQL Server most certainly does.
> You'll have to make better
> pudding before I'll buy that argument.
Fair comment, and exactly what I'm trying to do :-)
It looks like the packets sent and received are standard
TDS 1.0 packets, so there shouldn't need to be many
changes to freetds to support cursors.
And of course, the whole idea of the JDBC API is to make it
easy for developers using the api - not those implementing
the Drivers for it!
More information about the FreeTDS