I guess this can go in the FAQ section of DIH On Wed, Apr 29, 2009 at 9:47 PM, Erick Erickson <erickerick...@gmail.com> wrote: > Thanks for letting us all know the resolution, that may save some other > poor soul from frustration.... > > Best > Erick > > On Wed, Apr 29, 2009 at 9:31 AM, Ci-man <ciber...@yahoo.com> wrote: > >> >> Found the problem. >> It is with Microsoft jdbc drivers (jdbc 2.0). >> >> With the latest download Microsoft provides two .jar files: >> sqljdbc.jar >> sqljdbc4.jar >> >> I had copied both into the lib directory. By doing so it used the older >> drivers (sqljdbc.jar) which do not work with jvm1.6. You get this kind of >> cryptic message in debug trace: >> >> The JDBC Driver version 2.0 does not support JRE 1.4. You must upgrade JRE >> 1.4 to JRE 5.0 or later when using the JDBC Driver version 2.0. In some >> cases, you might need to recompile your application because it might not be >> compatible with JDK 5.0 or later. For more information, see the >> documentation on Sun Microsystems Web site >> >> No further help from MS or boards. I experimented and removed the >> sqljdbc.jar file from lib directory so that only the sqljdbc4.jar is >> available. And bingo. Everything is working like a charm. >> >> Thanks everyone, >> -Ci >> >> -- >> View this message in context: >> http://www.nabble.com/Unable-to-import-data-from-database-tp23283852p23295866.html >> Sent from the Solr - User mailing list archive at Nabble.com. >> >> >
-- --Noble Paul
