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?
Thanks, Adam Sent from my iPhone On Jan 4, 2011, at 11:34 PM, Gora Mohanty <g...@mimirtech.com> wrote: > On Wed, Jan 5, 2011 at 5:01 AM, Adam Estrada > <estrada.adam.gro...@gmail.com> wrote: >> Can anyone help me with the following error. I upgraded my database to SQL >> Server 2008 SP2 and now I get the following error. It was working with SQL >> Server 2005. >> >> <Solr Error Stack> >> Caused by: java.lang.UnsupportedOperationException: Java Runtime Environment >> (JR >> E) version 1.6 is not supported by this driver. Use the sqljdbc4.jar class >> libra >> ry, which provides support for JDBC 4.0. > [...] > > You need to do pretty much what the error message says. The last > time we looked at MS SQL Server, the Microsoft JDBC driver had > both a sqljdbc.jar, and a sqljdbc4.jar. The former was for Java 1.5, > and the latter for Java 1.6. > > You might also consider moving to the open source jTDS driver > ( http://jtds.sourceforge.net/ ). We moved to it in the advice of > some people on this list, and it does seem to perform better, drop > connections less often, etc. > > Regards, > Gora
