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
