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.
Thank you very much for the heads up on this one ;-) Adam On Wed, Jan 5, 2011 at 4:29 AM, Gora Mohanty <g...@mimirtech.com> wrote: > On Wed, Jan 5, 2011 at 10:18 AM, Estrada Groups > <estrada.adam.gro...@gmail.com> wrote: > > I downloaded that driver today and will test it tomorrow. Thanks for the > tip! Would you mind sending an XML code snippet if it's any different to > load than the MS driver? > [...] > > I presume that you are referring to the jTDS driver. The options are > slightly > different. Here is a snippet from the XML configuration of our > DataImportHandler, > with sensitive details obscured. > <dataSource type="JdbcDataSource" name="jdbc" > driver="net.sourceforge.jtds.jdbc.Driver" > > url="jdbc:jtds:sqlserver://<db_server>:<port>;databasename=<dbname>;responseBuffering=adaptive" > user="<user>" password="<password>" onError="skip" /> > > The jtds FAQ ( http://jtds.sourceforge.net/faq.html ) also has other > configuration > options, and more helpful information. For us, the transition was > pretty painless. > > Regards, > Gora >
