Will Railo 4.0 ship with MS JDBC driver 4.0?

[Thorsten Eilers]

Will railo 4.0 release ship with MS JDBC driver 4.0 by default?

I will thinks make easier to connect railo to MS SQL Server 2012.
It will take the pain away to make cfwheels running with the "Other-JDBC" driver.

One vote for MS JDBC driver 4.0 !

[Igal]

jTDS 1.2.5 is much better than Other-JDBC

unfortunately the version that ships with Railo 3 is 1.2.2 and it has some problems, but you can manually install 1.2.5

[Arthur Blake]

+1!!  I've been manually updating the Railo/ms driver to the latest ms version, since as long as I can remember.

BTW, you can just replace the ms jar(s) in the railo lib folder, and remove the old ones, and then you don't have to use "other" to make it work (I've been doing that forever as well, without any issues.)

I used to use JTDS exclusively, but I've found the latest MS drivers to be better.

[Igal]

Micha indicated in previous replies/posts that many jar files will be updated with Railo 4.  these drivers are probably (hopefully) on his list.

IIRC -- wasn't there a "package" change in the MS drivers from 3 to 4?  the new package is com.microsoft.sqlserver.jdbc.SQLServerDriver whereas the class that ships with Railo is (notice the difference in the package order) com.microsoft.jdbc.sqlserver.SQLServerDriver

if that's the case then simply dropping the new jar is not enough -- you'd have to update the config xml file.

[Arthur Blake]

No, the package name change was from version 2 to 3, not 3 to 4.

[Thorsten Eilers]

Push: ;-) "Will railo 4.0 release ship with MS JDBC driver 4.0 by default?"

[Mark Drew]

Maybe.. maybe not :)

I need to check with Engineering whether this has happened. One of the things we are thinking about is removing the inclusion of a lot of drivers and instead provide them as extensions.

This then means that if we need to update a driver, we can just update that extension, rather than the whole of railo (for essentially the sake of adding one JAR file)


If you need to use the MS JDBC driver you do know you can upgrade it yourself right?

Regards

Mark Drew