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
