On Wed, Jan 5, 2011 at 8:22 PM, Adam Estrada <estrada.a...@gmail.com> wrote: > I can't tell any difference in performance but it does work like a charm. At > least the messaging in the console is a lot more verbose. [...]
Well, as far as the performance goes, we were also simultaneously making other changes as we were switching drivers, so we did not make an objective measurement of improved performance in terms of requests/s. What we definitely noticed was a marked improvement in maintaining connections to the database. At that time, our data import handler used to take some 6-7 hours, and we had all kinds of problems with dropped connections while using the Microsoft JDBC driver. Things improved a lot with jtds. Even though the problems did not entirely go away, they were minimised enough that the glitches could equally well be attributed to network issues, or issues with the database server. Regards, Gora