Re: Upgrading and datasources
>Previous versions of the MS JDBC driver were licensed from DataDirect, but >it's my understanding that the current one is not based on any DataDirect >code. As for stability, I've seen results all over the place, with the >DataDirect driver sometimes being more stable than the new MS one, >sometimes being less stable. Dave, I don't know what MS JDBC driver version you are taking about. If it's SP3, then I'm afraid you're wrong. Just look at their changelog (it's somewhere in the bundle or on their site) and at the packaging. The difference between successive versions of the MS driver is 10 to 20 (minor) bugfixes. As about packaging, the DataDirect comes in three jars -- base, util and sqlserver -- and the Microsoft one comes in the same three jars -- msbase, msutil and mssqlserver. Also, the difference between the DataDirect and the MS Driver and DataSource class names is com.datadirect.whatever as opposed to com.microsoft.whatever. Ask the people at DataDirect why their driver is better than the MS one and they'll indicate that the MS driver is based on an old and unstable 2.x version of their driver. And I think 20 bugfixes every two years are not going to help stability too much. As a comparison, jTDS usually has about 10-30 bug fixes every new release, which is montly; and this only includes bugs that make it into SourceForge, a lot are discovered and fixed by developers. >I've heard a few people say good things about jTDS, but I don't have any >experience with it myself. I'll have to check it out. I'm obviously not going to tell you it's the best (that's relative, anyway) but you should definitely try it out. Alin, The jTDS Project. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196713 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Upgrading and datasources
>Dave Watts wrote: >> I wasn't aware of all that. In the case of Windows authentication using a >> native SSO library, do you have to run CFMX as the specific Windows user >> against which you want to perform authentication? > >apparently not. just add the domain property to the jdbc url along >w/domain user & password and bob's your uncle. Paul, Both of you are right. There are two ways in which Windows authentication can be used from jTDS: either (i) though a native SSO library (in which case you don't have to provide a user and password, the credentials of the logged in Windows user or of the user as which the application is run) or (ii) by providing the user name and password along with the domain when requesting the connection. Option (ii) is especially useful when running on a non-Windows platform or when trying to avoid native libraries (which, as you can see from my previous post can take down the application if something goes wrong). Alin, The jTDS Project. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196712 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Upgrading and datasources
Dave Watts wrote: > I wasn't aware of all that. In the case of Windows authentication using a > native SSO library, do you have to run CFMX as the specific Windows user > against which you want to perform authentication? apparently not. just add the domain property to the jdbc url along w/domain user & password and bob's your uncle. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196706 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Upgrading and datasources
> Sorry, I'm not very famililar (if at all) with CF. It's just > that the DataDirect driver is the parent of _a lot_ of the > JDBC drivers out there (including the MS, BEA and IBM ones) > and I was a bit confused by earlier posts I've seen on CF > forums. And although the DataDirect driver is (I have to > admit) the most stable and tested SQL Server drivers it's > definitely not the fastest (and also, some of its offspring, > such as the MS driver, is based on older much more unstable > versions). Previous versions of the MS JDBC driver were licensed from DataDirect, but it's my understanding that the current one is not based on any DataDirect code. As for stability, I've seen results all over the place, with the DataDirect driver sometimes being more stable than the new MS one, sometimes being less stable. > We have performed a lot of benchmarks, but major vendors such > as DataDirect and JNetDirect (not sure about NewAtlanta) do > not allow publishing of benchmark results produced using > their drivers. I think it's quite obvious why. There are a > couple of links to benchmarks provided by some commercial > vendors on the jTDS homepage ( http://jtds.sourceforge.net/ ) > and some older benchmark results also on the jTDS site ( > http://jtds.sourceforge.net/benchTest.html ). Running the > benchmarks is really straightforward and both come with > pretty detailed READMEs. I've heard a few people say good things about jTDS, but I don't have any experience with it myself. I'll have to check it out. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196698 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Upgrading and datasources
>While all that may be true, we were talking about the DataDirect Connect >driver shipped with CFMX, not the MS driver. Sorry, I'm not very famililar (if at all) with CF. It's just that the DataDirect driver is the parent of _a lot_ of the JDBC drivers out there (including the MS, BEA and IBM ones) and I was a bit confused by earlier posts I've seen on CF forums. And although the DataDirect driver is (I have to admit) the most stable and tested SQL Server drivers it's definitely not the fastest (and also, some of its offspring, such as the MS driver, is based on older much more unstable versions). >> You could, however use jTDS: it works both over TCP/IP and >> named pipes and supports three types of authentication >> (SQL Server, Windows authentication providing a user name >> and password and Windows authentication using a native >> Single Sign On library). > >I wasn't aware of all that. In the case of Windows authentication using a >native SSO library, do you have to run CFMX as the specific Windows user >against which you want to perform authentication? To be totally honest, I don't know for sure. I'm an almost 100% Java programmer and I use Linux most of the time. But if you ask this question on the jTDS forums you will definitely get an answer. And a warning: we have just discovered a bug in the SSO library, which being native can crash and take down the whole JVM; we have a patch submitted and we're working on it but we do not recommend using SSO in production yet. >> jTDS is also more stable and a faster than the MS driver. > >Have you performed benchmarks to this effect? Can you share the benchmark >results and the steps you went through to perform your tests? How does it >compare to DataDirect and JTurbo? We have performed a lot of benchmarks, but major vendors such as DataDirect and JNetDirect (not sure about NewAtlanta) do not allow publishing of benchmark results produced using their drivers. I think it's quite obvious why. There are a couple of links to benchmarks provided by some commercial vendors on the jTDS homepage ( http://jtds.sourceforge.net/ ) and some older benchmark results also on the jTDS site ( http://jtds.sourceforge.net/benchTest.html ). Running the benchmarks is really straightforward and both come with pretty detailed READMEs. Alin, The jTDS Project. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196696 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Upgrading and datasources
> Indeed the MS driver only supports TCP/IP as a communication > protocol and SQL Server authentication. While all that may be true, we were talking about the DataDirect Connect driver shipped with CFMX, not the MS driver. > You could, however use jTDS: it works both over TCP/IP and > named pipes and supports three types of authentication > (SQL Server, Windows authentication providing a user name > and password and Windows authentication using a native > Single Sign On library). I wasn't aware of all that. In the case of Windows authentication using a native SSO library, do you have to run CFMX as the specific Windows user against which you want to perform authentication? > jTDS is also more stable and a faster than the MS driver. Have you performed benchmarks to this effect? Can you share the benchmark results and the steps you went through to perform your tests? How does it compare to DataDirect and JTurbo? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196686 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Upgrading and datasources
DataDirect
Andy
On Fri, 25 Feb 2005 08:11:25 -0500, Calvin Ward <[EMAIL PROTECTED]> wrote:
> Is CFMX7 using the MS driver or DataDirect?
>
> -Original Message-
> From: Alin Sinpalean [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, February 23, 2005 2:30 PM
> To: CF-Talk
> Subject: Re: Upgrading and datasources
>
> >> Has anyone performed an upgrade to CFMX 7 from CF 5 and had
> >> issues with the datasources not working properly?
> >>
> >> CFMX7 doesn't seem to translate port numbers for SQL Server
> >> properly (especially if they are set to dynamically determine
> >> in the ODBC console) and none of the passwords seem to work!
> >
> >In my experience, you typically have to reconfigure SQL Server datasources
> >when upgrading CF 5 to CFMX. There are several differences between CFMX and
> >previous versions when it comes to SQL Server. If you use the SQL Server
> >JDBC driver, you can't use anything other than TCP/IP to connect, and you
> >can't use Windows authentication within SQL Server - you need to use native
> >SQL logins ("untrusted connections"). If you need to use other network
> >protocols or Windows authentication, you will need to use an ODBC
> datasource
> >instead, and choose "ODBC Socket" within the CF Administrator.
>
> Dave, Calvin,
>
> Indeed the MS driver only supports TCP/IP as a communication protocol and
> SQL Server authentication. You could, however use jTDS: it works both over
> TCP/IP and named pipes and supports three types of authentication (SQL
> Server, Windows authentication providing a user name and password and
> Windows authentication using a native Single Sign On library).
>
> jTDS is also more stable and a faster than the MS driver.
>
> Disclaimer: I am a jTDS developer.
>
> Alin,
> The jTDS Project.
>
>
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196500
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Upgrading and datasources
Is CFMX7 using the MS driver or DataDirect?
-Original Message-
From: Alin Sinpalean [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 23, 2005 2:30 PM
To: CF-Talk
Subject: Re: Upgrading and datasources
>> Has anyone performed an upgrade to CFMX 7 from CF 5 and had
>> issues with the datasources not working properly?
>>
>> CFMX7 doesn't seem to translate port numbers for SQL Server
>> properly (especially if they are set to dynamically determine
>> in the ODBC console) and none of the passwords seem to work!
>
>In my experience, you typically have to reconfigure SQL Server datasources
>when upgrading CF 5 to CFMX. There are several differences between CFMX and
>previous versions when it comes to SQL Server. If you use the SQL Server
>JDBC driver, you can't use anything other than TCP/IP to connect, and you
>can't use Windows authentication within SQL Server - you need to use native
>SQL logins ("untrusted connections"). If you need to use other network
>protocols or Windows authentication, you will need to use an ODBC
datasource
>instead, and choose "ODBC Socket" within the CF Administrator.
Dave, Calvin,
Indeed the MS driver only supports TCP/IP as a communication protocol and
SQL Server authentication. You could, however use jTDS: it works both over
TCP/IP and named pipes and supports three types of authentication (SQL
Server, Windows authentication providing a user name and password and
Windows authentication using a native Single Sign On library).
jTDS is also more stable and a faster than the MS driver.
Disclaimer: I am a jTDS developer.
Alin,
The jTDS Project.
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196499
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Upgrading and datasources
>> Has anyone performed an upgrade to CFMX 7 from CF 5 and had
>> issues with the datasources not working properly?
>>
>> CFMX7 doesn't seem to translate port numbers for SQL Server
>> properly (especially if they are set to dynamically determine
>> in the ODBC console) and none of the passwords seem to work!
>
>In my experience, you typically have to reconfigure SQL Server datasources
>when upgrading CF 5 to CFMX. There are several differences between CFMX and
>previous versions when it comes to SQL Server. If you use the SQL Server
>JDBC driver, you can't use anything other than TCP/IP to connect, and you
>can't use Windows authentication within SQL Server - you need to use native
>SQL logins ("untrusted connections"). If you need to use other network
>protocols or Windows authentication, you will need to use an ODBC datasource
>instead, and choose "ODBC Socket" within the CF Administrator.
Dave, Calvin,
Indeed the MS driver only supports TCP/IP as a communication protocol and SQL
Server authentication. You could, however use jTDS: it works both over TCP/IP
and named pipes and supports three types of authentication (SQL Server, Windows
authentication providing a user name and password and Windows authentication
using a native Single Sign On library).
jTDS is also more stable and a faster than the MS driver.
Disclaimer: I am a jTDS developer.
Alin,
The jTDS Project.
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196176
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Upgrading and datasources
I was afraid it would come to that, pretty unfortunate.
- Calvin
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 22, 2005 2:38 PM
To: CF-Talk
Subject: RE: Upgrading and datasources
> Has anyone performed an upgrade to CFMX 7 from CF 5 and had
> issues with the datasources not working properly?
>
> CFMX7 doesn't seem to translate port numbers for SQL Server
> properly (especially if they are set to dynamically determine
> in the ODBC console) and none of the passwords seem to work!
In my experience, you typically have to reconfigure SQL Server datasources
when upgrading CF 5 to CFMX. There are several differences between CFMX and
previous versions when it comes to SQL Server. If you use the SQL Server
JDBC driver, you can't use anything other than TCP/IP to connect, and you
can't use Windows authentication within SQL Server - you need to use native
SQL logins ("untrusted connections"). If you need to use other network
protocols or Windows authentication, you will need to use an ODBC datasource
instead, and choose "ODBC Socket" within the CF Administrator.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196080
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Upgrading and datasources
> Has anyone performed an upgrade to CFMX 7 from CF 5 and had
> issues with the datasources not working properly?
>
> CFMX7 doesn't seem to translate port numbers for SQL Server
> properly (especially if they are set to dynamically determine
> in the ODBC console) and none of the passwords seem to work!
In my experience, you typically have to reconfigure SQL Server datasources
when upgrading CF 5 to CFMX. There are several differences between CFMX and
previous versions when it comes to SQL Server. If you use the SQL Server
JDBC driver, you can't use anything other than TCP/IP to connect, and you
can't use Windows authentication within SQL Server - you need to use native
SQL logins ("untrusted connections"). If you need to use other network
protocols or Windows authentication, you will need to use an ODBC datasource
instead, and choose "ODBC Socket" within the CF Administrator.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195955
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
