Thank you for your responses Vadim and Jörn. You both prompted me to try again and this time I succeeded. The trick seemed to be the way that I installed Java using Open JDK versus from Oracle. In addition, I imagine I accidentally had a lot of old versions of JAR files lying around so it was easier to start with a fresh VM. Now I was able to install using JDK12 and the latest Microsoft 7.4.x driver. Now it works out of the box as I wanted.
Thanks again for being a sounding board for this, I primarily support Microsoft/dot net stuff so the Linux stuff sometimes gets away from me. ___________________________________________ Michael Friscia Office of Communications Yale School of Medicine (203) 737-7932 - office (203) 931-5381 - mobile http://web.yale.edu <http://web.yale.edu/> On 9/9/19, 6:53 AM, "Vadim Ivanov" <vadim.iva...@spb.ntk-intourist.ru> wrote: Hi, Latest jdbc driver 7.4.1 seems to support JRE 8, 11, 12 https://nam05.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.microsoft.com%2Fen-us%2Fdownload%2Fdetails.aspx%3Fid%3D58505&data=02%7C01%7Cmichael.friscia%40yale.edu%7C93626e2acbd4457d7f1608d73513f44d%7Cdd8cbebb21394df8b4114e3e87abeb5c%7C0%7C0%7C637036232130960752&sdata=3bLoGx8DzsAifCW9tv64V1sCeS7mTzFU3fAazODNGYE%3D&reserved=0 You have to delete all previous versions of Sql Server jdbc driver from Solr installation (/solr/server/lib/ in my case) -- Vadim > -----Original Message----- > From: Friscia, Michael [mailto:michael.fris...@yale.edu] > Sent: Monday, September 09, 2019 1:22 PM > To: solr-user@lucene.apache.org > Subject: SQL data import handler > > I setup SOLR on Ubuntu 18.04 and installed Java from apt-get with default-jre > which installed version 11. So after a day of trying to make my Microsoft SQL > Server data import handler work and failing, I built a new VM and installed > JRE 8 and then everything works perfectly. > > The root of the problem was the elimination of java.bind.xml in JRE 9. I’m not > a Java programmer so I’m only going by what I uncovered digging through the > error logs. I am not positive this is the only error to deal with, for all I know > fixing that will just uncover something else that needs repair. There were > solutions where you compile SOLR using Maven but this is moving out of my > comfort zone as well as long term strategy to keep SOLR management (as well > as other Linux systems management) out-of-the-box. There were also > solutions to include some sort of dependency on this older library but I’m at a > loss on how to relate that to a SOLR install. > > My questions, since I am not that familiar with Java dependencies: > > 1. Is it ok to run JRE 8 on a production server? It’s heavily firewalled and > SOLR, Zookeeper nor anything else on these servers is available off the virtual > network so it seems ok, but I try not to run very old versions of any software. > 2. Is there a way to fix this and keep the installation out-of-the-box or at > least almost out of the box? > > ___________________________________________ > Michael Friscia > Office of Communications > Yale School of Medicine > (203) 737-7932 - office > (203) 931-5381 - mobile > https://nam05.safelinks.protection.outlook.com/?url=http%3A%2F%2Fweb.yale.edu&data=02%7C01%7Cmichael.friscia%40yale.edu%7C93626e2acbd4457d7f1608d73513f44d%7Cdd8cbebb21394df8b4114e3e87abeb5c%7C0%7C0%7C637036232130960752&sdata=G5xMXdGQs12oK%2FDCxKy0zIn8sQ0uCpDLRGGatw45oiY%3D&reserved=0<https://nam05.safelinks.protection.outlook.com/?url=http%3A%2F%2Fweb.yale.edu%2F&data=02%7C01%7Cmichael.friscia%40yale.edu%7C93626e2acbd4457d7f1608d73513f44d%7Cdd8cbebb21394df8b4114e3e87abeb5c%7C0%7C0%7C637036232130960752&sdata=8pGHZPLlREYqKioyMrZDu2f9p3RXJBcFpkmvdKoHaZc%3D&reserved=0>
