SQL Server JDBC - What's in a name

Author

What's in a name

Marco Trevisan

2005-06-29, 9:23 am

I'm actually satisfied with the old driver and the new
driver. They both run against 2000 and 2005 (sql express).

I stumbled against the new naming: staring to a bunch of
characters an being able to use the new driver only after
cut & paste (pondering about readiness tests and tortoises ...)

Imagine: both driver installed on the same JVM and starting
to wondering: should it be jdbc.sqlserver or sqlserver.jdbc ?
What ? table not found ?!?! Wait a minute, it's dataBase,
not DataBase.

For the future: will the old driver (and following SPs) be
compatible with 2005 ?

--Marco

Angel Saenz-Badillos[MS]

2005-06-29, 8:23 pm

A rose by any other name...
Not trying to confuse, it was just a lot easier to get the name approved
internally if we did not deviate from the old name too much.

I personally dislike case sensitive connection string properties, I will
take a look at this to see if there is something we can do about it. I
really don't know what the support for the old driver is going to look like,
but it should work against Sql Server 2005 as a downlevel client. That said
I feel that the improvements of the new driver in performance and stability
and the fact that we will be supporting the new driver with a full team will
make this a much better choice going forward and I would like to encourage
you to plan accordingly.

Thank you for downloading the new driver, looking forward to hearing more
about your impressions as you start to play with it more in depth.
--
Angel Saenz-Badillos [MS] DataWorks
This posting is provided "AS IS", with no warranties, and confers no
rights.Please do not send email directly to this alias.
This alias is for newsgroup purposes only.
I am now blogging: http://weblogs.asp.net/angelsb/

"Marco Trevisan" <trevisan.marco@NOSPAMemail.it> wrote in message
news:1120051559. 44aec14ad6e775898bfd
65d37c6eb76c@teranew
s...
> I'm actually satisfied with the old driver and the new
> driver. They both run against 2000 and 2005 (sql express).
>
> I stumbled against the new naming: staring to a bunch of
> characters an being able to use the new driver only after
> cut & paste (pondering about readiness tests and tortoises ...)
>
> Imagine: both driver installed on the same JVM and starting
> to wondering: should it be jdbc.sqlserver or sqlserver.jdbc ?
> What ? table not found ?!?! Wait a minute, it's dataBase,
> not DataBase.
>
> For the future: will the old driver (and following SPs) be
> compatible with 2005 ?
>
> --Marco

Angel Saenz-Badillos[MS]

2005-06-29, 8:23 pm

Well, for now at least it looks like it is not worth taking a performance
hit to check for case on the connection strings so we will probably continue
with the current behavior. Let me know if this is a problem going forward
and I would be happy to take another look at it.

--
Angel Saenz-Badillos [MS] DataWorks
This posting is provided "AS IS", with no warranties, and confers no
rights.Please do not send email directly to this alias.
This alias is for newsgroup purposes only.
I am now blogging: http://weblogs.asp.net/angelsb/

"Angel Saenz-Badillos[MS]" <angelsa@online.microsoft.com> wrote in message
news:OuWm19NfFHA.268@TK2MSFTNGP15.phx.gbl...
>A rose by any other name...
> Not trying to confuse, it was just a lot easier to get the name approved
> internally if we did not deviate from the old name too much.
>
> I personally dislike case sensitive connection string properties, I will
> take a look at this to see if there is something we can do about it. I
> really don't know what the support for the old driver is going to look
> like, but it should work against Sql Server 2005 as a downlevel client.
> That said I feel that the improvements of the new driver in performance
> and stability and the fact that we will be supporting the new driver with
> a full team will make this a much better choice going forward and I would
> like to encourage you to plan accordingly.
>
> Thank you for downloading the new driver, looking forward to hearing more
> about your impressions as you start to play with it more in depth.
> --
> Angel Saenz-Badillos [MS] DataWorks
> This posting is provided "AS IS", with no warranties, and confers no
> rights.Please do not send email directly to this alias.
> This alias is for newsgroup purposes only.
> I am now blogging: http://weblogs.asp.net/angelsb/
>
>
>
>
> "Marco Trevisan" <trevisan.marco@NOSPAMemail.it> wrote in message
> news:1120051559. 44aec14ad6e775898bfd
65d37c6eb76c@teranew
s...
>
>

Shelby Goerlitz [MSFT]

2005-06-29, 8:23 pm

Marco:

The SQL Server 2005 driver is a new product, not an upgrade from the old
product.

There is no plan to ever support he SQL Server 2000 driver against SQL
Server 2005.

We plan to begin deprecating the SQL Server 2000 driver when the SQL Server
2005 driver launches this fall, although support for the older driver will
continue.

-shelby

Shelby Goerlitz
Microsoft SQL Server

"Angel Saenz-Badillos[MS]" <angelsa@online.microsoft.com> wrote in message
news:OuWm19NfFHA.268@TK2MSFTNGP15.phx.gbl...
>A rose by any other name...
> Not trying to confuse, it was just a lot easier to get the name approved
> internally if we did not deviate from the old name too much.
>
> I personally dislike case sensitive connection string properties, I will
> take a look at this to see if there is something we can do about it. I
> really don't know what the support for the old driver is going to look
> like, but it should work against Sql Server 2005 as a downlevel client.
> That said I feel that the improvements of the new driver in performance
> and stability and the fact that we will be supporting the new driver with
> a full team will make this a much better choice going forward and I would
> like to encourage you to plan accordingly.
>
> Thank you for downloading the new driver, looking forward to hearing more
> about your impressions as you start to play with it more in depth.
> --
> Angel Saenz-Badillos [MS] DataWorks
> This posting is provided "AS IS", with no warranties, and confers no
> rights.Please do not send email directly to this alias.
> This alias is for newsgroup purposes only.
> I am now blogging: http://weblogs.asp.net/angelsb/
>
>
>
>
> "Marco Trevisan" <trevisan.marco@NOSPAMemail.it> wrote in message
> news:1120051559. 44aec14ad6e775898bfd
65d37c6eb76c@teranew
s...
>
>

Sponsored Links